performanance issue

[Former Member]

Dear All,

I am extracting data from three tables EKKO, EKPO, LFA1

now for table ekko and lfa1 i am using inner join and putting data to itab

and from table ekpo i am using for all entries in itab

will it affect performance using above (i.e. both inner join and for all entries together )

\[removed by moderator\]

Regards

Sagar

Edited by: Jan Stallkamp on Aug 25, 2008 4:36 PM

[Former Member]

1.First select the enteries fromm ekko

2.Then ekpo by using for all entries.

3.LFA1 use read statement.

it will improve the performance

[ThomasZloch]

why don't you join all three of them in one go? Don't believe the "use for all entries" hype. Use correct ON and WHERE conditions that narrow down your result set, and you should be fine.

Thomas

[Former Member]

1.First select the enteries fromm ekko

2.Then ekpo by using for all entries.

3.LFA1 use read statement.

it will improve the performance

[Former Member]

A better idea is to go for the database view WB2_V_EKKO_EKPO2 to get master and item data in EKKO and EKPO. I guess you are hitting LFA1 to fetch Vendor details. Use a select endselect for fetching data from the view and from within that fetch the Vendor details from LFA1.

SELECT 
   FROM  wb2_v_ekko_ekpo2
     INTO

     PERFORM fetch_vendor_details.
     PERFORM fill_output_table.

ENDSELECT.

FORM fetch_vendor_details.
 
   Fetch vendor details based on the vendor number picked from the above select.

ENDFORM.

FORM fill_ouput_table.

   Append the fetched data to an internal table

ENDFORM.

[Former Member]

well for all entries on a database table forces a full table scan so it is NOT really performing any good.

better try to have a join over all your three tables.

Edited by: Florian Kemmer on Aug 25, 2008 11:31 AM