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
2601001442026-01-12PERSEDIAAN UMUM6010.0779FORM INSPEKSI CONTAINER26010029612,5002601002962026-01-192026-01-312012,5007–––2026-02-07Overdue
2601001442026-01-12PERSEDIAAN UMUM6010.0779FORM INSPEKSI CONTAINER26010029612,5002601002962026-01-192026-01-312012,50072601018202026-02-20322026-02-07Late
2601001442026-01-12PERSEDIAAN UMUM6010.078FORM SERAH TERIMA SHIFT26010090512,5002601002962026-01-192026-01-312012,5007–––2026-02-07Overdue
2601001442026-01-12PERSEDIAAN UMUM6010.0781FORM HARIAN DMG26010029612,5002601002962026-01-192026-01-312012,5007–––2026-02-07Overdue
2601001442026-01-12PERSEDIAAN UMUM6010.0782FORM LANGSIR 2 PLY26010029623,0002601002962026-01-192026-01-312023,00072601018202026-02-20322026-02-07Late
2601001442026-01-12PERSEDIAAN UMUM6010.0782FORM LANGSIR 2 PLY26010029623,0002601002962026-01-192026-01-312023,0007–––2026-02-07Overdue
2601001492026-01-12PERSEDIAAN UMUM6030.257DR SONNE ST 375 MILKY CLEAR L= 375 MM P= 1,7 M260100303100,039.632601003032026-01-192026-01-1911100,039.6372601017602026-02-19312026-01-26Late
2601001492026-01-12PERSEDIAAN UMUM6030.2569DR SHIELD SHEET SINGLE WALL RF1050 LE=1050MM P=8,4 M260100303716,8002601003032026-01-192026-01-1930716,80072601009092026-01-2782026-01-26Late
2601001492026-01-12PERSEDIAAN UMUM6030.2572DR SONNE ST 375 MILKY CLEAR L= 375 MM P= 5 M260101049294,234.232601003032026-01-192026-01-197294,234.2372601017602026-02-19312026-01-26Late
2601001492026-01-12PERSEDIAAN UMUM6030.0903DR. SHIELD WEATHER SEAL WHITE26010030332,432.42601003032026-01-192026-01-1914332,432.472601009092026-01-2782026-01-26Late
2601001492026-01-12PERSEDIAAN UMUM6030.2571DR SONNE ST 375 MILKY CLEAR L= 375 MM P= 4,1 M260100303241,2722601003032026-01-192026-01-1911241,27272601017602026-02-19312026-01-26Late
2601001492026-01-12PERSEDIAAN UMUM6030.2568DR SHIELD SHEET SINGLE WALL RF1050 LE=1050MM P=7 M260100303597,333.332601003032026-01-192026-01-1940597,333.3372601009092026-01-2782026-01-26Late
2601001492026-01-12PERSEDIAAN UMUM6030.2567DR SHIELD SHEET SINGLE WALL RF1050 LE=1050MM P=5 M260300242426,666.672601003032026-01-192026-01-1950426,666.6872601009092026-01-2782026-01-26Late
2601001492026-01-12PERSEDIAAN UMUM6030.2565DR SHIELD SHEET SINGLE WALL RF1050 LE=1050MM P=1,7 M260100303145,066.672601003032026-01-192026-01-1960145,066.6772601009092026-01-2782026-01-26Late
2601001492026-01-12PERSEDIAAN UMUM6030.2566DR SHIELD SHEET SINGLE WALL RF1050 LE=1050MM P=4,1 M260600067478,056.312601003032026-01-192026-01-1960349,866.6772601009092026-01-2782026-01-26Late
2601001552026-01-13SPAREPART5031.013LEM TIP TOP SC 2000260300146572,072.072601002952026-01-192026-01-304572,072.0762601007722026-01-2232026-02-06On time
2601001562026-01-13SPAREPART5028.0201MARTIN PULLY SPB 212 - 3 TAPER BUSH 2517 - 402601003051,490,0002601003052026-01-192026-01-3031,490,00062601007442026-01-2232026-02-06On time
2601001562026-01-13SPAREPART5028.0199MARTIN PULLY SPA 170 - 4 TAPER BUSH 2517 - 452601003051,160,0002601003052026-01-192026-01-3041,160,00062601007442026-01-2232026-02-06On time
2601001562026-01-13SPAREPART5028.02MARTIN PULLY SPB 200 - 3 TAPER BUSH 2517 - 422601003051,450,0002601003052026-01-192026-01-3061,450,00062601007442026-01-2232026-02-06On time
2601001562026-01-13SPAREPART5028.0198MARTIN PULLY SPA 180 - 4 TAPER BUSH 2517 - 422601003051,195,0002601003052026-01-192026-01-3041,195,00062601007442026-01-2232026-02-06On time
2601001562026-01-13SPAREPART5028.0202MARTIN PULLY SPB 170 - 3 TAPER BUSH 2517 - 422601003051,150,0002601003052026-01-192026-01-3031,150,00062601007442026-01-2232026-02-06On time
2601001582026-01-13PERSEDIAAN UMUM6030.0515CAT BESI AVIAN LEMONADE 48026060017170,725.232601002942026-01-192026-01-301057,472.9762601010282026-01-29102026-02-06On time
2601001592026-01-13STATIONERY6010.004FORM LAPORAN KONDISI PRODUKSI FR-PROD-11 A4, FR-PROD-1126060025512,0002601002922026-01-192026-01-302012,50062601009132026-01-2782026-02-06On time
2601001612026-01-13BAHAN BAKAR4050.0014SUPER GEAR OIL DAPHNE SUPER GEAR OIL 320 (IDEMITSU)26060009470,7502601003062026-01-192026-01-3040048,7506–––2026-02-06Overdue
2601001612026-01-13BAHAN BAKAR4050.0014SUPER GEAR OIL DAPHNE SUPER GEAR OIL 320 (IDEMITSU)26060009470,7502601003062026-01-192026-01-3040048,75062601009232026-01-2782026-02-06On time
2601001612026-01-13BAHAN BAKAR4050.0014SUPER GEAR OIL DAPHNE SUPER GEAR OIL 320 (IDEMITSU)26060009470,7502601003062026-01-192026-01-3040048,7506–––2026-02-06Overdue
2601001612026-01-13BAHAN BAKAR4050.0014SUPER GEAR OIL DAPHNE SUPER GEAR OIL 320 (IDEMITSU)26060009470,7502601003062026-01-192026-01-3040048,75062601013292026-02-07192026-02-06Late
2601001802026-01-08BAHAN BAKAR4010.0001SOLAR26060011120,720.722601002832026-01-192026-01-218,00012,792.79112601007142026-01-2232026-01-28On time
2601100042026-01-05PERSEDIAAN UMUM6050.1259GEMBOK 60MM26051001038,0002601101112026-01-192026-01-19525,567.2142601104122026-01-2232026-01-26On time
2601100112026-01-06SPAREPART5017.0117STEKER BROCO26060019911,7122601101052026-01-192026-01-192016,00013–––2026-01-26Overdue
2601100202026-01-09SPAREPART5017.0118STOP KONTAK 2 LUBANG26061002914,5002601101042026-01-192026-01-191545,000102601104042026-01-2232026-01-26On time
2601100252026-01-13PERSEDIAAN UMUM6020.0542KABEL NYYHY 3X2.5MM26011028627,7002601101102026-01-192026-01-1940024,20062601105072026-01-2892026-01-26Late
2512000742025-12-03PERSEDIAAN UMUM6020.0669KABEL SCUN RING 2.5 MM2601003155002601003152026-01-202026-01-20300500482601008632026-01-2662026-01-27On time
2512002322025-12-12SPAREPART5017.0505OMRON HMI NB 7W - TW00B2601003262,900,0002601003262026-01-202026-01-3122,900,000392601007952026-01-2332026-02-07On time
2512002322025-12-12SPAREPART5017.1025PLC CP2EN40DR2601003253,700,0002601003252026-01-202026-02-1063,700,000392601013882026-02-09202026-02-17On time
2512002322025-12-12SPAREPART5017.1025PLC CP2EN40DR2601003253,700,0002601003252026-01-202026-02-1063,700,000392601007992026-01-2332026-02-17On time
2512002322025-12-12SPAREPART5017.0322PUSH BUTTON TELE XB4-BS542 EX XB4-BS8442260500150152,5002601003262026-01-202026-01-313168,500392601007952026-01-2332026-02-07On time
2512002342025-12-15SPAREPART5011.0411BEARING RN 307 NTN260300230175,0002601003402026-01-202026-01-318175,000362601008062026-01-2332026-02-07On time
2512003842025-12-23PERSEDIAAN UMUM6050.1217KUNCI TABUNG260100309400,0002601003092026-01-202026-01-201400,000282601006402026-01-20–2026-01-27On time
2512004282025-12-26PERSEDIAAN UMUM6030.008PIPA GALVANIS 1 INCH MED SNI260600210320,0002601003142026-01-202026-01-2010278,108.11252601008262026-01-2442026-01-27On time
2601000202026-01-05PERSEDIAAN UMUM6060.0635SKRUP TAPPING 8X3/826010031795.232601003172026-01-202026-01-205,00095.23152601010162026-01-2992026-01-27Late
2601000222026-01-05SPAREPART5030.0708PNEUMATIC STRAPPING TOOL XQD-192606000226,550,0002601003212026-01-202026-01-2028,500,000152601008992026-01-2772026-01-27On time
2601000722026-01-08PERSEDIAAN UMUM6030.0898BESI UNP 100X50X5MM (@ 6000MM) SNI260610067576,0002601003142026-01-202026-01-2010576,576.57122601008262026-01-2442026-01-27On time
2601000722026-01-08PERSEDIAAN UMUM6030.2337BESI HOLLOW 50X50X5MM260400086345,945.952601003142026-01-202026-01-2020720,720.72122601008262026-01-2442026-01-27On time
2601000722026-01-08PERSEDIAAN UMUM6030.0366PIPA GALVANIS 3/4 INCH260100314185,405.412601003142026-01-202026-01-2050185,405.41122601008262026-01-2442026-01-27On time
2601000722026-01-08PERSEDIAAN UMUM6030.1185PIPA GALVANIS 1 INCH T=3 MM260100314278,108.112601003142026-01-202026-01-2050278,108.11122601008262026-01-2442026-01-27On time
2601001192026-01-10FIXED ASSETSAST02588AC WINDOW 1/2 PK AC PANEL2601003162,210,0002601003162026-01-202026-01-2022,210,000102601009062026-01-2772026-01-27On time
2601001542026-01-13PERSEDIAAN UMUM6030.2573SELANG SPIRAL DUCTING 4 INCH260100324267,0002601003242026-01-202026-01-3115267,00072601007102026-01-2112026-02-07On time
2601001542026-01-13PERSEDIAAN UMUM6020.0138KLEM SLANG 5 INCH26060017311,171.172601003232026-01-202026-01-312030,405.4172601007762026-01-2222026-02-07On time
2601001572026-01-13SPAREPART5011.0543BEARING NJ 2308 EC3 FAG260100327480,0002601003272026-01-202026-01-302480,00072601009732026-01-2882026-02-06On time
2601001732026-01-14PERSEDIAAN UMUM6030.0694SELANG BLANDER26060006827,027.032601003172026-01-202026-01-2010022,522.5262601007752026-01-2222026-01-27On time
2601001852026-01-14PERSEDIAAN UMUM6030.0945ELBOW 4 INCH DRAT DALAM26010032096,846.842601003202026-01-202026-01-201096,846.8462601007732026-01-2222026-01-27On time
2601001852026-01-14PERSEDIAAN UMUM6030.1302FLANGE 3 INCH JIS 10K26010032040,540.542601003202026-01-202026-01-201040,540.5462601007732026-01-2222026-01-27On time
2601001852026-01-14PERSEDIAAN UMUM6030.2312ELBOW LAS 3 INCH26030015059,0002601003202026-01-202026-01-20449,189.1862601007732026-01-2222026-01-27On time
2601001872026-01-15PERSEDIAAN UMUM6030.0936REFILL KUAS ROLL KECIL 110MM (ACE OLDFIELD)2605003005,518.022601003192026-01-202026-01-201009,00052601007772026-01-2222026-01-27On time
2601001872026-01-15PERSEDIAAN UMUM6050.0086SARUNG TANGAN LAS26051009322,5232601003182026-01-202026-01-201072,00052601007692026-01-2222026-01-27On time
2601001872026-01-15PERSEDIAAN UMUM6050.0059SARUNG TANGAN26060016817,6002601003182026-01-202026-01-201020,50052601007692026-01-2222026-01-27On time
2601001872026-01-15PERSEDIAAN UMUM6030.062KUAS 2 INCH2605004405,794.62601003172026-01-202026-01-20507,702.752601009402026-01-2772026-01-27On time
2601001872026-01-15PERSEDIAAN UMUM6030.0733RESIBON POTONG 105X1.2X162605004922,702.72601003172026-01-202026-01-201,0002,702.752601007752026-01-2222026-01-27On time
2601002052026-01-15PERSEDIAAN UMUM6030.0638KAPUR BESI 16 A260510200881.252601003172026-01-202026-01-202015,765.7652601007752026-01-2222026-01-27On time
2601002222026-01-19PERSEDIAAN UMUM6030.2574MATA BOR BETON M20260100308160,0002601003082026-01-202026-01-202160,00012601006392026-01-20–2026-01-27On time
2601100332026-01-17PERSEDIAAN UMUM6050.0059SARUNG TANGAN26060016817,6002601101122026-01-202026-01-2920022,50032601107592026-02-09202026-02-05Late
2601100332026-01-17PERSEDIAAN UMUM6050.0942MASKER KAIN2605102792,5002601101122026-01-202026-01-291,5002,50032601108462026-02-11222026-02-05Late
2601100342026-01-17BAHAN BAKU BODY1098.0017SODIUM POLYACRYLATE 230#2601101130.932601101132026-01-202026-01-204,0000.9332603104112026-03-31702026-01-27Late
2511004222025-11-28PERSEDIAAN UMUM6020.066KABEL NYYHY 4X50 MM260100330668,207.212601003302026-01-212026-01-2130668,207.21542601010182026-01-2982026-01-28Late
2511004552025-11-29PERSEDIAAN UMUM6020.0662KABEL NYYHY 5X1.5 MM26010033030,018.022601003302026-01-212026-01-2120030,018.02532601010182026-01-2982026-01-28Late
2512000562025-12-03STATIONERY6010.0169PLONG KERTAS KECIL(PERVORATOR) () PITCH 8 CM, 6 X 10.5X 5 CM26010033630,0002601003362026-01-212026-01-21130,000492601007272026-01-2212026-01-28On time
2512001102025-12-06PERSEDIAAN UMUM6020.0084KABEL NYM 2X1.5 MM2601003301,241,261.262601003302026-01-212026-01-2111,241,261.26462601010182026-01-2982026-01-28Late
2512001492025-12-09STATIONERY6010.0148CUTTER BESAR L-5002606101517,7672601003362026-01-212026-01-21116,000432601007272026-01-2212026-01-28On time
2512002502025-12-15SPAREPART5017.034MOTOR PROTECTION SCHNEIDER TYPE GV2ME10260500288545,0002601003642026-01-212026-01-2125464,000372601008682026-01-2652026-01-28On time
2512003942025-12-23STATIONERY6010.0714KERTAS A326060014577,0002601003362026-01-212026-01-21282,500292601007272026-01-2212026-01-28On time
2512004282025-12-26PERSEDIAAN UMUM6030.1713SENG TALANG GALVALUM 0.4 X 120 CM26010054357,0002601003332026-01-212026-01-2123,468,468.47262601014112026-02-10202026-01-28Late
2512004282025-12-26PERSEDIAAN UMUM6030.2589PLAT STRIP 50X4 MM X 600026010033293,243.242601003322026-01-212026-01-212593,243.24262601010322026-01-2982026-01-28Late
2512100392025-12-13PERSEDIAAN UMUM6030.249KARET STRIP U UKURAN 7MM X 14MM26011013410,0002601101342026-01-212026-01-3010010,000392601107842026-02-09192026-02-06Late
2601000632026-01-07PERSEDIAAN UMUM6030.0843WIREMESH M8-150 (2100X5400)260300278567,567.572601003312026-01-212026-01-2113580,000142601010332026-01-2982026-01-28Late
2601001102026-01-09SPAREPART5032.0776PACKING ASBETTOS TOMBO 1303/2 MM (HITAM)260100338575,0002601003382026-01-212026-01-2110575,000122601009002026-01-2762026-01-28On time
2601001102026-01-09SPAREPART5032.0776PACKING ASBETTOS TOMBO 1303/2 MM (HITAM)260100338575,0002601003382026-01-212026-01-2110575,000122601008452026-01-2432026-01-28On time
2601001252026-01-10PERSEDIAAN UMUM6060.0653MATA BOR NACHI 27 MM2601003391,564,0002601003392026-01-212026-02-1011,564,000112601007712026-01-2212026-02-17On time
2601001252026-01-10PERSEDIAAN UMUM6050.131SKETMAT MANUAL 300 MM MITOTOYO2601003391,550,0002601003392026-01-212026-02-1011,550,000112601007712026-01-2212026-02-17On time
2601001462026-01-12SPAREPART5017.0119STOP KONTAK 3 LUBANG26061002920,0002601003622026-01-212026-01-31194,594.692601009362026-01-2762026-02-07On time
2601001602026-01-13SPAREPART5017.1069CONTACTOR SCHNEIDER LC1D09BNE 24...60 AC/DC COIL260100357665,0002601003572026-01-212026-01-311665,00082601008002026-01-2322026-02-07On time
2601001672026-01-14PERSEDIAAN UMUM6060.0655MUR M20 (DRAT HALUS) LOADER XG955H26010035130,0002601003512026-01-212026-01-312030,00072601007942026-01-2322026-02-07On time
2601001672026-01-14PERSEDIAAN UMUM6060.0654BAUT M20 DRAT DUA ARAH (DRAT HALUS)260100351165,0002601003512026-01-212026-01-3120165,00072601007942026-01-2322026-02-07On time
2601001672026-01-14PERSEDIAAN UMUM6060.0656MUR M20 (DRAT HALUS) PELG RODA LOADER XG 955H26010035140,0002601003512026-01-212026-01-312040,00072601007942026-01-2322026-02-07On time
2601001672026-01-14PERSEDIAAN UMUM6060.0657PLAT BAJA M2026010035115,0002601003512026-01-212026-01-312015,00072601007942026-01-2322026-02-07On time
2601001732026-01-14PERSEDIAAN UMUM6050.0042KUAS ROLL KECIL26050030014,881.082601003352026-01-212026-01-211020,00072601008422026-01-2432026-01-28On time
2601001732026-01-14PERSEDIAAN UMUM6050.1301TANG CUCUT26050038953,2502601003342026-01-212026-01-21336,036.0472601007742026-01-2212026-01-28On time
2601001732026-01-14PERSEDIAAN UMUM6050.1302TANG POTONG26030004145,675.682601003342026-01-212026-01-21336,036.0172601007742026-01-2212026-01-28On time
2601001732026-01-14PERSEDIAAN UMUM6030.0912KABEL LAS26010033573,0002601003352026-01-212026-01-2110073,00072601008422026-01-2432026-01-28On time
2601001732026-01-14PERSEDIAAN UMUM6050.13TANG KOMBINASI26050038953,2502601003342026-01-212026-01-21349,549.5572601007742026-01-2212026-01-28On time
2601001732026-01-14PERSEDIAAN UMUM6050.077REGULATOR GAS ACETYLENE YAMATO260500003175,0002601003352026-01-212026-01-213160,00072601008422026-01-2432026-01-28On time
2601001742026-01-14PERSEDIAAN UMUM6050.0111OXYGEN26060017745,0002601003372026-01-212026-01-215090,00072601008592026-01-2652026-01-28On time
2601001742026-01-14PERSEDIAAN UMUM6050.0111OXYGEN26060017745,0002601003372026-01-212026-01-215090,00072601012352026-02-05152026-01-28Late
2601001742026-01-14PERSEDIAAN UMUM6050.0111OXYGEN26060017745,0002601003372026-01-212026-01-215090,00072601010812026-01-3092026-01-28Late
2601001742026-01-14PERSEDIAAN UMUM6050.0111OXYGEN26060017745,0002601003372026-01-212026-01-215090,00072601007282026-01-2212026-01-28On time
2601001742026-01-14PERSEDIAAN UMUM6050.0111OXYGEN26060017745,0002601003372026-01-212026-01-215090,00072601018552026-02-21312026-01-28Late
2601001882026-01-15PERSEDIAAN UMUM6030.1203TANG SKUN260100329105,0002601003292026-01-212026-01-213105,00062601008462026-01-2652026-01-28On time
2601001922026-01-15PERSEDIAAN UMUM6050.0568ACCU KERING 105 D 31 R/L2605003332,350,0002601003522026-01-212026-01-3122,350,00062601007932026-01-2322026-02-07On time
2601001942026-01-15PERSEDIAAN UMUM6030.0804AVIAN CLING SYNTHETIC 91 - KERAK ABU26030036945,905.252601003492026-01-212026-02-105045,905.4162601017062026-02-18282026-02-17Late
2601001952026-01-15PERSEDIAAN UMUM6050.1013KARET GELANG PENTIL26010058713,0002601003462026-01-212026-01-31137,00062601009992026-01-2982026-02-07On time
← PrevPage 45 of 135Next →Rows per page:1020501005001000