topic Delete Entries in Application Development and Automation Discussions

Delete Entries

Former Member — Fri, 25 Jan 2008 02:51:27 GMT

Hi Experts,

ITAB.

OBJNR STAT

10076532 DLFL

10076532 NOCO

I WANT TO DELETE ALL ENTRIES WHICH ARE HAVING STATUS DLFL.bUT MY PROBLEM IS THAT I WANT TO DELETE BOTH OBJNR BECAUSE THESE ARE SAME.

PLEASE TELL ME THE RIGHT SOLUTION.I DONT WANT TO

DELETE DUPLICATE ENTRIS.

Re: Delete Entries

former_member156446 — Fri, 25 Jan 2008 02:55:14 GMT

Hi Garima

check this updated code...


read table itab with key stat = 'DLFL'.
if sy-subrc eq 0.
delete itab where objnr = itab-objnr.
endif.

this will delete all the objnr which have a DLFL status..

Edited by: Jackandjay on Jan 24, 2008 10:04 PM

Re: Delete Entries

Former Member — Fri, 25 Jan 2008 03:01:14 GMT

i WANT TO DELETE SAME OBJNR BECAUSE I M HAVING OTHER ENTRIES OF STAT NOCO.

mY PROBLEM IS THAT WHEN THE STAT IS DLFL IT CREATE AN ENTRY OF STAT NOCO SO I WANT TO DELETE BOTH OBJNR.

Re: Delete Entries

Former Member — Fri, 25 Jan 2008 03:06:04 GMT

Hi Garima, then in that case go to the DB table entries and manually delete the duplicate records which u dont need. This u can do by going to se11, table entries, check the entries which are to be deleted and on the menu bar u have table entries tab, under which delete entries option is available.

hope this helps.

cheers,

Hema.

Re: Delete Entries

Former Member — Fri, 25 Jan 2008 04:12:32 GMT

Thanks Jackandjay

My problem is now solved.