cancel
Showing results for 
Search instead for 
Did you mean: 

Automatic Delivery Plant assignment in Sales Orders

Former Member
0 Kudos

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?

 

  • Ship To / Material
  • Ship To
  • Sold To / Material
  • Sold To

Thanks,

Tarek

Accepted Solutions (0)

Answers (3)

Answers (3)

Lakshmipathi
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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


 

 


 

 


 

 


 

 


 

 


 
Former Member
0 Kudos

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

Former Member
0 Kudos

Thanks Bhaskar! the sequence which i would like the system to use is:

  • Ship To / Material
  • Ship To
  • Sold To / Material
  • Sold To

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

Former Member
0 Kudos

Hi Tarek,

If that is the case you may have consider Joan suggestion, and even you can try in userexit_save_document in mv45afzz.

Thanks & Regards

Bhaskar

Former Member
0 Kudos

Hi,

you can use userexit_source_determination in MV45AFZB.

Regards,

JM

Former Member
0 Kudos

Thanks Joan! I am hoping to accomplish this through configuration. if not, i will use your reccomendation.

Thanks,

Tarek

siva_vasireddy2
Active Contributor
0 Kudos

Hi,

you need to Maintain the plant in the master data(Customer and Material)

system automatically picks the plant in the sales order.

Former Member
0 Kudos

Thanks Siva! I did maintained the plant on CMIR and customer master (Sold to and Ship To) but still not getting the correct delivery plant. for some reason it skips one of my hierarchy levels and goes to the next one.

Thanks,

Tarek