Hi Jonathan,
According to my experience at my client, material substitution doesn't work looking at availability of the stock for a material.
Hence if u have setup mat sub for X --> Y then during order creation this will be triggered .Same is the case at VA02.
Now the requirement you have is to link AC, stock levels check and then change the line item on the order. This will surely call for a user exit changes at order level.
We have implemented a similar type of function which will look for alternate plant for stock and will source the remaining from that plant if needed.
Hence for ur requirement you will define below tables
Table 1 : Material - Max stock, mim stock , safety stock, eligible for this functionality, SD related fields e.g sales org, cust grp, sales dist
Table 2 : MARD / MKOL to check the current stock levels.
Logic will go as below
1. Is stock X can fulfill order. If yes complete at X exit.
2. If no, then check by how much this is less and add a new line item 20 with remaining qty.
3. Check stock Y is more than order line item If yes good exit.
4. If no create new item of Z.
The table 1 can be useful to define the step 2 and further is allowed or not using eligible field. Secondly the checks can also consider product allocation if it is used.
Reward if helpful
Kind Regards
Sandeep
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.