topic Re: DELETE? in Application Development and Automation Discussions

DELETE?

Former Member — Fri, 20 Jul 2007 05:47:13 GMT

Hi all,

How to modify the internal table.

matnr werks maktx

0001 0008 khga

0002 0098

1111 mkhh

in this i want to delete a record which has an empty value in maktx.

kishi.

Former Member — Fri, 20 Jul 2007 05:54:40 GMT

Use this code.

DELETE it_mat WHERE maktx IS INITIAL.

It_mat is the internal table name.

Former Member — Fri, 20 Jul 2007 05:55:22 GMT

loop at itab.

delete itab where itab-matkx = ' '.

endloop.

Regards,

Pavan

Former Member — Fri, 20 Jul 2007 05:56:06 GMT

hey

Use this.

DELETE it_mat[] WHERE maktx IS space.

It_mat[] is the internal table name.

reward if help ful.

Regards

Azad,

Former Member — Fri, 20 Jul 2007 05:56:16 GMT

LOOP AT ITAB.

IF ITAB-MAKTX is initial.

DELETE ITAB.

ENDIF.

ENDLOOP.

gopi_narendra — Fri, 20 Jul 2007 05:56:42 GMT

You can use the below format for delete

DELETE itab WHERE cond.

Delete itab where maktx is initial.

delete itab where maktx = ' '.

Regards

Gopi