topic Re: Code inspector error message please help in Application Development and Automation Discussions

Code inspector error message please help

Former Member — Thu, 15 Jan 2009 09:45:55 GMT

Hi All i have used delete statement as shown below

DELETE t_output WHERE remain_invoice NOT IN s_invo[].

t_output is my internal table .

Error message in code inspector is :Sequential read access for a standard table

What should i do ?

Re: Code inspector error message please help

Sm1tje — Thu, 15 Jan 2009 09:50:54 GMT

are you deleting data from internal table or database table?

For internal table use addition DELETE TABLE....

Re: Code inspector error message please help

Former Member — Thu, 15 Jan 2009 09:55:55 GMT

hi,

i think you should not do this.

try .

loop at t_output.

vtabix = sy-tabix.

read table s_invo with key low = t_output-remain_invoice .

if sy-subrc ne 0.

delete t_output index vtabix.

endif.

endloop.

this wont lead any performance issue.

Re: Code inspector error message please help

Former Member — Thu, 15 Jan 2009 10:05:39 GMT

I think its better to avoid delete statements inside the loop

instead of using delete statement inside the loop

use

delete table itab where condition

if u have to use loop at any cost

modify internal table with flag=X

and then delete all records from the itab at one shot using above statement

Regards

Vikas C

Re: Code inspector error message please help

Former Member — Thu, 15 Jan 2009 10:24:24 GMT

Hi Manisha,

We should not do delete inside loop.

It will degrade performance.

Regards

Sandipan

Re: Code inspector error message please help

Former Member — Mon, 09 Mar 2020 15:17:22 GMT

There's 2 more and I'd really appreciate your inputs.

 1.) LOOP AT lt_plaf
    ASSIGNING FIELD-SYMBOL(<fs_plaf>).


    READ TABLE lt_zmrp
      INTO DATA(ls_zmrp)
      WITH KEY cno_order = <fs_plaf>-plnum+3(7).


    IF sy-subrc NE 0.
      MOVE abap_true TO <fs_plaf>-xdel .
    ENDIF.


  ENDLOOP.


  DELETE lt_plaf
    WHERE xdel EQ abap_true.

2.)   SELECT ordid
    FROM /bmw/ts_1143_log AS a
   WHERE ordid IN @s_ordid
     AND order_comp_flag EQ @space
     AND
  EXISTS ( SELECT *
             FROM zmrp
            WHERE cno_order  EQ a~ordid
              AND cid_status IN @s_status
              AND cno_assyl  IN @s_assyl )
    INTO TABLE @gt_log.


  IF sy-subrc EQ 0.


    SORT gt_log
      BY ordid.


    DELETE ADJACENT DUPLICATES FROM gt_log
      COMPARING ordid ##CI_SORTED.


  ENDIF.