Skip to Content
0
Former Member
Dec 07, 2006 at 08:06 PM

ABAP code for enhancement from multiple tables

48 Views

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!