topic ADRC table in Application Development and Automation Discussions

ADRC table

Former Member — Fri, 07 Dec 2007 12:00:17 GMT

Hi all

How to find sold to name and partner name from ADRC table using table VBAK,VBAP, VBPA....

Points will be rewarded.

Thanks,

Mani.

Former Member — Fri, 07 Dec 2007 12:03:55 GMT

hi,

u need to find kunnr from VBAK,

ADRNR from KNA1 according that kunnr,

And NAME1 from ADRC according to that ADRNR which is ADDRNUMBER in ADRC

what is field name of partner name?

Reward if useful

Message was edited by:

Dhwani shah

former_member188829 — Fri, 07 Dec 2007 12:05:10 GMT

Hi,

Take Customer Number(Kunnr) From VBAK...And Substitute this value in KNA1..

For Getting ADRNR...And give this Value In ADRC Table of ADDRNUMBER..Then u will get the address..

Former Member — Fri, 07 Dec 2007 12:07:25 GMT

hi,

Get the partner type from VBPA table based on the sales document number from VBAK or VBAP.

BAsed on KUNNR from VBPA fetch the partner name from KNA1 table.

From tables KNVP you will get partner no, partner type, from TPAR you can get partner description, from table KNA1 you will get partner name.

Reward points if found helpful...

Cheers,

Chandra Sekhar.