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 · Accepted solution]

Hi,

If you want to fetch the data from Master data KNVP and KNA1 will help you.

If you want to fetch the data from transactions :

EX: for a given sales order if you want to fetch all the parters information

Goto VBPA, take the Partner type (WE, AG etc) and then goto KNA1 and KNVP tale with the number to fetch the address.

If you just ant the numbers from VBPA, directly you can get these numbers.

Regards

Krishnam Raju

[Lakshmipathi]

Dear Anusha

You can consider Tables KNVP (to get partner functions) and KNA1 (to get address)

thanks

G. Lakshmipathi

[Former Member]

go to T Code SE16N - Table / View name KNA1VV...execute.

[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