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–2601102122026-01-13422025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512102212025-12-1192025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512105462025-12-27252025-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.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512102992025-12-15132025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512103232025-12-16142025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.002CLAY AYO 52#2606101794852512100072025-12-022025-12-026,000,000435–2601102322026-01-13422025-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.002CLAY AYO 52#2606101794852512100072025-12-022025-12-026,000,000435––––2025-12-09Overdue
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512104772025-12-23212025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512105442025-12-27252025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.002CLAY AYO 52#2606101794852512100072025-12-022025-12-026,000,000435–2601100612026-01-07362025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512102532025-12-12102025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512104762025-12-23212025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.002CLAY AYO 52#2606101794852512100072025-12-022025-12-026,000,000435–2601100632026-01-07362025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512102292025-12-1192025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512103612025-12-18162025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512102232025-12-1192025-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.002CLAY AYO 52#2606101794852512100072025-12-022025-12-026,000,000435–2512102112025-12-1082025-12-09Late
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–2601105372026-01-29582025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2512104132025-12-19172025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512105602025-12-27252025-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–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.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512103422025-12-16142025-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.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–2512105482025-12-27252025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2512105092025-12-24222025-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.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512103392025-12-16142025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601100882026-01-08372025-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.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512101782025-12-0972025-12-09On time
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601100902026-01-08372025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512103522025-12-17152025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601102112026-01-13422025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512105492025-12-27252025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512105622025-12-27252025-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–2601104732026-01-28572025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512102272025-12-1192025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601104702026-01-28572025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512103552025-12-17152025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512103972025-12-19172025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512103382025-12-16142025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601105502026-01-30592025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601104752026-01-28572025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512102542025-12-12102025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601105602026-01-31602025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512103212025-12-16142025-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–2512101922025-12-1082025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601102152026-01-13422025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601102182026-01-13422025-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–2512105902025-12-30282025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2512104812025-12-23212025-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–2512105612025-12-27252025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601102822026-01-17462025-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–2601105592026-01-31602025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601102902026-01-17462025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512102242025-12-1192025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601102872026-01-17462025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601102952026-01-17462025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601100082026-01-05342025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2512105892025-12-30282025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512101822025-12-0972025-12-09On time
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.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–2601102982026-01-17462025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601105632026-01-31602025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601104802026-01-28572025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601102082026-01-13422025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512103252025-12-16142025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512103412025-12-16142025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601104812026-01-28572025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512104072025-12-19172025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601100012026-01-02312025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512102692025-12-12102025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512104492025-12-20182025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512102682025-12-12102025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512104752025-12-23212025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512103502025-12-17152025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601102102026-01-13422025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2512104482025-12-20182025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601102202026-01-13422025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601102842026-01-17462025-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–2601102072026-01-13422025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2512104142025-12-19172025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512101842025-12-0972025-12-09On time
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–2601103352026-01-20492025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512101952025-12-1082025-12-09Late
← PrevPage 9 of 135Next →Rows per page:1020501005001000