partner functions table pull and customer master table pull

[#1]

Hi SAP gurus,

I need to pull the Sold to party customer number, complete address(street address, city, State, country etc) and also the partner functions ( customer number and partner function type). Can anybody please help me with this.

Thanks

Anusha

[Former Member]

If you want to fetch the data of sold to of sales order try to get the details from VBPA with partner function AG - you can get the address number from VBPA and with address number you can check in ADRC to get all address details of customer.

If you want to get data of sold to from customer master try to get from KNVP with partner function AG.

Hope this meets your requirement.

[Former Member]

what about the details of the partner functions like ship to, payee etc ( details here mean their numbers)

Thanks

Anusha

[Former Member]

Hi,

You can use KNVP table to get the details of partners assigned to the Sold to party.

Hope this will help you

Venkat Cheedalla

[Former Member]

You can find ship -to, payer, bill-to from same KNVP & VBPA table with partner function SH for ship-to, BP for bill-to & PY for payer