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
2601100512026-01-24PERSEDIAAN UMUM6030.2525MATA GERINDA POTONG 42604102063,3002601101932026-01-272026-02-051,5003,00032601108482026-02-11152026-02-12On time
2601100512026-01-24PERSEDIAAN UMUM6050.1246KUNCI L SET ISKU26010054890,0002601102002026-01-272026-01-27173,90032601107332026-02-09132026-02-03Late
2601100512026-01-24PERSEDIAAN UMUM6030.0486MATA GERINDA POLISH 4 INCH2605100307,5002601101922026-01-272026-02-0530026,60032601106002026-02-0262026-02-12On time
2601100522026-01-26PROMOSI6010.0791RAK DISPLAY GRANITE PARIS260100793380,0002601102012026-01-272026-01-2770380,00012603102492026-03-13452026-02-03Late
2601100522026-01-26PROMOSI6010.079RAK DISPLAY GRANITE OCEANIA260100793380,0002601102012026-01-272026-01-2770380,00012604101722026-04-09722026-02-03Late
2601100522026-01-26PROMOSI6010.0788RAK DISPLAY GRANITE KOBIN260100793380,0002601102012026-01-272026-01-2770380,00012604101722026-04-09722026-02-03Late
2601100522026-01-26PROMOSI6010.0789RAK DISPLAY GRANITE JUPITER260100793380,0002601102012026-01-272026-01-2770380,00012603102492026-03-13452026-02-03Late
2601100532026-01-26PROMOSI6010.0788RAK DISPLAY GRANITE KOBIN260100793380,0002601102022026-01-272026-01-2755380,00012603102502026-03-13452026-02-03Late
2601100532026-01-26PROMOSI6010.079RAK DISPLAY GRANITE OCEANIA260100793380,0002601102022026-01-272026-01-2755380,00012603102502026-03-13452026-02-03Late
2601100532026-01-26PROMOSI6010.0788RAK DISPLAY GRANITE KOBIN260100793380,0002601102022026-01-272026-01-2755380,00012603102232026-03-12442026-02-03Late
2601100532026-01-26PROMOSI6010.0791RAK DISPLAY GRANITE PARIS260100793380,0002601102022026-01-272026-01-2755380,00012603102502026-03-13452026-02-03Late
2601100532026-01-26PROMOSI6010.0791RAK DISPLAY GRANITE PARIS260100793380,0002601102022026-01-272026-01-2755380,00012603102232026-03-12442026-02-03Late
2601100532026-01-26PROMOSI6010.079RAK DISPLAY GRANITE OCEANIA260100793380,0002601102022026-01-272026-01-2755380,00012603102232026-03-12442026-02-03Late
2601100532026-01-26PROMOSI6010.0789RAK DISPLAY GRANITE JUPITER260100793380,0002601102022026-01-272026-01-2755380,00012603102232026-03-12442026-02-03Late
2601100562026-01-26SPAREPART5032.1359DONG AH TUBE 23.5-252604101881,440,0002601101942026-01-272026-02-0521,440,00012601107562026-02-09132026-02-12On time
2601100562026-01-26SPAREPART5032.136DONG AH FLAP 23.5-25260410188960,0002601101942026-01-272026-02-051960,00012601107562026-02-09132026-02-12On time
2511004072025-11-24BAHAN PEMBANTU20AB.0003MEDIUM ALUMINA BALL SIZE: 50MM 68%2603003100.312601005182026-01-282026-05-3127,0000.3652604010662026-04-29912026-06-07On time
2511004072025-11-24BAHAN PEMBANTU20AB.0004MEDIUM ALUMINA BALL SIZE: 60MM 68%2603003100.312601005182026-01-282026-05-3181,0000.3652604010662026-04-29912026-06-07On time
2512000752025-12-03SPAREPART5017.1007ROTARY PADDLE LEVEL SENSOR STICK PENDEK2601004981,900,0002601004982026-01-282026-01-2851,900,000562601012992026-02-0692026-02-04Late
2512000752025-12-03SPAREPART5017.1006MAGNETIC THERMIC 10-25 A260100500725,0002601005002026-01-282026-01-2815725,000562601012122026-02-0472026-02-04On time
2512000752025-12-03SPAREPART5017.1004POWER SUPPLY 24 VDC 50 A260100499510,0002601004992026-01-282026-01-281510,000562601013352026-02-07102026-02-04Late
2512004082025-12-26PERSEDIAAN UMUM6030.2513MATA BOR BESI M 20260100501883,738.742601005012026-01-282026-01-281883,738.74332601010782026-01-3022026-02-04On time
2512005022025-12-31SPAREPART5031.0604CAMLOCK TYPE A 2 INCH260100550180,0002601004932026-01-282026-01-282180,000282601011702026-02-0362026-02-04On time
2512005022025-12-31SPAREPART5031.0437CAMLOCK TYPE E 2 INCH260100550300,0002601004932026-01-282026-01-282300,000282601011702026-02-0362026-02-04On time
2512005112025-12-23PERSEDIAAN UMUM6030.1188SEALANT HITAM26010050126,126.132601005012026-01-282026-01-285026,126.13362601010782026-01-3022026-02-04On time
2512005112025-12-23PERSEDIAAN UMUM6030.1349SEALANT GUN26030030029,279.282601005012026-01-282026-01-28160,360.36362601010782026-01-3022026-02-04On time
2512100422025-12-15STATIONERY6010.0751CETAKAN FORM PACKING SORTIR FR-QMS-1126031006280,0002601102172026-01-282026-02-06580,00044–––2026-02-13Overdue
2512100422025-12-15STATIONERY6010.075CETAKAN FORM TILE DIMENSION FR-QMS-05/REV126011021780,0002601102172026-01-282026-02-06580,00044–––2026-02-13Overdue
2601000322026-01-06SPAREPART5030.0141SOLENOID VALVE MONOST. C9640100043 || SY5140-5FU-Q PLUG2601005211,136,7832601005212026-01-282026-03-28101,136,783222603010052026-03-31622026-04-04On time
2601000852026-01-08SPAREPART5011.0558BEARING 6004-ZZ-NR26010050727,5002601005072026-01-282026-02-16127,500202601012512026-02-0582026-02-23On time
2601000852026-01-08SPAREPART5011.0426BEARING 6206 ZZ NR26010050739,2002601005072026-01-282026-02-16239,200202601012512026-02-0582026-02-23On time
2601000852026-01-08SPAREPART5011.0429BEARING 6303 ZZ NR26010050734,2002601005072026-01-282026-02-16134,200202601012512026-02-0582026-02-23On time
2601000852026-01-08SPAREPART5011.0428BEARING 6202 ZZ NR26010050820,3502601005082026-01-282026-02-16220,350202601011472026-02-0252026-02-23On time
2601000852026-01-08SPAREPART5011.0427BEARING 6005 ZZ NR26010050745,5002601005072026-01-282026-02-16145,500202601012512026-02-0582026-02-23On time
2601000982026-01-05SPAREPART5030.0996CARELLO SPINTORE C8321271404 || DI=545X160X12 4F DF142601005218,812,9962601005212026-01-282026-03-2828,812,996232603010102026-03-31622026-04-04On time
2601000982026-01-05SPAREPART5030.1792PIN/BEARING C9213503206260100521946,9282601005212026-01-282026-03-284946,928232601011782026-02-0362026-04-04On time
2601000982026-01-05SPAREPART5030.1739660105093 CILINDRO SMC MGQM 50-252601005213,418,1612601005212026-01-282026-03-2823,418,161232601011782026-02-0362026-04-04On time
2601000982026-01-05SPAREPART5030.0641GUIDE NADELLA FS40TT C8125049430 || L=1530 7F DF92601005219,914,6212601005212026-01-282026-03-2829,914,621232603010052026-03-31622026-04-04On time
2601000982026-01-05SPAREPART5030.071ROLLER C9282032067260100521370,3332601005212026-01-282026-03-282370,333232601011782026-02-0362026-04-04On time
2601000982026-01-05SPAREPART5030.006PIN IDLE FRNR 32 C92135032112601005211,183,6602601005212026-01-282026-03-28141,183,660232601017122026-02-18212026-04-04On time
2601000982026-01-05SPAREPART5030.0059IDLE PIN FRN 32EI 9213-50-32102601005211,136,7832601005212026-01-282026-03-28201,136,783232601011782026-02-0362026-04-04On time
2601000982026-01-05SPAREPART5030.17319282032068 RULLO DUGOMRULLI 305011 ZB GV L330260100521435,9622601005212026-01-282026-03-282435,962232601011782026-02-0362026-04-04On time
2601001092026-01-09PERSEDIAAN UMUM6030.2559ELBOW GALVANIS 3 INCH260510043118,0002601005012026-01-282026-01-28538,918.92192601010782026-01-3022026-02-04On time
2601001092026-01-09PERSEDIAAN UMUM6030.2361TEE LAS GALVANIS 3 INCH26010050191,891.892601005012026-01-282026-01-28591,891.89192601010782026-01-3022026-02-04On time
2601001842026-01-14PERSEDIAAN UMUM6030.2337BESI HOLLOW 50X50X2.7-2.8 MM260400086345,945.952601004942026-01-282026-01-2820285,135.13142601011252026-01-3132026-02-04On time
2601001842026-01-14PERSEDIAAN UMUM6030.2337BESI HOLLOW 50X50X2.7-2.8 MM260400086345,945.952601004942026-01-282026-01-2820285,135.13142601011232026-01-3132026-02-04On time
2601001862026-01-14BAHAN BAKAR4060.0032SHELL GADUS S3 V220C 22601004861,818,0002601004862026-01-282026-01-28101,818,000142601010222026-01-2912026-02-04On time
2601002482026-01-20PERSEDIAAN UMUM6020.0107KABEL SCUN 25 MM2601006643,0002601004972026-01-282026-01-281003,00082601012172026-02-0472026-02-04On time
2601002482026-01-20PERSEDIAAN UMUM6030.0526ISOLASI ELECTRIC2605004926,306.312601004962026-01-282026-01-28205,855.8682601010762026-01-3022026-02-04On time
2601002482026-01-20PERSEDIAAN UMUM6020.0069KABEL SCUN 35 MM2604002686,0002601004972026-01-282026-01-281004,00082601012172026-02-0472026-02-04On time
2601002792026-01-22PERSEDIAAN UMUM6050.1313SEROK BERAS BESAR DIAMETER 22 CM26010050322,0002601005032026-01-282026-02-07222,00062601010802026-01-3022026-02-14On time
2601003012026-01-23SPAREPART5011.042BEARING RB 206260100504100,5002601005042026-01-282026-02-1410100,50052601013002026-02-0692026-02-21On time
2601003012026-01-23SPAREPART5027.0127REL VANBELT M 25X2400 MM260100684450,0002601004892026-01-282026-02-1950450,00052601013792026-02-09122026-02-26On time
2601003062026-01-23SPAREPART5017.0991DOUBLE LEVEL TERMINAL BLOCK26010051017,5002601005102026-01-282026-02-141517,50052601012182026-02-0472026-02-21On time
2601003112026-01-24PERSEDIAAN UMUM6010.0792LOGO PS MARK 40X40 15X4 CM260400378852601005062026-01-282026-02-065,0008542601011162026-01-3132026-02-13On time
2601003122026-01-24SPAREPART5011.0102BEARING 6206 2RS C326060022735,3002601005112026-01-282026-02-135035,30042601013092026-02-0692026-02-20On time
2601003122026-01-24SPAREPART5029.016CERAMIC FIBRE BULK TEMP 1350áµ’C @20KG BRAND: MORGAN260500157120,0002601005052026-01-282026-02-1320120,00042601012272026-02-0472026-02-20On time
2601003182026-01-24PERSEDIAAN UMUM6010.0333SERAT FIBER2604100335,0002601005022026-01-282026-01-281002,50042601010882026-01-3022026-02-04On time
2601003182026-01-24PERSEDIAAN UMUM6030.0541PIPA PVC 6 INCH260100502740,0002601005022026-01-282026-01-2820740,00042601010882026-01-3022026-02-04On time
2601003182026-01-24PERSEDIAAN UMUM6030.0479AQUA PROOF26030019958,7502601004952026-01-282026-01-28458,75042601020272026-02-27302026-02-04Late
2601003182026-01-24PERSEDIAAN UMUM6030.0578SOCK PVC() 6 INCH260100502170,0002601005022026-01-282026-01-2820170,00042601012062026-02-0472026-02-04On time
2601003182026-01-24PERSEDIAAN UMUM6030.0575ELBOW PVC 6 INCH260100502235,0002601005022026-01-282026-01-2840235,00042601010882026-01-3022026-02-04On time
2601003182026-01-24PERSEDIAAN UMUM6030.0575ELBOW PVC 6 INCH260100502235,0002601005022026-01-282026-01-2840235,00042601012062026-02-0472026-02-04On time
2601003182026-01-24PERSEDIAAN UMUM6030.0575ELBOW PVC 6 INCH260100502235,0002601005022026-01-282026-01-2840235,00042601012442026-02-0582026-02-04Late
2601003182026-01-24PERSEDIAAN UMUM6030.0479AQUA PROOF26030019958,7502601004952026-01-282026-01-28458,75042601010302026-01-2912026-02-04On time
2601003202026-01-24PERSEDIAAN UMUM6050.0045MAJUN WARNA2605004418,2002601005162026-01-282026-02-092137,20042601013412026-02-07102026-02-16On time
2601003202026-01-24PERSEDIAAN UMUM6050.0162SEKROP26060008750,0002601005122026-01-282026-02-07550,00042601010842026-01-3022026-02-14On time
2601003332026-01-26PERSEDIAAN UMUM6030.2602BAUT + MUR STAINLESS M 12X150 MM26010049222,2502601004922026-01-282026-01-28222,25022601010982026-01-3022026-02-04On time
2601003392026-01-26SPAREPART5021.0384V. BELT XPB 1550260100621220,0002601004902026-01-282026-02-098220,00022601014752026-02-11142026-02-16On time
2601003392026-01-26SPAREPART5021.0452V. BELT XPA 1532260100490152,2002601004902026-01-282026-02-094152,20022601014752026-02-11142026-02-16On time
2601003392026-01-26SPAREPART5021.0384V. BELT XPB 1550260100621220,0002601004902026-01-282026-02-098220,00022601020292026-02-27302026-02-16Late
2601003392026-01-26SPAREPART5021.045V. BELT XPA 1650260100490165,9002601004902026-01-282026-02-094165,90022601014752026-02-11142026-02-16On time
2601003392026-01-26SPAREPART5021.0451V. BELT 5VX560260100490189,7002601004902026-01-282026-02-0920189,70022601014752026-02-11142026-02-16On time
2601003432026-01-26PERSEDIAAN UMUM6050.0058SARUNG TANGAN TEBAL26060016821,0002601005132026-01-282026-02-0916520,50022601011202026-01-3132026-02-16On time
2601003432026-01-26PERSEDIAAN UMUM6050.1231CIKRAK SENG26050042110,0002601005172026-01-282026-02-09610,00022601010942026-01-3022026-02-16On time
2601003432026-01-26PERSEDIAAN UMUM6050.0039SAPU LIDI26061008012,0002601005172026-01-282026-02-09105,00022601010942026-01-3022026-02-16On time
2601003432026-01-26PERSEDIAAN UMUM6050.0059SARUNG TANGAN26060016817,6002601005132026-01-282026-02-0910517,00022601011202026-01-3132026-02-16On time
2601003572026-01-27PERSEDIAAN UMUM6030.259PAVING BLOCK PERSEGI PANJANG 80X105X210 MM (K-400)2604004992,0002601004852026-01-282026-01-2815,0001,843.712601011502026-02-0252026-02-04On time
2601003572026-01-27PERSEDIAAN UMUM6030.259PAVING BLOCK PERSEGI PANJANG 80X105X210 MM (K-400)2604004992,0002601004852026-01-282026-01-2815,0001,843.712601011172026-01-3132026-02-04On time
2601003572026-01-27PERSEDIAAN UMUM6030.259PAVING BLOCK PERSEGI PANJANG 80X105X210 MM (K-400)2604004992,0002601004852026-01-282026-01-2815,0001,843.712601011522026-02-0252026-02-04On time
2601003572026-01-27PERSEDIAAN UMUM6030.259PAVING BLOCK PERSEGI PANJANG 80X105X210 MM (K-400)2604004992,0002601004852026-01-282026-01-2815,0001,843.712601011512026-02-0252026-02-04On time
2601003572026-01-27PERSEDIAAN UMUM6030.259PAVING BLOCK PERSEGI PANJANG 80X105X210 MM (K-400)2604004992,0002601004852026-01-282026-01-2815,0001,843.712601011802026-02-0362026-02-04On time
2601003572026-01-27PERSEDIAAN UMUM6030.259PAVING BLOCK PERSEGI PANJANG 80X105X210 MM (K-400)2604004992,0002601004852026-01-282026-01-2815,0001,843.712601011822026-02-0362026-02-04On time
2601003572026-01-27PERSEDIAAN UMUM6030.259PAVING BLOCK PERSEGI PANJANG 80X105X210 MM (K-400)2604004992,0002601004852026-01-282026-01-2815,0001,843.712601011182026-01-3132026-02-04On time
2601003582026-01-28BAHAN PACKING3011.0201NFT00 40X40 KOBIN MP2 KW-A 403X54 (BK150/125/125)2606001203572601004872026-01-282026-02-1560,000314–2604002342026-04-08702026-02-22Late
2601003582026-01-28BAHAN PACKING3011.0201NFT00 40X40 KOBIN MP2 KW-A 403X54 (BK150/125/125)2606001203572601004872026-01-282026-02-1560,000314–2601014052026-02-10132026-02-22On time
2601003582026-01-28BAHAN PACKING3011.02NFT00 40X40 KOBIN MP1 KW-A 403X51 (BK150/125/125)2606001204092601004872026-01-282026-02-1560,000359–2601014052026-02-10132026-02-22On time
2601003582026-01-28BAHAN PACKING3011.02NFT00 40X40 KOBIN MP1 KW-A 403X51 (BK150/125/125)2606001204092601004872026-01-282026-02-1560,000359–2601013122026-02-07102026-02-22On time
2601003582026-01-28BAHAN PACKING3011.02NFT00 40X40 KOBIN MP1 KW-A 403X51 (BK150/125/125)2606001204092601004872026-01-282026-02-1560,000359–2604002342026-04-08702026-02-22Late
2601003582026-01-28BAHAN PACKING3011.0201NFT00 40X40 KOBIN MP2 KW-A 403X54 (BK150/125/125)2606001203572601004872026-01-282026-02-1560,000314–2601013122026-02-07102026-02-22On time
2601003592026-01-28BAHAN PACKING3011.0027BOX KOBIN MERAH TS PHIL 40*40 KW I2606001201,2752601004882026-01-282026-02-1515,0001,118–2601011992026-02-0472026-02-22On time
2601003592026-01-28BAHAN PACKING3011.003BOX JUPITER MERAH TS PHIL 40*40 KW I2606001201,2752601004882026-01-282026-02-1510,0001,118–2601011992026-02-0472026-02-22On time
2601100182026-01-09BAHAN BAKU GLAZE1098.0023PREVENTOL P 301260410075119,915.822601102112026-01-282026-01-28200119,591.28192601108782026-02-12152026-02-04Late
2601100362026-01-19STATIONERY6010.0501CETAKAN FORM TILE SHAPE INSPECTION RECORD ( FORM HD01 )26031006280,0002601102172026-01-282026-02-06280,0009–––2026-02-13Overdue
2601100452026-01-22BAHAN BAKU GLAZE1098.0014STPP (Sodium Tripolyphospate)26060004525,7002601102082026-01-282026-01-283,00026,00062604105692026-04-29912026-02-04Late
2601100462026-01-23BAHAN PACKING3011.0206CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP2 KWA 605X38 (WK150/125/150)2606101056592601102232026-01-282026-01-28159,60065952601111052026-02-23262026-02-04Late
2601100462026-01-23BAHAN PACKING3011.0205CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601102232026-01-282026-01-28159,60069652603102812026-03-16472026-02-04Late
2601100462026-01-23BAHAN PACKING3011.0205CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601102232026-01-282026-01-28159,60069652601109522026-02-16192026-02-04Late
2601100462026-01-23BAHAN PACKING3011.0205CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601102232026-01-282026-01-28159,60069652601108772026-02-12152026-02-04Late
2601100462026-01-23BAHAN PACKING3011.0205CARTON BOX SIDEWRAPS KOBIN 60X60 GP MP1 KWA 605X40 (WK150/125/150)2606101056962601102232026-01-282026-01-28159,60069652601111052026-02-23262026-02-04Late
← PrevPage 52 of 135Next →Rows per page:1020501005001000