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
2512004522025-12-30BAHAN BAKU GLAZE1030.0027SILICA 200 ID2606000381,3162601000832026-01-062026-01-27120,0001,22572601009252026-01-27212026-02-03On time
2512004522025-12-30BAHAN BAKU GLAZE1030.0027SILICA 200 ID2606000381,3162601000832026-01-062026-01-27120,0001,22572601004562026-01-1482026-02-03On time
2512004522025-12-30BAHAN BAKU GLAZE1030.0027SILICA 200 ID2606000381,3162601000832026-01-062026-01-27120,0001,22572601009862026-01-29232026-02-03On time
2512004522025-12-30BAHAN BAKU GLAZE1030.0027SILICA 200 ID2606000381,3162601000832026-01-062026-01-27120,0001,22572601006012026-01-19132026-02-03On time
2512004542025-12-30BAHAN BAKU GLAZE1030.005COMPOUND FRIT UC 30252606000358,574.242601000852026-01-062026-01-205,0008,039.0472601005722026-01-19132026-01-27On time
2512004552025-12-30BAHAN BAKU GLAZE1030.0002TRANSPARENT FRIT IT-1413A26060005310,466.42601000622026-01-062026-01-20200,00010,010.472601005212026-01-1592026-01-27On time
2512004552025-12-30BAHAN BAKU GLAZE1030.0002TRANSPARENT FRIT IT-1413A26060005310,466.42601000622026-01-062026-01-20200,00010,010.472601005752026-01-19132026-01-27On time
2512004552025-12-30BAHAN BAKU GLAZE1030.0002TRANSPARENT FRIT IT-1413A26060005310,466.42601000622026-01-062026-01-20200,00010,010.472601005742026-01-19132026-01-27On time
2512004552025-12-30BAHAN BAKU GLAZE1030.0002TRANSPARENT FRIT IT-1413A26060005310,466.42601000622026-01-062026-01-20200,00010,010.472601003672026-01-1372026-01-27On time
2512004552025-12-30BAHAN BAKU GLAZE1030.0002TRANSPARENT FRIT IT-1413A26060005310,466.42601000622026-01-062026-01-20200,00010,010.472601008482026-01-26202026-01-27On time
2512004552025-12-30BAHAN BAKU GLAZE1030.0002TRANSPARENT FRIT IT-1413A26060005310,466.42601000622026-01-062026-01-20200,00010,010.472601003662026-01-1372026-01-27On time
2512004562025-12-30BAHAN BAKU GLAZE1099.0019KAOLIN NOODLE KS-022606000472,5402601000792026-01-062026-02-1675,0002,50072603001812026-03-05582026-02-23Late
2512004562025-12-30BAHAN BAKU GLAZE1099.0019KAOLIN NOODLE KS-022606000472,5402601000792026-01-062026-02-1675,0002,50072601019992026-02-25502026-02-23Late
2512004562025-12-30BAHAN BAKU GLAZE1099.0019KAOLIN NOODLE KS-022606000472,5402601000792026-01-062026-02-1675,0002,50072601019472026-02-24492026-02-23Late
2512004562025-12-30BAHAN BAKU GLAZE1099.0019KAOLIN NOODLE KS-022606000472,5402601000792026-01-062026-02-1675,0002,50072601019462026-02-24492026-02-23Late
2512004572025-12-30BAHAN BAKU GLAZE1040.0022CP-714 (RED BROWN)260100056155,161.22601000562026-01-062026-01-09100155,161.27–––2026-01-16Overdue
2512004572025-12-30BAHAN BAKU GLAZE1040.0022CP-714 (RED BROWN)260100056155,161.22601000562026-01-062026-01-09100155,161.272601016782026-02-16412026-01-16Late
2512004572025-12-30BAHAN BAKU GLAZE1040.0022CP-714 (RED BROWN)260100056155,161.22601000562026-01-062026-01-09100155,161.272601003792026-01-1372026-01-16On time
2512004582025-12-30BAHAN BAKU GLAZE1030.001TRANSPARENT FRIT XIT-63152606000526,541.52601000602026-01-062026-01-1540,0006,256.572601003682026-01-1372026-01-22On time
2512004592025-12-30BAHAN BAKU GLAZE1099.0023BENTONITE LGI2603001416,7502601000552026-01-062026-01-108,0006,75072601004232026-01-1372026-01-17On time
2512004602025-12-30BAHAN BAKU GLAZE1030.0018COMPOSED GLAZE (MATT) IG-4052606002778,024.242601000612026-01-062026-01-2030,0007,674.6472601005732026-01-19132026-01-27On time
2512004612025-12-30BAHAN BAKU GLAZE1030.0057TRANSPARENT FRIT 16152606000508,285.92601000592026-01-062026-01-2280,0007,924.972601005762026-01-19132026-01-29On time
2512004612025-12-30BAHAN BAKU GLAZE1030.0057TRANSPARENT FRIT 16152606000508,285.92601000592026-01-062026-01-2280,0007,924.972601012202026-02-04292026-01-29Late
2512004612025-12-30BAHAN BAKU GLAZE1030.0057TRANSPARENT FRIT 16152606000508,285.92601000592026-01-062026-01-2280,0007,924.97–––2026-01-29Overdue
2512004612025-12-30BAHAN BAKU GLAZE1030.0057TRANSPARENT FRIT 16152606000508,285.92601000592026-01-062026-01-2280,0007,924.972601009262026-01-27212026-01-29On time
2512004612025-12-30BAHAN BAKU GLAZE1030.0057TRANSPARENT FRIT 16152606000508,285.92601000592026-01-062026-01-2280,0007,924.972601013892026-02-09342026-01-29Late
2512004622025-12-30BAHAN BAKU GLAZE1030.0059TITANIUM DIOXIDE ANASTASE DHA-10026060004642,692.572601000802026-01-062026-01-144,00034,500.8872601005262026-01-1592026-01-21On time
2512004642025-12-30BAHAN BAKU GLAZE1020.0019OPACIFIER U-1026060004028,580.82601000842026-01-062026-01-1430,00026,796.872601003642026-01-1372026-01-21On time
2512004652025-12-30BAHAN BAKU GLAZE1020.0023HIGH COE TITANIUM FRIT K-086326060004210,028.752601000712026-01-062026-01-19160,0009,322.572601005222026-01-1592026-01-26On time
2512004652025-12-30BAHAN BAKU GLAZE1020.0023HIGH COE TITANIUM FRIT K-086326060004210,028.752601000712026-01-062026-01-19160,0009,322.572601006162026-01-20142026-01-26On time
2512004652025-12-30BAHAN BAKU GLAZE1020.0023HIGH COE TITANIUM FRIT K-086326060004210,028.752601000712026-01-062026-01-19160,0009,322.572601004432026-01-1482026-01-26On time
2512004652025-12-30BAHAN BAKU GLAZE1020.0023HIGH COE TITANIUM FRIT K-086326060004210,028.752601000712026-01-062026-01-19160,0009,322.572601002452026-01-0822026-01-26On time
2512004652025-12-30BAHAN BAKU GLAZE1020.0023HIGH COE TITANIUM FRIT K-086326060004210,028.752601000712026-01-062026-01-19160,0009,322.572601002442026-01-0822026-01-26On time
2512004662025-12-30BAHAN BAKU GLAZE1030.0062TRANSPARENT FRIT K 02482606000438,786.252601000762026-01-062026-01-2054,0008,167.572601006782026-01-21152026-01-27On time
2512004662025-12-30BAHAN BAKU GLAZE1030.0062TRANSPARENT FRIT K 02482606000438,786.252601000762026-01-062026-01-2054,0008,167.572601002882026-01-1042026-01-27On time
2512004952025-12-31PERSEDIAAN UMUM6020.0136CONTACT CLEANER ER 5710 B260100849108,5002601000652026-01-062026-01-1912108,50062601003832026-01-1372026-01-26On time
2512004952025-12-31PERSEDIAAN UMUM6020.0056PENETRATING OIL ER 571126050045554,5002601000652026-01-062026-01-193649,50062601003832026-01-1372026-01-26On time
2512004972025-12-31BAHAN BAKAR4050.0014SUPER GEAR OIL DAPHNE SUPER GEAR OIL 320 (IDEMITSU)26060009470,7502601000462026-01-062026-01-1920048,75062601002202026-01-0822026-01-26On time
2512004982025-12-31PERSEDIAAN UMUM6050.0045MAJUN WARNA2605004418,2002601000642026-01-062026-01-172437,20062601003842026-01-1372026-01-24On time
2512004992025-12-31SPAREPART5017.0103DOP PHILIPS 10 W26010004550,0002601000452026-01-062026-01-12550,00062601001912026-01-0712026-01-19On time
2512005032025-12-31PERSEDIAAN UMUM6050.0034LPG 50 KG2606001661,300,0002601000392026-01-062026-01-1221,000,00062601001932026-01-0712026-01-19On time
2512005052025-12-31PERSEDIAAN UMUM6030.0614KERTAS GOSOK NO 02605004922,837.842601000512026-01-062026-01-24152,702.762601003362026-01-1262026-01-31On time
2512005052025-12-31PERSEDIAAN UMUM6030.0733RESIBON POTONG 105X1.2X162605004922,702.72601000512026-01-062026-01-24602,702.762601003362026-01-1262026-01-31On time
2512005052025-12-31PERSEDIAAN UMUM6030.0615KERTAS GOSOK NO 12605004923,018.022601000512026-01-062026-01-24152,882.8862601003362026-01-1262026-01-31On time
2512005052025-12-31PERSEDIAAN UMUM6050.0051SIKAT KUNINGAN26050049212,162.162601000512026-01-062026-01-241211,711.7162601003362026-01-1262026-01-31On time
2512005052025-12-31PERSEDIAAN UMUM6030.0616KERTAS GOSOK NO 22605004923,378.382601000512026-01-062026-01-24153,243.2462601003362026-01-1262026-01-31On time
2512005052025-12-31PERSEDIAAN UMUM6030.0693GERINDA KERTAS GOSOK 4 INCH2605004926,756.762601000512026-01-062026-01-24156,306.3162601003362026-01-1262026-01-31On time
2512005052025-12-31PERSEDIAAN UMUM6020.0042TERMINAL KABEL 6 MM26050038658,558.562601000512026-01-062026-01-241258,558.5662601003372026-01-1262026-01-31On time
2512005052025-12-31PERSEDIAAN UMUM6030.0527SEAL TAPE2606001484,504.512601000512026-01-062026-01-24254,504.5162601003362026-01-1262026-01-31On time
2512005052025-12-31PERSEDIAAN UMUM6020.0044TERMINAL KABEL 10 MM26050038672,072.072601000512026-01-062026-01-241272,072.0762601003372026-01-1262026-01-31On time
2512005052025-12-31PERSEDIAAN UMUM6030.0632KACA LAS HITAM2605004902,702.72601000512026-01-062026-01-24102,702.762601003362026-01-1262026-01-31On time
2512005052025-12-31PERSEDIAAN UMUM6030.0627RESIBON POTONG 4 INCH 100X6X1626050049210,810.812601000512026-01-062026-01-241210,360.3662601003362026-01-1262026-01-31On time
2512005052025-12-31PERSEDIAAN UMUM6050.0019KRAN AIR 3/4 INCH26050049038,288.292601000512026-01-062026-01-24535,135.1462601003362026-01-1262026-01-31On time
2512005052025-12-31PERSEDIAAN UMUM6030.0642KACA LAS BENING2606100226752601000512026-01-062026-01-2451,171.1762601003362026-01-1262026-01-31On time
2512005052025-12-31PERSEDIAAN UMUM6030.0526ISOLASI ELECTRIC2605004926,306.312601000512026-01-062026-01-24305,855.8662601003362026-01-1262026-01-31On time
2512005052025-12-31PERSEDIAAN UMUM6030.053LEM SILICON CLEAR 300ML26050049227,027.032601000512026-01-062026-01-241026,126.1362601002222026-01-0822026-01-31On time
2512005052025-12-31PERSEDIAAN UMUM6030.0521LEM ADHESIVE26060016455,0002601000512026-01-062026-01-242519,819.8262601002222026-01-0822026-01-31On time
2512005052025-12-31PERSEDIAAN UMUM6030.062KUAS 2 INCH2605004405,794.62601000512026-01-062026-01-24247,702.762601003362026-01-1262026-01-31On time
2512005052025-12-31PERSEDIAAN UMUM6030.0621KUAS 3 INCH2605004409,127.932601000512026-01-062026-01-242411,531.5362601003362026-01-1262026-01-31On time
2512005052025-12-31PERSEDIAAN UMUM6030.0622KUAS 4 INCH26050044015,405.412601000512026-01-062026-01-242418,603.662601003362026-01-1262026-01-31On time
2512005052025-12-31PERSEDIAAN UMUM6030.0522LEM BESI 48 GR26050000615,765.772601000512026-01-062026-01-241214,414.4162601003362026-01-1262026-01-31On time
2512005052025-12-31PERSEDIAAN UMUM6020.0078KLEM SLANG 3 INCH2605004907,117.122601000512026-01-062026-01-24106,756.7662601003362026-01-1262026-01-31On time
2512005052025-12-31PERSEDIAAN UMUM6030.0524LEM SUPER GLUE2605004924,954.962601000512026-01-062026-01-24254,504.5162601003362026-01-1262026-01-31On time
2512005052025-12-31PERSEDIAAN UMUM6030.0529LEM SILICON RED 85 GR26050049222,522.522601000512026-01-062026-01-241220,270.2762601003362026-01-1262026-01-31On time
2512005052025-12-31PERSEDIAAN UMUM6030.0612RESIBON POTONG 16X1/8X1 INCH26010023657,162.162601000512026-01-062026-01-241057,207.2162601003362026-01-1262026-01-31On time
2512005052025-12-31PERSEDIAAN UMUM6020.0077KLEM SLANG 2 INCH2605004904,954.962601000512026-01-062026-01-24104,684.6962601003362026-01-1262026-01-31On time
2512100372025-12-12PERSEDIAAN UMUM6020.0686CLOSE-TOOTH TYPE CABLE DUCT (DEPTH 80 X WIDTH 60)260110017225,0002601100172026-01-062026-01-1420225,000252601101282026-01-0932026-01-21On time
2512100472025-12-15PERSEDIAAN UMUM6050.0003KRAN WASTAFEL26011001485,8002601100142026-01-062026-01-14385,800222601101262026-01-0932026-01-21On time
2512100492025-12-16PERSEDIAAN UMUM6050.1189BACK SUPPORT KRISBOW KW1000045 BLACK260110018173,2502601100182026-01-062026-01-222173,250212601108542026-02-11362026-01-29Late
2512100492025-12-16PERSEDIAAN UMUM6050.0226SILICONE HITAM()26010011825,0002601100152026-01-062026-01-141025,784212601101272026-01-0932026-01-21On time
2512100492025-12-16PERSEDIAAN UMUM6030.053LEM SILICON CLEAR 300ML26050049227,027.032601100152026-01-062026-01-141025,784212601101272026-01-0932026-01-21On time
2512100602025-12-20PERSEDIAAN UMUM6050.0397KUNCI L 12MM PANJANG26011002153,0002601100212026-01-062026-01-06253,000172603100682026-03-05582026-01-13Late
2512100602025-12-20PERSEDIAAN UMUM6050.0803KUNCI L 14MM PENDEK26011002146,0002601100212026-01-062026-01-06246,000172604101192026-04-08922026-01-13Late
2512100602025-12-20PERSEDIAAN UMUM6050.0398KUNCI RING PAS 8-24 MM260500335299,9002601100212026-01-062026-01-061305,000172603100682026-03-05582026-01-13Late
2512100602025-12-20PERSEDIAAN UMUM6050.062KUNCI L SET TEKIRO260500486100,2002601100212026-01-062026-01-061103,000172603100682026-03-05582026-01-13Late
2512100602025-12-20PERSEDIAAN UMUM6050.0802KUNCI L 12MM PENDEK26011002130,0002601100212026-01-062026-01-06230,000172603100682026-03-05582026-01-13Late
2512100602025-12-20PERSEDIAAN UMUM6050.0426KUNCI L 14 MM PANJANG26011002168,0002601100212026-01-062026-01-06268,000172603100682026-03-05582026-01-13Late
2512100602025-12-20PERSEDIAAN UMUM6050.0804KUNCI L 17MM PENDEK26011002175,0002601100212026-01-062026-01-06175,000172603100682026-03-05582026-01-13Late
2512100602025-12-20PERSEDIAAN UMUM6050.0424KUNCI L 17 MM PANJANG260110249112,5142601100192026-01-062026-01-061112,51417–––2026-01-13Overdue
2512100602025-12-20PERSEDIAAN UMUM6050.0805KUNCI L 19MM PENDEK26011002195,0002601100212026-01-062026-01-06195,000172603100682026-03-05582026-01-13Late
2512100602025-12-20PERSEDIAAN UMUM6050.0819KUNCI L 19MM PANJANG260110021140,0002601100212026-01-062026-01-061140,000172603100682026-03-05582026-01-13Late
2512100602025-12-20SPAREPART5027.0446KARET RAKEL / ROUND BELT SCRAPER 60SHORE SIZE: L 50 X T 10 MM LUBANG 12MM RED26011002277,5002601100222026-01-062026-01-0650077,500172601102452026-01-1372026-01-13On time
2512100602025-12-20SPAREPART5027.0446KARET RAKEL / ROUND BELT SCRAPER 60SHORE SIZE: L 50 X T 10 MM LUBANG 12MM RED26011002277,5002601100222026-01-062026-01-0650077,500172601103182026-01-17112026-01-13Late
2512100602025-12-20PERSEDIAAN UMUM6050.1209KUNCI T 17MM26011002129,0002601100212026-01-062026-01-061229,000172603100682026-03-05582026-01-13Late
2512100602025-12-20PERSEDIAAN UMUM6050.121KUNCI T 19MM26011002026,4002601100202026-01-062026-01-061226,40017–––2026-01-13Overdue
2512100692025-12-26PERSEDIAAN UMUM6020.0735BOX PANEL 30X40CM260110012375,2502601100122026-01-062026-01-067375,250112601101172026-01-0822026-01-13On time
2512100732025-12-27SPAREPART5011.0528BEARING 6002RZ26011002325,0002601100232026-01-062026-01-153025,000102601102482026-01-1372026-01-22On time
2512100732025-12-27SPAREPART5011.0531BEARING 6205-2RZ26011002445,3502601100242026-01-062026-01-151045,350102603100992026-03-05582026-01-22Late
2512100732025-12-27SPAREPART5011.038BEARING 6209 RZ260110023114,5002601100232026-01-062026-01-1530114,500102601106372026-02-03282026-01-22Late
2512100732025-12-27SPAREPART5011.0532BEARING 6302 RZ26011002435,3852601100242026-01-062026-01-153035,385102603100992026-03-05582026-01-22Late
2512100802025-12-31BAHAN BAKU GLAZE1070.0035INK DP BLACK NS 1185260110011214,8562601100112026-01-062026-01-06700214,85662601105332026-01-28222026-01-13Late
2512100802025-12-31BAHAN BAKU GLAZE1070.0036INK DP YELLOW CIK 1124260110364146,098.422601100112026-01-062026-01-06700144,53962601105332026-01-28222026-01-13Late
2512100802025-12-31BAHAN BAKU GLAZE1070.0025INK DP BLUE K 3586 BETO INK260110365211,895.922601100102026-01-062026-01-061,500205,934.2762601101742026-01-1042026-01-13On time
2512100802025-12-31BAHAN BAKU GLAZE1070.0026INK DP BROWN K 3287 BETO26051007692,550.392601100102026-01-062026-01-0640085,613.1262601101742026-01-1042026-01-13On time
2512100802025-12-31BAHAN BAKU GLAZE1070.0028INK DP GREEN K 3801 BETO260110365111,835.982601100102026-01-062026-01-0680108,751.8162601101742026-01-1042026-01-13On time
2512100802025-12-31BAHAN BAKU GLAZE1070.003INK DP BLACK GSY 99023 GUOSE260310056952601100092026-01-062026-01-065007962603103292026-03-18712026-01-13Late
2512100802025-12-31BAHAN BAKU GLAZE1070.0031INK DP RED GSB 10023 GUOSE2603100561202601100092026-01-062026-01-0630012062603103292026-03-18712026-01-13Late
2601000022026-01-02SPAREPART5032.0092V. BELTB RECMF V 847026010006858,2002601000682026-01-062026-01-19558,20042601004002026-01-1372026-01-26On time
2601000082026-01-02SPAREPART5011.0091BEARING 6200 2RS26010094323,9002601000402026-01-062026-01-195023,90042601003872026-01-1372026-01-26On time
2601000082026-01-02SPAREPART5011.0093BEARING 6201 2RS26050018517,4002601000402026-01-062026-01-192517,80042601003912026-01-1372026-01-26On time
← PrevPage 31 of 135Next →Rows per page:1020501005001000