doubt in DELETE

[Former Member]

Hi all.

I have internal table ,it has few fileds like

vbeln TYPE likp-vbeln,

kunnr TYPE likp-kunnr,

tknum TYPE vttk-tknum,

daten TYPE vttk-daten,

now it has values.i need to delete record which one have "tknum" is blank in this internal table.

please help me.

To be reward all helpfull answers.

Jay

[former_member223537]

loop at itab.

if itab-tknum is initial.

delete itab index sy-tabix.

endif.

endloop.

[Former Member]

Hi,

Use below syntax to delete records..

DELETE ITAB WHERE TKNUM = ' '.

Regards,

Sankar

[Former Member]

hi,

<b>DELETE ITAB WHERE tknum IS INITIAL.</b>

With Rgds,

S.Barani

[Former Member]

delete * from itab where tknum = ' '.

regards,

srinivas

<b>*reward for useful answers*</b>

[Former Member]

Hi,

Try This.

DATA: BEGIN OF itab OCCURS 0,

vbeln LIKE likp-vbeln,

kunnr LIKE likp-kunnr,

tknum LIKE vttk-tknum,

daten LIKE vttk-daten,

END OF itab.

itab-vbeln = '12222'.

itab-kunnr = '1224'.

itab-tknum = ''.

itab-daten = ''.

APPEND itab.

itab-vbeln = '12223'.

itab-kunnr = '1223'.

itab-tknum = 'abc'.

itab-daten = 23082007.

APPEND itab.

LOOP AT itab.

DELETE itab WHERE tknum = ''.

ENDLOOP.

LOOP AT itab.

WRITE:/ itab-vbeln ,itab-kunnr,itab-tknum,itab-daten.

ENDLOOP.

[Former Member]

Hi Jay,

Use like this.

Loop at i_tab.

if i_tab-tknum = space.

delete i_tab.

endif.

endloop.

regards

Sourabh Verma

[Former Member]

hi,

to delete single record use

delete itab where tknum = ' '.

for no of records.

loop at itab.

if itab-tknum = ' '.

delete itab-tknum.

endif.

endloop.

if helpful reward some points.

with regards,

Suresh Aluri.

[Former Member]

Hello,

Deleting from an Internal Table

1. DELETE itab.

2. DELETE TABLE itab WITH TABLE KEY k1 = v1 ... kn = vn.

3. DELETE TABLE itab [FROM wa].

4. DELETE itab INDEX idx.

5. DELETE itab FROM idx1 TO idx2.

6. DELETE itab WHERE logexp.

7. DELETE ADJACENT DUPLICATES FROM itab.

You can use these methods according to your need.

eg: delete itab where tknum = ' '.

regards,

LIJO

[Former Member]

Hi Jay,

<b>DELETE <INTERNAL-TABLE NAME> WHERE TKNUM = SPACE.

Reward points if this helps,</b>

Kiran