Material Determination in SO

[Former Member]

Hi,

I have a business requirement wherein SAP should carry out material determination in sales order based on the Requested Delivery Date . I guess in standard SAP this is done on the order creation date.

How can this be done ?

[Former Member]

Hi,

Yes, standard material determination takes place based on the order creation date. You can create material determination condition tables with the validity periods. This validity period will be checked against the order creation date, but not the requested delivery date.

We have the similar functionality with pricing. where you create the pricing condition records with a validity period and in the sales document type customizing (VOV8), you can specify whether pricing date is based on the order creation date, requested delivery date, etc. What you're today searching is also the same for material determination. But this is not available in standard SAP.

Therefore you will have to do an ABAP enhancement to achieve this.

Use below include - MV45AFZA

You have below user exits;

USEREXIT_MOVE_FIELD_TO_KOMKD

USEREXIT_MOVE_FIELD_TO_KOMPD

Check below links on more info.

[User Exits In Sales Document Processing|http://help.sap.com/saphelp_46c/helpdata/en/1c/f62c7dd435d1118b3f0060b03ca329/content.htm]

[Material Determination|http://www.learnsaptips.com/2011/12/material-determination-in-sap.html]

Best regards,

Anupa

[Shiva_Ram]

Try with user exit EXIT_SAPFV45S_001 in program SAPLXVVA (Include LXVVAU02).

Regards,

[Former Member]

You are correct there is no standard way of doing it needs coding effort.

[Former Member]

Hi,

During sales order creating the program uses function module "Product_substitution" to get the substituted material number.To this function module the date inputted is order creation date.you need to use an user exit in which you can pass the requested delivery date to the valid from date of the funciton module.

Thanks,

Srini

[Former Member]

Hai Ankur,

1.Mat determination is used To findout the available alternative materials for a material when the material is entered in the sales order.

2. you can configure it as follows:

IMG -> sd -> basic functions -> material determinations.

3. Also maintain condition records at VB11and Order reason at OVRQ.

4. Mat determination in sale order is triggered by material entered in the line item of the sales order.

5. In manual production selection, the system does not automatically replace the Material. Instead, it displays a list of all of the substitution materials and other information in the master record. You can then select the required material from this list.

6. To simplify selection, the system displays the material quantities that can be confirmed on the customer's requested delivery date. If a material cannot be confirmed fully for the requested delivery date, the system displays the date on which the material can be completely delivered.

(Note: We can also do a seperate, new Mat determination by copy cotrol configuration during the creation with reference.)

Hope this helps you.

[kartefact]

Does Material determination/Product selection or aATP based Product substitution support one-to-many substitutions?

i.e.

If I have Product A, can we configure it in a way to substitute product A with product B, C and D creating new line items in the sales order based on stock availability of each material? 

e g.

If product A in plant 1 is requested for 100 quantity, but no stock is available, but there's 30 of product B in plant 1, 20 of product C in plant 2 and 50 of product D in plant 3 are available, then the one line item should get replaced as three line items in the sales order one line item for each of products B, C and D.

Is this achievable through standard configuration?

Another follow up question would be can we introduce custom logic somewhere to determine the ranking of the different substitute products for doing the substitutions e.g say based on batch characteristic?

Any clues appreciated. 

Regards,

Kartefact