Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Help reqd to display the addresses from ADRC table thru MT001W

Hi abappers,

i want to print the Delivery address with all name street& my PO form...the name of the Delivery(as in PO:me23n) is available in the <b>MT001W</b> table (DB view)...but the corresponding fields for addresses are available in <b>ADRC</b> displaying the name field from MT001W...

how can i match the table fields thru primary key to join the two tables of MT001W and ADRC....

FYI (coding)


select name2 from MT001w into g_name2 where WERKS = g_xekpo-werks.


if sy-subrc = 0.

*move g_name2 to g_add.


select house_num1 street post_code1 from adrc into (g_house , g_street , g_pcode)

where name2 = g_name2 and langu = 'E'.




it displaying the field text of g_name2 but not diplaying the field records from ADRC.....

Pls do the needful to solve my issue...

thanks & regards


Former Member
Not what you were looking for? View more on this topic or Ask a question