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
2512001792025-12-10BAHAN PEMBANTU2045.0006PALLET EXPORT 95*110*13 CM26060011277,0002512002102025-12-112025-12-261,50074,00012601002082026-01-08282026-01-02Late
2512001792025-12-10BAHAN PEMBANTU2045.0006PALLET EXPORT 95*110*13 CM26060011277,0002512002102025-12-112025-12-261,50074,0001–––2026-01-02Overdue
2512001792025-12-10BAHAN PEMBANTU2045.0006PALLET EXPORT 95*110*13 CM26060011277,0002512002102025-12-112025-12-261,50074,00012512004762025-12-1542026-01-02On time
2512001792025-12-10BAHAN PEMBANTU2045.0006PALLET EXPORT 95*110*13 CM26060011277,0002512002102025-12-112025-12-261,50074,0001–––2026-01-02Overdue
2512001792025-12-10BAHAN PEMBANTU2045.0006PALLET EXPORT 95*110*13 CM26060011277,0002512002102025-12-112025-12-261,50074,00012512005382025-12-1652026-01-02On time
2512001792025-12-10BAHAN PEMBANTU2045.0006PALLET EXPORT 95*110*13 CM26060011277,0002512002102025-12-112025-12-261,50074,00012601002902026-01-10302026-01-02Late
2512001792025-12-10BAHAN PEMBANTU2045.0006PALLET EXPORT 95*110*13 CM26060011277,0002512002102025-12-112025-12-261,50074,00012601004612026-01-14342026-01-02Late
2512001822025-12-11FIXED ASSETSAST02544SEPEDA LISTRIK D65 UWINFLY2512002003,250,0002512002002025-12-112025-12-1153,250,000–2512008362025-12-24132025-12-18Late
2512001842025-12-11PERSEDIAAN UMUM6030.0804AVIAN CLING SYNTHETIC 91 - KERAK ABU26030036945,905.252512002012025-12-112025-12-1120145,905.25–2512010212025-12-31202025-12-18Late
2512001842025-12-11PERSEDIAAN UMUM6030.0804AVIAN CLING SYNTHETIC 91 - KERAK ABU26030036945,905.252512002012025-12-112025-12-1120145,905.25–2512009172025-12-27162025-12-18Late
2512001852025-12-11PERSEDIAAN UMUM6030.0515CAT BESI AVIAN LEMONADE 48026060017170,725.232512002012025-12-112025-12-111862,868.13–2512010212025-12-31202025-12-18Late
2512001862025-12-11PERSEDIAAN UMUM6030.0515CAT BESI AVIAN LEMONADE 48026060017170,725.232512002012025-12-112025-12-1150.462,868.13–2512010212025-12-31202025-12-18Late
2512001862025-12-11PERSEDIAAN UMUM6030.0515CAT BESI AVIAN LEMONADE 48026060017170,725.232512002012025-12-112025-12-1150.462,868.13–2512009172025-12-27162025-12-18Late
2512001872025-12-11PERSEDIAAN UMUM6030.2458CAT AVIAN SYNTHETIC 1942604101321,219,5812512002012025-12-112025-12-1121.662,868.13–2512010212025-12-31202025-12-18Late
2512001872025-12-11PERSEDIAAN UMUM6030.2458CAT AVIAN SYNTHETIC 1942604101321,219,5812512002012025-12-112025-12-1121.662,868.13–2512009172025-12-27162025-12-18Late
2512100022025-12-01STATIONERY6010.0595KERTAS SAMSON UK. F4 75 GR (21,5 X 33 CM) WARNA COKLAT251210082130,0002512100822025-12-112025-12-201130,00010–––2025-12-27Overdue
2512100222025-12-08PERSEDIAAN UMUM6050.1102LEM RUBBER SUNPAT - S + HARDENER BANDO @ 1 KG U/ SAMBUNG CONVEYOR260410059529,5002512100642025-12-112025-12-225529,50032512103162025-12-1652025-12-29On time
2512100272025-12-09PERSEDIAAN UMUM6050.1172SEPATU SAFETY LOW (PENDEK) CEWEK NO.37251210063355,0002512100632025-12-112025-12-221355,00022512103132025-12-1652025-12-29On time
2512100272025-12-09PERSEDIAAN UMUM6050.1125SEPATU SAFETY LOW (PENDEK) NO.43251210063320,0002512100632025-12-112025-12-221320,00022512103132025-12-1652025-12-29On time
2512100272025-12-09PERSEDIAAN UMUM6050.1127SEPATU SAFETY LOW (PENDEK) NO.45251210135320,0002512100632025-12-112025-12-221320,00022512103132025-12-1652025-12-29On time
2512100272025-12-09PERSEDIAAN UMUM6050.1129SEPATU SAFETY LOW (PENDEK) CEWEK NO.39251210063355,0002512100632025-12-112025-12-222355,00022512103132025-12-1652025-12-29On time
2512100272025-12-09PERSEDIAAN UMUM6050.1123SEPATU SAFETY LOW (PENDEK) NO.41251210135320,0002512100632025-12-112025-12-221320,00022512103132025-12-1652025-12-29On time
2511004332025-11-28SPAREPART5023.0842CYLINDER SPC 40X50251200252375,0002512002522025-12-122025-12-293375,000142512007072025-12-22102026-01-05On time
2511004742025-11-29PERSEDIAAN UMUM6050.0082REFILL PENGHARUM RUANGAN26030016956,3002512003292025-12-122025-12-23134,300132512007352025-12-22102025-12-30On time
2511004742025-11-29PERSEDIAAN UMUM6050.0082REFILL PENGHARUM RUANGAN26030016956,3002512003292025-12-122025-12-23329,500132512007352025-12-22102025-12-30On time
2511004742025-11-29PERSEDIAAN UMUM6050.0082REFILL PENGHARUM RUANGAN26030016956,3002512003292025-12-122025-12-23229,500132512007352025-12-22102025-12-30On time
2511004742025-11-29PERSEDIAAN UMUM6050.0082REFILL PENGHARUM RUANGAN26030016956,3002512003292025-12-122025-12-23229,500132512007352025-12-22102025-12-30On time
2511004742025-11-29PERSEDIAAN UMUM6050.0082REFILL PENGHARUM RUANGAN26030016956,3002512003292025-12-122025-12-23129,500132512007352025-12-22102025-12-30On time
2511004742025-11-29PERSEDIAAN UMUM6050.0082REFILL PENGHARUM RUANGAN26030016956,3002512003292025-12-122025-12-231029,500132512007352025-12-22102025-12-30On time
2511004742025-11-29PERSEDIAAN UMUM6050.0082REFILL PENGHARUM RUANGAN26030016956,3002512003292025-12-122025-12-23161,000132512007352025-12-22102025-12-30On time
2511004742025-11-29PERSEDIAAN UMUM6050.0082REFILL PENGHARUM RUANGAN26030016956,3002512003292025-12-122025-12-2339,000132512007352025-12-22102025-12-30On time
2512000262025-12-01PERSEDIAAN UMUM6050.0588BODY HARNESS260300062350,0002512002272025-12-122025-12-262275,000112512007202025-12-22102026-01-02On time
2512000572025-12-01BAHAN BAKU GLAZE1099.0017KAOLIN POWDER MESH 3252606001901,8972512002332025-12-122026-01-1050,0001,640112601012242026-02-04542026-01-17Late
2512000572025-12-01BAHAN BAKU GLAZE1099.0017KAOLIN POWDER MESH 3252606001901,8972512002332025-12-122026-01-1050,0001,640112601012232026-02-04542026-01-17Late
2512000572025-12-01BAHAN BAKU GLAZE1099.0017KAOLIN POWDER MESH 3252606001901,8972512002322025-12-122026-01-0575,0001,575112512010072025-12-30182026-01-12On time
2512000572025-12-01BAHAN BAKU GLAZE1099.0017KAOLIN POWDER MESH 3252606001901,8972512002322025-12-122026-01-0575,0001,575112601017982026-02-20702026-01-12Late
2512000572025-12-01BAHAN BAKU GLAZE1099.0017KAOLIN POWDER MESH 3252606001901,8972512002322025-12-122026-01-0575,0001,575112512009972025-12-30182026-01-12On time
2512000572025-12-01BAHAN BAKU GLAZE1099.0017KAOLIN POWDER MESH 3252606001901,8972512002322025-12-122026-01-0575,0001,575112512010382025-12-31192026-01-12On time
2512000732025-12-01BAHAN BAKU GLAZE1030.0026POTASSIUM FELDSPAR POWDER KN-2002605003162,720.562512002342025-12-122026-01-2581,0002,450.2112601007352026-01-22412026-02-01On time
2512000732025-12-01BAHAN BAKU GLAZE1030.0026POTASSIUM FELDSPAR POWDER KN-2002605003162,720.562512002342025-12-122026-01-2581,0002,450.2112512010052025-12-30182026-02-01On time
2512000732025-12-01BAHAN BAKU GLAZE1030.0026POTASSIUM FELDSPAR POWDER KN-2002605003162,720.562512002342025-12-122026-01-2581,0002,450.2112512010062025-12-30182026-02-01On time
2512000732025-12-01BAHAN BAKU GLAZE1030.0026POTASSIUM FELDSPAR POWDER KN-2002605003162,720.562512002342025-12-122026-01-2581,0002,450.211–––2026-02-01Overdue
2512000732025-12-01BAHAN BAKU GLAZE1030.0026POTASSIUM FELDSPAR POWDER KN-2002605003162,720.562512002342025-12-122026-01-2581,0002,450.2112512009982025-12-30182026-02-01On time
2512000862025-12-04SPAREPART5031.0017BALLVALVE 3 INCH ONDA2605004822,106,0002512002502025-12-122025-12-2711,980,00082512007162025-12-22102026-01-03On time
2512001032025-12-06PERSEDIAAN UMUM6030.0487THINER A SPECIAL26040029850,7002512002822025-12-122025-12-1220031,60562512008812025-12-26142025-12-19Late
2512001032025-12-06PERSEDIAAN UMUM6030.0487THINER A SPECIAL26040029850,7002512002822025-12-122025-12-1220031,60562512009932025-12-30182025-12-19Late
2512001212025-12-09PERSEDIAAN UMUM6050.0034LPG 50 KG2606001661,300,0002512002392025-12-122025-12-2231,020,00032512005232025-12-1642025-12-29On time
2512001442025-12-09PERSEDIAAN UMUM6020.0138KLEM SLANG 5 INCH26060017311,171.172512002472025-12-122025-12-171215,00032512005112025-12-1642025-12-24On time
2512001442025-12-09PERSEDIAAN UMUM6030.0804AVIAN CLING SYNTHETIC 91 - KERAK ABU26030036945,905.252512002462025-12-122025-12-225053,689.1932512005752025-12-1752025-12-29On time
2512001442025-12-09PERSEDIAAN UMUM6030.0804AVIAN CLING SYNTHETIC 91 - KERAK ABU26030036945,905.252512002462025-12-122025-12-225053,689.1932512005392025-12-1642025-12-29On time
← PrevPage 32 of 270Next →Rows per page:1020501005001000