Skip to Content
0
Former Member
Dec 25, 2007 at 05:19 AM

Code optimization - Urgent

30 Views

Hi All,

I have called the function module - 'CS_BOM_EXPL_MAT_V2' with respective parameters. Following the function call, i have written these lines, to display each material & the corresponding field from MARC. There is no syntax error, but the execution of this query takes a very long time, i had to terminate the execution.

May i know what could be the reason for this?

Code

IF SY-SUBRC EQ 0.

LOOP AT IL_STBX INTO HL_STBX.

WL_MATNR = HL_STBX-IDNRK.

SELECT SINGLE WEBAZ FROM MARC INTO WL_WEBAZ

WHERE MATNR EQ HL_STBX-IDNRK.

ENDLOOP.

Note: I have declared the DATA as mentioned below.

DATA :

IL_STBX TYPE TABLE OF STPOX,

HL_STBX TYPE STPOX.

REFRESH :

IL_STBX[].

CLEAR

HL_STBX.

Await your inputs.

Vivek