on 08-22-2014 1:44 PM
Dear Gurus,
I am new to SAP and having a requirement to automatically assign delivery plant to sales orders based on the below hierarchy. Can this be
achieved in standard SAP?
Thanks,
Tarek
System will always prioritize CMIR, CMR (Ship To) and Material Master with standard configuration / master data. In your case, if this is not happening, then already some exit is in place which you need to check.
G. Lakshmipathi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thanks Lakshmipathi! seems like I will have to go with Joan M's recommendation of user exit.
Here is how I setup my CMIR and Customer Master:
Sold To | Ship To | Material | Plant | Table |
| 2000030 | 30000004 | 1701 | CMIR |
1000014 |
| 10000006 | 1700 | CMIR |
| 2000030 |
| 1706 | Customer Master |
| 2000029 |
| 1703 | Customer Master |
1000014 |
|
| 1100 | Customer Master |
|
|
|
|
|
When entered a sales order for sold to 1000014 and ship to 2000030 here
is what I got:
Sales Order Ship To | Sales Order Sold To | Sales Order Material | Sales Order Plant | Desired Plant |
2000030 | 1000014 | 10000006 | 1700 | 1706 |
2000030 | 1000014 | 30000003 | 1706 | 1706 |
2000030 | 1000014 | 30000004 | 1706 | 1701 |
|
|
|
|
|
When entered a sales order for sold to 1000014 and ship to 2000029 here
is what I got:
Sales Order Ship To | Sales Order Sold To | Sales Order Material | Sales Order Plant | Desired Plant |
2000029 | 1000014 | 10000006 | 1700 | 1703 |
2000029 | 1000014 | 30000003 | 1703 | 1703 |
2000029 | 1000014 | 30000004 | 1703 | 1703 |
|
|
|
|
|
Here is how I setup my CMIR and Customer Master (took out the sold
to/material from CMIR):
Sold To | Ship To | Material | Plant | Table |
| 2000030 | 30000004 | 1701 | CMIR |
1000014 |
| 10000006 | 1700 | CMIR |
| 2000030 |
| 1706 | Customer Master |
| 2000029 |
| 1703 | Customer Master |
1000014 |
|
| 1100 | Customer Master |
|
|
|
|
|
When entered a sales order for sold to 1000014 and ship to 2000030 here
is what I got:
Sales Order Ship To | Sales Order Sold To | Sales Order Material | Sales Order Plant | Desired Plant |
2000030 | 1000014 | 10000006 | 1706 | 1706 |
2000030 | 1000014 | 30000003 | 1706 | 1706 |
2000030 | 1000014 | 30000004 | 1706 | 1701 |
|
|
|
|
|
Hi,
Can you confirm below points... would be easy for solution.
If both sold to and ship to comes in sales order who should preceed.
your set up is not showing any combination of sold and shipto
As JM mentioned with the combination of above set up need to go with exit only, Std. config is not available.
If You wanted to go individually, maintain cmir for sold to & cmr for ship to.
But you with the combination of above with material you need to maintain ztable and pick in to plant determination table.
Thanks & Regards
Bhaskar
Thanks Bhaskar! the sequence which i would like the system to use is:
so I can setup certain items for certain ship to's to be delivered from specific plants or I can always ship to a certain ship to customers out of a plant. same for Sold to customers as i would like to be able to ask the system to deliver out of a plant if I am selling products to specific sold to regardless of the ship to. I know it is kind of confusing but we have a requirement to deliver certain items to a specific ship to's out of a certain plant.
I would like to be able to:
ship Item A to Ship To customer 123 out of plant 1100
ship Item B to Ship To customer 123 out of plant 1200
all other items to Ship To customer 123 out of plant 1300
the same will apply to sold to.
Thanks,
Tarek
Hi,
you can use userexit_source_determination in MV45AFZB.
Regards,
JM
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
you need to Maintain the plant in the master data(Customer and Material)
system automatically picks the plant in the sales order.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
91 | |
8 | |
7 | |
4 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.