Equivalent Material Code

Hi,

As material is same and specifications are different- Better go for ONE material code creation and then go for Split valuation( keep 3 valuation types which you procure from different 3 vendors from market) or for Batch Management( have 3 batches for different specifications.

Regards,

Biju K

Hi Swathi,

You can try this approach.

1. Add a field in Material Master to keep Primary Material Code in subordinate materials.

( Primary material: X, then material Y & Z will keep X in material master)

2. Customized Stock report to get stock from X, if zero stock, read stock from Y & Z.

Regards,

Bisweswar

Hi, in sap normally materials are classified based upon the Material type / material group . If materials are to be with Physical property differences or any such , classification based differenciation or variant configuration is used . since your materials are not having any such differentiation shown in SAP , std sap is not offering any std report . You will have to jave common property identified the group of the materials which you have with slight varination ( the variation can be on based upon say density --- Hydrochloric acid --- density 01 and another material HCL of density 03 ETC ) and this has to be mentioned in the system in any of the field .The you can write a program to fetch the stock data of such grouped materials . Better have a classification assigned http://scn.sap.com/docs/DOC-25224 then plan for a report alternatively maintain that difference in any of the un used fields and fetch the data based upon the tables like MARC/MARD etc . Regards,

What is the reason for having 3 material codes for the same specification? Can't you just delete 2 and continue with 1?

Hi Swathi,

In SAP Standard process its not possible, but somehow you can achieve it through batch management.

Maintain the same batch number for material X,Y & Z. run the code BMBC, through this report you can extract the materials with same batch. after that you can check whether you want to procure/ Issue.

Thanks & regards,

Ankur Chauhan

Hi Swathi,

Standard report don't have the option. Best way to discuss with abaper in order to develop a Customized Z Report.

Thanks,

Vivek

This is the case of Material determination(substitution) in Sales & Distribution.

Hi Swathi,

The standard Stock reports MMBE and MB52 are straight forward. You get stock for what you provide in selection screen.

From your comments it appears that the materials in question are alternate materials in BOM and if that is the case it is a valid scenario. Reason can be many like price, quality and availability from vendor.

However, your exact requirement cannot be met via standard reports. Best Standard Option would be to use MB52 report and filter it by using Material Type and Material Group in the scope of list and select No zero Stock Lines. Something like this.

Regards,

Niranjan

Hi All,

What I can understand from Swathi's question is - those 3 are different materials indeed BUT one can substitute the other in Production. So.. when Material A is not in stock, they want the system to suggest the stock of Material B and C and thereby they can use the available ones in Production.

Is it right Swathi?

If so, go for a custom report with these 3 Material codes in discussion with the Abaper !

Regards,

NR

Hi Swathi,

Logically there is no need to keep multiple material codes in system. However, if you want to continue with this process I would suggest you to keep the materials in separate logical storage locations.

Mat 1 -- Sloc1

Mat 2 -- Sloc 2

Similarly.

So if user have used all the stock of Mat1 from SLoc1 he may swtich to Mat2 of Sloc2 .

Rgds,