topic Re: ABAP SQL in Application Development and Automation Discussions

ABAP SQL

Former Member — Tue, 16 Mar 2010 12:39:39 GMT

Hello Experts,

can anyone please help me translate an Oracle select statement into ABAP, the main problem is reading from more than 4 tables in a single select query such as:

select t1.F1, t1.F2, t2.F3, t3.F4, t3.F5

from tabl1 t1, table2 t2, table3 t3, table4 t4

where t1.PK = t2.FK

and t1.PK = t3.FK

and t1.PK(+) = t2.FK

and t3.PK = t4.FK

and t4.F6 = 'VALUE'

where table1,2,3,4 are table names / F1,2,3,4 are table fields / left outer join / and 'VALUE' is any value passed to query / FK foreign key / PK primary key

note that table4 is used to setup the where clase and no fields are retrieved from it.

can this be translated into ABAP query? please help

Best Regards,

Re: ABAP SQL

vijaymanikandan — Tue, 16 Mar 2010 12:45:30 GMT

Hi,

There must a option like Bind variable in your screen. Are you running a SQL trace in ST05?

Regards,

Vijay V

Re: ABAP SQL

Former Member — Tue, 16 Mar 2010 12:48:41 GMT

It's shoul look something like this....

But not recommended to much...

select t1_{F1, t1}F2, t2_{F3, t3}F4, t3~F5

from tabl1 as t1 left outer join table2 as t2

on t1_{PK = t2}FK

inner join table3 as t3

on t1_{PK = t3}FK

inner join table4 as t4

on t3_{PK = t4}FK

where t4~F6 = 'VALUE'

Best Regards

Yossi Rozenberg

Re: ABAP SQL

Former Member — Tue, 16 Mar 2010 13:29:59 GMT

Actually I have a field that I should retrieve data to from different tables, so instead of making 3 or 4 queries I thought it is possible to write in my program a single query. but since this is not recommended I will try to get data from each table seperately.

Re: ABAP SQL

vijaymanikandan — Tue, 16 Mar 2010 13:33:27 GMT

Hi,

Try to use "for all entries" or you can find a suitable Function module that can meet your requirement. I think you can write a join upto 3 tables if the requirement is there.

Regards,

Vijay V

Re: ABAP SQL

Former Member — Tue, 16 Mar 2010 13:34:59 GMT

Samir

As far as i know you should avoid very complex joins (4 tables it's too much and not afficient but join of 2 tables for example it's more than welcome ( based on situation of course),but you can use all kinds of other tools like for all entries for example)

Best Regards

Yossi Rozenberg