ABAP code for enhancement from multiple tables

[Former Member]

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!

[Former Member]

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!

[Former Member]

You can do this usign the concept of Joins. Using Joins you can read data from multiple tables in a single shot.

- Guru

[Former Member]

You can use inner joins

http://www.sap-img.com/abap/inner-joins.htm

Regards

Kathirvel