topic Re: doubt in DELETE in Application Development and Automation Discussions

doubt in DELETE

Former Member — Thu, 23 Aug 2007 12:37:47 GMT

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

Re: doubt in DELETE

Former Member — Thu, 23 Aug 2007 12:39:30 GMT

loop at itab.

if itab-tknum is initial.

delete itab index sy-tabix.

endif.

endloop.

Re: doubt in DELETE

Former Member — Thu, 23 Aug 2007 12:39:44 GMT

Hi,

Use below syntax to delete records..

DELETE ITAB WHERE TKNUM = ' '.

Regards,

Sankar

Re: doubt in DELETE

Former Member — Thu, 23 Aug 2007 12:39:50 GMT

hi,

DELETE ITAB WHERE tknum IS INITIAL.

With Rgds,

S.Barani

Re: doubt in DELETE

Former Member — Thu, 23 Aug 2007 12:43:06 GMT

delete * from itab where tknum = ' '.

regards,

srinivas

*reward for useful answers*

Re: doubt in DELETE

Former Member — Thu, 23 Aug 2007 12:46:17 GMT

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.

Re: doubt in DELETE

Former Member — Thu, 23 Aug 2007 12:47:26 GMT

Hi Jay,

Use like this.

Loop at i_tab.

if i_tab-tknum = space.

delete i_tab.

endif.

endloop.

regards

Sourabh Verma

Re: doubt in DELETE

Former Member — Thu, 23 Aug 2007 12:49:20 GMT

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.

Re: doubt in DELETE

Former Member — Thu, 23 Aug 2007 13:12:47 GMT

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

Re: doubt in DELETE

Former Member — Thu, 23 Aug 2007 13:16:19 GMT

Hi Jay,

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

Reward points if this helps,

Kiran