KKobin GroupProcurement KPI

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
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812603104122026-03-31812026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812605100212026-05-041152026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812603101572026-03-09592026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601108242026-02-10322026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601108202026-02-10322026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812605100222026-05-041152026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601112442026-02-28502026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601108572026-02-12342026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601108582026-02-12342026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601108622026-02-12342026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604100152026-04-02832026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812603101562026-03-09592026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601111032026-02-23452026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601111552026-02-25472026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812603102932026-03-16662026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604101972026-04-11922026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601110412026-02-20422026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604103962026-04-211022026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601112172026-02-27492026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812603102552026-03-13632026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812603102352026-03-12622026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604101582026-04-09902026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601111592026-02-25472026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601112142026-02-27492026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604103032026-04-16972026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601110432026-02-20422026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604103952026-04-211022026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604103582026-04-201012026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812605104642026-05-181292026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601108212026-02-10322026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604104262026-04-221032026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604104222026-04-211022026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604100332026-04-04852026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604100312026-04-04852026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604100302026-04-04852026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601110982026-02-21432026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812603101982026-03-11612026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604103572026-04-201012026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812603101992026-03-11612026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601110972026-02-21432026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812603101942026-03-11612026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604103552026-04-201012026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604103562026-04-201012026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604103992026-04-211022026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601111582026-02-25472026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812605100192026-05-041152026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812603101962026-03-11612026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601110422026-02-20422026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812603101932026-03-11612026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604104212026-04-211022026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604104232026-04-211022026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604102002026-04-11922026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601111232026-02-24462026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604102312026-04-14952026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601111242026-02-24462026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604101602026-04-09902026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604101142026-04-07882026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812603102842026-03-16662026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604103972026-04-211022026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812603101542026-03-09592026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604104272026-04-221032026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604103982026-04-211022026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601109002026-02-14362026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601108982026-02-14362026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812605100142026-05-041152026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601108632026-02-12342026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601110992026-02-23452026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812603102062026-03-11612026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812605101942026-05-111222026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812603102892026-03-16662026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601110932026-02-21432026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601109432026-02-16382026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601110892026-02-21432026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601110882026-02-21432026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601111252026-02-24462026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604100202026-04-04852026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812603102872026-03-16662026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812603102002026-03-11612026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604100192026-04-04852026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601111042026-02-23452026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604101512026-04-09902026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601108192026-02-10322026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604102942026-04-15962026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604101952026-04-11922026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601110462026-02-20422026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812605100152026-05-041152026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604101562026-04-09902026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812603100442026-03-03532026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812603102012026-03-11612026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604101062026-04-07882026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601108672026-02-12342026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601109452026-02-16382026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604100212026-04-04852026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604101152026-04-07882026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604101982026-04-11922026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604103522026-04-201012026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604103532026-04-201012026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812603102362026-03-12622026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601108182026-02-10322026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812026-01-16Overdue
← PrevPage 37 of 135Next →Rows per page:1020501005001000