ADRC table

[Former Member]

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]

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]

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]

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.