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
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812605101042026-05-071182026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812605101022026-05-071182026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601110892026-02-21432026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601111042026-02-23452026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601108192026-02-10322026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812605105572026-05-191302026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604100332026-04-04852026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812603100422026-03-03532026-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,00046812604103522026-04-201012026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604101532026-04-09902026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604103032026-04-16972026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604104222026-04-211022026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601108942026-02-14362026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604104272026-04-221032026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601110532026-02-20422026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604101072026-04-07882026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601108632026-02-12342026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601108642026-02-12342026-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,00046812601112242026-02-27492026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812605104642026-05-181292026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601110442026-02-20422026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812603101942026-03-11612026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604100312026-04-04852026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812605100152026-05-041152026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812605100162026-05-041152026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812601108672026-02-12342026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,00046812604101582026-04-09902026-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,00046812601108242026-02-10322026-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,00046812601108222026-02-10322026-01-16Late
2601100152026-01-08BAHAN BAKU BODY1010.0028FELDSPAR FLNH 43# BATU2605102125082601100472026-01-092026-01-096,000,0004681–––2026-01-16Overdue
2512001492025-12-09PERSEDIAAN UMUM6020.0635KABEL SCUN FURRULES (SCUN TUSUK) 1 MM26010032810,3002601001572026-01-102026-01-10112,500322601008642026-01-26162026-01-17Late
2512002902025-12-17PERSEDIAAN UMUM6030.0523LEM KAYU/ RAJAWALI26010015321,0002601001532026-01-102026-01-10521,000242601003552026-01-1222026-01-17On time
2512002902025-12-17PERSEDIAAN UMUM6030.2501TONGKAT ROLL CAT26010015360,0002601001532026-01-102026-01-10160,000242601003552026-01-1222026-01-17On time
2512002902025-12-17PERSEDIAAN UMUM6030.0003KALSIUM26010015340,0002601001532026-01-102026-01-10140,000242601003552026-01-1222026-01-17On time
2512003762025-12-22PERSEDIAAN UMUM6050.0682RAK PLASTIK SUSUN26010016656,9002601001662026-01-102026-01-22156,900192601005002026-01-1552026-01-29On time
2512004302025-12-26PERSEDIAAN UMUM6060.0237RING PLAT M 122605004642602601001522026-01-102026-01-102,000260152601005952026-01-1992026-01-17Late
2512004302025-12-26PERSEDIAAN UMUM6060.0168BAUT M 12X402601003821,3002601001522026-01-102026-01-102,0001,300152601005952026-01-1992026-01-17Late
2601000352026-01-06SPAREPART5017.039INVERTER MITSUBISHI FR-D740-2.2 KW2601001674,450,0002601001672026-01-102026-01-1914,450,00042601004802026-01-1552026-01-26On time
2601000462026-01-06SPAREPART5011.0472BEARING UCP 310260100165551,0002601001652026-01-102026-01-222551,00042601003922026-01-1332026-01-29On time
2601000462026-01-06SPAREPART5011.0012BEARING 22217260500196900,0002601001652026-01-102026-01-222900,00042601003922026-01-1332026-01-29On time
2601000792026-01-09FIXED ASSETSAST02581FORTUNER 2.8 VRZ with GR Parts Aero Package TSS 4x2 A/T One Tone (Mobil Direktur)260100130519,135,7142601001302026-01-102026-01-19162,068,0001–––2026-01-26Overdue
2601000792026-01-09FIXED ASSETSAST02581FORTUNER 2.8 VRZ with GR Parts Aero Package TSS 4x2 A/T One Tone (Mobil Direktur)260100130519,135,7142601001302026-01-102026-01-191519,135,7141–––2026-01-26Overdue
2601000832026-01-08PERSEDIAAN UMUM6050.0034LPG 50 KG2606001661,300,0002601001582026-01-102026-01-1521,000,00022601004072026-01-1332026-01-22On time
2601000962026-01-08BAHAN PACKING3011.0253NFT00 60X60 JUPITER MP2 KW-A 606X48 (WK150/150/150)2603005066612601001592026-01-102026-01-2660,00058022601010542026-01-29192026-02-02On time
2601000962026-01-08BAHAN PACKING3011.0251NFT00 60X60 KOBIN MP2 KW-B 606X48 (WK150/150/150)2604003306822601001592026-01-102026-01-2630,0005802–––2026-02-02Overdue
2601000962026-01-08BAHAN PACKING3011.0255NFT00 60X60 JUPITER MP2 KW-B 606X48 (WK150/150/150)2603005066612601001592026-01-102026-01-2630,00058022601010552026-01-29192026-02-02On time
2601000962026-01-08BAHAN PACKING3011.025NFT00 60X60 KOBIN MP1 KW-B 606X45 (BK150/150/150)2604003306412601001592026-01-102026-01-2630,0005452–––2026-02-02Overdue
2601000962026-01-08BAHAN PACKING3011.0253NFT00 60X60 JUPITER MP2 KW-A 606X48 (WK150/150/150)2603005066612601001592026-01-102026-01-2660,00058022601010552026-01-29192026-02-02On time
2601000962026-01-08BAHAN PACKING3011.0254NFT00 60X60 JUPITER MP1 KW-B 606X45 (BK150/150/150)2603005066212601001592026-01-102026-01-2630,00054522601010552026-01-29192026-02-02On time
2601000962026-01-08BAHAN PACKING3011.0253NFT00 60X60 JUPITER MP2 KW-A 606X48 (WK150/150/150)2603005066612601001592026-01-102026-01-2660,00058022601011032026-01-31212026-02-02On time
2601000962026-01-08BAHAN PACKING3011.0252NFT00 60X60 JUPITER MP1 KW-A 606X45 (WK150/150/150)2603005067232601001592026-01-102026-01-2660,00063522601010552026-01-29192026-02-02On time
2601000962026-01-08BAHAN PACKING3011.0252NFT00 60X60 JUPITER MP1 KW-A 606X45 (WK150/150/150)2603005067232601001592026-01-102026-01-2660,00063522601011032026-01-31212026-02-02On time
2601000962026-01-08BAHAN PACKING3011.0252NFT00 60X60 JUPITER MP1 KW-A 606X45 (WK150/150/150)2603005067232601001592026-01-102026-01-2660,00063522601010542026-01-29192026-02-02On time
2601000972026-01-08BAHAN PACKING3011.0233BOX KOBIN BK TS KW 1 50X502606001201,4592601001602026-01-102026-01-26100,0001,22722601008222026-01-24142026-02-02On time
2601000972026-01-08BAHAN PACKING3011.0233BOX KOBIN BK TS KW 1 50X502606001201,4592601001602026-01-102026-01-26100,0001,22722601010522026-01-29192026-02-02On time
2601000972026-01-08BAHAN PACKING3011.0233BOX KOBIN BK TS KW 1 50X502606001201,4592601001602026-01-102026-01-26100,0001,22722601011022026-01-31212026-02-02On time
2601001122026-01-09PERSEDIAAN UMUM6030.0466CAT KAYU/ BESI HITAM26010016357,472.972601001632026-01-102026-01-211057,472.9712601004422026-01-1442026-01-28On time
2601100082026-01-07BAHAN BAKU GLAZE1030.0074CERAMICS GLAZE POWDER (DRY GRNAULAR) CODE 3012601100530.412601100522026-01-102026-01-10756,0000.40532601102752026-01-1552026-01-17On time
2601100082026-01-07BAHAN BAKU GLAZE1030.0075CERAMICS GLAZE POWDER (DRY GRANULAR) CODE 8062601100530.62601100522026-01-102026-01-10854,0000.59732603100882026-03-05542026-01-17Late
2601100082026-01-07BAHAN BAKU GLAZE1030.0074CERAMICS GLAZE POWDER (DRY GRNAULAR) CODE 3012601100530.412601100522026-01-102026-01-10756,0000.40532601105452026-01-29192026-01-17Late
2601100082026-01-07BAHAN BAKU GLAZE1030.0075CERAMICS GLAZE POWDER (DRY GRANULAR) CODE 8062601100530.62601100522026-01-102026-01-10854,0000.59732601105452026-01-29192026-01-17Late
2601100082026-01-07BAHAN BAKU GLAZE1030.0074CERAMICS GLAZE POWDER (DRY GRNAULAR) CODE 3012601100530.412601100522026-01-102026-01-10756,0000.4053–––2026-01-17Overdue
2601100082026-01-07BAHAN BAKU GLAZE1030.0074CERAMICS GLAZE POWDER (DRY GRNAULAR) CODE 3012601100530.412601100522026-01-102026-01-10756,0000.40532601105562026-01-30202026-01-17Late
2601100082026-01-07BAHAN BAKU GLAZE1030.0075CERAMICS GLAZE POWDER (DRY GRANULAR) CODE 8062601100530.62601100522026-01-102026-01-10854,0000.5973–––2026-01-17Overdue
2601100082026-01-07BAHAN BAKU GLAZE1030.0075CERAMICS GLAZE POWDER (DRY GRANULAR) CODE 8062601100530.62601100522026-01-102026-01-10854,0000.59732603103832026-03-30792026-01-17Late
2601100082026-01-07BAHAN BAKU GLAZE1030.0074CERAMICS GLAZE POWDER (DRY GRNAULAR) CODE 3012601100530.412601100522026-01-102026-01-10756,0000.40532601106422026-02-04252026-01-17Late
2601100082026-01-07BAHAN BAKU GLAZE1030.0074CERAMICS GLAZE POWDER (DRY GRNAULAR) CODE 3012601100530.412601100522026-01-102026-01-10756,0000.40532601105802026-01-31212026-01-17Late
2601100082026-01-07BAHAN BAKU GLAZE1030.0074CERAMICS GLAZE POWDER (DRY GRNAULAR) CODE 3012601100530.412601100522026-01-102026-01-10756,0000.40532601105572026-01-31212026-01-17Late
2601100082026-01-07BAHAN BAKU GLAZE1030.0074CERAMICS GLAZE POWDER (DRY GRNAULAR) CODE 3012601100530.412601100522026-01-102026-01-10756,0000.40532601105102026-01-28182026-01-17Late
2601100082026-01-07BAHAN BAKU GLAZE1030.0074CERAMICS GLAZE POWDER (DRY GRNAULAR) CODE 3012601100530.412601100522026-01-102026-01-10756,0000.40532601103332026-01-20102026-01-17Late
2601100082026-01-07BAHAN BAKU GLAZE1030.0075CERAMICS GLAZE POWDER (DRY GRANULAR) CODE 8062601100530.62601100522026-01-102026-01-10854,0000.59732601111482026-02-24452026-01-17Late
2601100082026-01-07BAHAN BAKU GLAZE1030.0075CERAMICS GLAZE POWDER (DRY GRANULAR) CODE 8062601100530.62601100522026-01-102026-01-10854,0000.59732601105802026-01-31212026-01-17Late
2601100082026-01-07BAHAN BAKU GLAZE1030.0075CERAMICS GLAZE POWDER (DRY GRANULAR) CODE 8062601100530.62601100522026-01-102026-01-10854,0000.59732601102752026-01-1552026-01-17On time
2601100082026-01-07BAHAN BAKU GLAZE1030.0075CERAMICS GLAZE POWDER (DRY GRANULAR) CODE 8062601100530.62601100522026-01-102026-01-10854,0000.59732601105562026-01-30202026-01-17Late
2601100082026-01-07BAHAN BAKU GLAZE1030.0074CERAMICS GLAZE POWDER (DRY GRNAULAR) CODE 3012601100530.412601100522026-01-102026-01-10756,0000.40532601106322026-02-03242026-01-17Late
2601100082026-01-07BAHAN BAKU GLAZE1030.0074CERAMICS GLAZE POWDER (DRY GRNAULAR) CODE 3012601100530.412601100522026-01-102026-01-10756,0000.40532601106622026-02-05262026-01-17Late
2601100092026-01-07BAHAN BAKU GLAZE1030.0074CERAMICS GLAZE POWDER (DRY GRNAULAR) CODE 3012601100530.412601100532026-01-102026-01-10756,0000.40532601106422026-02-04252026-01-17Late
2601100092026-01-07BAHAN BAKU GLAZE1030.0074CERAMICS GLAZE POWDER (DRY GRNAULAR) CODE 3012601100530.412601100532026-01-102026-01-10756,0000.40532601108352026-02-10312026-01-17Late
2601100092026-01-07BAHAN BAKU GLAZE1030.0074CERAMICS GLAZE POWDER (DRY GRNAULAR) CODE 3012601100530.412601100532026-01-102026-01-10756,0000.40532601106622026-02-05262026-01-17Late
2601100092026-01-07BAHAN BAKU GLAZE1030.0074CERAMICS GLAZE POWDER (DRY GRNAULAR) CODE 3012601100530.412601100532026-01-102026-01-10756,0000.40532601109012026-02-14352026-01-17Late
2601100092026-01-07BAHAN BAKU GLAZE1030.0075CERAMICS GLAZE POWDER (DRY GRANULAR) CODE 8062601100530.62601100532026-01-102026-01-10854,0000.5973–––2026-01-17Overdue
2512000232025-12-01SPAREPART5029.016CERAMIC FIBRE BULK TEMP 1350áµ’C @20KG BRAND: MORGAN260500157120,0002601001772026-01-112026-02-16100120,000412601012262026-02-04242026-02-23On time
2512002322025-12-12SPAREPART5017.0054FUJI CONTACTOR SC 0/220 V260500161220,0002601001872026-01-112026-01-2122164,000302601008722026-01-26152026-01-28On time
2512003422025-12-19PERSEDIAAN UMUM6050.0376TANG SNAPRING TUTUP 7 INCH26050038953,8502601002072026-01-112026-01-27149,000232601005582026-01-1762026-02-03On time
2512003422025-12-19PERSEDIAAN UMUM6050.1205RATCHET HANDLE TEKIRO 1/2 INCH260600086191,6502601002072026-01-112026-01-271239,189.19232601005582026-01-1762026-02-03On time
2512003422025-12-19PERSEDIAAN UMUM6050.0377TANG SNAPRING BUKA 7 INCH26050038953,8502601002072026-01-112026-01-27149,000232601005582026-01-1762026-02-03On time
2512003452025-12-19PERSEDIAAN UMUM6030.251NEPEL SELANG KUNINGAN 3/4 INCH26010018523,0002601001852026-01-112026-01-22523,000232601004482026-01-1432026-01-29On time
2512003452025-12-19PERSEDIAAN UMUM6030.2509NEPEL SELANG KUNINGAN 1 INCH26010018526,0002601001852026-01-112026-01-22526,000232601004482026-01-1432026-01-29On time
2512003452025-12-19PERSEDIAAN UMUM6030.0113REDUSER 1-3/4 INCH26010018517,0002601001852026-01-112026-01-22217,000232601004482026-01-1432026-01-29On time
2512003452025-12-19PERSEDIAAN UMUM6030.0527SEAL TAPE2606001484,504.512601002042026-01-112026-01-21104,504.51232601005602026-01-1762026-01-28On time
2512003452025-12-19PERSEDIAAN UMUM6030.0081SOCK GALVANIS 1 INCH26010018515,0002601001852026-01-112026-01-221015,000232601004482026-01-1432026-01-29On time
2512003452025-12-19PERSEDIAAN UMUM6030.0197ELBOW GALVANIS 1 INCH26010020614,054.052601002062026-01-112026-01-191014,054.05232601005612026-01-1762026-01-26On time
2512003452025-12-19PERSEDIAAN UMUM6030.215PIPA BESI 1 INCH X 6000 X 2 MM26010021371,171.172601002132026-01-112026-01-211071,171.17232601006432026-01-2092026-01-28On time
2512003452025-12-19PERSEDIAAN UMUM6030.215PIPA BESI 1 INCH X 6000 X 2 MM26010021371,171.172601002132026-01-112026-01-211071,171.17232601004512026-01-1432026-01-28On time
2512003452025-12-19SPAREPART5031.0595BALLVALVE ONDA 1 INCH260100204177,477.482601002042026-01-112026-01-213177,477.48232601005602026-01-1762026-01-28On time
2512003792025-12-22PERSEDIAAN UMUM6030.0065PLENDES 3 INCH26030026897,5002601001862026-01-112026-01-236125,000202601007972026-01-23122026-01-30On time
← PrevPage 39 of 135Next →Rows per page:1020501005001000