Skip to Content
0
Aug 13, 2008 at 06:16 AM

performance issue for rseg table

205 Views

hi,

we have an fi report related to inter state tax calculation.

the report is woking fine.

problem is here we r selecting data from rseg based on mseg

but we cannot use any primary key combination.so the database is taking long time to retrive data.

i checked in both se30 and st05.the below statement is taking more time to retrive data from database.

IF NOT it_mseg1[] IS INITIAL.

SELECT belnr gjahr buzei lfbnr lfgja lfpos ebeln ebelp FROM rseg

INTO TABLE it_rseg

FOR ALL ENTRIES IN it_mseg1

WHERE lfbnr = it_mseg1-mblnr AND

lfgja = it_mseg1-mjahr AND

lfpos = it_mseg1-zeile.

ENDIF.

can any one suggest in improving the performance .