Having performance issue in the query

[former_member150968]

Hi All,

We are facing performance issue with below query, Is there any way we can improve below query.

SELECT aufk~aufnr
           aufk~ktext
           aufk~objnr
           jest~inact
      FROM aufk
     INNER JOIN jest ON aufk~mandt EQ jest~mandt
       AND aufk~objnr EQ jest~objnr
      INTO TABLE ts_aufk_jest
        UP TO c_100 ROWS
     WHERE aufnr   LIKE  w_aufnr
       AND aufk~bukrs EQ us_BUKRS
       AND ( aufk~phas0 EQ c_x
        OR aufk~phas1 EQ c_x )
       AND aufk~phas3 NE c_x
       AND aufk~loekz EQ space
       AND jest~stat  EQ c_stat.

Regards,

Manish Sethia

[former_member150968]

Hi All,

We are facing performance issue with below query, Is there any way we can improve below query.

SELECT aufk~aufnr
           aufk~ktext
           aufk~objnr
           jest~inact
      FROM aufk
     INNER JOIN jest ON aufk~mandt EQ jest~mandt
       AND aufk~objnr EQ jest~objnr
      INTO TABLE ts_aufk_jest
        UP TO c_100 ROWS
     WHERE aufnr   LIKE  w_aufnr
       AND aufk~bukrs EQ us_BUKRS
       AND ( aufk~phas0 EQ c_x
        OR aufk~phas1 EQ c_x )
       AND aufk~phas3 NE c_x
       AND aufk~loekz EQ space
       AND jest~stat  EQ c_stat.

Regards,

Manish Sethia

[kesavadas_thekkillath]

Read this blog before posting your question. Post it in the correct forum with more details

http://scn.sap.com/community/abap/testing-and-troubleshooting/blog/2012/04/02/the-quality-of-an-answ...

[Former Member]

Moderator message - Duplicate locked.

Rob