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
2512100672025-12-24PERSEDIAAN UMUM6060.0646DYNA BOLT M82601101432,4252601101432026-01-152026-01-261002,425222601107242026-02-09252026-02-02Late
2512100672025-12-24PERSEDIAAN UMUM6060.0645DYNA BOLT M62601101068002601101062026-01-152026-01-26100800222601103812026-01-2052026-02-02On time
2512100742025-12-29PERSEDIAAN UMUM6030.0524LEM SUPER GLUE2605004924,954.962601100932026-01-152026-01-26151,500172601103702026-01-2052026-02-02On time
2512100742025-12-29PERSEDIAAN UMUM6050.1104COVER STRIP L. 10CM REMA TIPTOP260110109280,0002601101092026-01-152026-01-2650280,000172601107572026-02-09252026-02-02Late
2512100782025-12-31PERSEDIAAN UMUM6020.0744MAKITA LITHIUM BATTERY BL1021B 12V 2AH260110094717,0002601100942026-01-152026-01-261717,000152601104102026-01-2272026-02-02On time
2512100782025-12-31PERSEDIAAN UMUM6050.0747HELM SAFETY MSA (PUTIH)26041005381,1002601100942026-01-152026-01-26454,000152601104102026-01-2272026-02-02On time
2512100782025-12-31PERSEDIAAN UMUM6050.1001HELM SAFETY MSA (KUNING)26011009454,0002601100942026-01-152026-01-263054,000152601104102026-01-2272026-02-02On time
2601000262026-01-06SPAREPART5019.0088GEAR REDUCER G3LS-28-20-075 RATIO 1:20 0.75 KW B52601002671,657,6002601002672026-01-152026-01-3021,657,60092601013342026-02-07232026-02-06Late
2601000442026-01-06SPAREPART5017.1063OMRON RELAY MY4-N24 VAC26010027645,0002601002762026-01-152026-01-301045,00092601008762026-01-26112026-02-06On time
2601000442026-01-06SPAREPART5017.1064SOLENOID VALVE 4V210-08-AC24V260100276107,0002601002762026-01-152026-01-303107,00092601008762026-01-26112026-02-06On time
2601000442026-01-06SPAREPART5017.1061FUSE 10A 6X3026010027615,0002601002762026-01-152026-01-302015,00092601008762026-01-26112026-02-06On time
2601000442026-01-06SPAREPART5017.106FUSE 5A 5X2026010027612,0002601002762026-01-152026-01-302012,00092601008762026-01-26112026-02-06On time
2601000812026-01-08STATIONERY6010.0156STAPLES KECIL HD-102606101519,7412601002542026-01-152026-01-27334,50072601010002026-01-29142026-02-03On time
2601000812026-01-08STATIONERY6010.0307PITA PRINTER LX 31026061006016,8002601002542026-01-152026-01-27546,70072601010002026-01-29142026-02-03On time
2601000812026-01-08STATIONERY6010.0151ISI STAPLES KECIL #10 KECIL, NO.10-1M2606101511,5922601002542026-01-152026-01-2712,70072601010002026-01-29142026-02-03On time
2601000812026-01-08STATIONERY6010.0153PENGGARIS BESI BESI/IRON, 30 CM2604002066,0002601002542026-01-152026-01-2736,70072601010002026-01-29142026-02-03On time
2601000812026-01-08PERSEDIAAN UMUM6010.0777CONTINUOUS FORM 5 PLAY 9 1/2 X 11 : 2260100254431,5002601002542026-01-152026-01-2710431,50072601015342026-02-12282026-02-03Late
2601000812026-01-08PERSEDIAAN UMUM6010.0777CONTINUOUS FORM 5 PLAY 9 1/2 X 11 : 2260100254431,5002601002542026-01-152026-01-2710431,50072601010002026-01-29142026-02-03On time
2601000812026-01-08STATIONERY6010.0021COUNTINOUS FORM 3 PLAY 9 1/2 X 11 : 2260600027460,7002601002542026-01-152026-01-2710460,70072601010002026-01-29142026-02-03On time
2601000812026-01-08STATIONERY6010.0148CUTTER BESAR L-5002606101517,7672601002542026-01-152026-01-27112,00072601010002026-01-29142026-02-03On time
2601000812026-01-08STATIONERY6010.0192BUKU FOLIO 21.5*30.5 21.5 X 31.5 CM26060010816,5002601002542026-01-152026-01-27516,30072601010002026-01-29142026-02-03On time
2601000862026-01-08PERSEDIAAN UMUM6050.0459TENSIONER+SEALER260600133720,7212601002512026-01-152026-01-302600,00072601006042026-01-1942026-02-06On time
2601000902026-01-08PERSEDIAAN UMUM6030.2551BESI SIKU STAINLESS STEEL 50X50X6000 MM2604005321,115,315.322601002632026-01-152026-01-2621,171,171.1772601007962026-01-2382026-02-02On time
2601000922026-01-08PERSEDIAAN UMUM6030.0082OVERPAL26010027010,0002601002702026-01-152026-01-20110,00072601005962026-01-1942026-01-27On time
2601001232026-01-10SPAREPART5031.0934ROLL CONVEYOR OD 25MM X OD 60MM X 560MM X 700MM260100269210,0002601002692026-01-152026-02-1020210,00052604003892026-04-11862026-02-17Late
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601012842026-02-06222026-01-31Late
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601006802026-01-2162026-01-31On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601007222026-01-2272026-01-31On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601005812026-01-1942026-01-31On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601006172026-01-2052026-01-31On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601011142026-01-31162026-01-31On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601006182026-01-2052026-01-31On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601009882026-01-29142026-01-31On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601011132026-01-31162026-01-31On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601006792026-01-2162026-01-31On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601005802026-01-1942026-01-31On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601012822026-02-06222026-01-31Late
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601007232026-01-2272026-01-31On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601007852026-01-2382026-01-31On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601010672026-01-30152026-01-31On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601011852026-02-03192026-01-31Late
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601010662026-01-30152026-01-31On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601009442026-01-28132026-01-31On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601009872026-01-29142026-01-31On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601008922026-01-27122026-01-31On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601008932026-01-27122026-01-31On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601007862026-01-2382026-01-31On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601008162026-01-2492026-01-31On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601008172026-01-2492026-01-31On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601009432026-01-28132026-01-31On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601008562026-01-26112026-01-31On time
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601011842026-02-03192026-01-31Late
2601001412026-01-13BAHAN BAKAR4020.0002BATU BARA ADB 6300 - 65002606002621,7502601002412026-01-152026-01-241,000,0001,53022601008552026-01-26112026-01-31On time
2601001422026-01-14BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472601002662026-01-152026-01-261,000,00014012601006772026-01-2162026-02-02On time
2601001422026-01-14BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472601002662026-01-152026-01-261,000,00014012601009272026-01-27122026-02-02On time
2601001422026-01-14BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472601002662026-01-152026-01-261,000,00014012601009812026-01-28132026-02-02On time
2601001422026-01-14BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472601002662026-01-152026-01-261,000,00014012601010402026-01-29142026-02-02On time
2601001422026-01-14BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472601002662026-01-152026-01-261,000,00014012601007202026-01-2272026-02-02On time
2601001422026-01-14BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472601002662026-01-152026-01-261,000,00014012604001962026-04-08832026-02-02Late
2601001422026-01-14BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472601002662026-01-152026-01-261,000,00014012601007842026-01-2382026-02-02On time
2601001422026-01-14BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472601002662026-01-152026-01-261,000,00014012601011052026-01-31162026-02-02On time
2601001422026-01-14BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472601002662026-01-152026-01-261,000,00014012601008082026-01-2382026-02-02On time
2601001422026-01-14BAHAN BAKU BODY1010.0005PASIR KUARSA (LASEM) (HM JAYA)2606000091472601002662026-01-152026-01-261,000,00014012601006202026-01-2052026-02-02On time
2601001432026-01-14BAHAN BAKU BODY1010.0008BATU GAMPING (CA2)2605002852722601002452026-01-152026-01-26270,00025212603004902026-03-12562026-02-02Late
2601001432026-01-14BAHAN BAKU BODY1010.0008BATU GAMPING (CA2)2605002852722601002452026-01-152026-01-26270,00025212603000402026-03-03472026-02-02Late
2601001432026-01-14BAHAN BAKU BODY1010.0008BATU GAMPING (CA2)2605002852722601002452026-01-152026-01-26270,00025212603006392026-03-16602026-02-02Late
2601001432026-01-14BAHAN BAKU BODY1010.0008BATU GAMPING (CA2)2605002852722601002452026-01-152026-01-26270,00025212601015182026-02-12282026-02-02Late
2601001432026-01-14BAHAN BAKU BODY1010.0008BATU GAMPING (CA2)2605002852722601002452026-01-152026-01-26270,00025212601014952026-02-11272026-02-02Late
2601001432026-01-14BAHAN BAKU BODY1010.0008BATU GAMPING (CA2)2605002852722601002452026-01-152026-01-26270,00025212601014962026-02-11272026-02-02Late
2601001522026-01-13PERSEDIAAN UMUM6010.0351AIR MINERAL GALON26060024818,018.022601002652026-01-152026-01-3121017,567.5722601011922026-02-04202026-02-07On time
2601001522026-01-13PERSEDIAAN UMUM6050.0313AIR MINERAL BOTOL KECIL 220 ML26060024819,819.822601002652026-01-152026-01-316019,369.3722601007872026-01-2382026-02-07On time
2601001522026-01-13PERSEDIAAN UMUM6010.0351AIR MINERAL GALON26060024818,018.022601002652026-01-152026-01-3121017,567.5722601010382026-01-29142026-02-07On time
2601001522026-01-13PERSEDIAAN UMUM6050.0313AIR MINERAL BOTOL KECIL 220 ML26060024819,819.822601002652026-01-152026-01-316019,369.3722601010382026-01-29142026-02-07On time
2601001522026-01-13PERSEDIAAN UMUM6010.0351AIR MINERAL GALON26060024818,018.022601002652026-01-152026-01-3121017,567.5722601007872026-01-2382026-02-07On time
2601001522026-01-13PERSEDIAAN UMUM6050.0313AIR MINERAL BOTOL KECIL 220 ML26060024819,819.822601002652026-01-152026-01-316019,369.3722601005892026-01-1942026-02-07On time
2601001522026-01-13PERSEDIAAN UMUM6050.0313AIR MINERAL BOTOL KECIL 220 ML26060024819,819.822601002652026-01-152026-01-316019,369.3722601005862026-01-1942026-02-07On time
2601001522026-01-13PERSEDIAAN UMUM6010.0351AIR MINERAL GALON26060024818,018.022601002652026-01-152026-01-3121017,567.5722601008972026-01-27122026-02-07On time
2601001522026-01-13PERSEDIAAN UMUM6050.0313AIR MINERAL BOTOL KECIL 220 ML26060024819,819.822601002652026-01-152026-01-316019,369.3722601008972026-01-27122026-02-07On time
2601001522026-01-13PERSEDIAAN UMUM6050.0313AIR MINERAL BOTOL KECIL 220 ML26060024819,819.822601002652026-01-152026-01-316019,369.3722601005872026-01-1942026-02-07On time
2601001522026-01-13PERSEDIAAN UMUM6010.0351AIR MINERAL GALON26060024818,018.022601002652026-01-152026-01-3121017,567.5722601005872026-01-1942026-02-07On time
2601001522026-01-13PERSEDIAAN UMUM6010.0351AIR MINERAL GALON26060024818,018.022601002652026-01-152026-01-3121017,567.5722601005862026-01-1942026-02-07On time
2601001522026-01-13PERSEDIAAN UMUM6010.0351AIR MINERAL GALON26060024818,018.022601002652026-01-152026-01-3121017,567.5722601005892026-01-1942026-02-07On time
2601001532026-01-13PERSEDIAAN UMUM6050.0034LPG 50 KG2606001661,300,0002601002582026-01-152026-01-2621,000,00022601011062026-01-31162026-02-02On time
2601001772026-01-07PERSEDIAAN UMUM6030.0001BATU CORAL260500241400,0002601002552026-01-152026-01-201400,00082601006412026-01-2052026-01-27On time
2601001772026-01-07PERSEDIAAN UMUM6030.0049BESI COR 6 MM26010025530,0002601002552026-01-152026-01-20230,00082601006412026-01-2052026-01-27On time
2601001772026-01-07PERSEDIAAN UMUM6030.0004SEMEN GRESIK 40KG26050024159,5002601002552026-01-152026-01-201558,00082601006412026-01-2052026-01-27On time
2601001772026-01-07PERSEDIAAN UMUM6030.0422BESI COR 12 MM26010025599,0002601002552026-01-152026-01-20399,00082601006412026-01-2052026-01-27On time
2601001782026-01-08PERSEDIAAN UMUM6030.0804AVIAN CLING SYNTHETIC 91 - KERAK ABU26030036945,905.252601002622026-01-152026-01-1520045,905.2572601017232026-02-18342026-01-22Late
2601001782026-01-08PERSEDIAAN UMUM6030.0804AVIAN CLING SYNTHETIC 91 - KERAK ABU26030036945,905.252601002622026-01-152026-01-1520045,905.2572601010292026-01-29142026-01-22Late
2601001782026-01-08PERSEDIAAN UMUM6030.0804AVIAN CLING SYNTHETIC 91 - KERAK ABU26030036945,905.252601002622026-01-152026-01-1520045,905.2572601015792026-02-13292026-01-22Late
2601001782026-01-08PERSEDIAAN UMUM6030.0804AVIAN CLING SYNTHETIC 91 - KERAK ABU26030036945,905.252601002622026-01-152026-01-1520045,905.2572601015272026-02-12282026-01-22Late
2601001782026-01-08PERSEDIAAN UMUM6030.0917THINER A BIASA @ 5 LTR26050040363,5002601002622026-01-152026-01-1510026,505.0572601010292026-01-29142026-01-22Late
2601100042026-01-05PERSEDIAAN UMUM6050.1246KUNCI L SET ISKU26010054890,0002601100962026-01-152026-01-15268,932102601103742026-01-2052026-01-22On time
2601100082026-01-07BAHAN BAKU GLAZE1098.0018ENGOBE UNDER TILE 210#2601101032.52601101032026-01-152026-01-1524,0002.582603102832026-03-16602026-01-22Late
2601100142026-01-07PERSEDIAAN UMUM6030.0255SIKU 60X60X6000 MM260310039336,0002601100912026-01-152026-01-1520325,00082601103822026-01-2052026-01-22On time
2601100142026-01-07PERSEDIAAN UMUM6030.0291PLAT STRIP 3X30X6000 MM26011009147,0002601100912026-01-152026-01-151047,00082601103822026-01-2052026-01-22On time
2601100142026-01-07PERSEDIAAN UMUM6030.2542PLAT BAJA (1,2MX2,4MX3MM)260410224824,0002601100912026-01-152026-01-15450695,00082601104112026-01-2272026-01-22On time
2601100142026-01-07PERSEDIAAN UMUM6030.2542PLAT BAJA (1,2MX2,4MX3MM)260410224824,0002601100912026-01-152026-01-15450695,00082601103822026-01-2052026-01-22On time
2601100142026-01-07PERSEDIAAN UMUM6030.2543PLAT ALUMUNIUM 0,8 (@25M/ROLL)2605100254,348,0002601101002026-01-152026-01-15604,200,00082601104032026-01-2272026-01-22On time
2601100142026-01-07PERSEDIAAN UMUM6050.0088BESI UNP K.S U 120X6000260110227840,0002601100912026-01-152026-01-1560840,00082601103822026-01-2052026-01-22On time
← PrevPage 43 of 135Next →Rows per page:1020501005001000