Skip to Content

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

Help reqd to join the table of ADRC and MT001W tables

Hi all,

im working on PO and i need to display the delivery addresses where the records are available in these two tables.

I want to join the pls tell me which primary field key will work out for this...i've taken the record of name field from MT001W table but while i joining with ADRC table thru name2 = g_name2...its not getting printed.

****i've moved the MT001W-name2 to the variable g_name2.

****but when im matching the record with ADRC...its not coming..pls go thru the code once b4 reply.


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'.



*move g_street to i_street.



pls do the needful and reply ur comments on urgent basis.

thanks & regards


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