Material Master Upload Template

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1of 55

Material Number Material Type Plant Storage Location Valuation Type Sales Organization Distribution Channel Division

BCPIMATHEAD BCPIMATHEAD BCPI_MARC BCPI_MARD BCPI_MBEW BCPI_MVKE BCPI_MVKE BCPI_MARA

MATERIAL MATL_TYPE PLANT STGE_LOC VAL_TYPE SALES_ORG DISTR_CHAN DIVISION


CHAR CHAR CHAR CHAR CHAR CHAR CHAR CHAR
18 4 4 4 10 4 2 2
BC-0000001 ZERS BC00 A005
BC-0000002 ZERS BC00 A005

BC-0000003 ZERS BC00 A005


BC-0000004 ZERS BC00 A005
BC-0000005 ZERS BC00 A005
Material Description (Short Text) BCse UOM MATL_GROUP Old material number Product Hierarchy Control Code/HSN
BCPI_MAKT BCPI_MARA BCPI_MARA BCPI_MARA BCPI_MARA BCPI_MARC
MATL_DESC
BCSE_UOM MATL_GROUP OLD_MAT_NO PROD_HIER CTRL_CODE
CHAR UNIT CHAR CHAR CHAR CHAR
40 3 9 18 18 16
TITANIUM DIOXIDE RUTILE - TR28 (TIO2) KG 5023
CALCIUM CARBONATE 1T-IP KG 5023
METALLIC STREARATE EXPORT CALCIUM
STREARATE KG 5023
RUTILE TITANIUM DIOXIDE TION 134 KG 5023
CHIMASSORB 944 FDL KG 5023
External material Group Profit Center BCtch Management BCtch management Size/dimensions Gross Weight Weight Unit
BCPI_MARA BCPI_MARC BCPI_MARC BCPI_MARA BCPI_MARC BCPI_MARA BCPI_MARM
NO_COSTING PROFIT_CTR BCTCH_MGMT BCTCH_MGMT
EXTMATLGRP SIZE_DIM GROSS_WT
CHAR CHAR CHAR CHAR CHAR CHAR QUAN
18 1 10 1 1 32 13
BC00 1 KG
BC00 1 KG
BC00
1 KG
BC00 1 KG
BC00 1 KG
Unit of weight in ISO code Net Weight Denominator for Conversion (Alternate UOM 1) to BCse units of measure Alternative UOM 1
BCPI_MARA BCPI_MARM BCPI_MARA BCPI_MARM

UNIT_OF_WT UNIT_OF_WT_ISO NET_WEIGHT DENOMINATR


UNIT CHAR QUAN DEC
3 3 13 5
1 1
1 1

1 1
1 1
1 1
Numerator for Conversion (Alternate UOM1 ) to BCse Units of Measure
BCPI_MARM

ALT_UNIT
UNIT
3
Denominator for Conversion (Alternate UOM 2) to BCse units of measure Alternative UOM 2
BCPI_MARM BCPI_MARM1

NUMERATOR DENOMINATR
DEC DEC
5 5
Numerator for Conversion (Alternate UOM2 ) to BCse Units of Measure
BCPI_MARM1

ALT_UNIT
UNIT
3
Denominator for Conversion (Alternate UOM 3) to BCse units of measure Alternative UOM 3
BCPI_MARM1 BCPI_MARM2

NUMERATOR DENOMINATR
DEC DEC
5 5
Numerator for Conversion (Alternate UOM3 ) to BCse Units of Measure
BCPI_MARM2

ALT_UNIT
UNIT
3
Denominator for Conversion (Alternate UOM 4) to BCse units of measure Alternative UOM 4
BCPI_MARM2 BCPI_MARM3

NUMERATOR DENOMINATR
DEC DEC
5 5
Numerator for Conversion (Alternate UOM4 ) to BCse Units of Measure
BCPI_MARM3

ALT_UNIT
UNIT
3
Denominator for Conversion (Alternate UOM 5) to BCse units of measure Alternative UOM 5
BCPI_MARM3 BCPI_MARM4

NUMERATOR DENOMINATR
DEC DEC
5 5
Numerator for Conversion (Alternate UOM 5 ) to BCse Units of Measure BCsic Material Hazardous material number Environmentally Relevant
BCPI_MARM4 BCPI_MARM4 BCPI_MARA BCPI_MARA

ALT_UNIT NUMERATOR BCSIC_MATL HAZ_MAT_NO


UNIT DEC CHAR CHAR
3 5 48 18
Sales Unit Sales Unit ISO Code Deliverying Plant Departure Country Tax category Tax classification material Departure Country
BCPI_MARA BCPI_MVKE BCPI_MVKE BCPI_MLAN BCPI_MLAN BCPI_MLAN BCPI_MLAN

ENVT_RLVT SALES_UNIT_ISO DELYG_PLNT DEPCOUNTRY TAX_TYPE_1 TAXCLASS_1 DEPCOUNTRY


CHAR CHAR CHAR CHAR CHAR CHAR CHAR
1 3 4 3 4 1 3
Tax category Tax classification material Departure Country Tax category Tax classification material Matl statistics grp Item category group
BCPI_MLAN BCPI_MLAN BCPI_MLAN BCPI_MLAN BCPI_MLAN BCPI_MVKE BCPI_MVKE

TAX_TYPE_1 TAXCLASS_1 DEPCOUNTRY TAX_TYPE_1 TAXCLASS_1 MATL_STATS ITEM_CAT


CHAR CHAR CHAR CHAR CHAR CHAR CHAR
4 1 3 4 1 1 4
Product hierarchy Acct assignment grp Availability check Transportation Group Loading Group General item category group
BCPI_MVKE BCPI_MVKE BCPI_MARC BCPI_MARA BCPI_MARC BCPI_MARA

PROD_HIER ACCT_ASSGT AVAILCHECK TRANS_GRP LOADINGGRP ITEM_CAT


CHAR CHAR CHAR CHAR CHAR CHAR
18 2 2 4 4 4
Material group 1 Material group 2 Material group 3 Material group 4 Material group 5 Material Group for Packaging Materials
BCPI_MVKE BCPI_MVKE BCPI_MVKE BCPI_MVKE BCPI_MVKE BCPI_MARA

MATL_GRP_1 MATL_GRP_2 MATL_GRP_3 MATL_GRP_4 MATL_GRP_5 MAT_GRP_SM


CHAR CHAR CHAR CHAR CHAR CHAR
3 3 3 3 3 4
Purchasing Group Purchasing Unit Order Unit ISO Code Variable PO Unit Active Purchasing Value Key
BCPI_MARC BCPI_MARA BCPI_MARA BCPI_MARA BCPI_MARA
PUR_GROUP PO_UNIT PO_UNIT_ISO
VAR_ORD_UN PUR_VALKEY
CHAR UNIT CHAR CHAR CHAR
3 3 3 1 4
Goods Receipt Processing Time in Days Indicator: Source list requirement Storage Bin Storage conditions Total shelf life
BCPI_MARC BCPI_MARC BCPI_MARD BCPI_MARA BCPI_MARA

GR_PR_TIME SOURCELIST STGE_BIN STOR_CONDS SHELF_LIFE


DEC CHAR CHAR CHAR DEC
3 1 10 2 4
Minimum Remaining Shelf Life Period Indicator for Shelf Life Expiration Date CC phys. inv. ind. CC indicator fixed Label Type Label Form
BCPI_MARA BCPI_MARA BCPI_MARC BCPI_MARC BCPI_MARA BCPI_MARA

MINREMLIFE PERIOD_IND_EXPIRATION_DATE CC_PH_INV CC_FIXED LABEL_TYPE LABEL_FORM


DEC CHAR CHAR CHAR CHAR CHAR
4 1 1 1 2 2
Warehouse No Storage type indicator for stock removal Storage Section Indicators Storage type indicator for stock placement
BCPI_MLGT BCPI_MLGN BCPI_MLGN BCPI_MLGN

WHSE_NO WITHDRAWAL STGESECTOR PLACEMENT


CHAR CHAR CHAR CHAR
3 3 3 3
Bulk storage indicator Storage Type Plant-sp.matl status MRP Type MRP Group Reorder Point MRP Controller Lot size
BCPI_MLGN BCPI_MLGT BCPI_MARC BCPI_MARC BCPI_MARC BCPI_MARC BCPI_MARC BCPI_MARC

BLOCK_STGE STGE_TYPE PUR_STATUS MRP_TYPE MRP_GROUP REORDER_PT MRP_CTRLER LOTSIZEKEY


CHAR CHAR CHAR CHAR CHAR QUAN CHAR CHAR
2 3 2 2 4 13 3 2
VB B600 10 PR1 EX
VB B600 10 PR1 EX

VB B600 10 PR1 EX
VB B600 10 PR1 EX
VB B600 10 PR1 EX
Minimum Lot Size Maximum Lot Size Fixed lot size Maximum stock level Assembly scrap (%) Rounding Profile Rounding value
BCPI_MARC BCPI_MARC BCPI_MARC BCPI_MARC BCPI_MARC BCPI_MARC BCPI_MARC

MINLOTSIZE MAXLOTSIZE FIXED_LOT MAX_STOCK ASSY_SCRAP ROUND_PROF ROUND_VAL


QUAN QUAN QUAN QUAN DEC CHAR QUAN
13 13 13 13 5 4 13
Procurement type Special procurement Prod. stor. location BCckflush Storage loc. for EP Stock determination group
BCPI_MARC BCPI_MARC BCPI_MARC BCPI_MARC BCPI_MARC BCPI_MARC

PROC_TYPE SPPROCTYPE ISS_ST_LOC BCCKFLUSH SLOC_EXPRC DETERM_GRP


CHAR CHAR CHAR CHAR CHAR CHAR
1 2 4 1 4 4
F A002
F A002

F A002
F A002
F A002
Planned Deliv. Time GR Processing Time SchedMargin key Safety Stock Planning strategy group Consumption mode
BCPI_MARC BCPI_MARC BCPI_MARC BCPI_MARC BCPI_MARC BCPI_MARC

PLND_DELRY GR_PR_TIME SM_KEY SAFETY_STK PLAN_STRGP CONSUMMODE


DEC DEC CHAR QUAN CHAR CHAR
3 3 3 13 2 1
1 0 101 40 2
1 0 101 40 2

1 0 101 40 2
1 0 101 40 2
1 0 101 40 2
Bwd consumption per. Fwd consumption per. Availability check Selection method Individual/coll. Component scrap (%)
BCPI_MARC BCPI_MARC BCPI_MARC BCPI_MARC BCPI_MARC BCPI_MARC

BWD_CONS FWD_CONS AVAILCHECK ALT_BOM_ID DEP_REQ_ID COMP_SCRAP


NUMC NUMC CHAR CHAR CHAR DEC
3 3 2 1 1 5
30 30 CH 3 2 0
30 30 CH 3 2 0

30 30 CH 3 2 0
30 30 CH 3 2 0
30 30 CH 3 2 0
Work Scheduling Unit of issue Unit Of Issue ISO Code Production Supervisor Production Scheduling Profile Underdelivery tolerance limit
BCPI_MARC BCPI_MARC BCPI_MARC BCPI_MARC BCPI_MARC
PRODUCTION_SCHEDUL
ISSUE_UNIT ISSUE_UNIT_ISO ER PRODPROF UNDER_TOL
UNIT CHAR CHAR CHAR DEC
3 3 3 6 3
Overdelivery tolerance limit Indicator: Unlimited Overdelivery Allowed Material Authorization Group for Activities in QM
BCPI_MARC BCPI_MARC BCPI_MARC

OVER_TOL UNLIMITED QM_AUTHGRP


DEC CHAR CHAR
3 1 6
Goods Receipt Processing Catalog Profile Interval until next recurring inspection QM in Procurement is Active
Time in Days
BCPI_MARC BCPI_MARA BCPI_MARC BCPI_MARA

GR_PR_TIME CATPROFILE INSP_INT QM_PROCMNT


DEC CHAR DEC CHAR
3 9 5 1
X
Control Key for Quality Management in Procurement Certificate Type Valuation Class Valuation Category Price control Moving price
BCPI_MARC BCPI_MARC BCPI_MBEW BCPI_MBEW BCPI_MBEW BCPI_MBEW

CTRL_KEY CERT_TYPE VAL_CLASS VAL_CAT PRICE_CTRL MOVING_PR


CHAR CHAR CHAR CHAR CHAR DEC
8 4 4 1 1 23
Standard price Price Unit With Qty Structure Costing Overhead Group Material origin Origin Group Variance Key
BCPI_MBEW BCPI_MBEW BCPI_MBEW BCPI_MBEW BCPI_MBEW BCPI_MBEW BCPI_MARC
VARIANCE_KE
STD_PRICE PRICE_UNIT QTY_STRUCT OVERHEAD_GRP ORIG_MAT ORIG_GROUP Y
DEC DEC CHAR CHAR CHAR CHAR CHAR
23 5 1 10 1 4 6
Lot Size for Product Costing Special Procurement Type for Costing Production Version To Be Costed
BCPI_MARC BCPI_MARC BCPI_MARC

LOT_SIZE SPECPROCTY PRODVERSCS


QUAN CHAR CHAR
13 2 4
Key data structure

Material type Plant Storage locations Sales organization


FINISHED ZFER BC00 ASCI Manufacturing A001 RAW MATERIALS BC00
SEMI FINISHED ZHAL A002 PACKAGING MATERI BC01
SPARES ZERS A003 SEMI FINISHED GO
ACCESSORIES ZACC A004 FINISHED GOODS
TRADING ZHAW A005 SPARE PARTS
OFFICE SUPPLIES ZHIB A006 CONSUMABLES AND
RAW MATERIALS ZROH A007 QUARANTINE
STATIONARY ZSTA A008 REJECT LOCATION
NON-VALUATED ZUNB A009 SCRAP LOCATION
PACKAGIN ZVER A010 DAMMAM CALL-OFF
A012 FG FOR RE-USING
B001 MAIN QC LAB
B002 MICROBIOLOGY LAB
B003 RESERVE SAMPLE S
B004 VALIDATION SLOC
C001 REWORK PROCESSIN
C002 WIP1
C003 WIP2
C004 WIP3
G001 COLD STORAGE
G002 CORROSIVE, DANGE
H001 MAINT. SLOC
IM01 INTERMEDIATE SL
T001 Trading material

BC01 ASCI Office SL01 General


SL02 Stationary
SL03 Consumables
Sales organization Distribution channel Base unit of measure material group
ASCI Domestic Sales 00 Others AGG Agg/Gm 01
ASCI Export Sales 01 Direct AMP Ampule 02
02 Tender BAG Bag 101
03 GCC/SGH BOT Bottle 1010
04 Institution Sales BOX Box 1011
05 Toll Manufacturing CAP Capsule 1012
06 Stock Transfer CFU CFU/ml 1013
07 Distributors CON Container 1014
08 Outsource/Thirdparty CPS cPs 1015
09 AD00 Trading CS Case 1016
10 Export In Turkey CST cSt 1017
11 Export Out Of Turkey DEG Degree 1018
12 ASCI Intra Zone DR Drum 1019
13 ASCI Inter Zone DZ Dozen 102
14 Urban Speciality Bus E/K Units/KG 1020
15 Repacking EA each 1021
16 TPMC- RM Algeria EE Enzy.Units 1022
EMG Enzyme/mg 1023
EML Enzyme/ml 1024
G/L gai/liter 1025
GAU Gram Gold 1026
GG Gram/ Gram 1027
GRO Gross 1028
GSM gsm 1029
GW g act.ing. 103
K/B KG/BAG 1030
KAN Canister 1031
KAR Carton 1032
KGW kg ac.ing. 1033
KI Crate 1034
KI1 KG of AI 1035
KWK kai/kg 1036
LE Act. unit 1037
M/M %(m/m) 1038
MG1 mg/10mg 1039
MG2 µg/g 104
MG3 µg/mg 1040
MG4 microgram 1041
MLN Millions 1042
MLW ml act.in. 1043
NOS Numbers 1044
P/C Part/Cont 1045
PAA Pair 1046
PAK Pack 1047
PAL Pallet 1048
PCS Pieces 1049
PCT Group prop 105
PH pH value 1050
PRS Persons 1051
ROL Role 1052
SET Set 1053
ST items 1054
TAB Tablet 1055
THO Thousand 1056
TUB Tube 1057
U/K Units/KG 1058
U1 Unit/Vials 1059
UN unit 106
VAL Value 1060
VL Vial 107
Z1 mg/5ml 108
Z10 µR/HR 109
Z11 g/ml 201
Z12 mg/cm3 2010
Z13 µg/tab 2011
Z14 g/sec 2012
Z15 IU/5ml 2013
Z16 IU/ml 2014
Z17 Nm 2015
Z18 EU/D 2016
Z19 Rotation 2017
Z2 Abs 2018
Z20 Micro Volt 2019
Z21 Delta E 202
Z22 Bar per gr 2020
Z23 g/10 min 2021
Z24 Grams /CC 2022
Z25 IU 2023
Z26 CFU/g 2024
Z27 g/sq.m 2025
Z28 mg/ml 2026
Z3 IU/g 2027
Z4 IU/mg 2028
Z5 mEq 2029
Z6 P/U 203
Z7 U/mg 2030
Z8 mg/cap 2031
Z9 mg/tab 2032
2033
2034
2035
2036
2037
2038
2039
204
2040
2041
2042
2043
2044
2045
2046
2047
2048
2049
205
2050
2051
2052
2053
206
207
208
209
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
401
4010
4011
4012
4013
4014
4015
4016
4017
4018
4019
402
4020
4021
4022
4023
4024
4025
4026
4027
4028
4029
403
4030
4031
4032
4033
4034
4035
4036
4037
4038
4039
404
4040
4041
4042
4043
4044
4045
4046
4047
4048
4049
405
4050
4051
4052
4053
4054
4055
4056
406
407
408
409
501
5010
5011
5012
5013
5014
5015
5016
5017
5018
5019
502
5020
5021
50211
50212
50213
50214
50215
50216
50217
50218
50219
5022
50220
50221
5023
5024
5025
5026
5027
5028
5029
503
5030
5031
5032
5033
5034
5035
504
505
506
507
508
509
510
601
6010
6011
6012
6013
6014
6015
602
603
604
605
606
607
608
609
701
7010
7011
7012
7013
7014
7015
7016
7017
7018
7019
702
7020
7021
7022
7023
703
704
705
706
707
708
709
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
900
901
902
903
904
905
906
907
908
909
910
911
material group Profit center Availability check MRP Type
test1 01 Daily requirements PD
test2 02 Individ.requirements R1
ACTIVE INGREDIENTS CH Batches R2
GRATINGS DR RE
H. ROLLED BEAMS BC00 KP No check RF
H. ROLLED CHANNELS Z2 Individ.requirements RP
H. ROLLED COILS (GAL RR
H. ROLLED FLAT BARS RS
H. ROLLED FLAT COILS V1
H. ROLLED HOLLOW SEC V2
H. ROLLED PLATES VB
H. ROLLED PLATES COI VI
HOT ROLLED COILS (BL VM
ADDITIVE VS
NON ACTIVE INGREDIAN VV
PAINT MATERIALS X0
PHARMA GENERAL RM
PIGMENTS RM
PIPES
POLYMERS RM
RAW FOR FERTILIZER
RAW FOR PESTICIDES
ROUND BARS
SHEETING COILS
ANGLES
SOLVENTS
SURFACTANT
TI02
DECK PANELS
PURLIN
COLD FORM CHANNEL
SANDWICH PANELS
MISCELLANEOUS MATERI
FABRICATED GRATINGS
ROLL UP DOORS
BLASTING
WAX
CAL. CARBONATE
DYESTUFFS
BASF RM
YANSAB RM
LIQUID
SAMPLES POLYMERS
GAS
SAMPLES
CONTROLLED DEA ITEMS
BOROUGE RM
STRATEGIC APIS
FLAVOURS
EXCIPIENTS
MONO MB - RM
RAW FOR FUNGICIDES
RAW FOR HERBICIDES
RAW FOR INSECTICIDES
RAW FOR PLANT G REGL
RAW FOR PUB H CARE
RAW FOR OTHERS
CARBON BLACK
RAW FOR NEMATICIDES
CIBA RM
E.G. CAPSULE
FILLER
ALUMINUM FOIL
LABEL
LEAFLET
PACKING MATERIALS
PALLETS & PALLETIZIN
PLASTIC MATERIAL
PVC / PVDC
SHRINK FILM FOR PACK
SILICA GEL
VIAL
PE BAG (OM) PRINTED
ALUMINUM TUBE
PE BAG (OM) PLAIN
PP WOVEN VALVE BAG
PP JUMBO BAG
PE SHRINKHOOD
STRECTCH FILM
HDPE CONTAINER LINER
PP CONTAINER LINER
CARDBOARD
WOODEN PALLET
STEEL BAR
BAGS
DRUMS
DESICCANT
VIGNETTE
OUTER CARTON
SPOON
RUBBER STOPPER
DROPPER
APPLICATOR
SYRINGES
POUCHES
CARTON
COTTON
STRATEGIC PACK ITEMS
TUBE
AMPOULES
PVC
PVC/PVDC
PVC/PE
SAMPLES
OTHERS - PACKAGING
BOTTLE
CFB BOX
COEX BOTTLE
HDPE BOTTLE
LID
TIN
CONTAINER
DILUENTS
GLASS MATERIAL
INNER BOX
FERTILIZER BASE FORM
MICROELEMENT MIX
PESTICIDES BASE FORM
QUARANTINE FERTILIZE
QUARANTINE PESTICIDE
SFG FLANGE STANDARD
SFG FLANGE NON STD
SFG WEB
SFG DETAIL<16MM
SFG DETAIL>16MM
SFG BUILT UP ONLNE
SFG BUILT UP OFFLNE
SFG HOT ROLLED
SFG PURLINS
SFG EAVE STRUTS
SFG CHANNELS
SFG ANGLES
SFG SAG RODS
SFG BRACE RODS
SFG ANCHOR BOLTS
SFG SHEETING PANELS
SFG TRIMS
SFG SWP LOW RIB
SFG SWP HIGH RIB
WARE HOUSE
MONO MB - SFG
POLYMER - PULVERIZED
SFG TPMC
WIP TPMC
CREAM
SYRUP
CAPSULE
TABLETS
DRY SUSPENSION
VIAL
WIP FOR PLANT A
WIP FOR STERILE
WIP FOR PLANT B
SFG FOR FUNGICIDES
SFG FOR HERBICIDES
SFG FOR INSECTICIDES
SFG FOR PLANT G REGL
SFG FOR PUB H CARE
SFG FOR OTHERS
SFG FOR NEMATICIDES
SFG SUBCONTRACTING
SFG CHEQUERED PLATE
SFG GRATING
SFG HAND RAILS
SFG LOOSE PLATES
SFG MISCELLANEOUS CF
AMPOULE
ADDITIVE
MISCELLANIES
PHARMACEUTICLES
PIGMENTS FG
SEEDS
VETERANARY
WHITE
FG BUILT UP ONLINE
FG BUILT UP OFFLINE
FG HOT ROLL ASSEMBLY
FG CHEQUERED PLATE
AGROCHEMICALS
FG GRATINGS
FG ANGLES
FG Z PURLINS
FG C CHANNELS
FG EAVE STRUTS
FG RODS&ANCHOR BOLTS
FG SHEETING&SKYLIGHT
FG FLASHINGS&TRIMS
FG SANDWICH PANEL
FG INSULATIONS
BLACK
ACCESSORIES, STANDAR
MONO MB
FMS
SSUS : Dry suspensio
DRPS : Drops
Gel : Gel
SLOT: lotion
POWD : Powder
SDRP : Drops
Smpo: Shampoo
BOROUGE FG
Solu : Solution
Spry: Spray
Supp: Suppositories
Ssup: Liquid .suspen
FG FOR FUNGICIDES
FG FOR HERBICIDES
FG FOR INSECTICIDES
FG FOR PLANT G REGL
FG FOR PUB H CARE
FG FOR OTHERS
CIBA
FG FOR NEMATICIDES
FG HAND RAILS
FG LOOSE PLATES
FG STANDARD MATERIAL
FG ERECTION MATERIAL
FG for Granular
SFG for Granular
COLOR
COMPOUND
FERTILIZER
LIQUID / PASTES
ACCESSORIES
INSECTICIDE PRODUCTI
INSTRUMENT
IT SPARE PARTS
MECHANICAL
MISCELLANEOUS
PLUMBING
POWER FILLING PRODUC
SOLUBLE FERTILIZER P
SPARE PARTS A
SPARE PARTS B
CIVIL
SPARE PARTS C
SPARE PARTS UTILITIE
Civil
Cranes
Electrical
Electronic
Fleet
HVAC (A/C, AHU, De-
Instrument
IT Spare Parts
Mechanical
SUSPENSION CONCENTRA
Miscellaneous
Plumbing
SPARE PARTS
CLEANING MATERIALS
CONSTRUCTION MATERIA
COMPUTER/PRINTING SU
PAINT AND GASES
HARDWARE SUPPLIES
LUBRICANT
CRANES
TOOLS
SLIGHTLY USED SPARE
OTHERS
RE-WORK
SAFETY MATERIALS
Public Relation
ELECTRICAL
ELECTRONIC
FLEET
FLUID FERTILIZER PRO
HERBICIDE PRODUCTION
HVAC (A/C, AHU, DE-
MAINTENANCE SUBCON
ANALYTICAL STANDARD
WELDING MATERIALS
FOOD/PENTRY ITEMS
CLEANING CONSUMABLES
CONSTRUCTION CONS
HARDWARE CONSUMABLES
OTHERS CONSUMABLES
FOAMING CHEMICALS
GENERAL CONSUMABLES
IT CONSUMABLE
LAB CHEMICALS
LABORATORY CHEMICAL
PROMOTIONAL ITEMS
PVC SHRINK BAGS / SL
STATIONARY
BUILDING ACCESSORIES
DOOR ACCESSORIES
NMI MATERIALS
POP RIVETS
SEALANTS
SELF DRILLING SCREWS
SELF TAPPING SCREWS
STOCK PARTS
VENTILATOR ACCESSORI
HILTI BOLTS
OFFICE SUPPLIES
HIGH STRENGTH BOLTS
BOLTS
NUTS
WASHERS
ANCHOR BOLTS
HIGH STRENGTH NUTS
HIGH STRENGTH WASHER
HILL SIDE WASHERS
MILD STEEL BOLTS
MILD STEEL NUTS
MILD STEEL WASHERS
MISCELLANEOUS MATERI
SCRAP
ASSETS
SERVICES
MAINTENANCE SERV
OVERHEAD SERV
CLEANING SERV
TRANSPORT SERV
SCAPPING SERV
DRAFTING SERV
DETAILING SERV
MANPOWER SERV
ERECTION SERV
FABRICATION SERV
INSURANCE SERV
EQUIPMENT RENTAL SER
CONSTRUCTION SERV
REWORK FOR SPAREPART
CANTEEN EXPENSES
SD PRIMARY STEEL
SD SECONDARY
SD SECONDARY BUYOUT
SD SHEETING
SD SHEETING BUYOUT
SD SANDWICH PANELS
SD SW PANELS BUYOUT
SD ACCESSORIES
SD ACCESORIES BUYOUT
SD MISCELLANEOUS
SD MISC BUYOUT
SD SERVICES
MRP Type MRP Group MRP Controller
MRP BC10 FG1 – MRP Group 1 (90 days) 101
Time-phased planning BC20 SFG1 – MRP Group 1 (90 days) 102
Time-phased w.auto.reord.point BC30 RM1 – MRP Group 1 (90 days) 201
Replenishment plnd externally BC40 PM1 – MRP Group 1 (60 days) 202
Replenish with dyn.TargetStock BC60 Maint. Matls – MRP Group 1 (180 days) 301
Replenishment 302
Tmphsd. repl. w. dyn.trgt.stck 401
Time-phased replenishment plng 402
Manual reord.point w. ext.reqs 501
Autom. reord.point w. ext.reqs 502
Manual reorder point planning 601
Vendor Managed Inventory 602
Automatic reorder point plng 999
Seasonal MRP M20
Forecast-based planning M21
W/O MRP, with BOM Explosion PP1
PR1
YYY
ZZZ
MRP Controller Lotsize Schedule margin key Valuation class
Black Master B FG DY Dynamic lot size creation 100
Black Master B RM EX Lot-for-lot order quantity 101
Additives FG FS Fixing and splitting
Additives RM FX Fixed order quantity
White Master B FG GR Groff reorder procedure
White Master B RM HB Replenish to maximum stock level Consultant to fill
Color Master B FG M2 2 Months lot size, delivery 1st day
Color Master B RM M3 3 Months lot size, delivery 1st day
Liquid Master B FG MB Monthly lot size
Liquid Master B RM PB Period lot size = posting period
Compounds FG PK Period lot size acc. to plng calendar
Compounds RM SP Part period balancing
SF Master Batch TB Daily lot size
Consumables Ctrlr W2 Week - 2
Spare Parts Ctrlr WB Weekly lot size
Commom PM WI Least unit cost procedure
Commom RM
Missing MRP Ctrlr
Unknown MRP Ctrlr
Account assignment group Control key for QM procurement Scheduling Margin key
01 Finished Goods ZQ01 Delivery Release, Invoice Block, COA 100
02 Trading Goods ZQ02 Del. Rel., Invoice Block, COA & Sample 101
03 Services ZQ03 Del. Rel.,Invoice Block, No COA & Sample
04 Promotional Material
05 Free medical Samples
06 Raw Materials
07 Toll Material
08 Packaging Material
09 Semi-finished goods
10 oxygen
11 other
12 Power
13 By Product

You might also like