material determination

[Former Member]

Hi guru's,

I have a requirement wherein the material determination process in SD is to be automated to some extent. Now normally the material to be determined has a condition technique...access sequence associated with it. Now for our requirement, we need to automate this for a large number of materials so that , suppose, if these details are available in excel format, then it could be uploaded directly to a program and then the program would have the option to select the level of access sequence (general to specific) that we would like the material to be determined at.

How can I proceed with this ? I'm looking for possible tables that have the data , any BAPI's that can be used so that i can take this forward with my ABAPer.

regards,

Roy

[Former Member · Accepted solution]

Material Determination uses cond tech to swap one material for another in a sales order, when certain conditions apply. Substituting one product with another product is called material determination. The product is only substituted during the specific period.

You can use material det if you want the system to automatically substitute, for e.g.:

-          Customer specific product numbers with your own material numbers.

-          International article numbers (EAN's) with your own material numbers.

-          Substituting discontinued materials with newer materials

-          Seasonal products.

So basically you need to develop a program ( either BAPI or BDC ) to create condition records ( VB11) thru excel file uploading. Correct ?

Pls refer following link for further details :--

http://scn.sap.com/thread/1899084

http://scn.sap.com/thread/1214353

http://scn.sap.com/message/1409812#1409812

Thanks

Rajesh

[Former Member · Accepted solution]

thanks a ton Rajesh.

my requirement was exactly what one of those threads addressed. Got what i was looking for