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.