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
2512001602025-12-09PERSEDIAAN UMUM6010.064SERAGAM HEM WARNA PUTIH UK. M26010003390,0002601000332026-01-052026-01-301090,000272601012102026-02-04302026-02-06On time
2512001602025-12-09PERSEDIAAN UMUM6010.0422SERAGAM HEM WARNA COKLAT UK. L26010003390,0002601000332026-01-052026-01-301090,000272601012102026-02-04302026-02-06On time
2512001602025-12-09PERSEDIAAN UMUM6010.0426KAOS PUTIH KOBIN UK. XL26010003380,0002601000332026-01-052026-01-302080,000272601015822026-02-13392026-02-06Late
2512001602025-12-09PERSEDIAAN UMUM6010.0427KAOS COKLAT KOBIN UK.XL26010003380,0002601000332026-01-052026-01-305080,000272601015822026-02-13392026-02-06Late
2512003062025-12-18FIXED ASSETSAST02554Printer dotmetrik surat jalan 3ply Epson LX-3102601000212,700,0002601000212026-01-052026-01-0712,700,00018–––2026-01-14Overdue
2512003062025-12-18FIXED ASSETSAST02553Laptop Lenovo idePad i32601000215,750,0002601000212026-01-052026-01-0725,750,00018–––2026-01-14Overdue
2512004142025-12-26SPAREPART5017.0055FUJI MAGNETIC CONTACTOR SC N1/220 V260400174645,0002601000372026-01-052026-01-195535,000102601005282026-01-15102026-01-26On time
2512004142025-12-26SPAREPART5017.029SOCKET TIMER PF 0826010035525,0002601000372026-01-052026-01-19525,000102601008662026-01-26212026-01-26On time
2512004142025-12-26SPAREPART5017.0215MCCB SNEIDER 100 A260400272571,8502601000372026-01-052026-01-192500,000102601005282026-01-15102026-01-26On time
2512004142025-12-26SPAREPART5017.0221MCB SNEIDER 3P 10A260100415230,0002601000372026-01-052026-01-193230,000102601005282026-01-15102026-01-26On time
2512004212025-12-26SPAREPART5032.1433BEARING NO. 7 135C3-12081260100030190,0002601000302026-01-052026-01-242190,000102601003812026-01-1382026-01-31On time
2512004212025-12-26SPAREPART5032.0775CLUCTH COVER NO 2 135C3-120512601000302,100,0002601000302026-01-052026-01-2412,100,000102601003812026-01-1382026-01-31On time
2512004722025-12-27PERSEDIAAN UMUM6030.0004SEMEN GRESIK 40KG26050024159,5002601000232026-01-052026-01-062058,00092601001112026-01-0612026-01-13On time
2512004722025-12-27PERSEDIAAN UMUM6030.0898BESI UNP 100X50X5MM (@ 6000MM) SNI260610067576,0002601000222026-01-052026-01-0650596,396.492601001312026-01-0612026-01-13On time
2512004742025-12-29SPAREPART5019.0269MOTOR 0.75 KW 1 HP 1460 RPM 380 V B52605001361,187,5002601000262026-01-052026-01-2121,187,50072601001302026-01-0612026-01-28On time
2512004742025-12-29SPAREPART5019.0006MOTOR 0.37KW 0.5HP 1460 RPM 380V FLANGE B5260500136875,0002601000262026-01-052026-01-213875,00072601001302026-01-0612026-01-28On time
2512004742025-12-29SPAREPART5019.0283GEAR REDUCER MNRV 063 RATIO 1:30 FLANGE 0.75 KW B52601000264,500,0002601000262026-01-052026-01-2124,500,00072601001302026-01-0612026-01-28On time
2512004752025-12-29SPAREPART5011.0283BEARING UCP 210260400109241,0002601000322026-01-052026-01-214241,00072601001862026-01-0722026-01-28On time
2512004752025-12-29SPAREPART5031.013LEM TIP TOP SC 2000260300146572,072.072601000312026-01-052026-01-214572,072.0772601002342026-01-0832026-01-28On time
2512004772025-12-29SPAREPART5010.0054CLEANER HESCO 665 MOTOR CLEANER2601011873,150,0002601000352026-01-052026-01-1723,150,00072601004532026-01-1492026-01-24On time
2512004792025-12-29PERSEDIAAN UMUM6050.0034LPG 50 KG2606001661,300,0002601000272026-01-052026-01-1721,000,00072601001902026-01-0722026-01-24On time
2512004802025-12-29SPAREPART5019.0342MOTOR 1.5 KW 380 V 1500 RPM FLANGE B52605000991,875,0002601000362026-01-052026-01-1911,875,00072601002242026-01-0832026-01-26On time
2512004852025-12-30PERSEDIAAN UMUM6030.0004SEMEN GRESIK 40KG26050024159,5002601000292026-01-052026-01-101558,00062601001342026-01-0612026-01-17On time
2512100372025-12-12SPAREPART5017.1013FLEXIBLE CABLE (RVV 4x4MM)26010002051,0712601000202026-01-052026-01-1330051,071242601101142026-01-0832026-01-20On time
2512100372025-12-12SPAREPART5017.1012FLEXIBLE CABLE (RVV 4x2.5MM)26010002035,3672601000202026-01-052026-01-1350035,367242601101142026-01-0832026-01-20On time
2512100372025-12-12PERSEDIAAN UMUM6020.0687CLOSE-TOOTH TYPE CABLE DUCT (DEPTH 80 X WIDTH 80)260110006283,1432601100062026-01-052026-01-2215283,14324–––2026-01-29Overdue
2512100792025-12-31SPAREPART5031.0961KARET CLEANER 80057444260110004386,7412601100042026-01-052026-01-0530386,74152601107852026-02-09352026-01-12Late
2512100792025-12-31SPAREPART5031.0961KARET CLEANER 80057444260110004386,7412601100042026-01-052026-01-0530386,74152601111852026-02-27532026-01-12Late
2601000012026-01-02BAHAN BAKAR4010.0001SOLAR26060011120,720.722601000252026-01-052026-01-078,00012,792.7932601002052026-01-0832026-01-14On time
2601000152026-01-02PERSEDIAAN UMUM6050.0589LPG 12 KG260600005250,0002601000282026-01-052026-01-153210,00032601003822026-01-1382026-01-22On time
2512001802025-12-10PROMOSI6010.0735Stiker KOBIN Header Rak Granite uk 30 cm x 50 cm26010004110,5002601000412026-01-062026-01-2220010,500272601009302026-01-27212026-01-29On time
2512001802025-12-10PROMOSI6010.0738Stiker JUPITER Header Rak Granite uk 30 cm x 50 cm26010004110,5002601000412026-01-062026-01-2220010,500272601009302026-01-27212026-01-29On time
2512001802025-12-10PROMOSI6010.0737Stiker OCEANIA Header Rak Granite uk 30 cm x 50 cm26010004110,5002601000412026-01-062026-01-2220010,500272601009302026-01-27212026-01-29On time
2512001802025-12-10PROMOSI6010.0736Stiker PARIS Header Rak Granite uk 30 cm x 50 cm26010004110,5002601000412026-01-062026-01-2220010,500272601009302026-01-27212026-01-29On time
2512002322025-12-12SPAREPART5017.1034FUSE BASE RT16-1 250A260100042160,0002601000422026-01-062026-01-2120160,000252601005272026-01-1592026-01-28On time
2512002322025-12-12SPAREPART5017.0991DOUBLE LEVEL TERMINAL BLOCK26010051017,5002601000422026-01-062026-01-21517,500252601005272026-01-1592026-01-28On time
2512002322025-12-12SPAREPART5017.014PUSH BOTTON TELE XB2 BA3126050015054,9402601000422026-01-062026-01-21251,940252601008692026-01-26202026-01-28On time
2512002322025-12-12PERSEDIAAN UMUM6020.0713KABEL LIYCY 12X0.75 MM26010004250,0002601000422026-01-062026-01-213050,000252601005272026-01-1592026-01-28On time
2512002322025-12-12SPAREPART5017.034MOTOR PROTECTION SCHNEIDER TYPE GV2ME10260500288545,0002601000422026-01-062026-01-2110464,000252601005272026-01-1592026-01-28On time
2512002322025-12-12SPAREPART5017.0474CONTACTOR 3TF50/ 3RT10542601000422,700,0002601000422026-01-062026-01-2132,700,000252601005272026-01-1592026-01-28On time
2512002322025-12-12SPAREPART5017.0438MOTOR PROTECTION SCHNEIDER TYPE GV2ME14260500048570,0002601000422026-01-062026-01-215540,000252601005272026-01-1592026-01-28On time
2512002322025-12-12SPAREPART5017.0375OMRON RELAY MY4-N220 VAC26040018452,0002601000422026-01-062026-01-2116048,000252601008692026-01-26202026-01-28On time
2512002322025-12-12SPAREPART5017.0137OMRON SOCKET PYF 14 AE26010004226,0002601000422026-01-062026-01-213426,000252601008692026-01-26202026-01-28On time
2512002322025-12-12SPAREPART5017.0055FUJI MAGNETIC CONTACTOR SC N1/220 V260400174645,0002601000422026-01-062026-01-2110535,000252601005272026-01-1592026-01-28On time
2512002322025-12-12SPAREPART5017.0023MCB CIRCUIT BREAKER 3P 32A260500011260,0002601000422026-01-062026-01-213260,000252601005272026-01-1592026-01-28On time
2512002322025-12-12SPAREPART5017.0021MCB CIRCUIT BREAKER 3P 6A260300338206,0002601000422026-01-062026-01-2134206,000252601005272026-01-1592026-01-28On time
2512002952025-12-17SPAREPART5030.0122SIMPLE CHAIN P=1/2" C9990011025260100054752,3862601000542026-01-062026-01-224752,386202601006492026-01-20142026-01-29On time
2512002952025-12-17SPAREPART5030.1552ECCENTRIX CENTERING GUIDE C9213502202260100054878,9562601000542026-01-062026-01-2210878,956202603004122026-03-10632026-01-29Late
2512002952025-12-17SPAREPART5030.1553CONCENTRIX CENTERING GUIDE C9213502201260100054829,7342601000542026-01-062026-01-226829,734202601017142026-02-18432026-01-29Late
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,000196142601004832026-01-1592026-01-22On time
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,000196142601002262026-01-0822026-01-22On time
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,000196142601003612026-01-1372026-01-22On time
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,000196142601004142026-01-1372026-01-22On time
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,000196142601005122026-01-1592026-01-22On time
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,000196142601011302026-01-31252026-01-22Late
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,000196142601011872026-02-04292026-01-22Late
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,000196142601011652026-02-03282026-01-22Late
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,000196142601009292026-01-27212026-01-22Late
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,000196142601009842026-01-28222026-01-22Late
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,000196142601016302026-02-16412026-01-22Late
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,000196142601008872026-01-26202026-01-22Late
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,000196142601010442026-01-29232026-01-22Late
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,000196142601011102026-01-31252026-01-22Late
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,000196142601008542026-01-26202026-01-22Late
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,000196142601006212026-01-20142026-01-22On time
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,000196142601006742026-01-21152026-01-22On time
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,000196142601007172026-01-22162026-01-22On time
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,000196142601007782026-01-23172026-01-22Late
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,000196142601008132026-01-23172026-01-22Late
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,000196142601018452026-02-21462026-01-22Late
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,00019614–––2026-01-22Overdue
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,000196142601005682026-01-19132026-01-22On time
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,000196142601002742026-01-0932026-01-22On time
2512004012025-12-23BAHAN BAKU BODY1010.0022PHIROPILIT (ANUGERAH)2606000062182601000492026-01-062026-01-152,800,000196142601003152026-01-1262026-01-22On time
2512004272025-12-26SPAREPART5017.0055FUJI MAGNETIC CONTACTOR SC N1/220 V260400174645,0002601000432026-01-062026-01-265535,000112601005202026-01-1592026-02-02On time
2512004272025-12-26SPAREPART5011.0022BEARING 3020526010005270,0002601000522026-01-062026-01-171070,000112601003892026-01-1372026-01-24On time
2512004272025-12-26SPAREPART5011.0031BEARING 3030426030018365,0002601000522026-01-062026-01-171065,000112601003892026-01-1372026-01-24On time
2512004272025-12-26SPAREPART5017.0128OMRON RELAY G2R/24 VD26010005354,0002601000532026-01-062026-01-261054,000112601005542026-01-17112026-02-02On time
2512004272025-12-26SPAREPART5011.0031BEARING 3030426030018365,0002601000522026-01-062026-01-171065,000112601003862026-01-1372026-01-24On time
2512004272025-12-26SPAREPART5011.0025BEARING 3020826040001198,9002601000522026-01-062026-01-175100,000112601003892026-01-1372026-01-24On time
2512004382025-12-27BAHAN PACKING3011.0233BOX KOBIN BK TS KW 1 50X502606001201,4592601000502026-01-062026-01-2433,6001,227102601004932026-01-1592026-01-31On time
2512004392025-12-30BAHAN PEMBANTU20BK.0015MEDIUM ALUMINA LINING BRICK 140X40X972605004180.362601000342026-01-062026-02-1029,0000.50672601016262026-02-16412026-02-17On time
2512004392025-12-30BAHAN PEMBANTU20BK.0016MEDIUM ALUMINA LINING BRICK 140X40x40X972603002030.452601000342026-01-062026-02-1021,0000.50672601016262026-02-16412026-02-17On time
2512004462025-12-30BAHAN BAKU GLAZE1099.0018BALLCLAY (NOODLE) OPAL KA2606000371,3112601000822026-01-062026-01-1524,0001,20072601009782026-01-28222026-01-22Late
2512004472025-12-30BAHAN BAKU GLAZE1098.0014STPP (Sodium Tripolyphospate)26060004525,7002601000812026-01-062026-01-149,00023,00072601007132026-01-22162026-01-21Late
2512004472025-12-30BAHAN BAKU GLAZE1098.0014STPP (Sodium Tripolyphospate)26060004525,7002601000812026-01-062026-01-149,00023,00072601004162026-01-1372026-01-21On time
2512004482025-12-30BAHAN BAKU GLAZE1098.0004CMC C-2026060004985,475.62601000582026-01-062026-01-091,80081,751.672601003702026-01-1372026-01-16On time
2512004492025-12-30BAHAN BAKU GLAZE1099.0024ALUMINA A-1026060004812,036.362601000572026-01-062026-01-0935,00011,511.9672601002892026-01-1042026-01-16On time
2512004502025-12-30BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752601000742026-01-062026-01-20240,0007,342.57–––2026-01-27Overdue
2512004502025-12-30BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752601000742026-01-062026-01-20240,0007,342.572601006272026-01-20142026-01-27On time
2512004502025-12-30BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752601000742026-01-062026-01-20240,0007,342.572601005342026-01-17112026-01-27On time
2512004502025-12-30BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752601000742026-01-062026-01-20240,0007,342.572601004242026-01-1372026-01-27On time
2512004502025-12-30BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752601000742026-01-062026-01-20240,0007,342.572601003042026-01-1262026-01-27On time
2512004502025-12-30BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752601000742026-01-062026-01-20240,0007,342.572601005242026-01-1592026-01-27On time
2512004502025-12-30BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752601000742026-01-062026-01-20240,0007,342.572601005332026-01-17112026-01-27On time
2512004502025-12-30BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752601000742026-01-062026-01-20240,0007,342.57–––2026-01-27Overdue
2512004502025-12-30BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752601000742026-01-062026-01-20240,0007,342.572601006282026-01-20142026-01-27On time
2512004502025-12-30BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752601000742026-01-062026-01-20240,0007,342.572601005772026-01-19132026-01-27On time
2512004512025-12-30BAHAN BAKU GLAZE1099.0027SODIUM FELDSPAR 325 MESH2604004052,468.452601000782026-01-062026-01-2025,0002,311.2272601004182026-01-1372026-01-27On time
2512004522025-12-30BAHAN BAKU GLAZE1030.0027SILICA 200 ID2606000381,3162601000832026-01-062026-01-27120,0001,22572601009862026-01-29232026-02-03On time
← PrevPage 30 of 135Next →Rows per page:1020501005001000