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
2601001152026-01-09SPAREPART5017.1067FUSE CUBICLE 20 KV 160A2601003876,500,0002601003872026-01-232026-01-2336,500,000142601011722026-02-03112026-01-30Late
2601001152026-01-09FIXED ASSETSAST02589CUBICLE SM6 QM 630A 24KV SCHNEIDER26010038657,702,9422601003862026-01-232026-01-23157,702,942142601012292026-02-04122026-01-30Late
2601001172026-01-10PERSEDIAAN UMUM6060.066BAUT DRILLING M 8X20 MM2601004262482601004262026-01-232026-01-235,000248132601008432026-01-2412026-01-30On time
2601001172026-01-10PERSEDIAAN UMUM6060.0168BAUT M 12X402601003821,3002601003822026-01-232026-01-232,0001,300132601010972026-01-3072026-01-30On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601014432026-02-11192026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601012762026-02-06142026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601014442026-02-11192026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601017892026-02-20282026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601013482026-02-07152026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601013472026-02-07152026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601013492026-02-09172026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601013462026-02-07152026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601014012026-02-10182026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601013512026-02-09172026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601013502026-02-09172026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601012792026-02-06142026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601012782026-02-06142026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601017882026-02-20282026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601015212026-02-12202026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601014022026-02-10182026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601017902026-02-20282026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601016602026-02-16242026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601015202026-02-12202026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601017422026-02-19272026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601018472026-02-21292026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601017412026-02-19272026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601015932026-02-14222026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601015522026-02-13212026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601015942026-02-14222026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601015532026-02-13212026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601017402026-02-19272026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601018462026-02-21292026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601015222026-02-12202026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601015502026-02-13212026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601015512026-02-13212026-02-21On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601003992026-01-232026-02-141,150,0001,530102601016592026-02-16242026-02-21On time
2601001552026-01-13SPAREPART5022.0024GEAR RS 80 GIGI 23 LUBANG AS 40 SPY 10260100413300,0002601004132026-01-232026-02-164300,000102601016462026-02-16242026-02-23On time
2601001662026-01-14SPAREPART5032.0935WASHER / NO 33 OD 22 (GB 93-87)26010039240,0002601003922026-01-232026-01-311240,00092601009022026-01-2742026-02-07On time
2601001662026-01-14SPAREPART5032.0936NUT / NO 34 M22X1.5 (GB 6171-2000)26010039230,0002601003922026-01-232026-01-311230,00092601009022026-01-2742026-02-07On time
2601001662026-01-14SPAREPART5032.0937NUT / NO 31 404023260100392170,0002601003922026-01-232026-01-3112170,00092601009022026-01-2742026-02-07On time
2601001662026-01-14SPAREPART5032.0934RIM BOLT / NO 32 504022G26010039215,0002601003922026-01-232026-01-311215,00092601009022026-01-2742026-02-07On time
2601001682026-01-14SPAREPART5032.1302OH KIT STEERING NO 2,3,4,5,8,9260100393655,0002601003932026-01-232026-02-052655,00092601009032026-01-2742026-02-12On time
2601001682026-01-14SPAREPART5032.1182SEDIMENTOR 24662-22032260100393430,0002601003932026-01-232026-02-052430,00092601009032026-01-2742026-02-12On time
2601001732026-01-14PERSEDIAAN UMUM6050.1303REGULATOR ANGIN YAMATO260400341157,657.662601003802026-01-232026-01-235157,657.6692601009012026-01-2742026-01-30On time
2601001732026-01-14PERSEDIAAN UMUM6030.1903STRONG-8 CUTTING TIP NO126031012819,3492601003802026-01-232026-01-231031,531.5392601009012026-01-2742026-01-30On time
2601001752026-01-14PERSEDIAAN UMUM6030.0132MATA BOR BESI 11.5 MM260100382152,0002601003822026-01-232026-01-232152,00092601010972026-01-3072026-01-30On time
2601001752026-01-14PERSEDIAAN UMUM6030.013MATA BOR BESI 10 MM26061015799,0002601003822026-01-232026-01-232106,00092601010972026-01-3072026-01-30On time
2601001752026-01-14PERSEDIAAN UMUM6030.0961MATA BOR BESI 8 MM26060026758,4502601003822026-01-232026-01-23264,00092601010972026-01-3072026-01-30On time
2601001752026-01-14PERSEDIAAN UMUM6030.0415MATA BOR BESI 13 MM260610157172,5002601003822026-01-232026-01-232187,50092601010972026-01-3072026-01-30On time
2601001752026-01-14PERSEDIAAN UMUM6030.0131MATA BOR BESI 10.5 MM260100382120,0002601003822026-01-232026-01-235120,00092601010972026-01-3072026-01-30On time
2601001892026-01-15SPAREPART5026.0235CINGHIA DENTATA AT 5 LR=16 +PAZ MEGADYNE 9994050031260100390114,8502601003902026-01-232026-02-206114,85082601010152026-01-2962026-02-27On time
2601001892026-01-15SPAREPART5026.0236VACUOSTATO SMC ZSE20A-Y-01-J-X531 96205300152601003901,193,4272601003902026-01-232026-02-2031,193,42782603010062026-03-31672026-02-27Late
2601001892026-01-15SPAREPART5026.0236VACUOSTATO SMC ZSE20A-Y-01-J-X531 96205300152601003901,193,4272601003902026-01-232026-02-2031,193,42782604010512026-04-28952026-02-27Late
2601001892026-01-15SPAREPART5026.0168SENS CAP PNP M8 BCS S20HH09-GPSFHF-EP00 (INK LEVEL SENSOR FOR MAINTANK) 76300010042601008303,814,3532601003902026-01-232026-02-2053,773,65082603010062026-03-31672026-02-27Late
2601001892026-01-15SPAREPART5026.0168SENS CAP PNP M8 BCS S20HH09-GPSFHF-EP00 (INK LEVEL SENSOR FOR MAINTANK) 76300010042601008303,814,3532601003902026-01-232026-02-2053,773,65082601010152026-01-2962026-02-27On time
2601001912026-01-15SPAREPART5011.0559BEARING FAG NJ2308 - E - TVP2 - C3 - CYLNDERI RB260100425477,0502601004252026-01-232026-02-102477,05082601008442026-01-2412026-02-17On time
2601001952026-01-15PERSEDIAAN UMUM6050.129KESET LANTAI26041016733,0002601003972026-01-232026-01-31125,00082601010932026-01-3072026-02-07On time
2601001982026-01-15SPAREPART5017.0078LIMIT SWITCH HL 5030260300547150,0002601004232026-01-232026-02-103150,00082601008772026-01-2632026-02-17On time
2601001982026-01-15SPAREPART5017.0053SELENOID VALVE SPC 4V210-08/220 VAC260500011100,0002601004232026-01-232026-02-10470,00082601014542026-02-11192026-02-17On time
2601001982026-01-15SPAREPART5017.051COUNTER OMRON H7BX-A2601004214,900,0002601004212026-01-232026-02-0624,900,00082601010082026-01-2962026-02-13On time
2601001982026-01-15SPAREPART5017.0511COUNTER OMRON H7CC-A2606000722,000,0002601004212026-01-232026-02-0622,000,00082601010082026-01-2962026-02-13On time
2601001982026-01-15SPAREPART5017.0516SICK GRTE18-P2442260500010955,0002601004202026-01-232026-02-064895,50082601014172026-02-10182026-02-13On time
2601001992026-01-15SPAREPART5017.0059FUJI MAGNETIC CONTACTOR SC N10/220 V2601004143,822,0002601004142026-01-232026-02-0523,822,00082601009182026-01-2742026-02-12On time
2601001992026-01-15SPAREPART5017.0215MCCB SNEIDER 100 A260400272571,8502601004152026-01-232026-01-052520,00082601012152026-02-04122026-01-12Late
2601001992026-01-15SPAREPART5017.0023MCB CIRCUIT BREAKER 3P 32A260500011260,0002601004152026-01-232026-01-055260,00082601012152026-02-04122026-01-12Late
2601001992026-01-15SPAREPART5017.0221MCB SNEIDER 3P 10A260100415230,0002601004152026-01-232026-01-055230,00082601012152026-02-04122026-01-12Late
2601001992026-01-15SPAREPART5017.036MCCB SCHNEIDER NSX 400 N2601004065,400,0002601004062026-01-232026-02-0525,400,00082601009902026-01-2962026-02-12On time
2601001992026-01-15SPAREPART5017.0426MCB 3P 6A260100416230,0002601004162026-01-232026-02-065230,00082601012142026-02-04122026-02-13On time
2601001992026-01-15SPAREPART5019.0072GEAR REDUCER MNRV 050 RATIO 1:15 FLANGE 0.37KW B.52605001933,062,5002601004192026-01-232026-02-0623,062,50082601012522026-02-05132026-02-13On time
2601001992026-01-15SPAREPART5019.0034GEAR REDUCER MNRV050 RATIO 1:30 0.37KW FLANGE B52605001933,062,5002601004192026-01-232026-02-0613,062,50082601012522026-02-05132026-02-13On time
2601001992026-01-15SPAREPART5019.0111GEAR REDUCER MNRV 063 R 1:30 (FLANGE 0.75 KW B14)2605001934,500,0002601004192026-01-232026-02-0624,500,00082601012522026-02-05132026-02-13On time
2601001992026-01-15SPAREPART5017.0055FUJI MAGNETIC CONTACTOR SC N1/220 V260400174645,0002601004152026-01-232026-01-055535,00082601012152026-02-04122026-01-12Late
2601002002026-01-15SPAREPART5017.0144TELE AUX BLOCK ZBE 10226050015024,5002601004052026-01-232026-02-051024,50082601009912026-01-2962026-02-12On time
2601002002026-01-15SPAREPART5017.0208PILOT LAMP SCHNEIDER MERAH 220 VAC26010044048,0002601004402026-01-232026-02-051048,00082601009922026-01-2962026-02-12On time
2601002002026-01-15SPAREPART5017.0147TELE SELECTOR XB4 BD33260300481142,8002601004052026-01-232026-02-0515130,00082601009912026-01-2962026-02-12On time
2601002002026-01-15SPAREPART5017.014PUSH BOTTON TELE XB2 BA3126050015054,9402601004172026-01-232026-02-061051,94082601016672026-02-16242026-02-13Late
2601002002026-01-15SPAREPART5017.0145TELE SELECTOR XB4 BD21260600252122,9002601004052026-01-232026-02-0515113,50082601009912026-01-2962026-02-12On time
2601002002026-01-15SPAREPART5017.0141PUSH BOTTON TELE XB2 BA4226010100851,9402601004172026-01-232026-02-061051,94082601016672026-02-16242026-02-13Late
2601002002026-01-15SPAREPART5017.0145TELE SELECTOR XB4 BD21260600252122,9002601004052026-01-232026-02-0515113,50082601012572026-02-05132026-02-12On time
2601002002026-01-15SPAREPART5017.0143TELE AUX BLOCK ZBE 10126050015024,5002601004052026-01-232026-02-051024,50082601009912026-01-2962026-02-12On time
2601002042026-01-15SPAREPART5031.0015BALLVALVE 2 INCH260600095648,648.62601003802026-01-232026-01-233640,180.1882601009412026-01-2742026-01-30On time
2601002082026-01-15PERSEDIAAN UMUM6050.1305CONTAINER BOX PLASTIK JUMBO260100396370,0002601003962026-01-232026-01-314370,00082601010892026-01-3072026-02-07On time
2601002152026-01-17SPAREPART5017.1068PLC OMRON CP2E - N20DR - A2601004071,925,0002601004072026-01-232026-02-0511,925,00062601009932026-01-2962026-02-12On time
2601002232026-01-19PERSEDIAAN UMUM6030.0004SEMEN GRESIK 40KG26050024159,5002601003842026-01-232026-01-231058,00042601010012026-01-2962026-01-30On time
2601002322026-01-20SPAREPART5028.0203MARTIN PULLY SPA 180 - 4 TAPER BUSH 2517 - 482601004121,195,0002601004122026-01-232026-02-1021,195,00032601010072026-01-2962026-02-17On time
2601002352026-01-20STATIONERY6010.0336KERTAS STIKER A4 GLOSSY ( PUTIH )26050002637,5002601004182026-01-232026-02-05341,00032601012482026-02-05132026-02-12On time
2601002352026-01-20STATIONERY6010.058KERTAS STIKER KRAFT A4 COKLAT (DARK)26060018429,0002601004182026-01-232026-02-05527,00032601012482026-02-05132026-02-12On time
2601002382026-01-20SPAREPART5023.0354PULLEY 14 H 100260100411350,0002601004112026-01-232026-02-0710350,00032601010052026-01-2962026-02-14On time
2601002382026-01-20SPAREPART5023.0862PULLY TIMMING H 100 T16260100411420,0002601004112026-01-232026-02-0710420,00032601010052026-01-2962026-02-14On time
2601002452026-01-20SPAREPART5011.0278BEARING UCP 20526010042290,0002601004222026-01-232026-02-03690,00032601009752026-01-2852026-02-10On time
2601002452026-01-20SPAREPART5011.028BEARING UCP 207260500469147,5002601004222026-01-232026-02-034146,75032601009752026-01-2852026-02-10On time
2601002462026-01-20PERSEDIAAN UMUM6020.077CT 20 KV 400/5A2601003868,485,7852601003862026-01-232026-01-2338,485,78532601012292026-02-04122026-01-30Late
2601002482026-01-20PERSEDIAAN UMUM6030.149SEALTAPE2604002895,0002601003882026-01-232026-01-234324,324.3232601009632026-01-2852026-01-30On time
2601002482026-01-20PERSEDIAAN UMUM6030.149SEALTAPE2604002895,0002601003882026-01-232026-01-234324,324.323–––2026-01-30Overdue
2601002482026-01-20PERSEDIAAN UMUM6030.0632KACA LAS HITAM2605004902,702.72601003882026-01-232026-01-23202,702.732601009632026-01-2852026-01-30On time
2601002482026-01-20PERSEDIAAN UMUM6030.0632KACA LAS HITAM2605004902,702.72601003882026-01-232026-01-23202,702.73–––2026-01-30Overdue
2601002482026-01-20PERSEDIAAN UMUM6030.0642KACA LAS BENING2606100226752601003882026-01-232026-01-23201,171.1732601010172026-01-2962026-01-30On time
2601002482026-01-20PERSEDIAAN UMUM6030.0642KACA LAS BENING2606100226752601003882026-01-232026-01-23201,171.173–––2026-01-30Overdue
2601002502026-01-20PERSEDIAAN UMUM6030.07METERAN 7.5 MTR26051015759,4602601004042026-01-232026-01-31245,00032601008412026-01-2412026-02-07On time
2601002512026-01-20PERSEDIAAN UMUM6030.0483CAT SPRAY MERAH26061011934,2352601004102026-01-232026-02-16421,225.2332601010252026-01-2962026-02-23On time
← PrevPage 48 of 135Next →Rows per page:1020501005001000