joining 5 tables

[Former Member]

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

[Former Member]

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

[Former Member]

Hi..

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

Message was edited by:

Dhananjay Patil

[seshatalpasai_madala]

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 <b>INNER JOIN</b> TABLE2 ON TABLE1_{FLD1 = <b>TABLE2}FLD1<b> INNER JOIN</b> TABLE3 ON TABLE2_{FLD2 = TABLE3}FLD2 INNER JOIN</b> TABL4 ON TABLE3_{FLD3 = TABLE4}FLD3 <b>INNER JOIN</b> TABLE5 ON TABLE4_{FLD4 = TABLE5}FLD5 WHERE FLD1 = 'AA'.

Regards,

Sesh

[Former Member]

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

[suredarreddy_pulimamidi]

hi ravi,

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

[Former Member]

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**