Skip to Content
0
Former Member
Apr 02, 2010 at 10:15 AM

Lack Performance when select from GLPCA

229 Views

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