Skip to Content

Optimizing the code for lookup in end routine

Hi,

We have a lookup into DSO while loading data from one to DSO to other DSO, Could you please me to optimise this code.

DTP taking quite long time to load data, load struck in yellow status.

Types : Begin of itab,
COSTCENTER type /BI0/AFIGL_O0200-COSTCENTER,
coorder type /BI0/AFIGL_O0200-coorder,End of itab.
data : jtab type standard table of itab.
data : ktab type itab.

LOOP AT RESULT_PACKAGE ASSIGNING <result_fields>.
Select COSTCENTER coorder FROM /BI0/AFIGL_O0200 into TABLE jtab
WHERE AC_DOC_NO = <result_fields>-AC_DOC_NO.
loop at jtab into ktab.
move Ktab-COSTCENTER to <result_fields>-COSTCENTER.move Ktab-COORDER to <result_fields>-COORDER.endloop.endloop.

*$*$ end of routine - insert your code only before this line *-*ENDMETHOD.

Thanks

H

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

0 Answers