topic performanance issue in Application Development and Automation Discussions

performanance issue

Former Member — Mon, 25 Aug 2008 09:16:26 GMT

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

Re: performanance issue

ThomasZloch — Mon, 25 Aug 2008 09:20:59 GMT

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

Re: performanance issue

Former Member — Mon, 25 Aug 2008 09:24:09 GMT

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

Re: performanance issue

Former Member — Mon, 25 Aug 2008 09:29:14 GMT

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.

Re: performanance issue

Former Member — Mon, 25 Aug 2008 09:31:23 GMT

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