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
2512000012025-12-01SPAREPART5030.17558114202401 PIGNONE Z=20 P=1/2"” LR=28 DDI=47-43-47251200406566,4382512004062025-12-222025-12-222566,438212603004202026-03-10782025-12-29Late
2512000012025-12-01SPAREPART5030.17558114202401 PIGNONE Z=20 P=1/2"” LR=28 DDI=47-43-47251200406566,4382512004062025-12-222025-12-222566,43821–––2025-12-29Overdue
2512000012025-12-01SPAREPART5030.0322SHAPED GUIDE IN POLIZENE C8125031630 | DI=221.18X2212603000511,837,7172512004062025-12-222025-12-2221,606,45421–––2025-12-29Overdue
2512000012025-12-01SPAREPART5030.17538320883502 SUPPORTO BARRA VENTOSE DI=50X40X42251200406171,7882512004062025-12-222025-12-224171,788212603004202026-03-10782025-12-29Late
2512000012025-12-01SPAREPART5030.0322SHAPED GUIDE IN POLIZENE C8125031630 | DI=221.18X2212603000511,837,7172512004062025-12-222025-12-2221,606,454212603004202026-03-10782025-12-29Late
2512000012025-12-01SPAREPART5030.17538320883502 SUPPORTO BARRA VENTOSE DI=50X40X42251200406171,7882512004062025-12-222025-12-224171,78821–––2025-12-29Overdue
2512000012025-12-01SPAREPART5030.0702SUPPORT / PLATE SALD. "L" C8321266200 DI=140X130X70 4F DF12512004061,339,4862512004062025-12-222025-12-2241,339,486212601017162026-02-18582025-12-29Late
2512000012025-12-01SPAREPART5030.0498CYLINDER C9660103359 / SMC CDQ2B32-75 DCMZ260500172663,3812512004062025-12-222025-12-224640,338212601001682026-01-07162025-12-29Late
2512000252025-12-01SPAREPART5029.0006PRESSURE GAUGE 25 BAR251200421210,0002512004212025-12-222026-01-102210,000212601018792026-02-23632026-01-17Late
2512000842025-12-03SPAREPART5030.0793MODULE INDEXER 8AXLE / NPN STEPPER MOTOR V E590551001825120040668,715,3942512004062025-12-222025-12-22168,715,394192601017162026-02-18582025-12-29Late
2512000842025-12-03SPAREPART5032.1416MOLLA RICHIAMO PINZA C9999150027251200406285,5402512004062025-12-222025-12-223285,540192603004202026-03-10782025-12-29Late
2512000842025-12-03SPAREPART5032.1416MOLLA RICHIAMO PINZA C9999150027251200406285,5402512004062025-12-222025-12-223285,54019–––2025-12-29Overdue
2512000842025-12-03SPAREPART5030.1761ROLLER BEARING 9213502201251200406821,7992512004062025-12-222025-12-224821,799192601017162026-02-18582025-12-29Late
2512000842025-12-03SPAREPART5030.176ROLLER BEARING 9213502202251200406870,5502512004062025-12-222025-12-224870,550192601006572026-01-20292025-12-29Late
2512001362025-12-06SPAREPART5011.0551BEARING 32017 FAG251200425425,0002512004252025-12-222025-12-2910425,000162601001872026-01-07162026-01-05Late
2512001362025-12-06SPAREPART5011.0551BEARING 32017 FAG251200425425,0002512004252025-12-222025-12-2910425,000162512008782025-12-2642026-01-05On time
2512001362025-12-06SPAREPART5011.055BEARING 32019 FAG251200425530,0002512004252025-12-222025-12-295530,000162512008782025-12-2642026-01-05On time
2512001382025-12-06STATIONERY6010.0092FORM LAPORAN PENGISIAN BALL MILL25120042412,5002512004242025-12-222025-12-301012,500162512009772025-12-3082026-01-06On time
2512001382025-12-06STATIONERY6010.0074FORM LAPORAN DAFTAR KELUAR/MASUK DAN STOCK BAHAN POWDER26040015723,0002512004242025-12-222025-12-301023,000162512009772025-12-3082026-01-06On time
2512001382025-12-06STATIONERY6010.0117FORM LAPORAN PEMAKIAN NOZZEL ATM 7.00025120042412,5002512004242025-12-222025-12-30512,500162512009772025-12-3082026-01-06On time
2512001382025-12-06STATIONERY6010.0093FORM LAPORAN PEMAKAIAN NOZEL ATM 10.00026010014812,5002512004242025-12-222025-12-30512,500162512009772025-12-3082026-01-06On time
2512001382025-12-06STATIONERY6010.0045FORM TEST GRANULASI POWDER ATM 10000 100025120042410,0002512004242025-12-222025-12-302010,000162512009772025-12-3082026-01-06On time
2512001382025-12-06STATIONERY6010.0059FORM LAPORAN FORMULA CODE MILLER WORK REPORT26030008212,5002512004242025-12-222025-12-30512,500162512009772025-12-3082026-01-06On time
2512001382025-12-06STATIONERY6010.0086FORM LAPORAN SILO ATM 1000026050039412,0002512004242025-12-222025-12-301012,500162512009772025-12-3082026-01-06On time
2512001382025-12-06STATIONERY6010.0065FORM LAPORAN HARIAN PEKERJAAN SPRAY DRYER ATM 1000026030008212,5002512004242025-12-222025-12-30512,500162512009772025-12-3082026-01-06On time
2512001382025-12-06STATIONERY6010.0048LAPORAN HARIAN SRAY DRYER BATU BARA ATM 10000 LAPORAN HARIAN SRAY DRYER BATU BARA25120042423,0002512004242025-12-222025-12-301023,000162512009772025-12-3082026-01-06On time
2512001712025-12-10PERSEDIAAN UMUM6030.0612RESIBON POTONG 16X1/8X1 INCH26010023657,162.162512003982025-12-222025-12-221054,009.01122512007822025-12-2312025-12-29On time
2512001712025-12-10PERSEDIAAN UMUM6030.0612RESIBON POTONG 16X1/8X1 INCH26010023657,162.162512003982025-12-222025-12-221054,009.01122512008232025-12-2422025-12-29On time
2512001912025-12-11PERSEDIAAN UMUM6030.062KUAS 2 INCH2605004405,794.62512004132025-12-222025-12-22207,702.7112512008752025-12-2642025-12-29On time
2512001912025-12-11PERSEDIAAN UMUM6030.0621KUAS 3 INCH2605004409,127.932512004132025-12-222025-12-222011,531.53112512008752025-12-2642025-12-29On time
2512001912025-12-11PERSEDIAAN UMUM6030.0622KUAS 4 INCH26050044015,405.412512004132025-12-222025-12-222018,603.6112512008752025-12-2642025-12-29On time
2512001922025-12-11PERSEDIAAN UMUM6050.0086SARUNG TANGAN LAS26051009322,5232512004012025-12-222025-12-22572,000112512008642025-12-2642025-12-29On time
2512001922025-12-11PERSEDIAAN UMUM6050.0059SARUNG TANGAN26060016817,6002512004012025-12-222025-12-221020,500112512008642025-12-2642025-12-29On time
2512001922025-12-11PERSEDIAAN UMUM6050.0526STANG LAS 800 AMP26050044772,072.072512004122025-12-222025-12-221072,072.07112512008722025-12-2642025-12-29On time
2512001952025-12-11PERSEDIAAN UMUM6030.0642KACA LAS BENING2606100226752512004132025-12-222025-12-22201,171.17112512008732025-12-2642025-12-29On time
2512001952025-12-11PERSEDIAAN UMUM6030.053LEM SILICON CLEAR 300ML26050049227,027.032512004132025-12-222025-12-221526,126.13112512008732025-12-2642025-12-29On time
2512001952025-12-11PERSEDIAAN UMUM6030.0632KACA LAS HITAM2605004902,702.72512004132025-12-222025-12-22202,702.7112512008732025-12-2642025-12-29On time
2512001952025-12-11PERSEDIAAN UMUM6030.0936REFILL KUAS ROLL KECIL 110MM (ACE OLDFIELD)2605003005,518.022512004002025-12-222025-12-22259,000112512008202025-12-2422025-12-29On time
2512001952025-12-11PERSEDIAAN UMUM6030.0529LEM SILICON RED 85 GR26050049222,522.522512004132025-12-222025-12-22518,018.02112512008732025-12-2642025-12-29On time
2512002302025-12-12BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752512004032025-12-222025-12-3080,0007,342.5102601000762026-01-03122026-01-06On time
2512002302025-12-12BAHAN BAKU GLAZE1030.0025TITANIUM FRIT K - 08102606000417,898.752512004032025-12-222025-12-3080,0007,342.5102512010392025-12-3192026-01-06On time
2512002702025-12-16PERSEDIAAN UMUM6060.0418MESIN JET CLEANER MTMASAKI TEKANAN TINGGI WASHER MT-1800 STEAM TEKANAN TINGGI2512004221,400,0002512004222025-12-222026-01-1511,400,00062512009312025-12-2972026-01-22On time
2512002972025-12-17PERSEDIAAN UMUM6060.0317AS DRAT SS M 16260100941136,0002512004262025-12-222025-12-304136,00052601000542026-01-02112026-01-06On time
2512003102025-12-19BAHAN PEMBANTU2034.0006HOTMELT GLUE GM811E26060001683,0002512004052025-12-222026-01-301,20083,00032603001972026-03-05732026-02-06Late
2512003102025-12-19BAHAN PEMBANTU2034.0006HOTMELT GLUE GM811E26060001683,0002512004052025-12-222026-01-301,20083,00032601018102026-02-20602026-02-06Late
2512003102025-12-19BAHAN PEMBANTU2034.0006HOTMELT GLUE GM811E26060001683,0002512004052025-12-222026-01-301,20083,00032603007972026-03-18862026-02-06Late
2512003112025-12-19BAHAN BAKU GLAZE1098.0006PS-800026060027620,060.62512003922025-12-222026-01-3017,00018,360.132512009572025-12-2972026-02-06On time
2512003112025-12-19BAHAN BAKU GLAZE1098.0006PS-800026060027620,060.62512003922025-12-222026-01-3017,00018,360.132601001502026-01-06152026-02-06On time
2512003132025-12-18BAHAN BAKU BODY1010.0003FELDSPAR (KC-06)2606000121502512004092025-12-222026-01-207,500,0001404–––2026-01-27Overdue
2512003142025-12-19BAHAN BAKU BODY1010.003PASIR KUARSA (LASEM) (SELOJOYO)2606000101442512003962025-12-222026-01-221,300,00013632601009352026-01-27362026-01-29On time
← PrevPage 42 of 270Next →Rows per page:1020501005001000