Skip to Content
0
Former Member
Jul 01, 2009 at 10:47 AM

select inside loop converiting to for all entries for performance

37 Views

experts suggest the corrections for good performance.

ztable has following fields

user , kunnr.

i_table has following fields

name,auart,kunnr,flag.

parameters : p_user type ztable-user.

parameters : p_kunnr type vbeln-kunnr.

LOOP AT i_table.

IF i_table-NAME = 'Shiva'.

SELECT single kunnr INTO skunnr FROM vbeln WHERE

vbeln = i_table-value.

ENDIF.

IF i_table-NAME = 'Kumar'.

auart = i_table-auart.

ENDIF.

IF NOT skunnr IS INITIAL.

SELECT single user FROM zuser

INTO v_user

WHERE user = p_user

AND kunnr = p_skunnr.

IF user IS NOT INITIAL.

i_export-kunnr = i_table-kunnr.

i_export-auart = i_table-auart.

i_export-flag = 'X'.

ELSE.

i_export-NAME = i_table-NAME.

i_export-age = i_table-age.

i_export-flag = ''.

ENDIF.

Append i_export to itab_final.

ENDIF.

ENDLOOP.