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.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512105532025-12-27252025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512105432025-12-27252025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601101912026-01-12412025-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.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512103092025-12-16142025-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.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512102202025-12-1192025-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.002CLAY AYO 52#2606101794852512100072025-12-022025-12-026,000,000435–2512101642025-12-0972025-12-09On time
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601100872026-01-08372025-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.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512102262025-12-1192025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512101832025-12-0972025-12-09On time
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.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601105462026-01-30592025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512102502025-12-12102025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601100112026-01-05342025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512103602025-12-18162025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2601103562026-01-20492025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512105502025-12-27252025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512103102025-12-16142025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512102282025-12-1192025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512103112025-12-16142025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512102982025-12-15132025-12-09Late
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.0028FELDSPAR FLNH 43# BATU2605102125082512100082025-12-022025-12-025,000,000468–2601103452026-01-20492025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.002CLAY AYO 52#2606101794852512100072025-12-022025-12-026,000,000435–2512103592025-12-17152025-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.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–2512104752025-12-23212025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512103622025-12-18162025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512102032025-12-1082025-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.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512103532025-12-17152025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512103402025-12-16142025-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.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512105472025-12-27252025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512105512025-12-27252025-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–2512104772025-12-23212025-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.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512102232025-12-1192025-12-09Late
2512100042025-12-02BAHAN BAKU BODY1010.0027FELDSPAR FLNH 42# LUPUKAN2605102124402512100082025-12-022025-12-023,000,000408–2512103002025-12-15132025-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.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–2512102532025-12-12102025-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.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–2601100082026-01-05342025-12-09Late
← PrevPage 17 of 270Next →Rows per page:1020501005001000