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-01SPAREPART5019.0134MOTOR REDUCING GEAR C9111307004 || MRV40 UO3A I=1:20 71B4 220/380 50 HZ 70GMP "ROSSI"2601001227,289,4732512005202025-12-292026-02-28132028–––2026-03-07Overdue
2512000012025-12-01SPAREPART5030.0125GUIDE HORIZONTAL CHAIN C8125042800 | DI=1220X30X24 6F LAM.D2603000511,689,9512512005202025-12-292026-02-28433.528–––2026-03-07Overdue
2512000012025-12-01SPAREPART5030.0051VERTICAL CHAIN GUIDE C8125049330 | DI=170X30X24260300051368,0212512005202025-12-292026-02-28410282605000762026-05-041262026-03-07Late
2512000012025-12-01SPAREPART5030.17548111512801 PERNO ESAG. CH.17 L=60 DD=12-10-M10 ECC.1251200520122512005202025-12-292026-02-2841228–––2026-03-07Overdue
2512000402025-12-01SPAREPART5030.17379600220003 PLUG25120052132,5012512005212025-12-292026-02-28432,50128–––2026-03-07Overdue
2512000402025-12-01SPAREPART5030.17368321960301 PIATTO FISSAGGIO PROLUNGA BARRA VENTOSE F50251200521359,8272512005212025-12-292026-02-288359,827282603004222026-03-10712026-03-07Late
2512000402025-12-01SPAREPART5030.17419620200019 FILTRO PER VUOTO I-34S-A SMC25120052141,7862512005212025-12-292026-02-28541,786282601013312026-02-07402026-03-07On time
2512000402025-12-01SPAREPART5030.17429600210004 TAPPO 1/8" ES. INC CON GUARNIZ IN GOMMA S1908825120052127,8582512005212025-12-292026-02-28527,858282601013312026-02-07402026-03-07On time
2512000402025-12-01SPAREPART5030.17429600210004 TAPPO 1/8" ES. INC CON GUARNIZ IN GOMMA S1908825120052127,8582512005212025-12-292026-02-28527,85828–––2026-03-07Overdue
2512000402025-12-01SPAREPART5030.17419620200019 FILTRO PER VUOTO I-34S-A SMC25120052141,7862512005212025-12-292026-02-28541,78628–––2026-03-07Overdue
2512000402025-12-01SPAREPART5030.17399600404112 RACCORDO DIRITTO KJH06-01S 1/8" TUBO D=6 SMC25120052148,7512512005212025-12-292026-02-28548,751282601013312026-02-07402026-03-07On time
2512000402025-12-01SPAREPART5030.17399600404112 RACCORDO DIRITTO KJH06-01S 1/8" TUBO D=6 SMC25120052148,7512512005212025-12-292026-02-28548,75128–––2026-03-07Overdue
2512000402025-12-01SPAREPART5030.17379600220003 PLUG25120052132,5012512005212025-12-292026-02-28432,501282601013312026-02-07402026-03-07On time
2512000402025-12-01SPAREPART5030.17349600410102 RACCORDO DRITTO MM 1/4"-D10 COD.6811 CAMOZZI25120052134,8222512005212025-12-292026-02-28434,822282604005472026-04-161082026-03-07Late
2512000402025-12-01SPAREPART5030.071ROLLER C9282032067260100521370,3332512005212025-12-292026-02-288366,792282601001732026-01-0792026-03-07On time
2512000402025-12-01SPAREPART5030.17319282032068 RULLO DUGOMRULLI 305011 ZB GV L330260100521435,9622512005212025-12-292026-02-288431,793282601001732026-01-0792026-03-07On time
2512000402025-12-01SPAREPART5030.1739660105093 CILINDRO SMC MGQM 50-252601005213,418,1612512005212025-12-292026-02-2843,385,471282601001732026-01-0792026-03-07On time
2512000402025-12-01SPAREPART5030.1728RUOTA DENTATA M=1,5 Z=30 DP=46,6 L=15 DDF=32-27 8113015400251200521359,8272512005212025-12-292026-02-282359,827282603010152026-03-31922026-03-07Late
2512000412025-12-01SPAREPART5030.0562CYLINDER CDQ2B32TF-50DZ C9660103366 / EX-ECDQ2B32-50251200521582,3012512005212025-12-292026-02-284582,301282603004222026-03-10712026-03-07Late
2512000412025-12-01SPAREPART5030.17529254108000 SNODO SFERICO MASCHIO M8 JAM 8 ACC/BRONZO/ACC251200521185,7172512005212025-12-292026-02-284185,717282603004222026-03-10712026-03-07Late
2512000412025-12-01SPAREPART5030.17518111335700 DISTANZIALE D=15 DF=10,5 L=2925120052144,1082512005212025-12-292026-02-28244,108282601017132026-02-18512026-03-07On time
2512000412025-12-01SPAREPART5030.1759211101000 CUSCINETTO RADIALE A SFERE 6000 2RS (10X26X8)25120052139,4652512005212025-12-292026-02-28839,465282603004222026-03-10712026-03-07Late
2512000412025-12-01SPAREPART5030.17498321262201 PIATTI SALDATI DI=119X112X8 1FF M10 2FF M8251200521143,9312512005212025-12-292026-02-284143,931282601017132026-02-18512026-03-07On time
2512000412025-12-01SPAREPART5030.17498321262201 PIATTI SALDATI DI=119X112X8 1FF M10 2FF M8251200521143,9312512005212025-12-292026-02-284143,93128–––2026-03-07Overdue
2512000412025-12-01SPAREPART5030.17478322267200 SUPPORTO CILINDRO DI=25X18 L=50,5 1FD10 1FF102512005211,722,5282512005212025-12-292026-02-2821,722,52828–––2026-03-07Overdue
2512000412025-12-01SPAREPART5030.17478322267200 SUPPORTO CILINDRO DI=25X18 L=50,5 1FD10 1FF102512005211,722,5282512005212025-12-292026-02-2821,722,528282604002902026-04-091012026-03-07Late
2512000412025-12-01SPAREPART5030.17469666100137 CERNIERA POSTERIORE FEMMINA SMC CQ-D040 + PERNO25120052192,8592512005212025-12-292026-02-28292,85928–––2026-03-07Overdue
2512000412025-12-01SPAREPART5030.17469666100137 CERNIERA POSTERIORE FEMMINA SMC CQ-D040 + PERNO25120052192,8592512005212025-12-292026-02-28292,859282601013312026-02-07402026-03-07On time
2512000412025-12-01SPAREPART5030.0188GUIDE NADELLA FS32TT C8125042230 || L=663 4F DF6,52512005213,110,7642512005212025-12-292026-02-2823,110,764282603004222026-03-10712026-03-07Late
2512000412025-12-01SPAREPART5030.17458111835702 PROLUNGA PER CILINDRO RULLINI L=203 1FF M10251200521396,9712512005212025-12-292026-02-282396,971282603004222026-03-10712026-03-07Late
2512000412025-12-01SPAREPART5030.17448322273600/8322273601 PLATE251200521468,9362512005212025-12-292026-02-282468,936282601013312026-02-07402026-03-07On time
2512000412025-12-01SPAREPART5030.0198SHAFT WHEEL C81114939012512005211,095,7322512005212025-12-292026-02-2821,095,732282603004222026-03-10712026-03-07Late
2512000412025-12-01SPAREPART5030.0108GEAR RACK M=2+PLATE C 81132135042512005211,546,0962512005212025-12-292026-02-2821,546,096282604008602026-04-231152026-03-07Late
2512000412025-12-01SPAREPART5030.0391IDLE WHEEL DESMOPAN-385 C8128103900 EX-812810229025120052148,7512512005212025-12-292026-02-285048,751282603004222026-03-10712026-03-07Late
2512000412025-12-01SPAREPART5030.0112NADELLA GUIDE FS32TT C 81250421302512005213,714,3462512005212025-12-292026-02-2843,714,346282601017132026-02-18512026-03-07On time
2512000412025-12-01SPAREPART5030.1249PERNO FOLLE FRN 32 EI NADELLA C92135032102512005211,125,9112512005212025-12-292026-02-2861,125,91128–––2026-03-07Overdue
2512000412025-12-01SPAREPART5030.1249PERNO FOLLE FRN 32 EI NADELLA C92135032102512005211,125,9112512005212025-12-292026-02-2861,125,911282601013312026-02-07402026-03-07On time
2512000412025-12-01SPAREPART5030.006PIN IDLE FRNR 32 C92135032112601005211,183,6602512005212025-12-292026-02-2861,172,340282601001732026-01-0792026-03-07On time
2512001602025-12-09PERSEDIAAN UMUM6010.04KAOS MERAH KOBIN25120053245,0002512005322025-12-292026-01-265045,000202603008432026-03-24852026-02-02Late
2512002602025-12-16PERSEDIAAN UMUM6050.1186HEATER TUBULAR 5.7 KW FLANGE DN 502512005312,000,0002512005312025-12-292026-01-2032,000,000132601002182026-01-08102026-01-27On time
2512003202025-12-19BAHAN BAKU BODY1098.0016DEFLOCCULANT VL-012606000548,1502512005002025-12-292026-02-10125,0006,650102601011332026-02-02352026-02-17On time
2512003202025-12-19BAHAN BAKU BODY1098.0016DEFLOCCULANT VL-012606000548,1502512005002025-12-292026-02-10125,0006,650102601020012026-02-25582026-02-17Late
2512003202025-12-19BAHAN BAKU BODY1098.0016DEFLOCCULANT VL-012606000548,1502512005002025-12-292026-02-10125,0006,650102601011642026-02-03362026-02-17On time
2512003202025-12-19BAHAN BAKU BODY1098.0016DEFLOCCULANT VL-012606000548,1502512005002025-12-292026-02-10125,0006,650102601011632026-02-03362026-02-17On time
2512003202025-12-19BAHAN BAKU BODY1098.0016DEFLOCCULANT VL-012606000548,1502512005002025-12-292026-02-10125,0006,650102601020022026-02-25582026-02-17Late
2512003222025-12-19BAHAN PEMBANTU20OT.0001PAC POWDER2604005079,0002512004992025-12-292025-12-295,0009,000102601002142026-01-08102026-01-05Late
2512003502025-12-20PERSEDIAAN UMUM6050.0405GERINDA TANGAN 4 INCH MAKITA M0900B260410119337,837.842512005182025-12-292025-12-292350,00092601002622026-01-09112026-01-05Late
2512003502025-12-20FIXED ASSETSAST02560TRAFO LAS 1 PASS DAIDEN MMAI 1202512005181,355,0002512005182025-12-292025-12-2921,355,00092601002622026-01-09112026-01-05Late
2512004042025-12-23SPAREPART5012.0075SEAL TC 30.42.72604005306,0002512005292025-12-292026-01-15205,00062601001852026-01-0792026-01-22On time
2512004042025-12-23SPAREPART5012.0079SEAL TC 30.47.726010044111,0002512005292025-12-292026-01-15206,00062601001852026-01-0792026-01-22On time
← PrevPage 52 of 270Next →Rows per page:1020501005001000