KKobin GroupProcurement KPI

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
2601100162026-01-08SPAREPART5014.0048MESH 802601008718.100No ETA
2601100202026-01-09SPAREPART5017.0988SIBA LEGRAND FUSE 20 A (10X38)25120022648,00000No ETA
2601100252026-01-13PERSEDIAAN UMUM6030.0366PIPA GALVANIS 3/4 INCH260100314185,405.4100No ETA
2601100312026-01-14BAHAN BAKU BODY1010.0038BENTONITE BIG-20000No ETA
2601100352026-01-19PERSEDIAAN UMUM6030.2583PIPA 1 1/4 GALVANIS000No ETA
2601100412026-01-21SPAREPART5014.0046MESH 402601008718.100No ETA
2601100442026-01-21SPAREPART5014.0046MESH 402601008718.100No ETA
2601100502026-01-26BAHAN BAKU BODY1040.0025PIGMENT BLACK N3 GUOSE000No ETA
2601100512026-01-24FIXED ASSETSAST02621Generator Set (Alternator: Stamford) | 1250 kVA 220/380 Volt – 3 Phase, 15000 Rpm / 50 Hz (Type: Open & Handling Leveling), Include Instalasi & Accessories000No ETA
2601100512026-01-24PERSEDIAAN UMUM6050.0872REFIL KUAS ROLL 4 INCH2605101551,137503,440No ETA
2601100602026-01-28BAHAN BAKU BODY1040.0025PIGMENT BLACK N3 GUOSE000No ETA
2601100622026-01-28PERSEDIAAN UMUM6050.0237KABEL LAS 70MM26061002085,585.5800No ETA
2601100652026-01-29SPAREPART5031.0966IMPACT LINER, MODEL PFS1010000No ETA
2601100652026-01-29SPAREPART5031.0681PERIPHERAL LINER VSI9526-3-10225081021712400No ETA
2601100652026-01-29SPAREPART5031.0965IMPACT CRUSHER LINER SCREW, SQUARE HEAD M27X2X120, (INCLUDES NUT, FLAT WASHER, SPRING WASHER).000No ETA
2601100652026-01-29SPAREPART5031.0797UPPER FLOW CHANNEL PLATE VSI9526-8-103VSI9526-8-1032508102172700No ETA
2601100652026-01-29SPAREPART5021.0372NARROW V-BELT 25N-4320 GB/T11544-1997GB/T11544-19972508102171900No ETA
2601100652026-01-29SPAREPART5031.097UPPER IMPACT PLATE, MODEL VSI9526_3_105000No ETA
2601100652026-01-29SPAREPART5031.0682IMPACT BLOCK VSI9526-8-106250810217800No ETA
2601100652026-01-29SPAREPART5011.0512BEARING 23128 PFS1010 IMPACT CRUSHER25081021730800No ETA
2601100652026-01-29SPAREPART5031.0974HOOK BOLT M16X150 (INCLUDES NUT, FLAT WASHER, SPRING WASHER).000No ETA
2601100652026-01-29SPAREPART5031.0972VSI9526 ROTOR ASSEMBLY (IMPELLER/ROTOR)000No ETA
2601100652026-01-29SPAREPART5031.0963IMPACT CRUSHER BLOW BAR, MODEL PFS1010 (4 PIECES/SET).000No ETA
2601100652026-01-29SPAREPART5011.0513BEARING 22328 2YZS1860 VIBRATING SIEVE25081021728600No ETA
2601100652026-01-29SPAREPART5031.0968RIB GUARD PLATE, MODEL PFS1010000No ETA
2601100652026-01-29SPAREPART5021.0374BELT SPC3150 PFS1010 IMPACT CRUSHER250910170630,00000No ETA
2601100652026-01-29SPAREPART5031.0969WEAR PLATE, MODEL VSI9526_8_107000No ETA
2601100652026-01-29SPAREPART5011.0514BEARING 22320 HEAVY-DUTY FEEDER25081021713000No ETA
2601100652026-01-29SPAREPART5011.0511FRAME BEARING 22340 PE500*750 JAW CRUSHER25081021772900No ETA
2601100652026-01-29SPAREPART5011.051BEARING 22248 PE500*750 JAW CRUSHER25081021762600No ETA
2601100652026-01-29SPAREPART5021.0373BELT D-5600 PE500*750 JAW CRUSHER2511100801,125,00000No ETA
2601100652026-01-29SPAREPART5031.0973VIBRATING SCREEN RUBBER STRIP, 15/20 U-TYPE000No ETA
2601100652026-01-29SPAREPART5031.0967Z-TYPE TIGHTENING BLOCK, MODEL PFS1010000No ETA
2601100652026-01-29SPAREPART5031.0962MOVABLE PRESSURE BLOCK SCREW M36X670000No ETA
2601100652026-01-29SPAREPART5031.0683HAMMER HEAD VSI9526-8-225081021715700No ETA
2601100652026-01-29SPAREPART5031.08LOWER FLOW CHANNEL PLATEVSI9526-8-104 VSI9526-8-1042508102174400No ETA
2601100672026-01-29PERSEDIAAN UMUM6030.2625BAUT+MUR+RING+RING PER M14X50MM BAJA000No ETA
2601100772026-02-04PERSEDIAAN UMUM6050.132ELECTRIC SOCKET WRENCH SET (6MM - 36MM)000No ETA
2601100772026-02-04SPAREPART5023.1522RUBBER CONVEYOR BELT B600 X 6 LAYERS X 10MM THICK000No ETA
2601100772026-02-04SPAREPART5023.1525HYDRAULIC THREE-JAW PULLER 20 TON000No ETA
2601100772026-02-04PERSEDIAAN UMUM6030.2632DN25 PVC HOSE (SELANG) 50M/ROLL000No ETA
2601100772026-02-04SPAREPART5023.1528HIGH-DENSITY INDUSTRIAL WOOL FELT SHEET, 18MM X 1M X 1M000No ETA
2601100772026-02-04SPAREPART5023.1527OIL-RESISTANT RUBBER MAT, 3MM THICK, SIZE 1M X 10M000No ETA
2601100772026-02-04SPAREPART5023.1524HYDRAULIC THREE-JAW PULLER 30TON000No ETA
2601100772026-02-04PERSEDIAAN UMUM6030.2631AG10800 ANGLE GRINDER000No ETA
2601100772026-02-04SPAREPART5023.1524HYDRAULIC THREE-JAW PULLER 15TON000No ETA
2601100772026-02-04SPAREPART5023.1523WATER PUMP MOTOR BEARING MODEL 6314000No ETA
2601100772026-02-04SPAREPART5023.1521RUBBER CONVEYOR BELT B800 X 6 LAYERS X 10MM THICK000No ETA
2601100812026-02-04PERSEDIAAN UMUM6030.2649CLEM RAGUM26041009023,240459,999No ETA
2601100812026-02-04SPAREPART5027.0388WATERPASS 600 MM MAGNETIC000No ETA
2601100812026-02-04PERSEDIAAN UMUM6030.0036KAWAT LAS LB 26 3.2260500347297.300No ETA
2601100812026-02-04PERSEDIAAN UMUM6030.2648MESIN CUTTING WHEEL UKURAN 14 INC MAKITA000No ETA
2601100852026-02-05SPAREPART5023.1545MOLD GUIDE RAIL LENGTH 1.5M, WIDTH 100MM, HEIGHT 60MM000No ETA
2601100852026-02-05SPAREPART5023.1536PU POLYURETHANE DISCHARGE HOSE 130MM000No ETA
2601100902026-02-07PERSEDIAAN UMUM6050.1344BALING-BALING KIPAS ANGIN 16INCI000No ETA
2601101022026-02-11SPAREPART5021.037BELT B2616 WGJPA-220/Φ8.5×4 Φ8.5×4 SLURRY TANK AGITATOR260610171123,00000No ETA
2601101022026-02-11PERSEDIAAN UMUM6050.1349SELANG HOSTAR 1" PVC HOSE 10-20 METER000No ETA
2601101072026-02-12PERSEDIAAN UMUM6030.2708SEKRUP S6000No ETA
2601101072026-02-12PERSEDIAAN UMUM6030.2707LONG DRAT M 10000No ETA
2601101072026-02-12PERSEDIAAN UMUM6030.0754FISHER SKRUP 6 MM25091015525000No ETA
2601101072026-02-12PERSEDIAAN UMUM6030.1777BESI UNP 100 12M2605100691,284,00000No ETA
2601101072026-02-12SPAREPART5017.1086LAMPU DOWNLIGHT 12 W000No ETA
2601101072026-02-12PERSEDIAAN UMUM6020.0084KABEL NYM 2X1.5 MM2601003301,241,261.2600No ETA
2601101072026-02-12PERSEDIAAN UMUM6020.0783KABEL DUCT 100X100 MM000No ETA
2601101072026-02-12PERSEDIAAN UMUM6030.2706ELBOW PVC 1 INCH000No ETA
2601101072026-02-12PERSEDIAAN UMUM6030.0551ELBOW PVC 3/4 INCH2604002791,917.1200No ETA
2601101072026-02-12PERSEDIAAN UMUM6030.2709KABEL DUCT TC000No ETA
2601101072026-02-12PERSEDIAAN UMUM6030.0582PIPA PVC 3/4 INCH26050014530,422.5200No ETA
2601101072026-02-12PERSEDIAAN UMUM6030.2705PIPA PVC RUCIKA 1 INC000No ETA
2601101072026-02-12PERSEDIAAN UMUM6010.0562Kabel 3 x 2,5mm NYM251000605910,00000No ETA
2601101072026-02-12PERSEDIAAN UMUM6050.1356PIPA AC 1/4 INC000No ETA
2601101072026-02-12PERSEDIAAN UMUM60A0.0028DUCT TAPE LEM PIPA AC25081002413,00000No ETA
2601101072026-02-12SPAREPART5017.0019MCB CIRCUIT BREAKER 1P 16A26050001160,00000No ETA
2601101072026-02-12PERSEDIAAN UMUM6050.1357ARMAFLEX 1 INC000No ETA
2601101072026-02-12PERSEDIAAN UMUM6050.1355PIPA AC 5/8 INC000No ETA
2601101142026-02-16PERSEDIAAN UMUM6020.0789MODUL PWM MESIN LAS 200A 220V000No ETA
2601101142026-02-16PERSEDIAAN UMUM6050.1368MERK PWPGAS PN MZ 100 NR 235611 DIAMETER 4 INC PANJANG BODY 24,5 CM000No ETA
2601101142026-02-16PERSEDIAAN UMUM6020.0787GBT 50T65FD1 SILAN 50T65 50N65000No ETA
2601101152026-02-18PERSEDIAAN UMUM6030.2727SEKRUP PANEL SDS WAFER HEAD 10X16000No ETA
2601101152026-02-18PERSEDIAAN UMUM6020.047BOX PANEL 60X50X20 CM260100586620,00000No ETA
2601101152026-02-18PERSEDIAAN UMUM6030.2728SEKRUP PANEL SDS WAFER HEAD 10X25000No ETA
2601101222026-02-21PERSEDIAAN UMUM6030.2741CAT BESI AVIAN WARNA WALL FLOWER (MO-2D-0513)000No ETA
2601101222026-02-21PERSEDIAAN UMUM6050.0982POLYACRYLAMIDE25091013443,00000No ETA
2601101222026-02-21PERSEDIAAN UMUM6020.0795ADAPTOR CHARGER KRISBOW TIMBANGAN DUDUK DIGITAL KW06-579 ADAPTER TERA000No ETA
2601101252026-02-23STATIONERY6010.0468SPIDOL JUMBO 500 MARKER HITAM25080002315,50000No ETA
2601101342026-02-26PERSEDIAAN UMUM6030.2766BAUT DYNABOLT KETOK M14X100MM000No ETA
2601101342026-02-26PERSEDIAAN UMUM6030.255DYNABOLT M16-1202601102829,80600No ETA
2601101342026-02-26PERSEDIAAN UMUM6030.2769BOSH MATA BOR HAMMER EXPERT SDS MAX-8X Ø16 X 200/340 MM000No ETA
2601101342026-02-26PERSEDIAAN UMUM6030.2768BOSH MATA BOR HAMMER EXPERT SDS MAX-8X Ø14 X 200/340 MM000No ETA
2603000192026-03-03PERSEDIAAN UMUM6030.2715PIPA STAINLESS OD 60 TEBAL 3 PANJANG 3360 MM ( TEMPERATURE 800⁰C )2601009621,750,00000No ETA
2603000242026-03-02BAHAN BAKU BODY1010.0002FELDSPAR (MK-5)26060000815000No ETA
2603000272026-03-02BAHAN BAKU BODY1010.0003FELDSPAR (KC-06)26060001215000No ETA
2603000932026-03-07SPAREPART5021.0466TIMING BELT TIPE H 2000 PU03785,000No ETA
2603000932026-03-07SPAREPART5021.0467TIMING BELT TIPE H 2990 PU021,178,000No ETA
2603001042026-03-07BAHAN PEMBANTU20OT.0002IPAC CIP A200000No ETA
2603001192026-03-09PERSEDIAAN UMUM6060.0685LEM SUNPAT ECO 310 (CEMENT) + LEM SUNPAT ECO 305 (HARDENING AGENT)260400533485,00000No ETA
2603001352026-03-10SPAREPART5032.0142BEARING HMK /NO 6 M0905-TA2830Z26010088675,00000No ETA
2603001512026-03-11SPAREPART5017.0143TELE AUX BLOCK ZBE 10126050015024,50000No ETA
2603001622026-03-11SPAREPART5017.1089TELE SELECTOR XB4 BD53000No ETA
2603001642026-03-11SPAREPART5017.0038SIEMENS 3RT 1054 IAF36 3RT 1054 IAF36 110-127 VAC2510000793,550,00000No ETA
← PrevPage 5 of 135Next →Rows per page:1020501005001000