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
2512000992025-12-05BAHAN PACKING3011.025NFT00 60X60 KOBIN MP1 KW-B 606X45 (BK150/150/150)2604003306412512005012025-12-272026-01-3010,000545222601003282026-01-12162026-02-06On time
2512000992025-12-05BAHAN PACKING3011.0249NFT00 60X60 KOBIN MP2 KW-A 606X48 (WK150/150/150)2604003306822512005012025-12-272026-01-3040,000580222601002862026-01-10142026-02-06On time
2512000992025-12-05BAHAN PACKING3011.0248NFT00 60X60 KOBIN MP1 KW-A 606X45 (WK150/150/150)2604003307482512005012025-12-272026-01-3040,000635222601002862026-01-10142026-02-06On time
2512002392025-12-13SPAREPART5030.1453AS JARI-JARI PACKING NOUVAFIMA251200514350,0002512005142025-12-272026-01-3010350,000142601006652026-01-20242026-02-06On time
2512002392025-12-13SPAREPART5030.1454SOCK JARI-JARI PACKING NOUVAFIMA251200514300,0002512005142025-12-272026-01-3010300,000142601006652026-01-20242026-02-06On time
2512002392025-12-13SPAREPART5030.1455SHAFT SEGI ENAM DRAT251200514190,0002512005142025-12-272026-01-3010190,000142601003972026-01-13172026-02-06On time
2512003352025-12-19BAHAN BAKAR4040.0002MEDITRAN S40 SAE 4026060022037,070.562512004962025-12-272026-01-1041827,655.582601000032026-01-0262026-01-17On time
2512003352025-12-19BAHAN BAKAR4040.0009OIL CALTEX TEXAMATIC 188826050034857,5002512005272025-12-272026-01-1020049,00082601000042026-01-0262026-01-17On time
2512004052025-12-26PERSEDIAAN UMUM6030.062KUAS 2 INCH2605004405,794.62512005122025-12-272026-01-05410,00012601000612026-01-0262026-01-12On time
2512004052025-12-26PERSEDIAAN UMUM6050.0062KANEBO26061008012,0002512005122025-12-272026-01-051020,00012601000612026-01-0262026-01-12On time
2512004052025-12-26PERSEDIAAN UMUM6030.0622KUAS 4 INCH26050044015,405.412512005122025-12-272026-01-05420,00012601000612026-01-0262026-01-12On time
2512004052025-12-26PERSEDIAAN UMUM6050.0042KUAS ROLL KECIL26050030014,881.082512005122025-12-272026-01-05120,00012601000612026-01-0262026-01-12On time
2512004052025-12-26PERSEDIAAN UMUM6030.0775KUAS ROLL BESAR25120051235,0002512005122025-12-272026-01-05135,00012601000612026-01-0262026-01-12On time
2512004052025-12-26PERSEDIAAN UMUM6030.0621KUAS 3 INCH2605004409,127.932512005122025-12-272026-01-05415,00012601000612026-01-0262026-01-12On time
2512004122025-12-26STATIONERY6010.0249ISOLASI KERTAS KECIL2603005392,3002512005092025-12-272026-01-07125,00012512009952025-12-3032026-01-14On time
2512004152025-12-26BAHAN BAKAR4030.001DAPHNE SUPER HYDRO 46 (IDEMITSU)26060022462,2502512005102025-12-272026-01-1040041,50012601000502026-01-0262026-01-17On time
2512004172025-12-26PERSEDIAAN UMUM6050.0034LPG 50 KG2606001661,300,0002512005112025-12-272026-01-0521,000,00012601000622026-01-0262026-01-12On time
2512004182025-12-26PERSEDIAAN UMUM6030.2501TONGKAT ROLL CAT26010015360,0002512005152025-12-272026-01-10360,00012512009962025-12-3032026-01-17On time
2512004192025-12-26STATIONERY6010.0083FORM COUNTER FR-PROD-0626040015710,0002512005592025-12-272026-01-101010,00012601001212026-01-06102026-01-17On time
2512004192025-12-26STATIONERY6010.0039FORM GLAZING LINE CONTROL REPORT FR-PROD-04 A4, FR-PROD-0426050039412,0002512005592025-12-272026-01-101012,50012601001212026-01-06102026-01-17On time
2512004282025-12-26PERSEDIAAN UMUM6030.0804AVIAN CLING SYNTHETIC 91 - KERAK ABU26030036945,905.252512005052025-12-272025-12-2720045,905.2512601003492026-01-12162026-01-03Late
2512004282025-12-26PERSEDIAAN UMUM6030.0804AVIAN CLING SYNTHETIC 91 - KERAK ABU26030036945,905.252512005052025-12-272025-12-2720045,905.2512601000942026-01-0592026-01-03Late
2512100302025-12-10PERSEDIAAN UMUM6050.1174NOZZLE CLEANER25121014013,0002512101402025-12-272026-01-06113,000172601100952026-01-08122026-01-13On time
2512100602025-12-20PERSEDIAAN UMUM6030.0613METERAN 5 MTR2605101569,3632512101412025-12-272026-01-06214,22072512106112025-12-3032026-01-13On time
2512100682025-12-24PERSEDIAAN UMUM6050.0757KACAMATA SAFETY2601103956,9352512101422025-12-272026-01-0635,83332512106072025-12-3032026-01-13On time
2512100702025-12-26SPAREPART5026.0248CLEANER DE=765X32X12 PBT 0.60 SUPP. PVC 900068072512101441,806,1012512101442025-12-272025-12-2751,806,10112601104492026-01-27312026-01-03Late
2512100702025-12-26SPAREPART5026.018560000809 PRINT HEAD (SG1024-LC-HF-MF)PN 2100309925121014469,148,0002512101442025-12-272025-12-27369,148,00012601104492026-01-27312026-01-03Late
2512100702025-12-26SPAREPART5026.0247SQUEEGE H=27.5 L=201 TH=2 80057444251210144383,0422512101442025-12-272025-12-278383,04212601104492026-01-27312026-01-03Late
2512100702025-12-26SPAREPART5027.02FILTRO INDRAULICO POLIPROPILENE 9680100026 / CAA20PN02251210144260,0002512101442025-12-272025-12-2748260,00012601104492026-01-27312026-01-03Late
2512100702025-12-26SPAREPART5017.1054MODULO BRIDGE AURORA SU FIBRA OTTICA25121014415,228,8172512101442025-12-272025-12-27115,228,81712601104492026-01-27312026-01-03Late
2512100702025-12-26SPAREPART5017.1052MODULO COREXPRESS (CPU i7-9850HE SECO) 10GbE NO I/O LINUX251210144204,985,4482512101442025-12-272025-12-271204,985,44812601104492026-01-27312026-01-03Late
2512100702025-12-26SPAREPART5026.0246SQUEEGE H=45 L=1066 TH=10 800625022512101441,188,5912512101442025-12-272025-12-2741,188,59112601104492026-01-27312026-01-03Late
2512100702025-12-26SPAREPART5017.1053MODULO COREXPRESS (CPU i7-9850HE SECO) NO I/O LINUX251210144182,002,9342512101442025-12-272025-12-271182,002,93412601104492026-01-27312026-01-03Late
2512100702025-12-26SPAREPART5026.0245DL-G6 DEGASSING MEMBRANE (PMP) – CONN. F 900296352512101446,230,0002512101442025-12-272025-12-2756,230,00012601104492026-01-27312026-01-03Late
2512100702025-12-26SPAREPART5026.0013FILTRO INDRAULICO POLIPROPILENE 9680100025 / CAA10PN02251210144260,0002512101442025-12-272025-12-2748260,00012601104492026-01-27312026-01-03Late
2511004442025-11-28SPAREPART5030.0033PULLEY C8112106904 || SEZ.B D=60 LR=19 DDF=25-30260100122201,5742512005202025-12-292026-02-28105312605000762026-05-041262026-03-07Late
2511004442025-11-28SPAREPART5030.0505SPACER C811163260326030005136,8422512005202025-12-292026-02-28151.25312605000762026-05-041262026-03-07Late
2511004442025-11-28SPAREPART5030.1387CLAMP 832053140326030014310.212512005202025-12-292026-02-28103531–––2026-03-07Overdue
2511004442025-11-28SPAREPART5030.0026PULLEY / PULEG PER CINGH TONDA D=38 LR=17 C8112404203260500361274,0052512005202025-12-292026-02-282011312605000762026-05-041262026-03-07Late
2511004442025-11-28SPAREPART5030.008CHOOPER BUSHING C924400800326030005138,2362512005202025-12-292026-02-28200.6312605000762026-05-041262026-03-07Late
2511004442025-11-28SPAREPART5029.0128COMPRESSION SPRING C8151206401 || DE=13 DF=1,4 L-60 172512005200.62512005202025-12-292026-02-28100.6312605000762026-05-041262026-03-07Late
2511004522025-11-28SPAREPART5030.0645SPACER C81116218002512005202.52512005202025-12-292026-02-28102.531–––2026-03-07Overdue
2511004522025-11-28SPAREPART5030.0642BALL JOINT 925420800025120052072512005202025-12-292026-02-2847312605000762026-05-041262026-03-07Late
2511004522025-11-28SPAREPART5019.0136MOTOR REDUCTION GEAR 9111304401 MRV40 UO3A 71B4 220/380/50HZ I=1:32 43.8 GMP "ROSSI"2512005203202512005202025-12-292026-02-28132031–––2026-03-07Overdue
2511004522025-11-28SPAREPART5030.0134STRETCHER ROSTA SE-15 1F DF16 C8153001230251200520292512005202025-12-292026-02-281029312605000762026-05-041262026-03-07Late
2511004522025-11-28SPAREPART5030.0111JUNCTION OBTAINED C 8153-00-160025120052065.352512005202025-12-292026-02-28465.3531–––2026-03-07Overdue
2512000012025-12-01SPAREPART5030.17588320787101 LEVER251200520602512005202025-12-292026-02-2826028–––2026-03-07Overdue
2512000012025-12-01SPAREPART5030.17579131112400 PIGNONE SEMPLICE Z=24 P=1/2"” X BUSSOLA R3825 SYSTEM P251200520452512005202025-12-292026-02-28245282605000762026-05-041262026-03-07Late
2512000012025-12-01SPAREPART5030.018TAPER BUSH SYSTEM C9344305100251200520262512005202025-12-292026-02-28226282605000762026-05-041262026-03-07Late
2512000012025-12-01SPAREPART5030.17568111494300 ALBERO DD=30-24 L=136 2CL 1FF M8251200520402512005202025-12-292026-02-2824028–––2026-03-07Overdue
← PrevPage 51 of 270Next →Rows per page:1020501005001000