topic delete -ve value records in Application Development and Automation Discussions

delete -ve value records

Former Member — Tue, 03 Jul 2007 22:36:19 GMT

Hello All,

I am trying to delete the records if the value is less than zero.

IF it_tab-rhrs < 0 .

DELETE it_tab INDEX p_tabix.

ENDIF.

but its not deleting those records, still its displaying -ve values.

Points are rewarded.

thx.

Former Member — Tue, 03 Jul 2007 22:38:51 GMT

Are you in a loop? What is the type of the field "rhrs"? It should be number type.

You can simply use the following syntax.

DELETE it_tab WHERE rhrs < 0.

Former Member — Tue, 03 Jul 2007 22:56:17 GMT

Im in loop and i took rhrs as CHAR type.

Basically im doing plant maintenance and trying to calculate Remaning works hours based on planned hours and actual hours.

it_tab-rhrs = it_tab-arbei - it_tab-ismnw.

if it_tab < 0.

i want to delete whole record.

thx.

Former Member — Tue, 03 Jul 2007 23:14:13 GMT

Hi Raghu,

What is data type it_tav-rhrs ?

IF it_tab-rhrs < 0 .

delete table it_tab iNDEX p_tabix.-> use like this

ENDIF.

Thanks

seshu

Former Member — Tue, 03 Jul 2007 23:22:52 GMT

Hi,

I hope following code will solve your problem.

If you are not in a LOOP, then as Srinivas has said


DELETE it_tab WHERE rhrs < 0.

But, if you are in a LOOP, then


IF it_tab-rhrs < 0.
  DELETE it_tab INDEX sy-tabix.
ENDIF.


IF it_tab-rhrs CS '-'.
  DELETE it_tab INDEX sy-tabix.
ENDIF.

Reward points if the answer is helpful.

Regards,

Mukul