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
2601100222026-01-10BAHAN BAKU BODY1010.0012CLAY PRP 79#2601100613922601100612026-01-122026-01-1235,00039222603103512026-03-26732026-01-19Late
2511004402025-11-28PERSEDIAAN UMUM6030.2423BROSTEL 20326010021745,045.052601002172026-01-132026-01-13445,045.0546–––2026-01-20Overdue
2511004452025-11-28PERSEDIAAN UMUM6030.05CAT BESI TAHAN PANAS BIRU MUDA26010022281,0812601002222026-01-132026-01-247081,081462601004582026-01-1412026-01-31On time
2512003842025-12-23PERSEDIAAN UMUM6030.0923BENANG LOT TIMBANG2603005325,0002601002182026-01-132026-01-1345,000212601004782026-01-1522026-01-20On time
2512003842025-12-23PERSEDIAAN UMUM6030.1195KUNCI PAS RING UKURAN 8-10 MM,10-12 MM,13 MM,12-14 MM,14-17 MM,17-19 MM,19-22 MM,22-24 MM,27-30 MM260100227588,513.512601002272026-01-132026-01-134588,513.51212601006952026-01-2182026-01-20Late
2512003842025-12-23PERSEDIAAN UMUM6050.062KUNCI L SET TEKIRO260500486100,2002601002272026-01-132026-01-134155,765.77212601006952026-01-2182026-01-20Late
2512003842025-12-23PERSEDIAAN UMUM6050.0503KUNCI PIPA 24 INCH260100227192,972.972601002272026-01-132026-01-131192,972.97212601006952026-01-2182026-01-20Late
2512003842025-12-23PERSEDIAAN UMUM6030.1363MATA BOR BESI M 14260610157316,2002601002272026-01-132026-01-135295,675.68212601010752026-01-30172026-01-20Late
2512003842025-12-23PERSEDIAAN UMUM6030.1363MATA BOR BESI M 14260610157316,2002601002272026-01-132026-01-135295,675.68212601007122026-01-2182026-01-20Late
2512003842025-12-23PERSEDIAAN UMUM6030.1363MATA BOR BESI M 14260610157316,2002601002272026-01-132026-01-135295,675.68212601009512026-01-28152026-01-20Late
2512003842025-12-23PERSEDIAAN UMUM6030.0205MATA BOR BESI M 12260110248130,6312601002272026-01-132026-01-135134,234.23212601007122026-01-2182026-01-20Late
2512004102025-12-26PERSEDIAAN UMUM6030.0004SEMEN GRESIK 40KG26050024159,5002601002182026-01-132026-01-132058,000182601004782026-01-1522026-01-20On time
2512100652025-12-23SPAREPART5011.0269BEARING UCFL 20426050046984,0002601100922026-01-132026-01-223021,345212603101022026-03-05512026-01-29Late
2512100782025-12-31SPAREPART5011.0555FLANGED SLEEVE BEARING 620726011009264,5102601100922026-01-132026-01-222064,510132603101022026-03-05512026-01-29Late
2512100782025-12-31SPAREPART5011.0554FLANGED SLEEVE BEARING 620626011009246,2302601100922026-01-132026-01-222046,230132603101022026-03-05512026-01-29Late
2512100782025-12-31SPAREPART5011.0553FLANGED SLEEVE BEARING 620526011009234,2552601100922026-01-132026-01-222034,255132603101022026-03-05512026-01-29Late
2512100782025-12-31SPAREPART5011.0552FLANGED SLEEVE BEARING 620426011009229,5152601100922026-01-132026-01-222029,515132603101022026-03-05512026-01-29Late
2601000212026-01-05PERSEDIAAN UMUM6030.0868ELBOW LAS 2.5 INCH26030010931,981.982601002212026-01-132026-01-132022,072.0782601006052026-01-1962026-01-20On time
2601000252026-01-06SPAREPART5021.0255T. BELT 900 H - 100260101007236,9002601002502026-01-132026-01-306225,00072606001422026-06-041422026-02-06Late
2601000252026-01-06SPAREPART5021.0213V. BELT SPA 2360260100249104,0002601002492026-01-132026-01-306104,00072601007062026-01-2182026-02-06On time
2601000252026-01-06SPAREPART5021.0249T. BELT 750 H - 100260100233191,0002601002502026-01-132026-01-308191,00072601014772026-02-11292026-02-06Late
2601000252026-01-06SPAREPART5021.004V. BELT B - 5826010024942,2002601002492026-01-132026-01-30542,20072601009692026-01-28152026-02-06On time
2601000252026-01-06SPAREPART5021.0083V. BELT B - 13526010024998,1002601002492026-01-132026-01-30798,10072601007062026-01-2182026-02-06On time
2601000252026-01-06SPAREPART5021.01V. BELT B - 185260500209147,6002601002492026-01-132026-01-3010134,40072601007062026-01-2182026-02-06On time
2601000252026-01-06SPAREPART5021.0096V. BELT B - 173260100844125,6002601002492026-01-132026-01-307125,60072601007062026-01-2182026-02-06On time
2601000252026-01-06SPAREPART5021.0096V. BELT B - 173260100844125,6002601002492026-01-132026-01-307125,60072601013082026-02-06242026-02-06On time
2601000252026-01-06SPAREPART5021.0091V. BELT B - 158260500140126,0502601002492026-01-132026-01-3010114,80072601007062026-01-2182026-02-06On time
2601000252026-01-06SPAREPART5021.0045V. BELT B - 6526010023447,2002601002492026-01-132026-01-30847,20072601007062026-01-2182026-02-06On time
2601000252026-01-06SPAREPART5021.0046V. BELT B - 6626010023448,0002601002372026-01-132026-01-30647,95072601009502026-01-28152026-02-06On time
2601000252026-01-06SPAREPART5021.0073V. BELT B - 11926010102686,4002601002492026-01-132026-01-301086,40072601007062026-01-2182026-02-06On time
2601000252026-01-06SPAREPART5021.0096V. BELT B - 173260100844125,6002601002492026-01-132026-01-307125,60072601009692026-01-28152026-02-06On time
2601000252026-01-06SPAREPART5021.0129V. BELT B - 285260100234217,9002601002492026-01-132026-01-3010217,90072601020442026-02-27452026-02-06Late
2601000252026-01-06SPAREPART5021.0218V. BELT SPB 2800260100237164,9002601002372026-01-132026-01-308164,90072601009502026-01-28152026-02-06On time
2601000252026-01-06SPAREPART5021.0042V. BELT B - 6226010084545,0502601002372026-01-132026-01-30845,05072601009502026-01-28152026-02-06On time
2601000252026-01-06SPAREPART5021.0039V. BELT B - 5726010023441,4002601002492026-01-132026-01-30641,40072601007062026-01-2182026-02-06On time
2601000252026-01-06SPAREPART5021.0041V. BELT B - 6026010117643,6002601002492026-01-132026-01-30643,60072601009692026-01-28152026-02-06On time
2601000252026-01-06SPAREPART5021.0015V. BELT A - 3526010084417,2002601002372026-01-132026-01-301017,15072601009502026-01-28152026-02-06On time
2601000252026-01-06SPAREPART5021.0017V. BELT A - 4026010024919,6002601002492026-01-132026-01-30819,60072601007062026-01-2182026-02-06On time
2601000352026-01-06SPAREPART5017.0056FUJI MAGNETIC CONTACTOR SC N3/220 V2601010081,085,0002601002142026-01-132026-01-2631,085,00072601005182026-01-1522026-02-02On time
2601000422026-01-06SPAREPART5031.0437CAMLOCK TYPE E 2 INCH260100550300,0002601002262026-01-132026-01-245400,315.3272601005592026-01-1742026-01-31On time
2601000422026-01-06SPAREPART5031.0604CAMLOCK TYPE A 2 INCH260100550180,0002601002262026-01-132026-01-246280,540.5472601005592026-01-1742026-01-31On time
2601000422026-01-06SPAREPART5031.0436CAMLOCK TYPE C 2 INCH260500159348,018.022601002262026-01-132026-01-2416331,081.0872601005592026-01-1742026-01-31On time
2601000482026-01-06PERSEDIAAN UMUM6030.2524MULTIPLEX 1200X2400X3 MM26010021555,0002601002152026-01-132026-01-13355,00072601004772026-01-1522026-01-20On time
2601001172026-01-10PERSEDIAAN UMUM6050.0654KUNCI L 5MM2605003838,8002601002162026-01-132026-01-13816,00032601005922026-01-1962026-01-20On time
2601001172026-01-10PERSEDIAAN UMUM6050.0923KUNCI L 4 MM26041013022,0002601002162026-01-132026-01-13511,00032601005922026-01-1962026-01-20On time
2601001282026-01-10BAHAN PACKING3011.02NFT00 40X40 KOBIN MP1 KW-A 403X51 (BK150/125/125)2606001204092601001942026-01-132026-01-26160,00033132601007332026-01-2292026-02-02On time
2601001282026-01-10BAHAN PACKING3011.0201NFT00 40X40 KOBIN MP2 KW-A 403X54 (BK150/125/125)2606001203572601001942026-01-132026-01-26160,00028932601009082026-01-27142026-02-02On time
2601001282026-01-10BAHAN PACKING3011.0215NFT00 40X40 KOBIN MP1 KW-B 403X51 (BK150/125/125)2605000314122601001942026-01-132026-01-2650,00033132601009082026-01-27142026-02-02On time
2601001282026-01-10BAHAN PACKING3011.0201NFT00 40X40 KOBIN MP2 KW-A 403X54 (BK150/125/125)2606001203572601001942026-01-132026-01-26160,00028932601007332026-01-2292026-02-02On time
2601001282026-01-10BAHAN PACKING3011.0216NFT00 40X40 KOBIN MP2 KW-B 403X54 (BK150/125/125)2605000313632601001942026-01-132026-01-2650,00028932601009082026-01-27142026-02-02On time
2601001282026-01-10BAHAN PACKING3011.02NFT00 40X40 KOBIN MP1 KW-A 403X51 (BK150/125/125)2606001204092601001942026-01-132026-01-26160,00033132601008582026-01-26132026-02-02On time
2601001282026-01-10BAHAN PACKING3011.02NFT00 40X40 KOBIN MP1 KW-A 403X51 (BK150/125/125)2606001204092601001942026-01-132026-01-26160,00033132601009082026-01-27142026-02-02On time
2601001282026-01-10BAHAN PACKING3011.0201NFT00 40X40 KOBIN MP2 KW-A 403X54 (BK150/125/125)2606001203572601001942026-01-132026-01-26160,00028932601008582026-01-26132026-02-02On time
2601001352026-01-10SPAREPART5027.0451MARTIN PULLY SPB 315 - 5 TAPER BUSH 3535 - 752601001934,165,0002601001932026-01-132026-01-2424,165,00032601007432026-01-2292026-01-31On time
2601001352026-01-10SPAREPART5027.0457MARTIN PULLY SPZ 85 - 2 TAPER BUSH 1610 - 28260100350400,0002601001932026-01-132026-01-242400,00032601007432026-01-2292026-01-31On time
2601001352026-01-10SPAREPART5027.0454MARTIN PULLY SPZ 85 - 2 TAPER BUSH 1610 - 28260100193370,0002601001932026-01-132026-01-242370,00032601007432026-01-2292026-01-31On time
2601001352026-01-10SPAREPART5027.0011MARTIN PULLY SPB 200 - 4 TAPER BUSH 3020 - 482601001931,600,0002601001932026-01-132026-01-2421,600,00032601007432026-01-2292026-01-31On time
2601001352026-01-10SPAREPART5027.0445MARTIN PULLY SPB 200 - 4 TAPER BUSH 3020 - 422601001931,600,0002601001932026-01-132026-01-24101,600,00032601007432026-01-2292026-01-31On time
2601001352026-01-10SPAREPART5027.0427MARTIN PULLY SPB 125 - 4 TAPER BUSH 2012 - 48260100193600,0002601001932026-01-132026-01-2410600,00032601007432026-01-2292026-01-31On time
2601001352026-01-10SPAREPART5027.0456MARTIN PULLY SPZ 125 - 2 TAPER BUSH 1610 - 28260100193490,0002601001932026-01-132026-01-242490,00032601007432026-01-2292026-01-31On time
2601001352026-01-10SPAREPART5027.0448MARTIN PULLY SPB 250 - 4 TAPER BUSH 3020 - 602601001932,200,0002601001932026-01-132026-01-2422,200,00032601007432026-01-2292026-01-31On time
2601001352026-01-10SPAREPART5027.045MARTIN PULLY SPB 224 - 5 TAPER BUSH 3535 - 652601001932,915,0002601001932026-01-132026-01-2422,915,00032601007432026-01-2292026-01-31On time
2601001352026-01-10SPAREPART5027.001MARTIN PULLY SPA 200 - 3 TAPER BUSH 2517 - 482601001931,100,0002601001932026-01-132026-01-2411,100,00032601007432026-01-2292026-01-31On time
2601001352026-01-10SPAREPART5027.0455MARTIN PULLY SPZ 112 - 2 TAPER BUSH 1610 - 382601001934,325,0002601001932026-01-132026-01-2424,325,00032601007432026-01-2292026-01-31On time
2601001352026-01-10SPAREPART5027.0379MARTIN PULLY SPA 224 - 3 TAPER BUSH 2517 - 482601001931,300,0002601001932026-01-132026-01-2411,300,00032601007432026-01-2292026-01-31On time
2601001352026-01-10SPAREPART5027.0452MARTIN PULLY SPA 355 - 4 TAPER BUSH 3020 - 552601001933,330,0002601001932026-01-132026-01-2423,330,00032601007432026-01-2292026-01-31On time
2601001352026-01-10SPAREPART5027.0449MARTIN PULLY SPB 250 - 4 TAPER BUSH 3020 - 552601001932,200,0002601001932026-01-132026-01-2422,200,00032601007432026-01-2292026-01-31On time
2601001352026-01-10SPAREPART5027.0453MARTIN PULLY SPB 180 - 4 TAPER BUSH 2517 - 482601001931,250,0002601001932026-01-132026-01-2421,250,00032601007432026-01-2292026-01-31On time
2601100012026-01-02SPAREPART5019.0348COVER COUPLING EBARA 80 X 65 FS4KA EBARA 80 X 65 FS4KA260110078270,0002601100782026-01-132026-01-222270,000112601109822026-02-19372026-01-29Late
2601100012026-01-02SPAREPART5019.0347COUPLING MOTOR UNTUK EBARA 80X65 FS4KA EBARA 80X65 FS4KA2601100791,500,0002601100792026-01-132026-01-2321,500,000112601106072026-02-02202026-01-30Late
2601100012026-01-02SPAREPART5022.0383COUPLING POMPA UNTUK EBARA 80X65 FS4KA EBARA 80X65 FS4KA2601100791,500,0002601100792026-01-132026-01-2321,500,000112601106072026-02-02202026-01-30Late
2601100012026-01-02SPAREPART5019.0346BASE FRAME UNTUK POMPA EBARA 80 X 65 FS4KA EBARA 80 X 65 FS4KA INCLUDE MUR & BAUT2601100781,250,0002601100782026-01-132026-01-2221,250,000112601109822026-02-19372026-01-29Late
2601100042026-01-05SPAREPART5027.0386WATERPASS 300 MM MAGNETIC26051017165,0002601100792026-01-132026-01-23570,00082601106072026-02-02202026-01-30Late
2601100042026-01-05SPAREPART5027.0117WATERPASS 400 MM26011007945,0002601100792026-01-132026-01-23545,00082601106072026-02-02202026-01-30Late
2601100042026-01-05PERSEDIAAN UMUM6030.1595METERAN 10 MTR26050018363,7502601100632026-01-132026-01-131032,53082601103762026-01-2072026-01-20On time
2601100042026-01-05PERSEDIAAN UMUM6050.0428TANG KOMBINASI 8 INCH26051025946,846.852601100642026-01-132026-01-22455,00082601104082026-01-2292026-01-29On time
2601100042026-01-05PERSEDIAAN UMUM6050.0398KUNCI RING PAS 8-24 MM260500335299,9002601100642026-01-132026-01-222305,00082601104082026-01-2292026-01-29On time
2601100042026-01-05PERSEDIAAN UMUM6050.0608KUNCI INGGRIS 12 INCH26050048794,0002601100842026-01-132026-01-222100,00082601103672026-01-2072026-01-29On time
2601100042026-01-05PERSEDIAAN UMUM6050.0244REGULATOR LPG260110128100,0002601100842026-01-132026-01-225100,00082601103672026-01-2072026-01-29On time
2601100042026-01-05PERSEDIAAN UMUM6050.0245REGULATOR OXYGEN260610001135,135.142601100842026-01-132026-01-225200,00082601103672026-01-2072026-01-29On time
2601100112026-01-06PERSEDIAAN UMUM6030.2526CAT ALUMUNIUM AVIAN26041016051,143.252601100762026-01-132026-01-1330046,487.2572601111782026-02-27452026-01-20Late
2601100112026-01-06PERSEDIAAN UMUM6030.2527CAT AVIAN VERNIS26011007644,086.52601100762026-01-132026-01-1310044,086.572601111782026-02-27452026-01-20Late
2601100112026-01-06PERSEDIAAN UMUM6030.1843GERINDA AMPLAS 4 INCH2604102057,5002601100652026-01-132026-01-223007,50072601104072026-01-2292026-01-29On time
2601100112026-01-06PERSEDIAAN UMUM6030.2525MATA GERINDA POTONG 42604102063,3002601100742026-01-132026-01-223,6003,00072601105012026-01-28152026-01-29On time
2601100112026-01-06PERSEDIAAN UMUM6030.0033KAWAT LAS RB 26 3.2 MM26050021729,729.732601100752026-01-132026-01-1350030,85072601107352026-02-09272026-01-20Late
2601100112026-01-06PERSEDIAAN UMUM6050.0757KACAMATA SAFETY2601103956,9352601100732026-01-132026-01-22207,50072601103792026-01-2072026-01-29On time
2601100112026-01-06PERSEDIAAN UMUM6030.0803KAWAT LAS LB 52 OD 3.2 MM26060012341,531.532601100752026-01-132026-01-1320042,25072601105082026-01-28152026-01-20Late
2601100112026-01-06PERSEDIAAN UMUM6050.0059SARUNG TANGAN26060016817,6002601100722026-01-132026-01-225022,50072601105062026-01-28152026-01-29On time
2601100112026-01-06PERSEDIAAN UMUM6050.0086SARUNG TANGAN LAS26051009322,5232601100662026-01-132026-01-225080,00072601104002026-01-2292026-01-29On time
2601100112026-01-06PERSEDIAAN UMUM6030.0166KAWAT LAS RB 26 2.6 MM26060001333,333.332601100752026-01-132026-01-1350033,15072601107352026-02-09272026-01-20Late
2601100112026-01-06PERSEDIAAN UMUM6060.056FITTING 1/4" KE TUBING 14MM PC14-0226011006782,8752601100672026-01-132026-01-222082,87572601103712026-01-2072026-01-29On time
2601100112026-01-06PERSEDIAAN UMUM6050.0823FITTING 1 INCH KE TUBING 8MM26011006782,8752601100672026-01-132026-01-224082,87572601103712026-01-2072026-01-29On time
2601100112026-01-06PERSEDIAAN UMUM6030.1877CAT AVIAN MEDIUM YELLOW KODE 46526011007657,472.52601100762026-01-132026-01-1320057,472.572601111782026-02-27452026-01-20Late
2601100112026-01-06PERSEDIAAN UMUM6030.1878CAT AVIAN TWILIGHT BLUE KODE 731 @18LITER2606101391,514,692.582601100762026-01-132026-01-13251,108,710.0172601111782026-02-27452026-01-20Late
2601100112026-01-06PERSEDIAAN UMUM6060.0559FITTING 1" KE TUBING 14MM26011006784,5002601100672026-01-132026-01-222084,50072601103712026-01-2072026-01-29On time
2601100142026-01-07PERSEDIAAN UMUM6030.1439TANG LANCIP/ CUCUT 8 INCH26011008782,6502601100872026-01-132026-01-22382,65062601103682026-01-2072026-01-29On time
2601100142026-01-07PERSEDIAAN UMUM6030.062KUAS 2 INCH2605004405,794.62601100882026-01-132026-01-22203,31662601103772026-01-2072026-01-29On time
2601100142026-01-07PERSEDIAAN UMUM6050.0042KUAS ROLL KECIL26050030014,881.082601100882026-01-132026-01-221010,20362601103772026-01-2072026-01-29On time
2601100142026-01-07PERSEDIAAN UMUM6030.1729AVIAN THINNER ENAMEL26061013957,554.172601100952026-01-132026-01-137029,92562603102252026-03-12582026-01-20Late
2601100142026-01-07PERSEDIAAN UMUM6030.1878CAT AVIAN TWILIGHT BLUE KODE 731 @18LITER2606101391,514,692.582601100952026-01-132026-01-1321,108,71062603102252026-03-12582026-01-20Late
← PrevPage 41 of 135Next →Rows per page:1020501005001000