Extract customer master partner functions.

[Former Member]

Hi ,

We are generating an sales order extract we also need to provide customer details.I understand that the customer address data should read from transactional ADRC table.Could you please suggest which ship-to address should be put in the customer master extract in case have more than one ship-to address considering customer id the unique primary key.

I assume that customer master is on transactional level and customer id is bill-to partner function.In that case How to identify the ship-to address in both customer master and billing document?

Suppose we have such case(it is very common in best practice)

Invoice CustomerID(bill-to) bill-to address ship-to ID ship to address

123 A A-001 B B-001

124 A A-001 C C-001

We have customer id u201CAu201D, but we are not able to know that we should put u201CB-001u201D or u201CC-001u201D as our ship to address in customer master.

Could you please advise.

Amy

[Shiva_Ram · Accepted solution]

How to identify the ship-to address in both customer master and billing document?

To find ship-to number in the customer master, use table KNVP and from billing document use table VBPA.In the output the partner function WE represents the ship-to number. From these tables, get the address numbers (field ADRNR) for WE partner function and pass in table ADRC to find the address details.

Regards,