topic Re: Performance issue: table used twice for select statements in Application Development and Automation Discussions

Performance issue: table used twice for select statements

Former Member — Thu, 21 Jun 2012 07:40:06 GMT

This anlage table used two time how can use only one time can you guys assist me plz.

SELECT anlage sparte vstelle anlart
           FROM eanl
           INTO TABLE gt_eanl
            FOR ALL ENTRIES IN gt_ever
            WHERE anlage = gt_ever-anlage.
    SORT gt_eanl BY anlage.

    IF gt_eanl[] IS NOT INITIAL.

   SELECT a~anlage a~sparte b~operand b~betrag b~bis FROM
             eanl AS a INNER JOIN ettifn AS b
             ON a~anlage = b~anlage
             INTO TABLE gt_ettifn
             FOR ALL ENTRIES IN gt_eanl
             WHERE a~anlage = gt_eanl-anlage
             AND b~operand EQ 'YVMAKVAL'
             AND a~sparte EQ '07'.

Re: Performance issue: table used twice for select statements

Former Member — Thu, 21 Jun 2012 07:57:47 GMT

Hi,

I don't see the necessity to perform the selection by the first request. Simply use the second one:

IF gt_ever[] IS NOT INITIAL.

   SELECT a~anlage a~sparte b~operand b~betrag b~bis FROM
             eanl AS a INNER JOIN ettifn AS b
             ON a~anlage = b~anlage
             INTO TABLE gt_ettifn
             FOR ALL ENTRIES IN gt_ever
             WHERE a~anlage = gt_ever-anlage
             AND b~operand EQ 'YVMAKVAL'
             AND a~sparte EQ '07'.

ENDIF.

Re: Performance issue: table used twice for select statements

Former Member — Thu, 21 Jun 2012 08:36:48 GMT

hi thanks for your response but it's not working in the report some fields are missing.

Re: Performance issue: table used twice for select statements

yuri_ziryukin — Thu, 21 Jun 2012 09:16:20 GMT

Well, ofc. you have to modify a little more and make sure that fields "vstelle", "anlart" are also selected from EANL table and populated to the corresponding fields in the output structure of the report.

Re: Performance issue: table used twice for select statements

Former Member — Thu, 21 Jun 2012 09:36:25 GMT

The performance issue could be because of the condition

AND a~sparte EQ '07'.

try removing the condition and see if it is making any difference.

i.e. Remove the condition from select query, fetch all the data in internal table and the delete the unwanted data from internal table so that you have correct data without any performance issues.