Code inspector warning for this statement

[Former Member]

Sequential read access possible for a sorted table

lt_action_fld is a sorted table.

DELETE lt_action_fld WHERE status = '0'.

can anybody tell me how to improve it?

Best regards,

Blake Le

[Former Member]

what is warning..is it of Sy-subrc check after delete statement..then put this check after delete statement

[Former Member]

hi, Madam,

I don't think so , I believe it's a warning from read table statement and the internal table attribute.

Best regards,

Best regards,

[former_member195383]

make sure that lt_action_fld is sorted by status field..

that will improve the performance..

[Former Member]

Hello Blake,

Try this:

READ TABLE lt_action_fld WITH KEY STATUS = '0' BINARY SEARCH.

wf_index = sy-tabix.

loop at lt_action_fld from wf_index.

if lt_action_fld-status ne '0'.

exit.

endif.

delete lt_action_fld index wf_index.

endloop.

Let us know, if this helps.

Rgds,

Raghu.

[Former Member]

hiiii

first sort your table with 'status' field...& use like

delete from (table Name) where condition.

regards

twinkal

[Former Member]

Hi Blake,

Try if this works. Put your delete statement in

IF SY-SUBRC = 0.

DELETE

ENDIF.

Regards,

Sai