topic Re: delete in Application Development and Automation Discussions

delete

Former Member — Mon, 06 Oct 2008 09:19:40 GMT

Hi Guyz,

How can i delete entries in the internal table based on the selection screen , ie, i have range of clientnumber on the selection screen..i should delete all my entries in the internal table which are not equal to the client numbers based on the selection screen.. plz advise

declaration:

select-options:

s_client type ztable-client

regds

Re: delete

Former Member — Mon, 06 Oct 2008 09:21:10 GMT

Hi,

loop at ztable where client in s_client .

delete ztable.

endloop.

delete ztable where client in s_client.

regards

Nicole

Re: delete

Former Member — Mon, 06 Oct 2008 09:22:08 GMT

loop at s_client.

delete from internal where client = s_client-low.

endloop.

Regards

Re: delete

Former Member — Mon, 06 Oct 2008 09:22:25 GMT

Check this example..


tables: vbak.
DATA: BEGIN OF itab OCCURS 0,
  vbeln LIKE vbak-vbeln,
  END OF itab.
 
SELECT-OPTIONS s_vbeln for vbak-vbeln.
 
DELETE itab WHERE NOT vbeln IN s_vbeln.

Regards,

Omkaram.

Re: delete

Former Member — Mon, 06 Oct 2008 09:24:24 GMT

thanks for your replies..

but i need to delete the entries which are not specified on the selection screen..not the entries equal to the clientnumbers on the selection screen.

Re: delete

Former Member — Mon, 06 Oct 2008 09:25:01 GMT

Hi ,

There are several ways you can delete the records,

One way is :

Loop at <final_table>

if <final_table> value = selection screen value Then

delete index sy-tabix.

endif.

Endloop.

Thanks,

Chidanand

Re: delete

Former Member — Mon, 06 Oct 2008 09:25:14 GMT

Hi Brightside,

follow the logic below,



data: st_client like s_client.

loop at <your_internal_table>.
  read s_client into st_client where client eq <your_internal_table>-client.
  if sy-subrc ne 0.
     delete <your_internal_table>.
  endif.
endloop.

Regards,

Kiran

Re: delete

Former Member — Mon, 06 Oct 2008 09:30:20 GMT

delete ztable where not client in s_client.