Equivalent Material Code

[Former Member]

Hi All,

We have one requirement as follows.

Technically materials are same. But it has different code and descriptions. When we check the material system should show other material in stock.

Example:

We have material X, Y Z

These materials are technically same specification. But It has different material codes.

When we check Material X in system, if not in stock, immediately system should show other stock Y & Z material if stock available.

how do we do in standard configuration?

thanks

Swathi

[Former Member]

Hi,

You shall opt for one material code but keep them under three different batches using batch management.

Regards,

Roy

[schaganti1]

Hi Swathi

we dont have material determination process in the MM point of view, i will explain my experience in the hospital industry, there they have different material code with same generic name.

e.g take one medicine material code as  Crocin its generic name is "paracetamol", in same way we have another two three different material codes ( stepstils  etc) but its generic name is " paracetamol" in your case same specification raw material are different and core component is same just like paracetamol in above example

to over come this option we have taken a basic data in basic data 2 tab and created one category as " paracemtol" as generic name, in your case create accordingly and assign that in the basic data 2 tab in basic data section.

to get the stock accordingly we need to create a zreport based on the basic materials to get the details.

Follow the screen short to create basic data field options.

this option will work for you, try and let us know to scn community.

Regards

Sudhakar

[Former Member]

Hi All,

Thanks for replying to all.

We found the way to maintain thru material master.

There is one Z table should maintain in material master under basic data view one. There we need assign all equivalent material against that one material. ie. A is main material. B & C are equivalent material for A. So We need to maintain B & C in Z table against A material.

During the stock availability check, we need to maintain Z T.code similarly MB5B.

There if we give material A stock will display A + B + C all together.

Hope you all understand.

Thanks

Swathi

[Former Member]

Use Ind. Std. Description (which is purely a text field) to group your all related materials with a unique searchable code and develop a report which can be executed using this field as selection option. Or you can include this field in any standard report for execution.

[Former Member]

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,

[BijayKumarBarik]

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

[Former Member]

Hi Bijay,

If Technical specification of material X,Y & Z are same and Z is required to attend a compliant, then ideally system should check the total of X+Y+Z before declaring the stock is not available.

How do we achieve thru Batch Management/

Thanks

Swathi

[former_member183349]

All you need to activate batch at either plant level or material level or client level. Once it is activated any of these level can't be modified ( careful observation is needed )

Create class using T code: CL01:

Material 1 = X1

Material 2 = Y1

Material 3 = Z1

Class Type: 001 (Material Class)

Enter the Class and the Class type, choose and enter the details by maintaining other tabs:

Basic data, Keywords, Char , Texts, Document, Std

and save it.

After that,

Material Master Creation:

By using MM01,

Classification screen, enter class 'X1'  input field class and choose enter.

choose save.

Classification screen, enter class 'Y1'  input field class and choose enter.

Choose save.

Classification screen, enter class 'Z1'  input field class and choose enter.

choose save.

Thanks,

Vivek

[Former Member]

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

[former_member213836]

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

[p391977]

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

[Jelena]

Radheshyam P wrote:

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

I feel this is rather the case of a super dumb unreasonable requirement.

"For safer side", seriously? What's so safe about it? Is 3 a magic number? Why not create 1003 material numbers then? To be even safer.

You can totally procure the same exact material number from any number of vendors. The business will run even "smoother" and, you know, Simpler.

[former_member183349]

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

[ankurch]

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

[JL23]

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

[Former Member]

Hi,

We are purchasing three material different vendors in market. But all three materials are having technically same. only difference is Material code. Specification also different.

While consuming from stock, If A material is not available, system should show alternative material stock if available for example B or C material.

During running business, manually we can select If A is not in stock, we can go for B material.

Similar way SAP should act in system.

For this, how do we configure or any customize programme?

Thanks

Swathi

[JL23]

Still I do not see that you gave a valid reason for having 3 different material masters in your system

see my answers in earlier similar discussions and make sure you searched before asking redundant questions:

[Former Member]

Hi Juergen,

I will explain more details.

We have three material in our master data.

Raw material 1 & Raw material 2 & Raw material 3

This three materials are having different numbers. But we can use alternatively any one of them. For example, Production department need Raw material 1, but it does not have stock. same time, Raw material 2 & Raw material 3 are having stock also we can utilize this material also for production.

This is our requirement, where system should show alternative stock.

Hope you understand why we are using 3 different materials in master data.

Just I had given example three materials. It might be 2 or 4 also.

Thanks

Swathi

[JL23]

You are just repeating your current situation but you do not explain why you need to have 3 material numbers. Why is it important for you to have 3 individual material numbers, what does this do for you?

[Former Member]

Hi Juergen,

Thanks for your reply.

For safer side we are having 3 materials. If A is not available we can go for B & C.

So production will not be having any issue. Business will run smoothly.

Therefore, we are having 3 materials in our master data.

Regards

Swathi

[JL23]

I do not see a reason and will stop replying now

[former_member197616]

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,

[bisweswar_sahu]

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