Hello Folks,
I have 0CUSTOMER_ATTR to which i've appended 4 zfields which corresponds to 4 fields from 3 tables. I need to write the ABAP code for enhancement. The question is "What is the syntax for a single Select statement to choose fields from Multiple tables"
for ex.
select single * from knvv,knvp,knvb1 where kunn2 = s_tab-kunnr and knvv-kunnr = s_tab-kunnr and knvp-kunnr = s_tab-kunnr and knb1-kunnr = s_tab-kunnr
what will be the equivalent of the above in ABAP. Is this feasible? or would it be better to use views and then load the data?
I would appreciate your response!