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
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601104922026-01-28572025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2512104172025-12-19172025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601102982026-01-17462025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601102072026-01-13422025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601102962026-01-17462025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601105372026-01-29582025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601105382026-01-29582025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601102142026-01-13422025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512102082025-12-1082025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601104732026-01-28572025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601102912026-01-17462025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601101322026-01-09382025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601104872026-01-28572025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601104712026-01-28572025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601105392026-01-29582025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601103382026-01-20492025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601101302026-01-09382025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601104892026-01-28572025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601106142026-02-03632025-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–2601102092026-01-13422025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601103842026-01-21502025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601104822026-01-28572025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601104852026-01-28572025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408––––2025-12-09Overdue
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512103952025-12-19172025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601104612026-01-27562025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601104602026-01-27562025-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––––2025-12-09Overdue
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468––––2025-12-09Overdue
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601104172026-01-23522025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512101952025-12-1082025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512104082025-12-19172025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601104862026-01-28572025-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–2601106152026-02-03632025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512102252025-12-1192025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601105932026-02-02622025-12-09Late
2511003472025-11-21PERSEDIAAN UMUM6020.0052STOPWATCH260600222200,2502512000322025-12-032025-12-153168,833.33122512001142025-12-0522025-12-22On time
2511003592025-11-22PERSEDIAAN UMUM6050.042KUNCI RING PAS 27 MM26040001887,567.572512000402025-12-032025-12-15187,567.57112512002492025-12-0962025-12-22On time
2511003592025-11-22PERSEDIAAN UMUM6050.0375OBENG(+)() 6 INCH(+)25120004030,765.772512000402025-12-032025-12-15130,765.77112512002492025-12-0962025-12-22On time
2511003732025-11-25SPAREPART5021.0412V. BELT B - 154260500209122,9002512000352025-12-032025-12-2212111,90082512001352025-12-0522025-12-29On time
2511003732025-11-25SPAREPART5021.0412V. BELT B - 154260500209122,9002512000352025-12-032025-12-2212111,90082512006152025-12-18152025-12-29On time
2511003742025-11-25SPAREPART5026.0014PURITY WIPES 9" X 9" 90008614 (1 PACK = 100 SHEETS)260400181280,2502512000442025-12-032025-12-103280,25082512004312025-12-13102025-12-17On time
2511003952025-11-25PERSEDIAAN UMUM6030.2421PVC STRIP CURTAIN BLUE CLEAR 2MM X 200MM X 50M2606002641,450,0002512000482025-12-032025-12-03101,450,00082512005052025-12-16132025-12-10Late
2511003992025-11-25PERSEDIAAN UMUM6050.011PLASTIK KANTONG 1/4 KG2512000299,0002512000292025-12-032025-12-1569,00082512001132025-12-0522025-12-22On time
2511004282025-11-28SPAREPART5019.0268GEAR REDUCER MNRV 050 RATIO 1:15 0.75 KW FLANGE B52512000423,062,5002512000422025-12-032025-12-1823,062,50052512004422025-12-13102025-12-25On time
2511004282025-11-28SPAREPART5011.0279BEARING UCP 206260400546120,3002512000412025-12-032025-12-176127,00052512001362025-12-0522025-12-24On time
2511004292025-11-28PERSEDIAAN UMUM6030.0487THINER A SPECIAL26040029850,7002512000542025-12-032025-12-175031,605.0552512002452025-12-0962025-12-24On time
← PrevPage 19 of 270Next →Rows per page:1020501005001000