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 table...so 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.

endselect.

if sy-subrc = 0.

*move g_name2 to g_add.

*endif.

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

where name2 = g_name2 and langu = 'E'.

endselect.

*if

*move g_street to i_street.

endif.

*******************

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

thanks & regards

sankar.

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