Can this statement be optimized?

[Former Member]

loop at lt_hide_log_list into ls_hide_log_list.

delete table et_save_log_customizing from ls_hide_log_list.

endloop.

Thanks for helping.

Best regards,

Lament

[Former Member]

can u tell what all those tables are??how they are related???

[Former Member]

They are all the type tihttpnvp

That is the "name-value" list.

Regards,

Lament

[Former Member]

Hi Gates,

I dont think it requires further optimization. The code is already optmized. Inside LOOP when you are using a work area to delete the values from another internal table of same line type, the performance is satisfactory. The code that you have used is the recommended way of using the delete statement.

So you can use the code as it is.

Best Regards,

Ram.

[Former Member]

Hi,

when u use a work area...it is like...

The statement deletes the first internal table row whose values in the columns of the table key match those of the corresponding components of wa. If the key fields in wa are empty, no entry is deleted.

So if you want to delete more than one row from the table et_save_log_customizing having the same key as the work area...u have to use..

loop at lt_hide_log_list into ls_hide_log_list.

DELETE TABLE et_save_log_customizing WITH KEY name = ls_hide_log_list-name.

endloop.

preformance wise both are ok...

[Former Member]

Hi Gates,

Can u please elaborate u r question please.

[former_member222860]

Hi

loop at lt_hide_log_list into ls_hide_log_list.

delete table et_save_log_customizing from ls_hide_log_list.

APPEND lt_hide_log_list.

endloop.

thanks

Mahesh

[Former Member]

Thanks very much for all your reply

Regards,