I want to find out the fields and the corresponding table for the delivery address in a PO (line item details). It is the address of the plant. I searched the tables ADRNR, ADRN2 and one customized field (/GLB/Ship_to) in the table EKPO, but of no help. I can find out from other tables the address of the plant, but I want to go to a table for PO, where I can have the delivery address/ship to address.
For Plant Address, check the table T001W
If you want complete address details, take the ADRNR field value from T001W and pass it to the field ADDRNUMBER of table ADRC, you will get the details.
Normally addresses are stored in the table ADRC. If you gave any other Delivery Address in the PO, instead of Plant, get the value of ADRN2 from EKPO and pass it to ADDRNUMBER of ADRC and you will get the address detials.
Edited by: Arun R on Dec 17, 2010 2:39 PM
For PO delivery address, just update the Plant or Sloc address in Customising.
The address is fetched in real time from T001W and T001L. Take ADRNR field from these tables.
However, if the adress is entered or changed manually, then EKPO-ADRNR is updated with an address number.
In both cases use ADRNR value in the following tables to get the address: ADRC, ADR6.
The ADRNR Field in EKPO contains the Address Number , this number should be Passed to ADRC Table to get address details.
However, the Delivery Address in PO Item , is always by default the Plant Address, and so unless you Change the Address at Item level, the EKPO-ADRNR field will be BLANK .
It is updated only after the address is changed in the PO Item.