topic Re: Is a loop really needed? in Application Development and Automation Discussions

Is a loop really needed?

Former Member — Wed, 13 Jan 2010 18:32:48 GMT

Hello everyone,

I have my internal table and want to delete the rows with more less than 5 characters. I do not want to use a loop because of perfomance issues, rather I am trying to use the DELETE statement, but I am not being successful.


  DATA: it_bseg type STANDARD TABLE OF bseg,
             wa_bseg type bseg.


  SELECT * FROM bseg
    INTO CORRESPONDING FIELDS OF TABLE it_bseg
    WHERE bukrs EQ pa_bukrs and
                 belnr  IN so_belnr   and
                 gjahr EQ pa_gjahr.


delete it_bseg WHERE strlen(dbmtr) > pa_min_value.

Thank you in advance

Re: Is a loop really needed?

Former Member — Wed, 13 Jan 2010 18:47:07 GMT

Many reasons:

instead of dbmtr, try DMBTR;

But strlen only works on characters, not currency amounts.

You probably want to use:

delete it_bseg WHERE DMBTR > pa_min_value.

But it wouldn't be a performance problem anyway.

Rob

I should have added that it's really a mug's game. ABAP will have to do an internal loop anyway to read each row and decide whether or not to delete it.

Edited by: Rob Burbank on Jan 13, 2010 2:05 PM

Re: Is a loop really needed?

Former Member — Wed, 13 Jan 2010 18:56:14 GMT

Sorry...Duplicate post

Edited by: PRITAM MOHANTY on Jan 13, 2010 10:57 AM