topic Re: Code inspector warning for this statement in Application Development and Automation Discussions

Code inspector warning for this statement

Former Member — Wed, 09 Jul 2008 05:42:35 GMT

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

Re: Code inspector warning for this statement

Former Member — Wed, 09 Jul 2008 05:48:30 GMT

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

Re: Code inspector warning for this statement

Former Member — Wed, 09 Jul 2008 07:08:58 GMT

hi, Madam,

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

Best regards,

Re: Code inspector warning for this statement

former_member195383 — Wed, 09 Jul 2008 07:11:14 GMT

make sure that lt_action_fld is sorted by status field..

that will improve the performance..

Re: Code inspector warning for this statement

Former Member — Wed, 09 Jul 2008 07:14:36 GMT

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.

Re: Code inspector warning for this statement

Former Member — Wed, 09 Jul 2008 07:15:08 GMT

hiiii

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

delete from (table Name) where condition.

regards

twinkal

Re: Code inspector warning for this statement

Former Member — Wed, 09 Jul 2008 07:19:51 GMT

Hi Blake,

Try if this works. Put your delete statement in

IF SY-SUBRC = 0.

DELETE

ENDIF.

Regards,

Sai