Skip to Content
0
Former Member
Jul 18, 2008 at 01:37 PM

Taking too much time

36 Views

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,