Hi Experts,
I have the following select statement from table GLPCA.
SELECT RLDNR RRCTY RVERS RYEAR RTCUR DRCRK
RBUKRS RPRCTR KOKRS RACCT TSL HSL
INTO TABLE GT_GLPCA
FROM GLPCA CLIENT SPECIFIED
WHERE RCLNT EQ SY-MANDT
AND RLDNR EQ CC_C8A
AND RRCTY IN S_RRCTY
AND RVERS IN S_RVERS
AND RYEAR EQ JAHR
AND POPER EQ MONAT
AND RBUKRS EQ SKB1-BUKRS
AND KOKRS EQ CC_CUOBM
AND RACCT EQ SKB1-SAKNR
AND HSL NE '0'
AND TSL NE '0'
AND BUDAT IN S_BUDAT1.
However, this select query took really long time to retrieving the data for only 1 GL account.
I don't have key GL_SIRID at this point.
May I know is there any way I can enhance the performance?
===================================
Please assume data as below:
CC_C8A is constant '8A'.
S_RRCTY is '0'.
S_RVERS is '0'
JAHR is '2009'
MONAT is '12'
SKB1-BUKRS and SKB1-SAKNR are taking from logical database GET SKB1 (only 1 GL).
CC_CUOBM is constant 'UOBM'
S_BUDAT1 is from 01.12.2009 to 20.12.2009
===================================
Hope someone may help! Thank you very much!!
Regards,
Darren