Customer (shipt-to) adress in deliveries

[former_member582701]

Hello,

I need to know in what tables is the data of the adress of the customers (street, location, etc)

Also, I would need to know if this information exists in delivery tables or this information is only linked to the customer table/s (u can see all this data in vl03n in the right of the customer)

Thank you,

Manel

[Former Member]

Hi,

Goto table KNA1 get the ADDNR (Address number of a customer) then goto table ADDR and check the corresponding ADDNR record for your mentioned fields.

Rgds,

Bujji

[naveen_inuganti2]

Hi..

We are having KNA1 table with address fields..

Thanks,

Naveen.I

[Former Member]

Hi

Customer master records can be referred like KNA1 and take ADRNR (address number) and to go ADRC table for address number and get required address details.

BR

Lavanya

[Former Member]

<removed_by_moderator>

Please read the rules.

Edited by: Julius Bussche on Aug 11, 2008 1:33 PM

[former_member582701]

ok, thank u.

And the other question?

Is this information in other tables than this tables? In some delivery table?

Thank u

[naveen_inuganti2]

Hi..

Check these tables....

DVK01 R/2-R/3 Link: Delivery Header Data R2 -> R3

FTPT_PNR_ADDRESS PNR delivery / billing addresses

EKAN Vendor Address: Purchasing Document

Thanks,

Naveen.I

[Former Member]

If you know the address number (ADRNR) of the delivery address

use it to fetch from the ADRC table..

Hope this helps

[Former Member]

In case of drop Shipment, the delivery address will be different to ship-to address because of the manual changes to the address in the delivery. Read the address number from table VBPA and then ADRC. (If you are on older version read it from SADR).

Manoj