topic ALV Report Performance in Application Development and Automation Discussions

ALV Report Performance

Former Member — Wed, 27 Aug 2008 10:28:02 GMT

HI ,

LOOP AT DD07V_TAB1.

N = 0.

LOOP AT DD07T_TAB WHERE DOMNAME = DD07V_TAB1-DOMNAME AND

DOMVALUE_L = DD07V_TAB1-DOMVALUE_L.

N = N + 1.

here there is loop under loop can any one pls write with read statment loop with read statment ,

iam thankful to u,

it is taking lot of time for executing

thanks in advance,

Re: ALV Report Performance

Former Member — Wed, 27 Aug 2008 10:49:46 GMT

Hello


SORT DD07V_TAB1.
SORT DD07T_TAB BY DOMNAME DOMVALUE_L.
LOOP AT DD07V_TAB1.
N = 0.
READ TABLE DD07T_TAB WITH KEY DOMNAME = DD07V_TAB1-DOMNAME AND
DOMVALUE_L = DD07V_TAB1-DOMVALUE_L BINARY SEARCH.
N = N + 1.
...
ENDLOOP.

Re: ALV Report Performance

Former Member — Wed, 27 Aug 2008 11:55:30 GMT

Hi,

SORT DD07V_TAB.

SORT DD07T_TAB BY DOMNAME DOMVALUE.

LOOP AT DD07V_TAB1.

N = 0.

READ TABLE DD07T_TAB WITH KEY DOMNAME = DD07V_TAB1-DOMNAME AND

DOMVALUE_L = DD07V_TAB1-DOMVALUE_L.

IF SY-SUBRC EQ 0.

READ TABLE DD07T_TAB WITH KEY DOMNAME = DD07V_TAB1-DOMNAME AND

DOMVALUE_L = DD07V_TAB1-DOMVALUE_L.

IF SY-SUBRC EQ 0.

N = N + 1.

ENDIF.

ENDLOOP.

Regards,

Rama.

Re: ALV Report Performance

Former Member — Thu, 02 Apr 2009 10:20:49 GMT

answered

Re: ALV Report Performance

Former Member — Thu, 02 Apr 2009 13:39:01 GMT

Please use this solution see section 3

Measurements on internal tables: Reads and Loops:

/people/siegfried.boes/blog/2007/09/12/runtimes-of-reads-and-loops-on-internal-tables

or better use a sorted table as inner table.

And be aware, that only the inner table must be sorted, the other sort is a waste of time !!!

Siegfried