Skip to Content
0
Former Member
Jul 02, 2009 at 08:11 AM

'For all entries ' taking much time

48 Views

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' .