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
2601100352026-01-19PERSEDIAAN UMUM6030.258PLAT POLOS 3MM260110227695,0002601102272026-01-302026-01-30100695,000112601107502026-02-09102026-02-06Late
2601100352026-01-19PERSEDIAAN UMUM6030.2581PLAT POLOS 16MM2601102273,735,0002601102272026-01-302026-01-30303,735,000112601107512026-02-09102026-02-06Late
2601100352026-01-19PERSEDIAAN UMUM6030.2582PLAT POLOS 10MM2601102272,350,0002601102272026-01-302026-01-30402,350,000112601107502026-02-09102026-02-06Late
2601100352026-01-19PERSEDIAAN UMUM6030.2579PLAT BORDES 3MM260110227815,0002601102272026-01-302026-01-30150815,000112601107512026-02-09102026-02-06Late
2601100352026-01-19PERSEDIAAN UMUM6030.2579PLAT BORDES 3MM260110227815,0002601102272026-01-302026-01-30150815,000112601107652026-02-09102026-02-06Late
2601100352026-01-19PERSEDIAAN UMUM6030.2578SIKU 60 4MM260110227300,0002601102272026-01-302026-01-3060300,000112601107512026-02-09102026-02-06Late
2601100352026-01-19PERSEDIAAN UMUM6050.0091BESI UNP U 100X6000 MM260610065475,0002601102272026-01-302026-01-30235475,000112601107512026-02-09102026-02-06Late
2601100352026-01-19PERSEDIAAN UMUM6050.0091BESI UNP U 100X6000 MM260610065475,0002601102272026-01-302026-01-30235475,000112601107652026-02-09102026-02-06Late
2601100352026-01-19PERSEDIAAN UMUM6050.0088BESI UNP K.S U 120X6000260110227840,0002601102272026-01-302026-01-3060840,000112601107512026-02-09102026-02-06Late
2601100352026-01-19PERSEDIAAN UMUM6030.2286H BEAM 2002601102277,825,0002601102272026-01-302026-01-3067,825,000112601107512026-02-09102026-02-06Late
2601100432026-01-21PERSEDIAAN UMUM6050.1076BESI BAKARAN UKURAN 40X40CM LIHAT GAMBAR / CONTOH2601102376502601102372026-01-302026-03-02265092605105672026-05-201102026-03-09Late
2601100512026-01-24PERSEDIAAN UMUM6030.2597WASTAFEL TOTO TYPE LW11CJW/F#W INCLUDE KERAN AIR TOTO2601102261,756,8002601102262026-01-302026-01-3011,756,80062601107412026-02-09102026-02-06Late
2601100512026-01-24PERSEDIAAN UMUM6030.2598FLASH URINIOR260110226918,0002601102262026-01-302026-01-301918,00062601107412026-02-09102026-02-06Late
2601100512026-01-24PERSEDIAAN UMUM6050.0608KUNCI INGGRIS 12 INCH26050048794,0002601102392026-01-302026-02-10253,20062601107342026-02-09102026-02-17On time
2601100572026-01-27PERSEDIAAN UMUM6030.1784WD POLES 4 INCHI2606100427,5002601102382026-01-302026-02-105007,50032601108492026-02-11122026-02-17On time
2601100582026-01-28PERSEDIAAN UMUM6050.0059SARUNG TANGAN26060016817,6002601102312026-01-302026-02-105022,50022601107262026-02-09102026-02-17On time
2601100582026-01-28PERSEDIAAN UMUM6050.0942MASKER KAIN2605102792,5002601102312026-01-302026-02-102002,50022601108472026-02-11122026-02-17On time
2601100582026-01-28PERSEDIAAN UMUM6030.1791WD CUTTING 4 INCH2606100423,3002601102312026-01-302026-02-10603,00022601108472026-02-11122026-02-17On time
2601100642026-01-29BAHAN BAKU BODY1040.0026PIGMENT BLACK X31 GUOSE2601102346.252601102342026-01-302026-01-308,0006.2512603101492026-03-09382026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2604101442026-04-08682026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601108122026-02-10112026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601109192026-02-16172026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601110032026-02-19202026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601106842026-02-0672026-02-06On time
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601109242026-02-16172026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601108072026-02-10112026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601109022026-02-14152026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601108692026-02-12132026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2604101462026-04-09692026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601106582026-02-0562026-02-06On time
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601110012026-02-19202026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601106562026-02-0562026-02-06On time
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601109322026-02-16172026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601110002026-02-19202026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601109282026-02-16172026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601110022026-02-19202026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601106852026-02-0672026-02-06On time
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601110722026-02-20212026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601109032026-02-14152026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601108112026-02-10112026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2604101502026-04-09692026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601110762026-02-20212026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601110752026-02-20212026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601109972026-02-19202026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601109932026-02-19202026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601109902026-02-19202026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601109922026-02-19202026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601109942026-02-19202026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2605101122026-05-07972026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601109232026-02-16172026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2604105372026-04-28882026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601109982026-02-19202026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601110832026-02-20212026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601109222026-02-16172026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601110642026-02-20212026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2604101422026-04-08682026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601109952026-02-19202026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601110742026-02-20212026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601109402026-02-16172026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601108082026-02-10112026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601110772026-02-20212026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601109412026-02-16172026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385––––2026-02-06Overdue
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601108062026-02-10112026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601108052026-02-10112026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2604103652026-04-20802026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601109342026-02-16172026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2604101492026-04-09692026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2604102582026-04-15752026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601109332026-02-16172026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601109422026-02-16172026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601109962026-02-19202026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2604101432026-04-08682026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601106612026-02-0562026-02-06On time
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601106832026-02-0672026-02-06On time
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601106672026-02-0672026-02-06On time
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601106822026-02-0672026-02-06On time
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601106692026-02-0672026-02-06On time
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601106682026-02-0672026-02-06On time
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601108022026-02-10112026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601106702026-02-0672026-02-06On time
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601106772026-02-0672026-02-06On time
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601106782026-02-0672026-02-06On time
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601106812026-02-0672026-02-06On time
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601106752026-02-0672026-02-06On time
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601106742026-02-0672026-02-06On time
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601106732026-02-0672026-02-06On time
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601106722026-02-0672026-02-06On time
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601106712026-02-0672026-02-06On time
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601107052026-02-0782026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601109362026-02-16172026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601106762026-02-0672026-02-06On time
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601106602026-02-0562026-02-06On time
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601108042026-02-10112026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601110622026-02-20212026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601108032026-02-10112026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601109912026-02-19202026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2603101302026-03-07362026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601109372026-02-16172026-02-06Late
2601100712026-01-30BAHAN BAKU BODY1010.0039BENTONITE CBP2606101443852601102352026-01-302026-01-304,000,000385–2601108712026-02-12132026-02-06Late
← PrevPage 55 of 135Next →Rows per page:1020501005001000