cancel
Showing results for 
Search instead for 
Did you mean: 

PO Delivery address table

bhushan_bivalkar
Participant
0 Kudos
23,568

Hi ..

In PO item details there is a tab Delivery Address where this data is getting stored when I create the PO

I want a table in which this data is stored with reference to PO number . I checke EKKO and EKPO both the tables but I didnt get data in this tab . Also where Account assignment data is stored ?

Please reply ASAP

Accepted Solutions (1)

Accepted Solutions (1)

Former Member

Hi,

You can find the delivery address in two ways-

Case 1:

NO storage location is entered in PO item overview.In this case,ADRN2 field(Table EKPO) will be blank and address of plant will act as delivery address.Just get the value of ADRN fied in T001W table and get the address in ADRC table w.ref to ADRN value.

Case 2:

Storage Location is entered in PO.In this case,Storage location's first address will act as delivery address.Get the value of ADRN2 field in Table EKPO,then take it as ref in ADRC table and get the address.

Hope it helps...

regards,

vineet

Answers (6)

Answers (6)

Former Member
0 Kudos

Hi

Delievry address of the PO, u can check it in T001w and ADRC.

Regards,

Raman

bhushan_bivalkar
Participant
0 Kudos

Also in ADRC there is no reference of Po Please try to understand the question first and then only reply .

I have clearly written what I expect exact;y and please do not misguide . I have checked all these options earlier

former_member182609
Active Contributor
0 Kudos

You will not get PO delivery address from directly table

In EKPO table with reference to PO you will get delivery address number XXXX (ADRN2 Field)

With this number you can view address details in ADRC table.

Hope this would help.

Former Member
0 Kudos

Please check EKKN table

bhushan_bivalkar
Participant
0 Kudos

No address related info is not satsfactory ..

If I change delivery address while creating the PO and I want to pull the data in PO Printout as a delivery location , where this data is stored with reference to PO number .

In the table T001w there is no field for PO number EBELN

Hope you understand

Former Member
0 Kudos

Hi,

These details are picked from vendor master table LFA1.

Regards

Former Member
0 Kudos

Delivery address in picked from table where Plant address is Stored.

The system stores the plant address in T001W table

Use EKKN Table to check account assignment in the PO line item

former_member581212
Active Contributor
0 Kudos

hi,

This data is pulled from the vendor details via a structure...so you shd check it in LFA1 table other than PO tables...

Hope your problem is solved..

Regards

Priyanka.P

Former Member
0 Kudos

Hi

Account assignement for PO is getting stored in EKKN.

Hope this will do

Regards,

Raman