Dear All,
Here our client requirement is for the material number, when user create a material then the material number will generate based on the material type and material group. the material number will be of 10 digits first two digits define the material type, second three digits show the material group and last five digits will show the material code. this 10 digits will define the material number so that while seeing the material number user will easily identify the material from which material type and material group it will belongs.
for an example
material type
ZMEH (01) Mechanical
ZELE (03) Electrical
material group
01001 Chain
01002 Gear
02001 Fan
02002 Bulb
At the time user create material with TCode MM01 and select material type ZMEH and material group 01001 then the material number will generate 0100100001 and goes on till 0100199999
and when the material create with same material type ZMEH but with different material group 01002 then the material will be 0100200000, till 0100299999.