Address tables

[former_member208541]

hi,

what are customer address tables in SAP SD.

regards

sachin

[Former Member · Accepted solution]

Hi

You can find in

KNA1 General Data

You can find the tables in <b>OBD2</b>

Select the a/c group(Sold to Party)Double click on General Data--> Click on Address button

In Menu Goto >Extras>Field Check-->With Technical Name You can find the table info in detail

Message was edited by:

SHESAGIRI.G

[former_member208541 · Accepted solution]

hi,

thanks for the reply but what for ADDR table is used.

regards

sachin

[Former Member · Accepted solution]

ADDR is structure it's not a table,so we cannot directly fetch the value from this.

Regards,

Chandra

[Former Member]

ADRC table. KNA1-ADRNR gives the address number and using this in ADRC-ADDRNUMBER (address no) field all details of customer address can be retrieved.

KNA1 is also useful, but it do not store all the complete address. (like street 2 , street 3 )

[Former Member]

Use table ADRC for complete address of customer master...

thanks

Inder

[Former Member]

Hi,

If i understood correctly,

Customer address data you can get it from table KNA1.

And if you want to see the address at transaction level,you can check it through OV50,here there is one column called address,there you get address data.

Reward if it helful.

Regards,

Chandra

[Former Member]

in kna1 table check fields name1,name2,ort01,pstlz

[former_member208541]

hi,

thanks for the reply but what for ADDR table is used.

regards

sachin

[Former Member]

Hi,

KNA1 is the table which has address of the customer.

Reward points if helpful.

Regards,

Sreekanth

[former_member208541]

hi,

thanks for the reply but what for ADDR table is used.

regards

sachin

[Former Member]

Hi sachin,

ADDR is a structure and not a table. What exactly is your requirement ?

Regards,

Sreekanth

[rajesh_chavan]

Hi,

Kna1 contains address fields and ADDR1_DATA is a structure for address...use Tcode se11 and put above names in database table field...and enter..it will show you the results...

Rewards if this helps....

cheers,

RC