cancel
Showing results for 
Search instead for 
Did you mean: 

Delivery Address in ME23n (PO)

Former Member
0 Kudos

Hi Friends,

I need to find the table where the delivery address gets stored, when delivery address is entered manually in the delivery address field while creating the PO.

Thanks in advance.

Regards,

Prabhu

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi ,

please check the table ADRC in se16.

Regards

Aasif

Answers (2)

Answers (2)

Former Member
0 Kudos

Delivery address is a text field & hence wont be stored in table.

ir will be available in the structure ADDR1_DATA

pl try it under se11

reward if found useful

Former Member
0 Kudos

Hi

In this code you will get the address no. for the manually entered address in PO.

With that address no. fetch the data from ADRC table..

DATA ls_cmmda TYPE cmmda.

DATA ls_cmmda2 TYPE cmmda.

DATA ls_ekpo TYPE ekpo.

data im_ebeln like ekpo-ebeln value '4500000005'.

data im_ebelp like ekpo-ebelp value 00010.

DATA lt_cmmda TYPE TABLE OF cmmda.

REFRESH lt_cmmda.

  • Select the PO Item data (all fields need to be selected here!)

CLEAR ls_ekpo.

SELECT SINGLE * INTO ls_ekpo FROM ekpo

WHERE ebeln = im_ebeln

AND ebelp = im_ebelp.

  • Populate the relevant global parameters from the

  • function group MMDA

REFRESH lt_cmmda.

CLEAR ls_cmmda.

MOVE-CORRESPONDING ls_ekpo TO ls_cmmda.

APPEND ls_cmmda TO lt_cmmda.

CALL FUNCTION 'MM_DELIVERY_ADDRESS_INIT'

  • EXPORTING

  • IM_NO_REFRESH = ' '

TABLES

it_cmmda = lt_cmmda

.

  • Get the address number and/or more details required to

  • determine the delivery address

CALL FUNCTION 'MM_DELIVERY_ADDRESS_FOR_BAPI'

EXPORTING

im_ebeln = im_ebeln

im_ebelp = im_ebelp

IMPORTING

ex_cmmda = ls_cmmda2.

write: ls_cmmda2-adrnr,

ls_cmmda2-werks,

ls_cmmda2-emlif.

Thanks your replies...

Regards

Prabhu

Former Member
0 Kudos

Hi Prahbu,

The delivery address field in PO is stored in table ADDR1_DATA

check the table and field through T.code SE11

Regards

Madasamy.R