topic Re: Inner join in Application Development and Automation Discussions

Inner join

Former Member — Thu, 29 May 2008 15:38:54 GMT

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

Re: Inner join

Former Member — Thu, 29 May 2008 15:44:25 GMT

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

Re: Inner join

Former Member — Thu, 29 May 2008 15:53:41 GMT

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

Re: Inner join

Former Member — Thu, 29 May 2008 16:00:11 GMT

hi,

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

Regards,

Santosh

Re: Inner join

Former Member — Thu, 29 May 2008 16:08:24 GMT

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

Re: Inner join

Former Member — Thu, 29 May 2008 16:59:32 GMT

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