topic Re: performance tuning in Application Development and Automation Discussions

performance tuning

Former Member — Thu, 03 Jan 2013 03:26:01 GMT

HI,

PLEASE ANYONE SUGGEST TO AVOID THIS PERFORMANCE RELATED ISSUES

"LOOP AT record.

CHECK record-sys_equnr IS INITIAL.

SELECT SINGLE hequi

INTO record-hequi

FROM equz WHERE equnr EQ record-equnr

AND datbi = '99991231'.

MODIFY record.

CLEAR record.

ENDLOOP. "

Moderator message: please do more research before posting.

Message was edited by: Thomas Zloch

Re: performance tuning

former_member195270 — Thu, 03 Jan 2013 05:37:56 GMT

data lv_index type i.

LOOP AT record where sys_equnr is initial.

lv_index = sy-tabix.

SELECT SINGLE hequi

INTO record-hequi

FROM equz WHERE equnr EQ record-equnr

AND datbi = '99991231'.

MODIFY record from record index lv_index.

ENDLOOP.