on 11-01-2007 7:55 AM
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
Hi ,
please check the table ADRC in se16.
Regards
Aasif
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
86 | |
7 | |
6 | |
4 | |
3 | |
3 | |
3 | |
3 | |
3 | |
2 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.