Application Development and Automation 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: 
Read only

Delete Entries

Former Member
0 Likes
611

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.

1 ACCEPTED SOLUTION
Read only

former_member156446
Active Contributor
0 Likes
587

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

4 REPLIES 4
Read only

former_member156446
Active Contributor
0 Likes
588

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

Read only

0 Likes
587

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.

Read only

0 Likes
587

Thanks Jackandjay

My problem is now solved.

Read only

Former Member
0 Likes
587

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.