Help reqd to join the table of ADRC and MT001W tables

[Former Member]

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]

Actually MT001W is not a table, it is a table based on ADRC and T001W.

so we can not joing MT001W and ADRC

U try use inner join between ADRC and T001W

[Former Member]

hi Madhavi t ,

thanks a lot man....

i've done it....

thansk & regards

sankar.

,

[Former Member]

THANKS

DONE IT WITH TABLE T001W

REGARDS

SANKAR