Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Provide alternative select statements to improve performance

Hi Frnds

I want to improve the performance of my report. below statement is taking more time. Please provide any suggestions to include alternative statement for the below select statement.

SELECT H~CLMNO H~PNGUID P~PVGUID V~PNGUID AS V_PNGUID
           V~AKTIV V~KNUMV  P~POSNR  V~KATEG  AS ALTNUM   V~VERSN
         APPENDING CORRESPONDING FIELDS OF TABLE EX_WTYKEY_T
         FROM ( ( PNWTYH AS H
           INNER JOIN PNWTYV AS V ON V~HEADER_GUID   = H~PNGUID )
           INNER JOIN PVWTY  AS P ON P~VERSION_GUID  = V~PNGUID )
         FOR ALL ENTRIES IN lt_claim
        WHERE  H~PNGUID = lt_claim-pnguid
           AND V~AKTIV IN rt_AKTIV
           AND V~KATEG IN IM_ALTNUM_T.

Thanks

Amminesh.

Moderator message - Moved to the correct forum

Edited by: Rob Burbank on May 14, 2009 11:00 AM

Former Member
Not what you were looking for? View more on this topic or Ask a question