Skip to Content
avatar image
Former Member

Extract customer master partner functions.

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    Mar 09, 2012 at 04:57 PM

    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,

    Add comment
    10|10000 characters needed characters exceeded