Skip to Content
0

Optimizing the code for lookup in end routine

Feb 24 at 09:21 AM

24

avatar image

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

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers