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
2512003792025-12-22PERSEDIAAN UMUM6030.0065PLENDES 3 INCH26030026897,5002601001862026-01-112026-01-236125,000202601007972026-01-23122026-01-30On time
2512003792025-12-22PERSEDIAAN UMUM6030.1739BESI UNP 10260100202536,036.042601002022026-01-112026-01-2110536,036.04202601004522026-01-1432026-01-28On time
2512003792025-12-22PERSEDIAAN UMUM6030.0035SOCK BESI 3" 3 INCH26010018673,0002601001862026-01-112026-01-233673,00020–––2026-01-30Overdue
2512003792025-12-22PERSEDIAAN UMUM6030.0035SOCK BESI 3" 3 INCH26010018673,0002601001862026-01-112026-01-233673,000202601007972026-01-23122026-01-30On time
2512003792025-12-22PERSEDIAAN UMUM6060.0424ELBOW DRAT GALVANIS 3 INCH260100186105,0002601001862026-01-112026-01-2320105,000202601004502026-01-1432026-01-30On time
2512003792025-12-22PERSEDIAAN UMUM6060.0424ELBOW DRAT GALVANIS 3 INCH260100186105,0002601001862026-01-112026-01-2320105,000202601007972026-01-23122026-01-30On time
2512003792025-12-22SPAREPART5031.0008BUTTERFLY VALVE 3 INCH260500112217,567.572601001862026-01-112026-01-235245,00020–––2026-01-30Overdue
2512003792025-12-22PERSEDIAAN UMUM6030.0065PLENDES 3 INCH26030026897,5002601001862026-01-112026-01-236125,00020–––2026-01-30Overdue
2512003792025-12-22SPAREPART5031.0008BUTTERFLY VALVE 3 INCH260500112217,567.572601001862026-01-112026-01-235245,000202601004502026-01-1432026-01-30On time
2512003792025-12-22PERSEDIAAN UMUM6030.0095PLAT BESI 3X1200X2400 MM260500009807,207.212601002022026-01-112026-01-218662,162.16202601005322026-01-1542026-01-28On time
2512004162025-12-26SPAREPART5011.0367BEARING 6312 2Z C3 SKF260100195425,8002601001952026-01-112026-01-228425,800162601007012026-01-21102026-01-29On time
2512004162025-12-26SPAREPART5011.027BEARING UCFL 20526050014890,0002601001952026-01-112026-01-22889,500162601007012026-01-21102026-01-29On time
2512004162025-12-26SPAREPART5011.0292BEARING UCPA 206260100179136,5002601001792026-01-112026-01-228136,500162601007082026-01-21102026-01-29On time
2512004162025-12-26SPAREPART5011.029BEARING UCPA 20426010019595,2002601001952026-01-112026-01-22895,200162601006992026-01-21102026-01-29On time
2512004162025-12-26SPAREPART5011.0249BEARING UC 20526010062764,0002601001952026-01-112026-01-221063,500162601007012026-01-21102026-01-29On time
2512004162025-12-26SPAREPART5011.025BEARING UC 20626050014875,5002601001952026-01-112026-01-221074,900162601007012026-01-21102026-01-29On time
2512004162025-12-26SPAREPART5011.0141BEARING 6304 2RS26050012033,5002601001792026-01-112026-01-221533,500162601007082026-01-21102026-01-29On time
2512004162025-12-26SPAREPART5011.0138BEARING 6303 2RS C326010017926,3002601001792026-01-112026-01-221526,300162601007082026-01-21102026-01-29On time
2512004162025-12-26SPAREPART5011.0133BEARING 6300 2RS C326010062726,0002601001792026-01-112026-01-221526,000162601007082026-01-21102026-01-29On time
2512004162025-12-26SPAREPART5011.0102BEARING 6206 2RS C326060022735,3002601001792026-01-112026-01-221535,300162601007082026-01-21102026-01-29On time
2512004162025-12-26SPAREPART5011.0101BEARING 6205 2RS2604101407,1102601001792026-01-112026-01-221528,100162601007082026-01-21102026-01-29On time
2512004162025-12-26SPAREPART5011.0099BEARING 6204 2RS26050046922,1002601001792026-01-112026-01-222022,100162601007082026-01-21102026-01-29On time
2512004162025-12-26SPAREPART5011.0095BEARING 6202 2RS26060022717,7002601001792026-01-112026-01-222017,700162601007082026-01-21102026-01-29On time
2512004162025-12-26SPAREPART5011.007BEARING 6005 2RS26040001026,2002601001792026-01-112026-01-221526,200162601007082026-01-21102026-01-29On time
2512004162025-12-26SPAREPART5011.0068BEARING 6004 2RS26050014921,1002601001792026-01-112026-01-222021,700162601007082026-01-21102026-01-29On time
2512004162025-12-26SPAREPART5011.0066BEARING 6003 2RS26050047020,0002601001792026-01-112026-01-222020,600162601007082026-01-21102026-01-29On time
2512004162025-12-26SPAREPART5011.0065BEARING 6002 2RS26050046920,0002601001952026-01-112026-01-223019,900162601006992026-01-21102026-01-29On time
2512004162025-12-26SPAREPART5011.0063BEARING 6001 2RS26050014924,4002601001952026-01-112026-01-222023,100162601007012026-01-21102026-01-29On time
2512004162025-12-26SPAREPART5011.0061BEARING 6000 2RS26050014923,8002601001952026-01-112026-01-222022,600162601007012026-01-21102026-01-29On time
2512004252025-12-26SPAREPART5023.1508NYLON PA OD 100X1000 MM260100180810,0002601001802026-01-112026-01-191810,000162601004042026-01-1322026-01-26On time
2512004252025-12-26SPAREPART5023.1507NYLON PA OD 70X1000 MM260600110380,6312601001802026-01-112026-01-191410,000162601004042026-01-1322026-01-26On time
2512004252025-12-26SPAREPART5023.0981NYLON PA OD 65X1000 MM260100180350,0002601001802026-01-112026-01-191350,000162601004042026-01-1322026-01-26On time
2512004782025-12-29PERSEDIAAN UMUM6050.0428TANG KOMBINASI 8 INCH26051025946,846.852601002052026-01-112026-01-24160,022.52132601005572026-01-1762026-01-31On time
2512004782025-12-29PERSEDIAAN UMUM6050.0378TANG KOMBINASI 7 INCH26050003644,5002601002052026-01-112026-01-24152,139.64132601005572026-01-1762026-01-31On time
2512004902025-12-31PERSEDIAAN UMUM6050.0298CHAIN LUBE26060016939,1002601001972026-01-112026-01-24837,500112601004332026-01-1432026-01-31On time
2512004902025-12-31PERSEDIAAN UMUM6060.0273BORG M 8X82605002146102601001972026-01-112026-01-24300610112601004332026-01-1432026-01-31On time
2512004902025-12-31PERSEDIAAN UMUM6020.0059MOUSE KOMPUTER26030051154,054.052601001982026-01-112026-01-22551,700112601009972026-01-29182026-01-29On time
2601000142026-01-02PERSEDIAAN UMUM6050.1237BAUT L M 6X35 STAINLESS FULL DRAT2601001961,4502601001962026-01-112026-01-23201,45092601004372026-01-1432026-01-30On time
2601000302026-01-06SPAREPART5021.0258T. BELT 1000 H - 100260100188250,0002601001882026-01-112026-01-233250,00052601003992026-01-1322026-01-30On time
2601000302026-01-06SPAREPART5021.0256T. BELT 950 H - 100260101006238,6002601001882026-01-112026-01-233238,60052601003992026-01-1322026-01-30On time
2601000312026-01-06SPAREPART5021.0129V. BELT B - 285260100234217,9002601001902026-01-112026-01-2310217,90052601007052026-01-21102026-01-30On time
2601000312026-01-06SPAREPART5021.0129V. BELT B - 285260100234217,9002601001902026-01-112026-01-2310217,90052601020482026-02-27472026-01-30Late
2601000312026-01-06SPAREPART5021.0129V. BELT B - 285260100234217,9002601001902026-01-112026-01-2310217,90052601009722026-01-28172026-01-30On time
2601000312026-01-06SPAREPART5021.0123V. BELT B - 250260101026191,2002601001902026-01-112026-01-2310191,20052601007052026-01-21102026-01-30On time
2601000312026-01-06SPAREPART5021.0344V. BELT C - 253260100190352,1002601001902026-01-112026-01-2310352,10052603009922026-03-31792026-01-30Late
2601000312026-01-06SPAREPART5021.0344V. BELT C - 253260100190352,1002601001902026-01-112026-01-2310352,10052601009722026-01-28172026-01-30On time
2601000882026-01-08BAHAN BAKAR4050.0017OIL DELTALUBE 790 ISO VG3202603002882,090,0002601001782026-01-112026-01-2422,090,00032601004592026-01-1432026-01-31On time
2601000892026-01-08PERSEDIAAN UMUM6030.0515CAT BESI AVIAN LEMONADE 48026060017170,725.232601001992026-01-112026-01-23457,472.9732601004412026-01-1432026-01-30On time
2601000892026-01-08PERSEDIAAN UMUM6030.0487THINER A SPECIAL26040029850,7002601001992026-01-112026-01-232531,605.0532601004412026-01-1432026-01-30On time
2601000892026-01-08PERSEDIAAN UMUM6030.052CAT BESI / KAYU AVIAN TWILIGHT BLUE 73126010069257,472.972601001992026-01-112026-01-23457,472.9732601004412026-01-1432026-01-30On time
2512001492025-12-09PERSEDIAAN UMUM6020.0445TANG SKUN FERRULES260100173185,0002601001732026-01-122026-01-121185,000342601008832026-01-26142026-01-19Late
2512001492025-12-09PERSEDIAAN UMUM6030.146TANG KUPAS KABEL260100173175,0002601001732026-01-122026-01-121175,000342601008832026-01-26142026-01-19Late
2512001492025-12-09PERSEDIAAN UMUM6030.1146TOOL BAG 17,5 INCH260100777110,0002601001732026-01-122026-01-121110,000342601008832026-01-26142026-01-19Late
2512001492025-12-09PERSEDIAAN UMUM6050.1039OBENG SET TEKIRO260500335120,5002601001732026-01-122026-01-121150,000342601008832026-01-26142026-01-19Late
2512001492025-12-09PERSEDIAAN UMUM6030.1203TANG SKUN260100329105,0002601001732026-01-122026-01-121165,000342601008832026-01-26142026-01-19Late
2512001492025-12-09PERSEDIAAN UMUM6050.1171TANG CRIMPING RJ45260400514185,0002601001732026-01-122026-01-121185,000342601008832026-01-26142026-01-19Late
2512002632025-12-16PERSEDIAAN UMUM6050.0683BAN DALAM + LUAR + MARSET 23.5 - 25X322604000561,1902601001612026-01-122026-01-14413,873,873.87272601004382026-01-1422026-01-21On time
2512002742025-12-16PERSEDIAAN UMUM6030.2498BENANG NILON D122601101671,0502601001712026-01-122026-01-12205,00027–––2026-01-19Overdue
2512003242025-12-19SPAREPART5029.0458CERAMIC FIBER GRADE 1260°260100175855,0002601001752026-01-122026-01-12100855,000242601006072026-01-1972026-01-19On time
2512003242025-12-19SPAREPART5029.0458CERAMIC FIBER GRADE 1260°260100175855,0002601001752026-01-122026-01-12100855,000242601011832026-02-03222026-01-19Late
2512003422025-12-19PERSEDIAAN UMUM6050.1203MATA BOR TUNER 8MM2601002101,036,036.042601002102026-01-122026-01-2411,036,036.04242601007682026-01-22102026-01-31On time
2512003422025-12-19PERSEDIAAN UMUM6050.1202KIKIR DATAR26010021042,522.522601002102026-01-122026-01-24142,522.52242601009382026-01-27152026-01-31On time
2512003422025-12-19PERSEDIAAN UMUM6050.1201KIKIR SEGITIGA26010021051,261.262601002102026-01-122026-01-24151,261.26242601006692026-01-2082026-01-31On time
2512003422025-12-19PERSEDIAAN UMUM6050.044KIKIR BULAT 12 MM26010021039,549.552601002102026-01-122026-01-24139,549.55242601006692026-01-2082026-01-31On time
2512004672025-12-30BAHAN BAKU GLAZE1099.0017KAOLIN POWDER MESH 3252606001901,8972601002032026-01-122026-01-20200,0001,575132601020002026-02-25442026-01-27Late
2512004672025-12-30BAHAN BAKU GLAZE1099.0017KAOLIN POWDER MESH 3252606001901,8972601002032026-01-122026-01-20200,0001,575132601020852026-02-28472026-01-27Late
2512004672025-12-30BAHAN BAKU GLAZE1099.0017KAOLIN POWDER MESH 3252606001901,8972601002032026-01-122026-01-20200,0001,575132601011912026-02-04232026-01-27Late
2512004672025-12-30BAHAN BAKU GLAZE1099.0017KAOLIN POWDER MESH 3252606001901,8972601002032026-01-122026-01-20200,0001,575132601012862026-02-06252026-01-27Late
2512004672025-12-30BAHAN BAKU GLAZE1099.0017KAOLIN POWDER MESH 3252606001901,8972601002032026-01-122026-01-20200,0001,575132604007672026-04-221002026-01-27Late
2512004672025-12-30BAHAN BAKU GLAZE1099.0017KAOLIN POWDER MESH 3252606001901,8972601002032026-01-122026-01-20200,0001,575132601012882026-02-06252026-01-27Late
2512004672025-12-30BAHAN BAKU GLAZE1099.0017KAOLIN POWDER MESH 3252606001901,8972601002032026-01-122026-01-20200,0001,575132604008422026-04-231012026-01-27Late
2512004672025-12-30BAHAN BAKU GLAZE1099.0017KAOLIN POWDER MESH 3252606001901,8972601002032026-01-122026-01-20200,0001,575132601013182026-02-07262026-01-27Late
2512004682025-12-29STATIONERY6010.0247AMPLOP COKLAT KOP KOBIN KOP KOBIN 35X24 CM260100526191,5002601001842026-01-122026-01-203175,000142601009422026-01-27152026-01-27On time
2512004912025-12-31SPAREPART5011.0479BEARING 6206 2Z C326010020136,0002601002012026-01-122026-01-235036,000122601007072026-01-2192026-01-30On time
2512004962025-12-31PERSEDIAAN UMUM6050.0098MASKER2605004383702601002002026-01-122026-01-2415,000284.685122601009942026-01-29172026-01-31On time
2512005132025-12-01SPAREPART5032.1446DISK CLUTCH FORKLIFT TAILIFT 02260100174275,0002601001742026-01-122026-01-121275,000422601004872026-01-1532026-01-19On time
2512100732025-12-27PERSEDIAAN UMUM6050.123FITTING PNEUMATIC PSA 826011006030,8752601100602026-01-122026-01-213030,875162601103212026-01-1752026-01-28On time
2512100732025-12-27PERSEDIAAN UMUM6050.1229FITTING PNEUMATIC PSA 1026011006033,7252601100602026-01-122026-01-213033,725162601103212026-01-1752026-01-28On time
2512100732025-12-27PERSEDIAAN UMUM6050.1228FITTING PNEUMATIC PSA 1226011006042,7502601100602026-01-122026-01-213042,750162601103212026-01-1752026-01-28On time
2512100732025-12-27PERSEDIAAN UMUM6050.1226FITTING PNEUMATIC PW 12-1026011006011,8752601100602026-01-122026-01-213011,875162601103212026-01-1752026-01-28On time
2512100732025-12-27PERSEDIAAN UMUM6050.1224FITTING PNEUMATIC PY 1026011006011,4002601100602026-01-122026-01-213011,400162601103212026-01-1752026-01-28On time
2512100732025-12-27PERSEDIAAN UMUM6050.1222FITTING PNEUMATIC PE 1226011006011,8752601100602026-01-122026-01-213011,875162601103212026-01-1752026-01-28On time
2601000032026-01-02PERSEDIAAN UMUM6050.1236KUNCI KOMSTER ADAPTOR BEARING260100209271,981.982601002092026-01-122026-01-211271,981.98102601009342026-01-27152026-01-28On time
2601000482026-01-06PERSEDIAAN UMUM6030.2108BATU PECAH 1-2 CM260100679400,0002601001722026-01-122026-01-121400,00062601005042026-01-1532026-01-19On time
2601000482026-01-06PERSEDIAAN UMUM6030.0823PASIR AYAK2605003391,150,0002601001722026-01-122026-01-121300,00062601003942026-01-1312026-01-19On time
2601000612026-01-07PERSEDIAAN UMUM6030.0823PASIR AYAK2605003391,150,0002601001722026-01-122026-01-1213,125,00052601005972026-01-1972026-01-19On time
2601000872026-01-09PERSEDIAAN UMUM6030.2102BESI BETON ULIR 16 MM260410106185,0002601001762026-01-122026-01-19100161,216.2132601013982026-02-10292026-01-26Late
2601000872026-01-09PERSEDIAAN UMUM6030.1553BESI BETON ULIR 10 MM26040047771,0002601001762026-01-122026-01-195063,034.2332601013982026-02-10292026-01-26Late
2601000872026-01-09PERSEDIAAN UMUM6030.0413BESI BETON ULIR 13 MM260400477119,932.432601001762026-01-122026-01-1950106,453.1532601013982026-02-10292026-01-26Late
2601001052026-01-09SPAREPART5025.0042UPE GUIDE/ WEARSTRIP 3MM X 30MM26060026130,0002601001822026-01-122026-01-2630030,00032601008342026-01-24122026-02-02On time
2601001242026-01-10PERSEDIAAN UMUM6050.0879POMPA GREASE260100208145,045.052601002082026-01-122026-01-262145,045.0522601005552026-01-1752026-02-02On time
2601001262026-01-10PERSEDIAAN UMUM6030.003PAKU 2 INCH26060016715,333.332601001892026-01-122026-01-226015,00022601004082026-01-1312026-01-29On time
2601001322026-01-10BAHAN PACKING3011.0044BOX JUPITER T.S KW 1 30X302605003821,1772601001812026-01-122026-01-221009052–––2026-01-29Overdue
2601001322026-01-10BAHAN PACKING3011.0139BOX PARIS HIJAU TS 30*30 KW 22605000989052601001812026-01-122026-01-228509052–––2026-01-29Overdue
2601001322026-01-10BAHAN PACKING3011.0076BOX JUPITER 30*30 PHIL2603000441,0322601001812026-01-122026-01-2230090522601010502026-01-29172026-01-29On time
2601001342026-01-08PERSEDIAAN UMUM6020.0758MATERIAL MESIN POLISH, NANO COATING, DRY SQUARING DAN PACKING2601001682,906,874,0002601001682026-01-122026-01-1212,906,874,0004–––2026-01-19Overdue
2601001392026-01-12SPAREPART5020.0002ADAPTER H-2309260100191124,4002601001912026-01-122026-01-268124,400–2601004572026-01-1422026-02-02On time
2601100112026-01-06PERSEDIAAN UMUM6030.0622KUAS 4 INCH26050044015,405.412601100592026-01-122026-01-21407,20062601103802026-01-2082026-01-28On time
2601100112026-01-06PERSEDIAAN UMUM6030.0621KUAS 3 INCH2605004409,127.932601100592026-01-122026-01-211004,66462601103802026-01-2082026-01-28On time
2601100222026-01-10BAHAN BAKU BODY1010.0012CLAY PRP 79#2601100613922601100612026-01-122026-01-1235,00039222601103912026-01-22102026-01-19Late
← PrevPage 40 of 135Next →Rows per page:1020501005001000