how to get sold to party address number for particular contract no.

[Former Member]

Hi All,

I am creating an smartform on which address of customer needs to be printed.

I have only contract numbers. I know ADRC has the address details, how can relate tables to get the customer address for particular contract no.

[Former Member · Accepted solution]

Hi Suman,

1) Goto VBAK table and give your contract number to VBELN and get the customer number KUNNR from VBAK.

2) Give this customer number to KNA1(Customer master table) KUNNR and get the address number ADRNR.

3) Use this ADRNR and query on ADRC to get the address (or) use function moudle ADDR_GET to get the address for an address number(ADRNR)..

Thanks,

Vinay

[Former Member]

Pass your document number in VBPA. Get the corresponding ADRNR field.

This is the key in ADRC. Fetch the address details with this key!

All the best!!

Ashutosh

[Former Member]

You can get the details from VBPA table.

reward points if helpfull

regards

Biju

[Former Member]

From The VBPA table you can get the address number and then use the ADRC table to get the address

regards

Biju