topic Re: SD partner name in Application Development and Automation Discussions

SD partner name

Former Member — Thu, 09 Mar 2006 02:07:23 GMT

Hi experts,

I want to findout the table for partner name where it getting stored.

va02-click on "Display doc.header details" icon(beside PO date),Click partners tab,there you can see "NAME" field for parters.

Just iam looking for <b>table</b> for Parter names...

Thanks

kaki

Re: SD partner name

Former Member — Thu, 09 Mar 2006 02:22:26 GMT

Not sure of the question - Which partner are you interested in? All of the partners attached to the sales order will be displayed uisng the screen navigation that you mentioned. What else are you looking to find?

Re: SD partner name

former_member186741 — Thu, 09 Mar 2006 02:27:03 GMT

you need to join the VBPA table with KNA1 to get the name,

something like this:

SELECT SINGLE kna1~name1

from vbak

JOIN vbpa ON vbpa_{vbeln = vbak}vbeln

AND vbpa~posnr = '00000'

JOIN kna1 ON kna1_{kunnr = vbpa}kunnr

INTO KNA1-NAME1

where vbak~vbeln = ???

and vbpa~parvw = ??.

Message was edited by: Neil Woodruff

Re: SD partner name

Former Member — Thu, 09 Mar 2006 02:35:40 GMT

Hi experts,

I found in KNVK table..

Thanks for all the replies..

cheers

kaki

Re: SD partner name

former_member186741 — Thu, 09 Mar 2006 02:52:47 GMT

Kaki, I don't think KNVK is the correct table for partners relating to speciific sales docs, eg VA02. I think you need VBPA.

Re: SD partner name

Former Member — Thu, 09 Mar 2006 03:03:34 GMT

KNVK is "true" customer master. If you are looking for the partner info about a particular sales order, you MUST start in VBPA - SALES ORDER PARTNER table.