Inner join

[Former Member]

Hi all

Can any one tell me how many inner join that we can maximum use in single select query...

My requirement is i have to fetch data's from nearly 12 data base tables..

And can any one suggest me the optimum use of inner joins..

please its urgent..

Thanks and Regards,

Arun

[Former Member]

hi Joseph,

Use FOR ALL ENTRIES statement instead of innerjoins ... Joining 12 tables will definitely will create a lot of impact on performance ..

Regards,

Santosh

[Former Member]

Hi santhosh

But my requirment is i have to retieve entries from 12 database tables...can you suggest me some thins briefly so that i can move according to that..

[Former Member]

hi,

If you still want to make use of joins then you can go ahead joining them ...

Regards,

Santosh

[Former Member]

Hi

This is my requirement..can u please provide me example for this requirment.

selection screen has got ebeln,bsart,bedat,bukrs,lifnr.

1. Based on the selection screen values, get the PO number(EBELN),

Vendor(LIFNR), Company Code(BUKRS), PO currency(WAERS) from EKKO.

2. If Deletion Indicator = u2018Xu2019.

Pass PO number in EKPO table and get the item details EKPO-EBELN, EKPO-EBELP,

EKPO-MATNR, EKPO-NETPR, EKPO-NETWR.

Else.

Pass PO number and EKPO- LOEKZ = space in EKPO table and get the item details EKPO-

EBELN, EKPO-EBELP, EKPO-MATNR, EKPO-NETPR, EKPO-NETWR.

End If.

3. Pass PO number and item number in EKKN table to get the following:

EKKN-VBELN

EKKN-VBELP

Please suggest me with sample coding??

[Former Member]

hi,

First try to fetch the data from 12 database tables into 12 internal tables.

And then try to fetch the data using FOR ALL ENTRIES.

Regards

Sandeep Reddy