Skip to Content
0
Former Member
Nov 08, 2006 at 11:39 AM

Query Optimisation

27 Views

Please Help optimize the following query.

SELECT HKONT GSBER BUKRS AUGDT BUDAT SHKZG

DMBTR WAERS AUGBL ZUONR GJAHR BELNR BUZEI

INTO TABLE T_BSIS_TEMP

FROM BSIS

FOR ALL ENTRIES IN T_SKB1

WHERE BUKRS EQ T_SKB1-BUKRS

AND HKONT EQ T_SKB1-SAKNR

AND BUDAT LE P_BUDAT.

IF SY-SUBRC = 0.

DELETE T_BSIS WHERE NOT GSBER IN S_GSBER.

T_BSIS[] = T_BSIS_TEMP[].

SORT T_BSIS BY BUKRS HKONT GSBER.

ENDIF.

Thanking you.