topic Re: Using nested Joins in abap prog in Application Development and Automation Discussions

Using nested Joins in abap prog

Former Member — Fri, 14 Nov 2008 09:25:09 GMT

Hi All,

please help me out in using nested joins in abap progrmaming. I dont know about joins in abap.specially in case of outer join.

I have 5 internal tables.. mara ,marc, mvke,mbew,ampl. am using a select query with certain fields from all these tables.

I need to disply all the materials of a mara for a particular date irrespective of the values in fields of other tables.

Even if that materail is not present in other table for certain condtion ,that material should get displyed with all other fields showing null value..

Re: Using nested Joins in abap prog

Former Member — Fri, 14 Nov 2008 09:29:45 GMT

Hi,

Use for all entries rather joins.

Tks,

Krishna..

Re: Using nested Joins in abap prog

Former Member — Fri, 14 Nov 2008 09:30:07 GMT

HI Suruti

Write Join in any report and press f1 on it. You will get the detail and Syntax.

Regards

Aditya

Re: Using nested Joins in abap prog

Former Member — Fri, 14 Nov 2008 09:30:58 GMT

hi,

Its better not to use joins for 5 tables.

try for all entries.

rgds,

Re: Using nested Joins in abap prog

rthoodi — Fri, 14 Nov 2008 09:34:50 GMT

Hi,

for better performance try for all entries like this.

select matnr

from mara

into table it_mara

where matnr in s_matnr.

if not it_mara is initial..

select matnr

werks

from marc

into table it_marc

for all entries in it_mara

where matnr EQ it_mara-matnr.

endif.

Thanks

Edited by: RK on Nov 14, 2008 10:35 AM

Re: Using nested Joins in abap prog

arjun_subhash — Fri, 14 Nov 2008 10:40:28 GMT

Hi,

I think a better option is to create a view of all 5 tables in DDIC.

You can use the view in se38 to create internal tables just like you do using tables.

thanks nd regards

Arjun

Re: Using nested Joins in abap prog

Former Member — Fri, 14 Nov 2008 10:59:30 GMT

Hi RK,

the code am using is of the same way...but my problem was with the joins..in the select query am using nested join combining inner and outer join.. but i could not able to display all the materials of mara of a particular date..

The code looks like this..

SELECT <some fields.......>

INTO TABLE i_materials

FROM ( marc AS b

INNER JOIN mara AS a ON a_{matnr = b}matnr

INNER JOIN mvke AS c ON c_{matnr = a}matnr

INNER JOIN ampl AS g ON g_{bmatn = a}matnr

LEFT OUTER JOIN mbew AS d ON d_{matnr = b}matnr

AND d_{bwkey = b}werks )

WHERE a~matnr IN s_matnr AND .................

Else

SELECT <some fields.......>

INTO TABLE i_materials

FROM ( marc AS b

INNER JOIN mara AS a ON a_{matnr = b}matnr

INNER JOIN mvke AS c ON c_{matnr = a}matnr

INNER JOIN ampl AS g ON g_{bmatn = a}matnr

LEFT OUTER JOIN mbew AS d ON d_{matnr = b}matnr

AND d_{bwkey = b}werks )

FOR ALL ENTRIES IN i_mara

WHERE a~matnr = i_mara-matnr AND ............