topic Re: delete row if field is initial. in Application Development and Automation Discussions

delete row if field is initial.

Former Member — Fri, 31 Mar 2006 08:03:40 GMT

Hello,

What I want to do is to delete the whole row if a specific field is empty. If it helps this is an ALV_GRID report

I have seen that there are a couple of topics about this but I haven't been able to solv it. My attempts are in bold.

wa_rec-sek_norm_sal = wa_rec-norm_sal - wa_rec-bet01.

if wa_rec-sek_norm_sal is initial.

delete wa_rec.

endif.

append wa_rec to lt_rec.

loop at lt_rec.

if lt_rec-sek_norm_sal is initial.

delete lt_rec.

endif.

endloop.

Error from first attempt:

"WA_REC" is not an internal table - the "OCCURS n" specification is missing"

Error from second attempt:

The internal table "LT_REC" has no Header line - explicit specification of an output area with "INTO wa" or "ASSIGNING <fs>" is required.

Thank you all.

Best Regards Claes

Re: delete row if field is initial.

Former Member — Fri, 31 Mar 2006 08:06:51 GMT

Hi claes,

1. how is your internal table defined ?

wa_rec

(is it work area or internal table ?

if internal table, then

it should be declared someting like this :

dat a: wa_rec like table of

T001 WITH HEADER LINE.

2. same is the case with 2.

lt_rec-sek_norm_sal

(it does not have header line)

regards,

amit m.

Re: delete row if field is initial.

Former Member — Fri, 31 Mar 2006 08:07:01 GMT

create it_rec with header line.

let me know if u need any assistance.

Raja.

Re: delete row if field is initial.

Former Member — Fri, 31 Mar 2006 08:09:58 GMT

1. The first part of the code must be running in a loop.. right??

If I am not wrong, your code looks like this:

loop at it_rec into wa_rec.

.....

wa_rec-sek_norm_sal = wa_rec-norm_sal - wa_rec-bet01.

if wa_rec-sek_norm_sal is initial.

*delete wa_rec.

DELETE <IT_REC> index sy-tabix.

endif.

endloop.

Create a workarea for lt_rec.

For ex:

data: wa_rec like lt_rec.

data: v_tabix like sy-tabix.

loop at lt_rec into wa_rec.

v_tabix = sy-tabix.

if wa_rec-sek_norm_sal is initial.

delete lt_rec index v_tabix.

endif.

endloop.

Hope this helps

Re: delete row if field is initial.

Former Member — Fri, 31 Mar 2006 08:10:35 GMT

hi,

data: x_rec like line of lt_rec.

loop at lt_rec into x_rec. 
if x_rec-sek_norm_sal is initial.
delete lt_rec index sy-tabix.
endif.
endloop.

this will solve .

Regards

Vijay

Re: delete row if field is initial.

Former Member — Fri, 31 Mar 2006 08:18:31 GMT

Problem solved, Thank you for all the help!

Best Regards

Claes