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
2601000952026-01-08BAHAN PACKING3011.0066BOX KAISAR TS 40*40 KW I2605004741,2752601004592026-01-262026-02-1630,0001,118182603002972026-03-07402026-02-23Late
2601000952026-01-08BAHAN PACKING3011.0066BOX KAISAR TS 40*40 KW I2605004741,2752601004592026-01-262026-02-1630,0001,118182601016982026-02-18232026-02-23On time
2601000952026-01-08BAHAN PACKING3011.0066BOX KAISAR TS 40*40 KW I2605004741,2752601004592026-01-262026-02-1630,0001,11818–––2026-02-23Overdue
2601000952026-01-08BAHAN PACKING3011.0071BOX MY TS 40*40 KW 12605004741,2752601004592026-01-262026-02-1630,0001,118182603006912026-03-16492026-02-23Late
2601000952026-01-08BAHAN PACKING3011.0071BOX MY TS 40*40 KW 12605004741,2752601004592026-01-262026-02-1630,0001,118182601015082026-02-12172026-02-23On time
2601000952026-01-08BAHAN PACKING3011.0071BOX MY TS 40*40 KW 12605004741,2752601004592026-01-262026-02-1630,0001,11818–––2026-02-23Overdue
2601000952026-01-08BAHAN PACKING3011.0071BOX MY TS 40*40 KW 12605004741,2752601004592026-01-262026-02-1630,0001,118182601016982026-02-18232026-02-23On time
2601000952026-01-08BAHAN PACKING3011.0026BOX KOBIN MERAH TS 40*40 KW I2606001201,2752601004592026-01-262026-02-1670,0001,118182601011572026-02-0382026-02-23On time
2601000952026-01-08BAHAN PACKING3011.0026BOX KOBIN MERAH TS 40*40 KW I2606001201,2752601004592026-01-262026-02-1670,0001,118182601012872026-02-06112026-02-23On time
2601001912026-01-15SPAREPART5012.0008SEAL TC 140.170.1526010044466,6502601004442026-01-262026-02-10466,650112601012772026-02-06112026-02-17On time
2601001912026-01-15SPAREPART5011.0046BEARING 32024260100444751,8502601004442026-01-262026-02-104751,850112601012772026-02-06112026-02-17On time
2601001982026-01-15PERSEDIAAN UMUM6020.0183LAMPU SOROT LED 100 WATT260600253180,180.182601004542026-01-262026-02-042171,171.17112601009532026-01-2822026-02-11On time
2601001982026-01-15SPAREPART5017.0471LAMPU TL LED 1X16W (PK)26010045547,5002601004552026-01-262026-02-06347,500112601009552026-01-2822026-02-13On time
2601001982026-01-15SPAREPART5017.0117STEKER BROCO26060019911,7122601004542026-01-262026-02-04711,711.71112601009532026-01-2822026-02-11On time
2601001982026-01-15SPAREPART5017.012STOP KONTAK 4 LUBANG26061002925,0002601004542026-01-262026-02-04820,720.72112601009532026-01-2822026-02-11On time
2601001982026-01-15SPAREPART5017.0594AUXILIARY CONTACTS 3RH5921-1FA22;2NO+2NC 220080300926010045697,7002601004562026-01-262026-02-10197,700112601012252026-02-0492026-02-17On time
2601002262026-01-19SPAREPART5031.016BALLVALVE PLANDES 5 INCH2601004512,747,747.752601004512026-01-262026-02-1012,747,747.7572604002712026-04-09732026-02-17Late
2601002292026-01-19STATIONERY6010.0243PAPER CLIP NO 52604002074,0002601004632026-01-262026-02-0234,00072601009982026-01-2932026-02-09On time
2601002292026-01-19STATIONERY6010.0148CUTTER BESAR L-5002606101517,7672601004632026-01-262026-02-02112,00072601009982026-01-2932026-02-09On time
2601002292026-01-19STATIONERY6010.0162TIPEX CAIR2606001083,6002601004632026-01-262026-02-0214,90072601009982026-01-2932026-02-09On time
2601002302026-01-19PROMOSI6010.0787BROSUR A52606101146,276.262601004382026-01-262026-01-261,00055072601010902026-01-3042026-02-02On time
2601002332026-01-15PERSEDIAAN UMUM6060.0463BAUT + MUR M 16X602601004503,1002601004502026-01-262026-01-263003,100112601011002026-01-3042026-02-02On time
2601002342026-01-20PERSEDIAAN UMUM6060.0188BAUT SS M 8X25 KUNCI 142601004641,7252601004642026-01-262026-02-101001,72562601012952026-02-06112026-02-17On time
2601002382026-01-20SPAREPART5011.0279BEARING UCP 206260400546120,3002601004692026-01-262026-02-1010127,00062601009762026-01-2822026-02-17On time
2601002382026-01-20SPAREPART5011.025BEARING UC 20626050014875,5002601004692026-01-262026-02-103075,50062601009762026-01-2822026-02-17On time
2601002382026-01-20SPAREPART5011.0141BEARING 6304 2RS26050012033,5002601004692026-01-262026-02-1040033,50062601009762026-01-2822026-02-17On time
2601002382026-01-20SPAREPART5011.0093BEARING 6201 2RS26050018517,4002601004682026-01-262026-02-1015017,40062601012562026-02-05102026-02-17On time
2601002382026-01-20SPAREPART5011.0091BEARING 6200 2RS26010094323,9002601004692026-01-262026-02-1020023,90062601009762026-01-2822026-02-17On time
2601002382026-01-20SPAREPART5011.0065BEARING 6002 2RS26050046920,0002601004692026-01-262026-02-1020020,00062601009762026-01-2822026-02-17On time
2601002382026-01-20SPAREPART5027.0149AS 30MM X 6000MM260100538421,621.622601005382026-01-262026-02-031421,621.6262601011242026-01-3152026-02-10On time
2601002422026-01-20SPAREPART5017.0405OVERLOAD FUJI TR N3H/3 24-34 A260600144510,0002601005592026-01-262026-02-052437,00062604002012026-04-08722026-02-12Late
2601002442026-01-20SPAREPART5022.0387GEAR RS 60 GIGI 30 LUBANG AS 50 SPY 10260100461215,0002601004612026-01-262026-02-202215,00062601016492026-02-16212026-02-27On time
2601002442026-01-20SPAREPART5022.0386GEAR RS 60 GIGI 19 LUBANG AS 28 SPY 8260100461165,0002601004612026-01-262026-02-202165,00062601016492026-02-16212026-02-27On time
2601002442026-01-20SPAREPART5022.0388GEAR RS 60 GIGI 20 LUBANG AS 28 SPY 10260100461225,0002601004612026-01-262026-02-202225,00062601016492026-02-16212026-02-27On time
2601002612026-01-21SPAREPART5019.0351MOTOR 3 PHASE VERMONT MOTOR 1.5 KW 2 HP 1460 RPM 220/380 V FLANGE B52601004451,875,0002601004452026-01-262026-02-0741,875,00052601009582026-01-2822026-02-14On time
2601002612026-01-21SPAREPART5017.107LAMPU SOROT LED IP66 100W260100442171,171.172601004422026-01-262026-02-054171,171.1752601009522026-01-2822026-02-12On time
2601002652026-01-22PERSEDIAAN UMUM6030.2591AS DRAT M 30X100 CM260100450106,0002601004502026-01-262026-01-2620106,00042601011002026-01-3042026-02-02On time
2601002652026-01-22PERSEDIAAN UMUM6060.0659LONG DRAT M 1426010045015,1002601004502026-01-262026-01-261015,10042601011002026-01-3042026-02-02On time
2601002652026-01-22PERSEDIAAN UMUM6060.0205MUR M 4260400531352601004502026-01-262026-01-261503542601011002026-01-3042026-02-02On time
2601002652026-01-22PERSEDIAAN UMUM6060.0238RING PLAT M 142605004645502601004502026-01-262026-01-2620055042601011002026-01-3042026-02-02On time
2601002712026-01-22BAHAN PEMBANTU2034.0001LEM LP 5840N26060024741,218.32601004482026-01-262026-02-0280033,67642601011532026-02-0382026-02-09On time
2601002712026-01-22BAHAN PEMBANTU2034.0001LEM LP 5840N26060024741,218.32601004482026-01-262026-02-0280033,67642601014672026-02-11162026-02-09Late
2601002752026-01-22SPAREPART5012.0106SEAL TC 40.62.102601004419,0002601004412026-01-262026-02-10159,00042601011482026-02-0272026-02-17On time
2601002752026-01-22SPAREPART5012.0056SEAL TC 25.35.82601004414,0002601004412026-01-262026-02-10154,00042601011482026-02-0272026-02-17On time
2601002752026-01-22SPAREPART5012.0125SEAL TC 50.72.1026010044112,0002601004412026-01-262026-02-101012,00042601011482026-02-0272026-02-17On time
2601002752026-01-22SPAREPART5012.0109SEAL TC 40.62.826010044113,0002601004412026-01-262026-02-101513,00042601011482026-02-0272026-02-17On time
2601002752026-01-22SPAREPART5012.0202SEAL TC 45.65.72601011179,0002601004412026-01-262026-02-10159,00042601011482026-02-0272026-02-17On time
2601002752026-01-22SPAREPART5012.0055SEAL TC 25.35.72601009564,0002601004412026-01-262026-02-10157,00042601011482026-02-0272026-02-17On time
2601002752026-01-22SPAREPART5012.0231SEAL TC 50.80.826010044112,0002601004412026-01-262026-02-101012,00042601011482026-02-0272026-02-17On time
2601002752026-01-22SPAREPART5012.0075SEAL TC 30.42.72604005306,0002601004412026-01-262026-02-10159,00042601011482026-02-0272026-02-17On time
2601002752026-01-22SPAREPART5012.0073SEAL TC 30.40.72601004414,0002601004412026-01-262026-02-10104,00042601011482026-02-0272026-02-17On time
2601002752026-01-22SPAREPART5012.0079SEAL TC 30.47.726010044111,0002601004412026-01-262026-02-101511,00042601011482026-02-0272026-02-17On time
2601002772026-01-22SPAREPART5021.022V. BELT SPB 3550260100466209,0002601004662026-01-262026-02-109209,00042601009682026-01-2822026-02-17On time
2601002772026-01-22SPAREPART5021.0123V. BELT B - 250260101026191,2002601004662026-01-262026-02-1010191,20042601009682026-01-2822026-02-17On time
2601002772026-01-22SPAREPART5021.0123V. BELT B - 250260101026191,2002601004662026-01-262026-02-1010191,20042601013052026-02-06112026-02-17On time
2601002772026-01-22SPAREPART5021.0155V. BELT C - 214260300498297,8002601004662026-01-262026-02-1010297,80042601020472026-02-27322026-02-17Late
2601002772026-01-22SPAREPART5021.0104V. BELT B - 196260101095142,3002601004662026-01-262026-02-108142,30042601009682026-01-2822026-02-17On time
2601002772026-01-22SPAREPART5021.0155V. BELT C - 214260300498297,8002601004662026-01-262026-02-1010297,80042601013052026-02-06112026-02-17On time
2601002772026-01-22SPAREPART5021.0104V. BELT B - 196260101095142,3002601004662026-01-262026-02-108142,30042601013052026-02-06112026-02-17On time
2601002772026-01-22SPAREPART5021.0155V. BELT C - 214260300498297,8002601004662026-01-262026-02-1010297,80042601020452026-02-27322026-02-17Late
2601002772026-01-22SPAREPART5021.0155V. BELT C - 214260300498297,8002601004662026-01-262026-02-1010297,80042601009682026-01-2822026-02-17On time
2601002772026-01-22SPAREPART5021.0311V. BELT B - 11626010084584,2502601004652026-01-262026-02-10384,25042601011462026-02-0272026-02-17On time
2601002772026-01-22SPAREPART5021.0119V. BELT B - 240260100658183,5002601004662026-01-262026-02-1010183,50042601009682026-01-2822026-02-17On time
2601002872026-01-23FIXED ASSETSAST02623Sieben Screen 118 Fabric Greydimensi produk 118 cm x 3.6 cm x 31.5 cm260100431688,423.52601004312026-01-262026-01-304688,423.53–––2026-02-06Overdue
2601002872026-01-23FIXED ASSETSAST02622Sieben Meja Kantor 1s lw - Putih (120 CM)dimensi produk: 120 cm x 60 cm x 75 cm2601004311,990,2252601004312026-01-262026-01-3011,990,2253–––2026-02-06Overdue
2601002872026-01-23FIXED ASSETSAST02522Sunon Shield Kursi Kantor - Hitam2601004311,080,1802601004312026-01-262026-01-3081,080,1803–––2026-02-06Overdue
2601002872026-01-23FIXED ASSETSAST02524Sieben Meja Kantor Ekstensi 2s lw - Putih (120 CM)2601004314,057,793.662601004312026-01-262026-01-3034,057,793.663–––2026-02-06Overdue
2601002872026-01-23FIXED ASSETSAST02523Sieben Meja Kantor 2s lw - Putih (120 CM)2601004314,517,2532601004312026-01-262026-01-3014,517,2533–––2026-02-06Overdue
2601002952026-01-19PERSEDIAAN UMUM6030.0004SEMEN GRESIK 40KG26050024159,5002601005392026-01-262026-01-261558,00072601010862026-01-3042026-02-02On time
2601002952026-01-19PERSEDIAAN UMUM6030.2576PIPA AW 10 INCH X 4 M2604002201,168,301.82601005392026-01-262026-01-2681,785,00072601010962026-01-3042026-02-02On time
2601002952026-01-19PERSEDIAAN UMUM6030.0823PASIR AYAK2605003391,150,0002601005392026-01-262026-01-2611,150,00072601011152026-01-3152026-02-02On time
2601003142026-01-24PERSEDIAAN UMUM6030.003PAKU 2 INCH26060016715,333.332601004702026-01-262026-02-026015,00022601009162026-01-2712026-02-09On time
2601003252026-01-22STATIONERY6010.0001KERTAS A426060024443,0002601004392026-01-262026-02-105043,50042601009962026-01-2932026-02-17On time
2601003292026-01-24BAHAN PACKING3011.0249NFT00 60X60 KOBIN MP2 KW-A 606X48 (WK150/150/150)2604003306822601004582026-01-262026-02-1660,00062922601016962026-02-18232026-02-23On time
2601003292026-01-24BAHAN PACKING3011.0248NFT00 60X60 KOBIN MP1 KW-A 606X45 (WK150/150/150)2604003307482601004582026-01-262026-02-1660,00068922601016962026-02-18232026-02-23On time
2601100112026-01-06SPAREPART5010.0073TEKIRO SARINGAN UDARA KOMPRESOR AT-AC1703 2 TUBE 1PC260110182535,5002601101822026-01-262026-02-0420535,500202601108282026-02-10152026-02-11On time
2601100112026-01-06SPAREPART5010.0073TEKIRO SARINGAN UDARA KOMPRESOR AT-AC1703 2 TUBE 1PC260110182535,5002601101822026-01-262026-02-0420535,500202603100362026-03-03362026-02-11Late
2601100352026-01-19PERSEDIAAN UMUM6030.2238KACA LAS HITAM NO.102605100913,2502601101782026-01-262026-01-26203,4257–––2026-02-02Overdue
2601100352026-01-19PERSEDIAAN UMUM6030.1731KAWAT LAS LB 52 Ø 2,6MM26031009344,3002601101792026-01-262026-01-2615042,70072601111532026-02-25302026-02-02Late
2601100352026-01-19PERSEDIAAN UMUM6030.0803KAWAT LAS LB 52 OD 3.2 MM26060012341,531.532601101792026-01-262026-01-2615042,25072601111532026-02-25302026-02-02Late
2601100412026-01-21PERSEDIAAN UMUM6050.0687OXYGEN /O2 (Refill, Capacity 6 m3/ 40L/ Pressure 150 bar industrial Grade Purity 99,6%)26061011063,0002601101812026-01-262026-02-04563,00052601111862026-02-27322026-02-11Late
2601100442026-01-21PERSEDIAAN UMUM6020.0146WD 4026060016991,5002601101832026-01-262026-02-051575,00052601110292026-02-20252026-02-12Late
2601100442026-01-21PERSEDIAAN UMUM6050.0938LEM AICA AIBON (KEMASAN 300GRAM)26051017956,0002601101802026-01-262026-02-041049,00052601105962026-02-0272026-02-11On time
2511003912025-11-25SPAREPART5030.0253CHAIN 13320480026040042672.752601004772026-01-272026-05-154064.6863–––2026-05-22Overdue
2511003922025-11-25SPAREPART5021.0307V. BELT 5B - 230 SEGI 5260100476702601004762026-01-272026-02-282070632603008302026-03-19512026-03-07Late
2512000582025-12-03BAHAN BAKU GLAZE1070.0007INK - CIK RC 1151 SINKING260600273284,2812601004722026-01-272026-01-28126270,914552601010032026-01-2922026-02-04On time
2512001352025-12-06PERSEDIAAN UMUM6020.067SSD ADATA SU650 512 GB - SSD SATA 3-2.5 INCH2601004821,300,0002601004822026-01-272026-01-2711,300,000522601018182026-02-20242026-02-03Late
2512001352025-12-06PERSEDIAAN UMUM6050.0665TRAFFIC CONE260400449108,108.112601004812026-01-272026-01-272152,252.25522601015372026-02-12162026-02-03Late
2512003712025-12-22SPAREPART5014.0051STANDART SIEVE MESH 60 OPENING 0.25 MM2601004848.12601004842026-01-272026-02-2818.136–––2026-03-07Overdue
2512003712025-12-22SPAREPART5014.0051STANDART SIEVE MESH 60 OPENING 0.25 MM2601004848.12601004842026-01-272026-02-2818.1362604009922026-04-27902026-03-07Late
2512003712025-12-22SPAREPART5014.0052STANDART SIEVE MESH 80 OPENING 0.177 MM2601004848.12601004842026-01-272026-02-2818.1362604009922026-04-27902026-03-07Late
2512003712025-12-22SPAREPART5014.0052STANDART SIEVE MESH 80 OPENING 0.177 MM2601004848.12601004842026-01-272026-02-2818.136–––2026-03-07Overdue
2512003712025-12-22SPAREPART5014.005STANDART SIEVE MESH 40 OPENING 0.24 MM2601004848.12601004842026-01-272026-02-2818.136–––2026-03-07Overdue
2512003712025-12-22SPAREPART5014.005STANDART SIEVE MESH 40 OPENING 0.24 MM2601004848.12601004842026-01-272026-02-2818.1362604009922026-04-27902026-03-07Late
2512003712025-12-22SPAREPART5014.0049STANDART SIEVE MESH 20 OPENING 0.84 MM2601004848.12601004842026-01-272026-02-2818.136–––2026-03-07Overdue
2512003712025-12-22SPAREPART5014.0049STANDART SIEVE MESH 20 OPENING 0.84 MM2601004848.12601004842026-01-272026-02-2818.1362604009922026-04-27902026-03-07Late
2512003912025-12-23SPAREPART5029.046316DO (OC211) CCT+0001535260100475251.752601004752026-01-272026-03-271251.7535–––2026-04-03Overdue
2512003912025-12-23SPAREPART5029.046416DO (OC212) CCT+0004223260100475214.232601004752026-01-272026-03-276214.2335–––2026-04-03Overdue
2512003912025-12-23SPAREPART5029.046216DI CCT+0001016260100475170.052601004752026-01-272026-03-273170.0535–––2026-04-03Overdue
2512003912025-12-23SPAREPART5029.0461POWER SUPLY UNIT PLC CCT+0001013260100475250.82601004752026-01-272026-03-271250.835–––2026-04-03Overdue
← PrevPage 50 of 135Next →Rows per page:1020501005001000