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
2511004462025-11-29BAHAN PEMBANTU2024.0001OPP 48*10026050005510,4952512003832025-12-022025-12-201,8727,00032512009102025-12-27252025-12-27On time
2511004492025-11-29BAHAN PEMBANTU2024.0004STRETCH FILM260500461535,0002512000672025-12-022025-12-1154355,00032512007662025-12-23212025-12-18Late
2511004492025-11-29BAHAN PEMBANTU2024.0004STRETCH FILM260500461535,0002512000672025-12-022025-12-1154355,00032512005312025-12-16142025-12-18On time
2511004512025-11-29BAHAN PEMBANTU2034.0001LEM LP 5840N26060024741,218.32512000172025-12-022025-12-201,00033,33632512006382025-12-18162025-12-27On time
2511004512025-11-29BAHAN PEMBANTU2034.0001LEM LP 5840N26060024741,218.32512000172025-12-022025-12-201,00033,33632512003312025-12-1192025-12-27On time
2511004602025-11-29PERSEDIAAN UMUM6020.0059MOUSE KOMPUTER26030051154,054.052512000182025-12-022025-12-20351,00032512001062025-12-0532025-12-27On time
2511004662025-11-29PERSEDIAAN UMUM6050.0034LPG 50 KG2606001661,300,0002512000142025-12-022025-12-1021,020,00032512001102025-12-0532025-12-17On time
2511004682025-11-29PERSEDIAAN UMUM6050.0045MAJUN WARNA2605004418,2002512000232025-12-022025-12-202437,20032512004382025-12-13112025-12-27On time
2511004692025-11-29PERSEDIAAN UMUM6050.0058SARUNG TANGAN TEBAL26060016821,0002512000272025-12-022025-12-1524520,50032512002642025-12-0972025-12-22On time
2511004692025-11-29PERSEDIAAN UMUM6050.0059SARUNG TANGAN26060016817,6002512000272025-12-022025-12-156017,00032512002642025-12-0972025-12-22On time
2511004702025-11-29STATIONERY6010.0166TAPE DISPENSER TAPE, 48 mm26050017616,0002512000262025-12-022025-12-201216,00032512001042025-12-0532025-12-27On time
2511004812025-11-29BAHAN PACKING3011.0218NFT00 40X40 JUPITER MP2 KW-A 403X54 (BK150/125/125)2606001203572512000152025-12-022025-12-2030,00027532512006472025-12-19172025-12-27On time
2511004812025-11-29BAHAN PACKING3011.0218NFT00 40X40 JUPITER MP2 KW-A 403X54 (BK150/125/125)2606001203572512000162025-12-022025-12-2030,00035032512006812025-12-22202025-12-27On time
2511004812025-11-29BAHAN PACKING3011.02NFT00 40X40 KOBIN MP1 KW-A 403X51 (BK150/125/125)2606001204092512000152025-12-022025-12-2050,00031532512006472025-12-19172025-12-27On time
2511004812025-11-29BAHAN PACKING3011.0217NFT00 40X40 JUPITER MP1 KW-A 403X51 (BK150/125/125)2606001204092512000152025-12-022025-12-2030,00031532512006472025-12-19172025-12-27On time
2511004812025-11-29BAHAN PACKING3011.0217NFT00 40X40 JUPITER MP1 KW-A 403X51 (BK150/125/125)2606001204092512000162025-12-022025-12-2030,00040032512006812025-12-22202025-12-27On time
2511004812025-11-29BAHAN PACKING3011.0201NFT00 40X40 KOBIN MP2 KW-A 403X54 (BK150/125/125)2606001203572512000162025-12-022025-12-2050,00035032512009432025-12-29272025-12-27Late
2511004812025-11-29BAHAN PACKING3011.02NFT00 40X40 KOBIN MP1 KW-A 403X51 (BK150/125/125)2606001204092512000162025-12-022025-12-2050,00040032512009432025-12-29272025-12-27Late
2511004812025-11-29BAHAN PACKING3011.0201NFT00 40X40 KOBIN MP2 KW-A 403X54 (BK150/125/125)2606001203572512000152025-12-022025-12-2050,00027532512006472025-12-19172025-12-27On time
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601102802026-01-17462025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601103432026-01-20492025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.002CLAY AYO 52#2606101794852512100072025-12-022025-12-026,000,000435––––2025-12-09Overdue
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601104142026-01-23522025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601105402026-01-29582025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601102812026-01-17462025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2512105762025-12-29272025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601103952026-01-22512025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2512106192025-12-31292025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601100072026-01-05342025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601101542026-01-10392025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601106172026-02-03632025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.002CLAY AYO 52#2606101794852512100072025-12-022025-12-026,000,000435––––2025-12-09Overdue
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601105652026-01-31602025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601106162026-02-03632025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601103482026-01-20492025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601102852026-01-17462025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601100532026-01-06352025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601105642026-01-31602025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601102882026-01-17462025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601106182026-02-03632025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601104632026-01-27562025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601101532026-01-10392025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601101522026-01-10392025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601103442026-01-20492025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601103932026-01-22512025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601103852026-01-21502025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601104152026-01-23522025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601102162026-01-13422025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601100062026-01-05342025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601103942026-01-22512025-12-09Late
← PrevPage 13 of 270Next →Rows per page:1020501005001000