DATA: BEGIN OF IT_BSEGSA1 OCCURS 0,
RYEAR LIKE FAGLFLEXA-RYEAR,
BELNR LIKE FAGLFLEXA-DOCNR,
RBUKRS LIKE FAGLFLEXA-RBUKRS,
HKONT LIKE FAGLFLEXA-RACCT,
RBUSA LIKE FAGLFLEXA-RBUSA,
DMBTR LIKE FAGLFLEXA-TSL,
BSCHL LIKE FAGLFLEXA-BSCHL,
WERKS LIKE T001W-WERKS,
END OF IT_BSEGSA1.
R_ACCT-SIGN = 'I'.
R_ACCT-OPTION = 'EQ'.
R_ACCT-LOW = '0020895100' .
APPEND R_ACCT.
CLEAR R_ACCT.
R_ACCT-SIGN = 'I'.
R_ACCT-OPTION = 'EQ'.
R_ACCT-LOW = '0020895200' .
APPEND R_ACCT.
CLEAR R_ACCT.
R_ACCT-SIGN = 'I'.
R_ACCT-OPTION = 'EQ'.
R_ACCT-LOW = '0020895300' .
APPEND R_ACCT.
CLEAR R_ACCT.
IF NOT IT_FINALSA[] IS INITIAL.
SELECT RYEAR
DOCNR
RBUKRS
RACCT
RBUSA
TSL FROM FAGLFLEXA INTO TABLE IT_BSEGSA1 FOR ALL ENTRIES IN IT_FINALSA WHERE DOCNR = IT_FINALSA-BELNR
AND RBUKRS = '1000' AND RACCT IN R_ACCT AND RBUSA = PLANT .
ENDIF.
When i am executing the above 'Select' statement in Quality Server,its taking much time. When i debugged,IT_FINALSA[] table is containing 2600 entries. Please suggest what should i do to improve the performance. Should i use innerjoin instead of 'For all entries' .