Skip to Content
Former Member
Mar 19, 2007 at 09:22 PM

select with join


<b>I have itab structure</b>

data: begin of itab3 occurs 0,

adrnr like adrc-addrnumber,

name1 like adrc-name1,

address1 like adrc-street,

address2 like adrc-str_suppl1,

city like adrc-city1,

state like adrc-region,

zip like adrc-post_code1,

country like t005t-landx,

countrycode like adrc-country,

telnum like adrc-tel_number,

end of itab3,

wa_itab3 like itab3.

I want to select the records and put them into the itab3. But as you can see I have adrc and t005t tables and they are joined on adrc-country = t005t-land1

I want to do something like this

select addrnumber name1 street str_suppl1 city1 region post_code1 country countrycode tel_number from adrc into table itab3