KKobin GroupProcurement KPI
ConsolidatedPR TO PO TO GRPO (spine)PO exportLEAD TIME

Merged data

The merged procurement sheet (PR → PO → GRPO) with the realisasi status used by KPI 2/3 · 13,488 row(s)

Export CSV
How the three files are consolidated— click to expand

Three SAP exports are combined. The SPINE is PR TO PO TO GRPO — the master PR list (one row per PR-item, including PRs not yet converted to a PO). It sets the dashboard's date span and is KPI 4's denominator.

PO.csv enriches it with the PO details that only it carries: the Lokal/Impor flag (the KPI 2 vs KPI 3 split), the ETA, currency and unit price, joined on PO No.

LEAD TIME PR TO GR adds the goods-receipt detail: one row per GR with its date and quantity, plus the ordered PO quantity, last/current price and PR→PO days. This is what makes the quantity-aware completion possible.

KPI 2/3 'received' logic is quantity-aware: a PO-item counts as received only when the running sum of GR quantities reaches the ordered quantity; the completion date (the GR that crosses the ordered qty) is compared to ETA + 7 days (Local) / 14 days (Import).

On import each file is upserted by its natural key, so re-uploading an updated export updates rows in place instead of duplicating them. KPI 5 (Quality), 6 (Substitution) and 7 (New Vendor) have no source in these files yet — they are seeded with best-case defaults so the scorecard is complete; replace those entries as real data arrives.

Realisasi here uses a 7-day tolerance (local). Each KPI's own formula is on its methodology page — click any KPI title on the dashboard.

PR NoPR DateItem GroupItem CodeItemLast POLast PricePO NoPO Date ▲ETAQtyPricePR→POGRPO NoGRPO DatePO→GRPODeadlineRealisasi
2512003192025-12-19BAHAN BAKU BODY1010.0007FELDSPAR (RGS-2)2605002842842512004072025-12-222026-01-203,500,00026932601008492026-01-26352026-01-27On time
2512003192025-12-19BAHAN BAKU BODY1010.0007FELDSPAR (RGS-2)2605002842842512004072025-12-222026-01-203,500,00026932601012752026-02-06462026-01-27Late
2512003192025-12-19BAHAN BAKU BODY1010.0007FELDSPAR (RGS-2)2605002842842512004072025-12-222026-01-203,500,00026932601013272026-02-07472026-01-27Late
2512003192025-12-19BAHAN BAKU BODY1010.0007FELDSPAR (RGS-2)2605002842842512004072025-12-222026-01-203,500,00026932601002212026-01-08172026-01-27On time
2512003192025-12-19BAHAN BAKU BODY1010.0007FELDSPAR (RGS-2)2605002842842512004072025-12-222026-01-203,500,00026932601005132026-01-15242026-01-27On time
2512003192025-12-19BAHAN BAKU BODY1010.0007FELDSPAR (RGS-2)2605002842842512004072025-12-222026-01-203,500,00026932601005672026-01-19282026-01-27On time
2512003212025-12-19BAHAN BAKU BODY1098.0005WATERGLASS (SODIUM SILICATE)2605004162,6502512004042025-12-222026-01-30180,0002,33032601008472026-01-26352026-02-06On time
2512003212025-12-19BAHAN BAKU BODY1098.0005WATERGLASS (SODIUM SILICATE)2605004162,6502512004042025-12-222026-01-30180,0002,33032512010372025-12-3192026-02-06On time
2512003212025-12-19BAHAN BAKU BODY1098.0005WATERGLASS (SODIUM SILICATE)2605004162,6502512004042025-12-222026-01-30180,0002,33032601001472026-01-06152026-02-06On time
2512003212025-12-19BAHAN BAKU BODY1098.0005WATERGLASS (SODIUM SILICATE)2605004162,6502512004042025-12-222026-01-30180,0002,33032601010392026-01-29382026-02-06On time
2512003212025-12-19BAHAN BAKU BODY1098.0005WATERGLASS (SODIUM SILICATE)2605004162,6502512004042025-12-222026-01-30180,0002,33032601005712026-01-19282026-02-06On time
2512003212025-12-19BAHAN BAKU BODY1098.0005WATERGLASS (SODIUM SILICATE)2605004162,6502512004042025-12-222026-01-30180,0002,33032601003652026-01-13222026-02-06On time
2512003232025-12-19PERSEDIAAN UMUM6050.0111OXYGEN26060017745,0002512005042025-12-222025-12-221090,00032512009652025-12-3082025-12-29Late
2512003342025-12-19PERSEDIAAN UMUM6030.0515CAT BESI AVIAN LEMONADE 48026060017170,725.232512004202025-12-222025-12-305057,472.9732512008792025-12-2642026-01-06On time
2512003342025-12-19PERSEDIAAN UMUM6030.0515CAT BESI AVIAN LEMONADE 48026060017170,725.232512004202025-12-222025-12-305057,472.9732512009882025-12-3082026-01-06On time
2512003492025-12-20PERSEDIAAN UMUM6050.0589LPG 12 KG260600005250,0002512004142025-12-222025-12-293210,00022512007912025-12-2312026-01-05On time
2512003522025-12-20PERSEDIAAN UMUM6060.024RING PLAT M-182605004648052512004102025-12-222025-12-2215041522512008652025-12-2642025-12-29On time
2512003522025-12-20PERSEDIAAN UMUM6060.0644BAUT M-18*402512004104,0002512004102025-12-222025-12-221504,00022512008652025-12-2642025-12-29On time
2512003552025-12-19PERSEDIAAN UMUM6030.0004SEMEN GRESIK 40KG26050024159,5002512004112025-12-222025-12-222058,00032512008192025-12-2422025-12-29On time
2512100362025-12-12PERSEDIAAN UMUM6020.0701INSULATED EV TYPE TUBE-TYPE TERMINAL LUG (6 MM)25121012427,0002512101242025-12-222026-01-01227,000102512106032025-12-3082026-01-08On time
2512100362025-12-12PERSEDIAAN UMUM6020.07INSULATED EV TYPE TUBE-TYPE TERMINAL LUG (4 MM)25121012417,0002512101242025-12-222026-01-01517,000102512106032025-12-3082026-01-08On time
2512100372025-12-12PERSEDIAAN UMUM6020.0707TUBE MARKER 0.5MM251210116134,9002512101162025-12-222025-12-311134,900102601100802026-01-08172026-01-07Late
2512100372025-12-12PERSEDIAAN UMUM6050.1182LABEL PRINTING (YELLOW) 9MM FOR PUTY PT101025121011671,2502512101162025-12-222025-12-312071,250102601100802026-01-08172026-01-07Late
2512100372025-12-12PERSEDIAAN UMUM6050.1183LABEL PRINTING (YELLOW) 12MM FOR PUTY PT101025121011685,5002512101162025-12-222025-12-312085,500102601100802026-01-08172026-01-07Late
2512100372025-12-12PERSEDIAAN UMUM6020.0697INSULATED EV TYPE TUBE-TYPE TERMINAL LUG (1 MM)2512101158,5002512101152025-12-222025-12-3158,500102512106042025-12-3082026-01-07On time
2512100372025-12-12PERSEDIAAN UMUM6020.0698INSULATED EV TYPE TUBE-TYPE TERMINAL LUG (1.5 MM)2512101159,0002512101152025-12-222025-12-3159,000102512106042025-12-3082026-01-07On time
2512100372025-12-12PERSEDIAAN UMUM6020.0695INSULATED RV TYPE O-TYPE TERMINAL LUG (RV2-6.3)25121011542,0002512101152025-12-222025-12-31342,000102512106042025-12-3082026-01-07On time
2512100372025-12-12PERSEDIAAN UMUM6020.0696INSULATED RV TYPE O-TYPE TERMINAL LUG (RV5.5-8)25121011586,5002512101152025-12-222025-12-31386,500102512106042025-12-3082026-01-07On time
2512100372025-12-12PERSEDIAAN UMUM6020.0699INSULATED EV TYPE TUBE-TYPE TERMINAL LUG (2.5 MM)25121011512,0002512101152025-12-222025-12-31512,000102512106042025-12-3082026-01-07On time
2512100372025-12-12PERSEDIAAN UMUM6050.1178CROSS HEAD SELF DRILLING SCREW ST4.8X16251210116118,7502512101162025-12-222025-12-312118,750102601100802026-01-08172026-01-07Late
2512100372025-12-12PERSEDIAAN UMUM6050.1181ELECTRIC SCREWDRIVER CROSS HEAD PH3251210116123,5002512101162025-12-222025-12-3110123,500102601100802026-01-08172026-01-07Late
2512100372025-12-12PERSEDIAAN UMUM6020.0703DIN RAIL (T35)25121011623,7502512101162025-12-222025-12-313023,750102601100802026-01-08172026-01-07Late
2512100372025-12-12PERSEDIAAN UMUM6050.1179ELECTRIC SCREWDRIVER CROSS HEAD PH125121011684,5502512101162025-12-222025-12-311084,550102601100802026-01-08172026-01-07Late
2512100372025-12-12PERSEDIAAN UMUM6050.118ELECTRIC SCREWDRIVER CROSS HEAD PH225121011699,7502512101162025-12-222025-12-311099,750102601100802026-01-08172026-01-07Late
2512100372025-12-12PERSEDIAAN UMUM6020.0688AXIAL FAN 120MMX120MM AC220 VOLT260110129114,0002512101162025-12-222025-12-3115114,000102601100802026-01-08172026-01-07Late
2512100572025-12-19BAHAN BAKU GLAZE1030.0082CERAMICS GLAZE ANTI SLIP 9152603101071.552512101122025-12-222025-12-2212,0001.5532601105562026-01-30392025-12-29Late
2511003022025-11-22BAHAN BAKU BODY1098.0016DEFLOCCULANT VL-012606000548,1502512004282025-12-232026-01-1550,0006,650312601003692026-01-13212026-01-22On time
2511003022025-11-22BAHAN BAKU BODY1098.0016DEFLOCCULANT VL-012606000548,1502512004282025-12-232026-01-1550,0006,650312601004222026-01-13212026-01-22On time
2511003382025-11-21SPAREPART5023.0862PULLY TIMMING H 100 T16260100411420,0002512004512025-12-232026-01-155425,000322601001972026-01-07152026-01-22On time
2511004402025-11-28PERSEDIAAN UMUM6030.2066BESI HOLLOW 50X50X6MX2MM260510178278,0002512004662025-12-232025-12-2330177,477.4825–––2025-12-30Overdue
2512000372025-12-01PERSEDIAAN UMUM6030.187BESI HOLLOW 40X60X2MMX6M260400315235,135.142512004662025-12-232025-12-2320177,477.4822–––2025-12-30Overdue
2512000402025-12-01SPAREPART5030.1729CUSCINETTO RADIALE A SFERE 6201 2RS (12X32X10) 921110120125120041625,0002512004162025-12-232025-12-23425,000222603000012026-03-02692025-12-30Late
2512000412025-12-01SPAREPART5030.007CUS RADIATE A SFERA ASS C 921110080025120041613,5002512004162025-12-232025-12-235013,500222603000012026-03-02692025-12-30Late
2512000552025-12-03PERSEDIAAN UMUM6030.0899PLAT BESI 20X1200X2400 MM2512004384,459,639.642512004382025-12-232025-12-2334,459,639.64202512008692025-12-2632025-12-30On time
2512000552025-12-03PERSEDIAAN UMUM6030.0433PLAT BESI 1X1200X2400 MM260410045313,6002512004382025-12-232025-12-233256,756.76202512008692025-12-2632025-12-30On time
2512000552025-12-03PERSEDIAAN UMUM6030.0167PIPA GALVANIS MEDIUM SNI 2 INCH260300096629,729.732512004662025-12-232025-12-234556,756.7620–––2025-12-30Overdue
2512001072025-12-06PERSEDIAAN UMUM6030.2463NIKKO STEEL NS STAINCLEAN @1KG251200432133,333.332512004322025-12-232025-12-2310133,333.33172601003542026-01-12202025-12-30Late
2512001072025-12-06PERSEDIAAN UMUM6030.2463NIKKO STEEL NS STAINCLEAN @1KG251200432133,333.332512004322025-12-232025-12-2310133,333.33172601004022026-01-13212025-12-30Late
2512001282025-12-06SPAREPART5031.0958SCREW, SELF TAPPING (1-J)25120046376,5002512004632025-12-232025-12-236076,500172601004542026-01-14222025-12-30Late
2512001282025-12-06SPAREPART5031.0957MUFFLER (1-F)260400293135,0002512004632025-12-232025-12-2315135,000172601004542026-01-14222025-12-30Late
← PrevPage 45 of 270Next →Rows per page:1020501005001000