Hi All,
I am using this select statement in my report, this is taking too much time to pick the data. BSAK table contains huge data.
please modify this statement.
SELECT BUKRS LIFNR ZUONR BELNR BUDAT BLDAT
XBLNR SHKZG DMBTR HKONT
INTO TABLE I_BSAK FROM BSAK
WHERE BUKRS = CO_CODE-LOW
AND UMSKS = 'A' AND UMSKZ IN SPEC_GL AND
AUGDT > ASOFDATE AND BUDAT <= ASOFDATE.
Thanks,