Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

DELETE?

Former Member
0 Kudos
88

Hi all,

How to modify the internal table.

ex

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.

5 REPLIES 5

Former Member
0 Kudos
70

Use this code.

DELETE it_mat WHERE maktx IS INITIAL.

It_mat is the internal table name.

0 Kudos
70

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
0 Kudos
70

loop at itab.

delete itab where itab-matkx = ' '.

endloop.

Regards,

Pavan

former_member223537
Active Contributor
0 Kudos
70

LOOP AT ITAB.

IF ITAB-MAKTX is initial.

DELETE ITAB.

ENDIF.

ENDLOOP.

gopi_narendra
Active Contributor
0 Kudos
70

You can use the below format for delete

DELETE itab WHERE cond.

Delete itab where maktx is initial.

delete itab where maktx = ' '.

Regards

Gopi