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
2512100382025-12-13SPAREPART5011.0282BEARING UCP 209260500470194,0002512100792025-12-172025-12-25580,20042601101162026-01-08222026-01-01Late
2512100492025-12-16SPAREPART5011.0279BEARING UCP 206260400546120,3002512100792025-12-172025-12-251036,68512601101162026-01-08222026-01-01Late
2511100802025-11-24SPAREPART5027.0438HYDRAULIC HOSE 400MM, WITH FEMALE THREADED FITTING, OUTER DIAMETER Ø25251210100210,0002512101002025-12-182025-12-2612210,000242512104542025-12-2242026-01-02On time
2511100822025-11-24PERSEDIAAN UMUM6030.195SENDOK TEMBOK MODEL LANCIP 7 INCH26041021011,5922512100972025-12-182025-12-261016,880242512104982025-12-2462026-01-02On time
2511100992025-11-29PERSEDIAAN UMUM6060.021MUR M 142605004641,0502512100962025-12-182025-12-26200900192512104932025-12-2462026-01-02On time
2512000742025-12-03PERSEDIAAN UMUM6020.0103KABEL NYAF 1X0.75 MM260600150303,603.62512003322025-12-182025-12-182220,720.72152512008252025-12-2462025-12-25On time
2512000742025-12-03PERSEDIAAN UMUM6020.0666KABEL NYYHY 10X1.5 MM25120033260,7442512003322025-12-182025-12-1820060,744152512008252025-12-2462025-12-25On time
2512000742025-12-03PERSEDIAAN UMUM6020.0665KABEL NYAF 4X2.5 MM26010023834,1002512003322025-12-182025-12-181,50027,699152601003412026-01-12252025-12-25Late
2512000742025-12-03PERSEDIAAN UMUM6020.0665KABEL NYAF 4X2.5 MM26010023834,1002512003322025-12-182025-12-181,50027,699152512008252025-12-2462025-12-25On time
2512001172025-12-08BAHAN PACKING3011.0235BOX PARIS BK TS KW 1 50X502606001201,4592512003242025-12-182026-01-2050,0001,227102512010302025-12-31132026-01-27On time
2512001172025-12-08BAHAN PACKING3011.002BOX PARIS COKLAT TS 50*50 KW II2605003821,4592512003242025-12-182026-01-2015,0001,227102512010302025-12-31132026-01-27On time
2512001272025-12-06STATIONERY6010.0041FORM CATATAN PENYEBAB LINE STOP FR-PROD-18 A4, FR-PROD-1826060025512,0002512003442025-12-182025-12-301012,500122512007752025-12-2352026-01-06On time
2512001272025-12-06STATIONERY6010.0042FORM DAFTAR PEMERIKSAAN UKURAN BARANG JADI DAFTAR PEMERIKSAAN UKURAN BARANG JADI,A426060025512,0002512003442025-12-182025-12-301012,500122512007752025-12-2352026-01-06On time
2512001272025-12-06STATIONERY6010.0039FORM GLAZING LINE CONTROL REPORT FR-PROD-04 A4, FR-PROD-0426050039412,0002512003442025-12-182025-12-301012,500122512007752025-12-2352026-01-06On time
2512001272025-12-06STATIONERY6010.0052FORM DAFTAR PEMERIKSAAN MUTU HASIL PRESS26040015712,5002512003442025-12-182025-12-301012,500122512007752025-12-2352026-01-06On time
2512001272025-12-06STATIONERY6010.0053FORM PEMAKAIAN GLAZE DAN ENGOBE26040015710,0002512003442025-12-182025-12-302010,000122512007752025-12-2352026-01-06On time
2512001272025-12-06STATIONERY6010.0094DAFTAR LAPORAN HARIAN KELOMPOK SORTIR FR-PROD-12 REV 0026050039412,0002512003442025-12-182025-12-301012,500122512007752025-12-2352026-01-06On time
2512001272025-12-06STATIONERY6010.0109FORM TEST BODY / SIZE (KILN-PRESS) FR-PRO-03 REV 0226040015712,5002512003442025-12-182025-12-301012,500122512007752025-12-2352026-01-06On time
2512001312025-12-06PERSEDIAAN UMUM6020.0521SENTER LED RECHARGEABLE260300329145,3452512003452025-12-182025-12-241201,323122512007402025-12-2242025-12-31On time
2512001542025-12-09FIXED ASSETSAST02521SCAFFOLDING251200340427,927.932512003402025-12-182025-12-1810427,927.939–––2025-12-25Overdue
2512001682025-12-10PERSEDIAAN UMUM6020.068FLASHDISK 128 GB (SANDISK)260100361170,5002512003492025-12-182025-12-261189,20082512007392025-12-2242026-01-02On time
2512001722025-12-10PERSEDIAAN UMUM6020.0371SAKLAR SERI SCHNEIDER VIVACE260101158125,0002512003312025-12-182025-12-187125,00082512007192025-12-2242025-12-25On time
2512001722025-12-10PERSEDIAAN UMUM6020.0372SAKLAR TUNGGAL SCHNEIDER VIVACE26030031724,5002512003312025-12-182025-12-18490,00082512007192025-12-2242025-12-25On time
2512002092025-12-12SPAREPART5017.0209PILOT LAMP SCHNEIDER HIJAU 220 VAC26010036950,0002512003302025-12-182025-12-183050,00062512007742025-12-2352025-12-25On time
2512002092025-12-12SPAREPART5017.0208PILOT LAMP SCHNEIDER MERAH 220 VAC26010044048,0002512003302025-12-182025-12-183050,00062512007742025-12-2352025-12-25On time
2512002092025-12-12SPAREPART5017.0145TELE SELECTOR XB4 BD21260600252122,9002512003302025-12-182025-12-181113,50062512007742025-12-2352025-12-25On time
2512002092025-12-12SPAREPART5017.1019MOTOR PROTECTION SCHNEIDER TYPE GV2ME08260500287490,0002512003312025-12-182025-12-181465,00062512007192025-12-2242025-12-25On time
2512002092025-12-12PERSEDIAAN UMUM6020.0103KABEL NYAF 1X0.75 MM260600150303,603.62512003322025-12-182025-12-182220,720.7262512008252025-12-2462025-12-25On time
2512002092025-12-12SPAREPART5017.0054FUJI CONTACTOR SC 0/220 V260500161220,0002512003302025-12-182025-12-1820215,00062512007742025-12-2352025-12-25On time
2512002092025-12-12SPAREPART5017.034MOTOR PROTECTION SCHNEIDER TYPE GV2ME10260500288545,0002512003312025-12-182025-12-181465,00062512007192025-12-2242025-12-25On time
2512002362025-12-13BAHAN PACKING3011.0233BOX KOBIN BK TS KW 1 50X502606001201,4592512003232025-12-182026-01-2070,0001,22752601002552026-01-09222026-01-27On time
2512002362025-12-13BAHAN PACKING3011.0235BOX PARIS BK TS KW 1 50X502606001201,4592512003232025-12-182026-01-2070,0001,22752601016992026-02-18622026-01-27Late
2512002362025-12-13BAHAN PACKING3011.0234BOX JUPITER BK TS KW 1 50X502605004741,4592512003232025-12-182026-01-2070,0001,22752601002522026-01-09222026-01-27On time
2512002362025-12-13BAHAN PACKING3011.0235BOX PARIS BK TS KW 1 50X502606001201,4592512003232025-12-182026-01-2070,0001,22752601005452026-01-17302026-01-27On time
2512002362025-12-13BAHAN PACKING3011.0233BOX KOBIN BK TS KW 1 50X502606001201,4592512003232025-12-182026-01-2070,0001,22752601003262026-01-12252026-01-27On time
2512002362025-12-13BAHAN PACKING3011.0234BOX JUPITER BK TS KW 1 50X502605004741,4592512003232025-12-182026-01-2070,0001,22752601002552026-01-09222026-01-27On time
2512002362025-12-13BAHAN PACKING3011.0235BOX PARIS BK TS KW 1 50X502606001201,4592512003232025-12-182026-01-2070,0001,22752601009652026-01-28412026-01-27Late
2512002362025-12-13BAHAN PACKING3011.0236BOX MY BK TS KW 1 50X502605004741,4592512003232025-12-182026-01-2070,0001,22752601009652026-01-28412026-01-27Late
2512002362025-12-13BAHAN PACKING3011.0014BOX KOBIN COKLAT TS 50*50 KW II2606001201,4592512003232025-12-182026-01-2020,0001,22752601006882026-01-21342026-01-27On time
2512002362025-12-13BAHAN PACKING3011.0236BOX MY BK TS KW 1 50X502605004741,4592512003232025-12-182026-01-2070,0001,22752601010532026-01-29422026-01-27Late
2512002362025-12-13BAHAN PACKING3011.0018BOX JUPITER COKLAT TS 50*50 KW II2605003821,4592512003232025-12-182026-01-2020,0001,2275–––2026-01-27Overdue
2512002362025-12-13BAHAN PACKING3011.0236BOX MY BK TS KW 1 50X502605004741,4592512003232025-12-182026-01-2070,0001,22752601002552026-01-09222026-01-27On time
2512002362025-12-13BAHAN PACKING3011.0236BOX MY BK TS KW 1 50X502605004741,4592512003232025-12-182026-01-2070,0001,22752601004922026-01-15282026-01-27On time
2512002362025-12-13BAHAN PACKING3011.002BOX PARIS COKLAT TS 50*50 KW II2605003821,4592512003232025-12-182026-01-2040,0001,2275–––2026-01-27Overdue
2512002362025-12-13BAHAN PACKING3011.014BOX MY COKLAT TS 50*50 KW II2603004441,3192512003232025-12-182026-01-2020,0001,2275–––2026-01-27Overdue
2512002362025-12-13BAHAN PACKING3011.0025BOX KOBIN HITAM TS 50*50 KW III2606001201,4592512003232025-12-182026-01-2030,0001,2275–––2026-01-27Overdue
2512002362025-12-13BAHAN PACKING3011.0237BOX KAISAR BK TS KW 1 50X502512003231,2272512003232025-12-182026-01-2040,0001,2275–––2026-01-27Overdue
2512002372025-12-13BAHAN PACKING3011.0043BOX KOBIN T.S KW 1 30X302604004001,1772512003222025-12-182026-01-10120,00095152512010312025-12-31132026-01-17On time
2512002372025-12-13BAHAN PACKING3011.0047BOX KOBIN HIJAU T.S KW 2 30X302512003229512512003222025-12-182026-01-1036,00095152512009742025-12-30122026-01-17On time
2512002372025-12-13BAHAN PACKING3011.0048BOX KOBIN HITAM T.S KW 3 30X302605003821,1772512003222025-12-182026-01-1036,00095152512009742025-12-30122026-01-17On time
← PrevPage 38 of 270Next →Rows per page:1020501005001000