08-11-2008 1:58 PM
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
08-11-2008 6:26 PM
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
08-11-2008 2:01 PM
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
08-11-2008 2:01 PM
Hi..
We are having KNA1 table with address fields..
Thanks,
Naveen.I
08-11-2008 2:02 PM
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
08-11-2008 2:03 PM
<removed_by_moderator>
Please read the rules.
Edited by: Julius Bussche on Aug 11, 2008 1:33 PM
08-11-2008 2:04 PM
ok, thank u.
And the other question?
Is this information in other tables than this tables? In some delivery table?
Thank u
08-11-2008 2:07 PM
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
08-11-2008 2:23 PM
If you know the address number (ADRNR) of the delivery address
use it to fetch from the ADRC table..
Hope this helps
08-11-2008 6:26 PM
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