topic Re: joining 5 tables in Application Development and Automation Discussions

joining 5 tables

Former Member — Tue, 28 Aug 2007 13:24:16 GMT

anybody tell how to join 5 tables .....if u have coding plz send me ........

Re: joining 5 tables

Former Member — Tue, 28 Aug 2007 13:26:42 GMT

Hi..

Joining 5 tables will give performance issue...if u r very sure then only go ahead..

Message was edited by:

Dhananjay Patil

Re: joining 5 tables

seshatalpasai_madala — Tue, 28 Aug 2007 13:29:25 GMT

Hi,

Why dont you create Views and then use the view in your SELECT query.

Generic example of JOINING 5 tables

SELECT FLD1 FLD2 FLD3 FLD4 FLD5 INTO CORRESPONDING FIELDS OF TABLE ITAB FROM TABLE1 INNER JOIN TABLE2 ON TABLE1_{FLD1 = TABLE2}FLD1 INNER JOIN TABLE3 ON TABLE2_{FLD2 = TABLE3}FLD2 INNER JOIN TABL4 ON TABLE3_{FLD3 = TABLE4}FLD3 INNER JOIN TABLE5 ON TABLE4_{FLD4 = TABLE5}FLD5 WHERE FLD1 = 'AA'.

Regards,

Sesh

Re: joining 5 tables

Former Member — Tue, 28 Aug 2007 13:57:48 GMT

HI,

There is no difference in joining 2 tables are 5 tables.. the systax goes like this.

select table1_{field table2}field table3~field..... from table1

join table2 on table1_{field = table2}field

join table3 on table2_{field = table3}field........

where <your condiation> ex... table~field in s_field..

Thanks

Mahesh

Re: joining 5 tables

suredarreddy_pulimamidi — Tue, 28 Aug 2007 17:04:47 GMT

hi ravi,

SAP limited joining of 3 tables maximum,and also avoid using joining fro that use for all entries.

Re: joining 5 tables

Former Member — Tue, 28 Aug 2007 17:13:38 GMT

Hi Ravi,

Dont use joins on five tables, it will impact the performence very badly.. instead use FOR ALL ENTRIES..

Proceed as follows:

SELECT xxxx

FROM xxxx

INTO tab1

WHERE selection condtions.

IF sy-subrc EQ 0

AND NOT tab1[] IS INITIAl.

SELECT yyyy

FROM yyyy

INTO tab2

FOR ALL ENTRIES IN tab1

WHERE xxx EQ tab1-xxx.

and so on.. for all the 5 tables..

Thanks and Best Regards,

Vikas Bittera.

**Points for useful answers**