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
2601000592026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601002122026-01-082026-01-1970050,00032601012342026-02-05282026-01-26Late
2601000592026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601002112026-01-082026-01-221,00058,00032601008212026-01-24162026-01-29On time
2601000592026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601002112026-01-082026-01-221,00058,00032601010462026-01-29212026-01-29On time
2601000592026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601002112026-01-082026-01-221,00058,00032601009042026-01-27192026-01-29On time
2601000592026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601002122026-01-082026-01-1970050,00032601011322026-02-02252026-01-26Late
2601000592026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601002122026-01-082026-01-1970050,00032601011952026-02-04272026-01-26Late
2601000592026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601002122026-01-082026-01-1970050,00032601009482026-01-28202026-01-26Late
2601000592026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601002112026-01-082026-01-221,00058,00032601009472026-01-28202026-01-29On time
2601000602026-01-05BAHAN PEMBANTU2045.0011PALLET LOKAL BARU 100*110 BALOK 426060024047,0002601000942026-01-082026-01-191,40047,00032601004202026-01-1352026-01-26On time
2601000602026-01-05BAHAN PEMBANTU2045.0011PALLET LOKAL BARU 100*110 BALOK 426060024047,0002601000942026-01-082026-01-191,40047,00032601004622026-01-1462026-01-26On time
2601000602026-01-05BAHAN PEMBANTU2045.0011PALLET LOKAL BARU 100*110 BALOK 426060024047,0002601000962026-01-082026-01-191,00047,00032601016942026-02-18412026-01-26Late
2601000602026-01-05BAHAN PEMBANTU2045.0011PALLET LOKAL BARU 100*110 BALOK 426060024047,0002601000942026-01-082026-01-191,40047,00032601011942026-02-04272026-01-26Late
2601000602026-01-05BAHAN PEMBANTU2045.0011PALLET LOKAL BARU 100*110 BALOK 426060024047,0002601000942026-01-082026-01-191,40047,00032601012412026-02-05282026-01-26Late
2601000602026-01-05BAHAN PEMBANTU2045.0011PALLET LOKAL BARU 100*110 BALOK 426060024047,0002601000942026-01-082026-01-191,40047,00032601008192026-01-24162026-01-26On time
2601000602026-01-05BAHAN PEMBANTU2045.0011PALLET LOKAL BARU 100*110 BALOK 426060024047,0002601000962026-01-082026-01-191,00047,00032601012812026-02-06292026-01-26Late
2601000602026-01-05BAHAN PEMBANTU2045.0011PALLET LOKAL BARU 100*110 BALOK 426060024047,0002601000942026-01-082026-01-191,40047,00032601009602026-01-28202026-01-26Late
2601000602026-01-05BAHAN PEMBANTU2045.0011PALLET LOKAL BARU 100*110 BALOK 426060024047,0002601000972026-01-082026-01-191,00049,50032601019592026-02-25482026-01-26Late
2601000602026-01-05BAHAN PEMBANTU2045.0011PALLET LOKAL BARU 100*110 BALOK 426060024047,0002601000972026-01-082026-01-191,00049,50032601020132026-02-26492026-01-26Late
2601000602026-01-05BAHAN PEMBANTU2045.0011PALLET LOKAL BARU 100*110 BALOK 426060024047,0002601000962026-01-082026-01-191,00047,00032601015482026-02-13362026-01-26Late
2601000602026-01-05BAHAN PEMBANTU2045.0011PALLET LOKAL BARU 100*110 BALOK 426060024047,0002601000972026-01-082026-01-191,00049,50032601015052026-02-12352026-01-26Late
2601000602026-01-05BAHAN PEMBANTU2045.0011PALLET LOKAL BARU 100*110 BALOK 426060024047,0002601000962026-01-082026-01-191,00047,00032601015012026-02-12352026-01-26Late
2601000602026-01-05BAHAN PEMBANTU2045.0011PALLET LOKAL BARU 100*110 BALOK 426060024047,0002601000972026-01-082026-01-191,00049,50032601015462026-02-13362026-01-26Late
2601000602026-01-05BAHAN PEMBANTU2045.0011PALLET LOKAL BARU 100*110 BALOK 426060024047,0002601000972026-01-082026-01-191,00049,50032601016582026-02-16392026-01-26Late
2601000602026-01-05BAHAN PEMBANTU2045.0011PALLET LOKAL BARU 100*110 BALOK 426060024047,0002601000972026-01-082026-01-191,00049,50032601013692026-02-09322026-01-26Late
2601000602026-01-05BAHAN PEMBANTU2045.0011PALLET LOKAL BARU 100*110 BALOK 426060024047,0002601000962026-01-082026-01-191,00047,00032601014032026-02-10332026-01-26Late
2601000602026-01-05BAHAN PEMBANTU2045.0011PALLET LOKAL BARU 100*110 BALOK 426060024047,0002601000962026-01-082026-01-191,00047,00032601013672026-02-09322026-01-26Late
2601000602026-01-05BAHAN PEMBANTU2045.0011PALLET LOKAL BARU 100*110 BALOK 426060024047,0002601000962026-01-082026-01-191,00047,00032601014392026-02-11342026-01-26Late
2601000662026-01-07SPAREPART5011.0556BEARING RB 20426010014774,0002601001472026-01-082026-01-231074,00012601003932026-01-1352026-01-30On time
2601000662026-01-07SPAREPART5011.042BEARING RB 206260100504100,5002601001472026-01-082026-01-2310100,50012601003932026-01-1352026-01-30On time
2601000662026-01-07SPAREPART5011.0556BEARING RB 20426010014774,0002601001472026-01-082026-01-231074,00012601009742026-01-28202026-01-30On time
2601000692026-01-07PERSEDIAAN UMUM6050.0055SAPU DORONG260500475113,0002601001382026-01-082026-01-144103,00012601005492026-01-1792026-01-21On time
2601000692026-01-07PERSEDIAAN UMUM6050.0162SEKROP26060008750,0002601001352026-01-082026-01-15450,00012601004062026-01-1352026-01-22On time
2601000692026-01-07PERSEDIAAN UMUM6050.004SAPU TONGKAT26010013810,0002601001382026-01-082026-01-14410,00012601005492026-01-1792026-01-21On time
2601000692026-01-07PERSEDIAAN UMUM6050.1231CIKRAK SENG26050042110,0002601001382026-01-082026-01-14410,00012601005492026-01-1792026-01-21On time
2601000702026-01-07BAHAN BAKU GLAZE1070.0004INK - CIK AZ 1111 BLUE260600273298,6292601001072026-01-082026-01-10180269,15612601003902026-01-1352026-01-17On time
2601000702026-01-07BAHAN BAKU GLAZE1070.0022INK - CIK RC 1116 SINKING260500301262,1882601001072026-01-082026-01-1096255,67812601003902026-01-1352026-01-17On time
2601000702026-01-07BAHAN BAKU GLAZE1070.0019INK - CIK AZ 1165 BLUE260600119228,3272601001072026-01-082026-01-10180202,16012601003902026-01-1352026-01-17On time
2601000702026-01-07BAHAN BAKU GLAZE1070.0005INK - CIK MA 5115 BROWN260600273145,5232601001072026-01-082026-01-10180138,68012601003902026-01-1352026-01-17On time
2601000702026-01-07BAHAN BAKU GLAZE1070.0002INK - CIK AM 5118 YELLOW260600273179,3412601001072026-01-082026-01-10240170,90812601003902026-01-1352026-01-17On time
2601000702026-01-07BAHAN BAKU GLAZE1070.0006INK - CIK NE 6153 BLACK260600246259,2762601001072026-01-082026-01-10300227,35712601003902026-01-1352026-01-17On time
2601000702026-01-07BAHAN BAKU GLAZE1070.002INK - CIK MA 5457 BROWN26060024697,9722601001072026-01-082026-01-109093,36512601003902026-01-1352026-01-17On time
2601100042026-01-05PERSEDIAAN UMUM6020.0542KABEL NYYHY 3X2.5MM26011028627,7002601100402026-01-082026-01-0820024,36132601104022026-01-22142026-01-15Late
2601100042026-01-05PERSEDIAAN UMUM6020.0327KABEL NYYHY 2 X 2.5 MM26011019517,8742601100402026-01-082026-01-0831,787,40032601104022026-01-22142026-01-15Late
2511003862025-11-25SPAREPART5029.0147MAIN UNIT CCT+0008886 TYPE DSM11P TW1s TS5s 100-240v 50-60Hz 7VA S.1,2µA2601001191,539,4002601001192026-01-092026-01-31201,539,400452601006562026-01-20112026-02-07On time
2511004342025-11-28FIXED ASSETSAST02497MOR MACHINE (MESIN BENDING STRENGHT)2601001292,1702601001292026-01-092026-07-2912,17042–––2026-08-05Outstanding
2512000492025-12-03PERSEDIAAN UMUM6030.135SEALANT WHITE26010011825,0002601001182026-01-092026-01-091025,000372601002922026-01-1232026-01-16On time
2512000512025-12-03SPAREPART5030.1571RUBBER GRIPPER COUPLER (HORIZONTAL) 832838610026060023689.52601001202026-01-092026-01-31101,980,580372603010072026-03-31812026-02-07Late
2512000512025-12-03SPAREPART5030.1571RUBBER GRIPPER COUPLER (HORIZONTAL) 832838610026060023689.52601001202026-01-092026-01-31101,980,58037–––2026-02-07Overdue
2512000512025-12-03SPAREPART5030.1571RUBBER GRIPPER COUPLER (HORIZONTAL) 832838610026060023689.52601001202026-01-092026-01-31101,980,580372601017212026-02-18402026-02-07Late
2512000512025-12-03SPAREPART5030.1569RUBBER GRIPPER COUPLER (VERTICAL) 8005430426060023646.52601001202026-01-092026-01-31101,089,905372603004072026-03-10602026-02-07Late
2512001082025-12-06PERSEDIAAN UMUM6050.0226SILICONE HITAM()26010011825,0002601001182026-01-092026-01-092025,000342601002922026-01-1232026-01-16On time
2512003812025-12-22PERSEDIAAN UMUM6050.1216BANTAL260100151143,243.242601001512026-01-092026-01-093143,243.24182601011792026-02-03252026-01-16Late
2512003812025-12-22PERSEDIAAN UMUM6050.1215SPREI UK 100X200260400001215,4962601001512026-01-092026-01-097269,369.37182601011792026-02-03252026-01-16Late
2512003812025-12-22FIXED ASSETSAST02570TEMPAT TIDUR SUSUN UK 100X2002604000016,123,4232601001512026-01-092026-01-0933,782,882.88182601011792026-02-03252026-01-16Late
2512003972025-12-23PERSEDIAAN UMUM6030.0004SEMEN GRESIK 40KG26050024159,5002601001172026-01-092026-01-092058,000172601002932026-01-1232026-01-16On time
2512004262025-12-26SPAREPART5026.0244DRV HCS01 18A R911325247+FWA R911325612 BOSC (6800001464)26010012522,360,6342601001252026-01-092026-02-20122,360,634142603004082026-03-10602026-02-27Late
2512005122025-12-27PERSEDIAAN UMUM6020.0679POE SWITCH HIKVISION 8 PORT + 2 UPLINK260100115695,4952601001152026-01-092026-01-093695,495132601007702026-01-22132026-01-16Late
2512100662025-12-23PERSEDIAAN UMUM6050.0994SEPATU BOOTS SIZE 41260400358160,0002601100572026-01-092026-01-20171,250172601103222026-01-1782026-01-27On time
2512100662025-12-23PERSEDIAAN UMUM6050.1218SEPATU BOOTS SIZE 4426011005771,2502601100572026-01-092026-01-20171,250172601103222026-01-1782026-01-27On time
2601000102026-01-02PERSEDIAAN UMUM6050.0191SPON HITAM260400045165,0002601001322026-01-092026-01-211150,00072601004052026-01-1342026-01-28On time
2601000342026-01-06PERSEDIAAN UMUM6050.0048SPON 10CM260300059575,0002601001322026-01-092026-01-211575,00032601004052026-01-1342026-01-28On time
2601000342026-01-06PERSEDIAAN UMUM6050.0047SPON 5CM260500350350,0002601001322026-01-092026-01-211287,50032601004052026-01-1342026-01-28On time
2601000762026-01-08PERSEDIAAN UMUM6030.0917THINER A BIASA @ 5 LTR26050040363,5002601001162026-01-092026-01-0910026,505.051–––2026-01-16Overdue
2601000762026-01-08PERSEDIAAN UMUM6030.0804AVIAN CLING SYNTHETIC 91 - KERAK ABU26030036945,905.252601001162026-01-092026-01-0920045,905.251–––2026-01-16Overdue
2601000782026-01-08BAHAN BAKAR4010.0001SOLAR26060011120,720.722601001312026-01-092026-01-128,00012,792.7912601004172026-01-1342026-01-19On time
2601000942026-01-09FIXED ASSETSAST02583GRANMAX MINIBUS 1.5 D PS (Mobil Operational Surabaya)260100220173,830,4622601002202026-01-092026-01-30123,759,883–2601005012026-01-1562026-02-06On time
2601000942026-01-09FIXED ASSETSAST02582GRANMAX MINIBUS 1.5 D PS (Mobil Operational Jakarta)260100220169,338,3932601002202026-01-092026-01-301169,338,393––––2026-02-06Overdue
2601000942026-01-09FIXED ASSETSAST02582GRANMAX MINIBUS 1.5 D PS (Mobil Operational Jakarta)260100220169,338,3932601002202026-01-092026-01-30124,691,000––––2026-02-06Overdue
2601000942026-01-09FIXED ASSETSAST02583GRANMAX MINIBUS 1.5 D PS (Mobil Operational Surabaya)260100220173,830,4622601002202026-01-092026-01-301173,830,462–2601005012026-01-1562026-02-06On time
2601100132026-01-07BAHAN PACKING3011.0209CARTON BOX SIDEWRAPS JUPITER 60X60 GP MP1 KWA 605X40 (WK150/125/150)2604100186962601100482026-01-092026-01-0983,32870522601104422026-01-23142026-01-16Late
2601100132026-01-07BAHAN PACKING3011.0209CARTON BOX SIDEWRAPS JUPITER 60X60 GP MP1 KWA 605X40 (WK150/125/150)2604100186962601100482026-01-092026-01-0983,32870522601104942026-01-28192026-01-16Late
2601100132026-01-07BAHAN PACKING3011.021CARTON BOX SIDEWRAPS JUPITER 60X60 GP MP2 KWA 605X38 (WK150/125/150)2604100186592601100482026-01-092026-01-0983,32862522601104422026-01-23142026-01-16Late
2601100132026-01-07BAHAN PACKING3011.021CARTON BOX SIDEWRAPS JUPITER 60X60 GP MP2 KWA 605X38 (WK150/125/150)2604100186592601100482026-01-092026-01-0983,32862522601104942026-01-28192026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,0004681–––2026-01-16Overdue
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601108132026-02-10322026-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,00046812603102342026-03-12622026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812605101012026-05-071182026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812605100082026-05-021132026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601108602026-02-12342026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604102612026-04-15962026-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,00046812601108582026-02-12342026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,0004681–––2026-01-16Overdue
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601108142026-02-10322026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604101162026-04-07882026-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,00046812604100242026-04-04852026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812603102912026-03-16662026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812605100072026-05-021132026-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,00046812601109452026-02-16382026-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,00046812601109462026-02-16382026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601110952026-02-21432026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812603100632026-03-04542026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604101522026-04-09902026-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,00046812604103962026-04-211022026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601110432026-02-20422026-01-16Late
← PrevPage 36 of 135Next →Rows per page:1020501005001000