Have an abap query. Although only 40K records in SKAT program utilizes 100%cpu and takes a long time.
Any suggestions would be greatly appreciated.
SELECT
T_00 . "KTOPL" , T_00 . "MANDT" , T_00 . "SAKNR" , T_00 . "TXT20" , T_00 . "TXT50" ,
T_01 . "BILKT" , T_01 . "GVTYP" , T_01 . "KTOKS" , T_01 . "KTOPL" , T_01 . "SAKNR" ,
T_01 . "XBILK" , T_02 . "BEGRU" , T_02 . "BUKRS" , T_02 . "ERDAT" , T_02 . "FSTAG" ,
T_02 . "MITKZ" , T_02 . "MWSKZ" , T_02 . "SAKNR" , T_02 . "WAERS" , T_02 . "XKRES" ,
T_02 . "XMWNO" , T_02 . "XOPVW" , T_02 . "XSALH" , T_02 . "ZUAWA"
FROM
"SKAT" T_00 INNER JOIN "SKA1" T_01 ON T_01 . "MANDT" = :A0 AND T_01 . "KTOPL" = T_00 . "KTOPL" AND
T_01 . "SAKNR" = T_00 . "SAKNR" INNER JOIN "SKB1" T_02 ON T_02 . "MANDT" = :A1 AND T_02 . "SAKNR"
= T_00 . "SAKNR"
WHERE
T_00 . "MANDT" = :A2 AND T_00 . "KTOPL" = :A3 AND T_02 . "BUKRS" BETWEEN :A4 AND :A5 AND T_02 .
"ERDAT" BETWEEN :A6 AND :A7#