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
2601100052026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601100512026-01-072026-01-192,00041,00022601103902026-01-21142026-01-26On time
2601100052026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601100512026-01-072026-01-192,00041,00022601105272026-01-28212026-01-26Late
2601100052026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601100512026-01-072026-01-192,00041,00022601103972026-01-22152026-01-26On time
2601100052026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601100512026-01-072026-01-192,00041,00022601102652026-01-1472026-01-26On time
2601100052026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601100512026-01-072026-01-192,00041,00022601102742026-01-1472026-01-26On time
2601100052026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601100512026-01-072026-01-192,00041,00022601103062026-01-17102026-01-26On time
2601100052026-01-05BAHAN PEMBANTU2045.0007PALLET LOKAL BARU 110*11026060027161,0002601100512026-01-072026-01-192,00041,00022601103982026-01-22152026-01-26On time
2601100062026-01-06BAHAN BAKU BODY1098.0019WATERGLASS 215#2606101252,5002601100352026-01-072026-01-0748,0002,27512601105022026-01-28212026-01-14Late
2601100062026-01-06BAHAN BAKU BODY1098.0019WATERGLASS 215#2606101252,5002601100352026-01-072026-01-0748,0002,27512601103012026-01-17102026-01-14Late
2601100072026-01-07BAHAN BAKU BODY1010.0021BLACK TALCUM2601100300.972601100302026-01-072026-01-072,688,0000.97–2603104072026-03-31832026-01-14Late
2601100072026-01-07BAHAN BAKU BODY1098.0017SODIUM POLYACRYLATE 230#2601101130.932601100292026-01-072026-01-0748,0000.93–2603104112026-03-31832026-01-14Late
2601100072026-01-07BAHAN BAKU BODY1010.0021BLACK TALCUM2601100300.972601100302026-01-072026-01-072,688,0000.97–2603101862026-03-10622026-01-14Late
2601100072026-01-07BAHAN BAKU BODY1010.0021BLACK TALCUM2601100300.972601100302026-01-072026-01-072,688,0000.97–2605108132026-05-261392026-01-14Late
2601100072026-01-07BAHAN BAKU BODY1010.0021BLACK TALCUM2601100300.972601100302026-01-072026-01-072,688,0000.97–2606102952026-06-101542026-01-14Late
2601100072026-01-07BAHAN BAKU BODY1010.0021BLACK TALCUM2601100300.972601100302026-01-072026-01-072,688,0000.97–2606102942026-06-101542026-01-14Late
2601100102026-01-07BAHAN BAKU GLAZE1070.0031INK DP RED GSB 10023 GUOSE2603100561202601100312026-01-072026-01-07300120–2603103292026-03-18702026-01-14Late
2601100102026-01-07BAHAN BAKU GLAZE1070.003INK DP BLACK GSY 99023 GUOSE260310056952601100312026-01-072026-01-072,00079–2603103292026-03-18702026-01-14Late
2601100102026-01-07BAHAN BAKU GLAZE1070.0029INK DP YELLOW GSB 20010 GUOSE260310056982601100312026-01-072026-01-0750098–2603103292026-03-18702026-01-14Late
2511004432025-11-28PERSEDIAAN UMUM6060.0639AS BRONZE 40MM X 500MM2601001051,650,0002601001052026-01-082026-01-2321,650,000412601006632026-01-20122026-01-30On time
2512000852025-12-03PERSEDIAAN UMUM6060.0582AS BRONZE 20MM X 500MM260100141900,0002601001412026-01-082026-01-212900,000362601006612026-01-20122026-01-28On time
2512001712025-12-10PERSEDIAAN UMUM6030.0891STANG BLANDER ST-8 (STRONG)260510110292,783.332601000932026-01-082026-01-0810540,540.54292601002642026-01-0912026-01-15On time
2512001712025-12-10PERSEDIAAN UMUM6030.0891STANG BLANDER ST-8 (STRONG)260510110292,783.332601000932026-01-082026-01-0810540,540.54292601003382026-01-1242026-01-15On time
2512001712025-12-10PERSEDIAAN UMUM6030.0891STANG BLANDER ST-8 (STRONG)260510110292,783.332601000932026-01-082026-01-0810540,540.54292601006942026-01-21132026-01-15Late
2512002322025-12-12SPAREPART5017.0166INVERTER MITSUBISHI FR-D740-0.75 K2605000242,550,0002601000982026-01-082026-01-22342,300,000272601004812026-01-1572026-01-29On time
2512002402025-12-13SPAREPART5022.0382GEAR RS 60 OD 28 Z 30 SPY 12260100150308,0002601001502026-01-082026-01-302308,000262601006622026-01-20122026-02-06On time
2512002402025-12-13SPAREPART5022.0381GEAR RS 60 OD 28 Z 18 SPY 10260100150165,0002601001502026-01-082026-01-302165,000262601006622026-01-20122026-02-06On time
2512002402025-12-13SPAREPART5022.038GEAR RS 80 OD 28 Z 18 SPY 10260100150295,0002601001502026-01-082026-01-302295,000262601006622026-01-20122026-02-06On time
2512003202025-12-19BAHAN BAKU BODY1098.0016DEFLOCCULANT VL-012606000548,1502601001622026-01-082026-02-27175,0006,650202601018682026-02-23462026-03-06On time
2512003202025-12-19BAHAN BAKU BODY1098.0016DEFLOCCULANT VL-012606000548,1502601001622026-01-082026-02-27175,0006,650202601017742026-02-19422026-03-06On time
2512003202025-12-19BAHAN BAKU BODY1098.0016DEFLOCCULANT VL-012606000548,1502601001622026-01-082026-02-27175,0006,650202601019552026-02-24472026-03-06On time
2512003202025-12-19BAHAN BAKU BODY1098.0016DEFLOCCULANT VL-012606000548,1502601001622026-01-082026-02-27175,0006,650202601019482026-02-24472026-03-06On time
2512003202025-12-19BAHAN BAKU BODY1098.0016DEFLOCCULANT VL-012606000548,1502601001622026-01-082026-02-27175,0006,650202601019252026-02-23462026-03-06On time
2512003202025-12-19BAHAN BAKU BODY1098.0016DEFLOCCULANT VL-012606000548,1502601001622026-01-082026-02-27175,0006,650202601018692026-02-23462026-03-06On time
2512003202025-12-19BAHAN BAKU BODY1098.0016DEFLOCCULANT VL-012606000548,1502601001622026-01-082026-02-27175,0006,650202601017752026-02-19422026-03-06On time
2512003602025-12-22PERSEDIAAN UMUM6010.076Lanyard KKI 20262604002648,8752601001282026-01-082026-01-21308,875172601009892026-01-29212026-01-28Late
2512003602025-12-22PERSEDIAAN UMUM6010.0758ID Card NFC2601001285,5002601001282026-01-082026-01-21305,500172601009892026-01-29212026-01-28Late
2512003812025-12-22FIXED ASSETSAST02572AC 1 PK2603000884,037,5002601001132026-01-082026-01-0814,020,500172601003432026-01-1242026-01-15On time
2512003812025-12-22FIXED ASSETSAST02571AC 2 PK2601001136,647,0002601001132026-01-082026-01-0816,647,000172601003432026-01-1242026-01-15On time
2512004052025-12-26STATIONERY6010.0386PLASTIK 5 KG2601001449,0002601001442026-01-082026-01-1259,000132601003712026-01-1352026-01-19On time
2512004682025-12-29PERSEDIAAN UMUM6010.0575MOUSE LAPTOP WIRELESS260500321119,0002601001342026-01-082026-01-2110115,000102601005062026-01-1572026-01-28On time
2512004682025-12-29STATIONERY6010.0124PENSIL MEKANIK26040010713,0002601001042026-01-082026-01-19212,000102601005382026-01-1792026-01-26On time
2512004682025-12-29STATIONERY6010.015ISI CUTTER BESAR L-1502606100606,5002601001342026-01-082026-01-2125,000102601005062026-01-1572026-01-28On time
2512004682025-12-29PERSEDIAAN UMUM6010.0772TRIPOD HANDPHONE260100104143,4402601001042026-01-082026-01-191143,440102601005382026-01-1792026-01-26On time
2512004682025-12-29STATIONERY6010.0716ISI CUTTER A-30026051002334,1202601001342026-01-082026-01-2122,500102601005062026-01-1572026-01-28On time
2512004682025-12-29STATIONERY6010.0667ISOLASI MEJA 1 INCHI2604002063,2002601001042026-01-082026-01-1926,000102601005382026-01-1792026-01-26On time
2512004682025-12-29STATIONERY6010.0572TIPE X / STIPO KERTAS2604002075,4002601001342026-01-082026-01-2115,400102601005062026-01-1572026-01-28On time
2512004682025-12-29STATIONERY6010.0569TAPE CUTTER / DISPENSER LAKBAN26011027124,0352601001342026-01-082026-01-21116,000102601005062026-01-1572026-01-28On time
2512004682025-12-29PERSEDIAAN UMUM6020.005KALKULATOR26060002765,0002601001342026-01-082026-01-21356,000102601005062026-01-1572026-01-28On time
2512004682025-12-29STATIONERY6010.0168GUNTING SEDANG2606000276,2002601001342026-01-082026-01-2126,200102601005062026-01-1572026-01-28On time
2512004682025-12-29STATIONERY6010.0126ISI PENSIL 2B CETEKAN 2B,0.5 mm,12TUBE/BOX,60 mm 12LEADS/TUBE2605000253,0002601001042026-01-082026-01-1922,200102601005382026-01-1792026-01-26On time
2512004682025-12-29STATIONERY6010.0567STOPMAP DIAMOND NO. 200226010010428,0002601001042026-01-082026-01-191128,000102601005382026-01-1792026-01-26On time
2512004682025-12-29STATIONERY6010.0445BATERAI ALKALINE GP AA 1.5V26050002525,8002601001342026-01-082026-01-21512,200102601005062026-01-1572026-01-28On time
2512004682025-12-29STATIONERY6010.0141STABILO BIRU2606000279,3002601001342026-01-082026-01-2119,300102601005062026-01-1572026-01-28On time
2512004892025-12-31PERSEDIAAN UMUM6050.0058SARUNG TANGAN TEBAL26060016821,0002601001462026-01-082026-01-1726520,50082601004362026-01-1462026-01-24On time
2512004892025-12-31PERSEDIAAN UMUM6050.0059SARUNG TANGAN26060016817,6002601001462026-01-082026-01-175017,00082601004362026-01-1462026-01-24On time
2512005002025-12-31PERSEDIAAN UMUM6050.0015PEMBERSIH LANTAI26050042116,0002601001362026-01-082026-01-173016,00082601005532026-01-1792026-01-24On time
2512005002025-12-31PERSEDIAAN UMUM6050.0013SABUN CUCI CAIR26050042112,0002601001362026-01-082026-01-173012,00082601005532026-01-1792026-01-24On time
2512005002025-12-31PERSEDIAAN UMUM6050.0017KAPUR BARUS TOILET26050042128,0002601001362026-01-082026-01-17127,00082601005532026-01-1792026-01-24On time
2512005002025-12-31PERSEDIAAN UMUM6050.1225SABUN COLEK2601003455,5002601001362026-01-082026-01-1725,50082601005532026-01-1792026-01-24On time
2512005042025-12-31STATIONERY6010.0122BOLPOIN HITAM2606000271,3002601001422026-01-082026-01-23341,30082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0146ACCO FASTENER 8.0 CM, 50 SETS/BOX2601005237,7002601001422026-01-082026-01-2317,70082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.015ISI CUTTER BESAR L-1502606100606,5002601001422026-01-082026-01-23605,00082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0241ISI BOLPOIN HITAM2606000277002601001422026-01-082026-01-234870082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.019BUKU TULIS SIDU(16*21) 16 X 21 CM2606000274,6002601001422026-01-082026-01-23204,60082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0151ISI STAPLES KECIL #10 KECIL, NO.10-1M2606101511,5922601001422026-01-082026-01-23422,70082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0027COUNTINOUS FORM 2 PLY 9 ½X11:2260410006186,0002601001422026-01-082026-01-232298,80082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0163LEM POVINAL KERTAS OD: 2.5 X 9 CM, 22ml2606001082,0002601001422026-01-082026-01-2331,90082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0175BINDER CLIP NO. 260 NO. 26026061006018,0002601001422026-01-082026-01-23113,40082601005072026-01-1572026-01-30On time
2512005042025-12-31PERSEDIAAN UMUM6020.0035BATERAI AA2601104505,5002601001422026-01-082026-01-23242,30082601005072026-01-1572026-01-30On time
2512005042025-12-31PERSEDIAAN UMUM6020.0037BATERAI ALKALINE AAA26050002524,0002601001422026-01-082026-01-23511,40082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0771TRIGONAL CLIP NO. 12605002611,6002601001422026-01-082026-01-23101,70082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0148CUTTER BESAR L-5002606101517,7672601001422026-01-082026-01-23212,00082601005072026-01-1572026-01-30On time
2512005042025-12-31PERSEDIAAN UMUM6020.005KALKULATOR26060002765,0002601001422026-01-082026-01-23156,00082601005072026-01-1572026-01-30On time
2512005042025-12-31PERSEDIAAN UMUM6020.0039BATERAI KOTAK 9V26010052311,6002601001422026-01-082026-01-232411,60082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0166TAPE DISPENSER TAPE, 48 mm26050017616,0002601001422026-01-082026-01-231030,00082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0319TINTA WARNA EPSON 00326010052383,0002601001422026-01-082026-01-23483,00082601005072026-01-1572026-01-30On time
2512005042025-12-31PERSEDIAAN UMUM6050.0567DOUBLE FOAM 24 MM NACHI2606001089,2002601001422026-01-082026-01-2356,70082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0319TINTA WARNA EPSON 00326010052383,0002601001422026-01-082026-01-23483,00082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0589LAKBAN HITAM 2 INCI / 48MM2604004939,9002601001422026-01-082026-01-2329,90082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0307PITA PRINTER LX 31026061006016,8002601001422026-01-082026-01-231246,70082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0319TINTA WARNA EPSON 00326010052383,0002601001422026-01-082026-01-23483,00082601005072026-01-1572026-01-30On time
2512005042025-12-31PERSEDIAAN UMUM6030.0531LAKBAN KUNING 48MM2606001459,9002601001422026-01-082026-01-2339,90082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0275TINTA EPSON BLACK - T664126060002783,0002601001422026-01-082026-01-23183,00082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0278TINTA EPSON MAGENTA T664326060002783,0002601001422026-01-082026-01-23183,00082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0279TINTA EPSON YELLOW - T664426060002783,0002601001422026-01-082026-01-23183,00082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.045KERTAS STIKER NON GLOSSY A426060002711,2002601001422026-01-082026-01-23211,20082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.028TINTA EPSON CYAN - T664226060002783,0002601001422026-01-082026-01-23183,00082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0162TIPEX CAIR2606001083,6002601001422026-01-082026-01-2354,90082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0127SPIDOL BOARDMARKER HITAM - BOARDMARKER, HITAM/BLACK2606101518,9982601001422026-01-082026-01-23546,70082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0128SPIDOL BOARD MARKER MERAH BOARDMARKER, MERAH/RED2606000276,7002601001422026-01-082026-01-23366,70082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0133SPIDOL MARKER HITAM - MARKER, HITAM/BLACK2606000275,7002601001422026-01-082026-01-23185,70082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0467TIPEX KERTAS2606001084,7002601001422026-01-082026-01-2345,40082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0761KERTAS BINDER A5 BERGARIS2606000273,5002601001422026-01-082026-01-2343,50082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.001POST IT KECIL2605000266,0002601001422026-01-082026-01-2338,70082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0192BUKU FOLIO 21.5*30.5 21.5 X 31.5 CM26060010816,5002601001422026-01-082026-01-231016,30082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0025CONTINUOUS FORM 5 PLY 9,5 X 11:2260610075175,0002601001422026-01-082026-01-234431,50082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0124PENSIL MEKANIK26040010713,0002601001422026-01-082026-01-23313,00082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0173BINDER CLIP NO. 111 NO. 1112606000273,8002601001422026-01-082026-01-2313,80082601005072026-01-1572026-01-30On time
2512005042025-12-31PERSEDIAAN UMUM6020.0291TINTA HITAM EPSON 00326010014283,0002601001422026-01-082026-01-23883,00082601005072026-01-1572026-01-30On time
2512005042025-12-31STATIONERY6010.0156STAPLES KECIL HD-102606101519,7412601001422026-01-082026-01-23134,50082601005072026-01-1572026-01-30On time
← PrevPage 34 of 135Next →Rows per page:1020501005001000