07-15-2009 10:09 AM
Hi,
I want delete an entry from DB table, can u help how can I delete, without effecting other data.
thanks
07-15-2009 10:36 AM
go to se11
Give table name
Press F7( ie: display table entries)
F8
Select the entry
Give /H in command bar
Press enter(debugger switch on)
Press enter again
Give CODE in debugge
F8
Select the entry
Press display (F2)
/H
Press ENTER twice
Now edit the CODE from SHOW to DELE
Press ENTER
F8
Press delete in Menu bar
Now check in the DB
07-15-2009 10:36 AM
go to se11
Give table name
Press F7( ie: display table entries)
F8
Select the entry
Give /H in command bar
Press enter(debugger switch on)
Press enter again
Give CODE in debugge
F8
Select the entry
Press display (F2)
/H
Press ENTER twice
Now edit the CODE from SHOW to DELE
Press ENTER
F8
Press delete in Menu bar
Now check in the DB
07-15-2009 10:38 AM
Hi,
If you want to delete all the record form table then you can use T-code SE14.
Go To --> Se14 ---> Enter table name & press Edit Button --- > Select Delete Data Radio Button ---> Click on Activate and Adjust Database.
You Can also Generate Table maintains of the table. So that u can delete record of the table in tcode SM30.
If you want to delete record by code then use stmt DELETE.
Thanks & Regards
ShreeMohan
07-15-2009 10:50 AM
Hi ,
goto ABAP editor and using delete statement try to delete the data in the table
DELETE { {FROM target [WHERE sql_cond]}
| {target FROM source} }.
Effect
The statement DELETE deletes one or more rows from the database table specified in target. The rows that are to be deleted are specified either in a WHERE condition sql_cond or with data objects in source.
Please let me know if you still need any more help.
Thanks and regards,
Rajeshwar.
07-15-2009 12:14 PM
Hi all,
Thanks for all to ur consideration. Through SM30 we can not delete bcs that entry does not exist there. reagrding through SE16 by debugging I already done, but as per my ABAP team here they are saying that is not recommendable, bcs it may be effect to other data in future..
but regarding code fro DELETE which u r saying I will try. before that pls confirm me if we will do this thing through Coding then it will not be effect to other data?
pls reply me soon.
thanks
07-15-2009 12:19 PM
Hi ,
by deleting it does'nt effect other data, check whether it is a key field , if not then you can delete it.
PLease let me know if you still need any more help.
Thanks and regards,
Rajeshwar.
07-15-2009 12:37 PM
Hi Rajeshwar,
Its really thankful for ur reply. but can u just tell there is any SAP note for that.
thanks
07-15-2009 1:19 PM
You can specify the delete statement with where condition and only the entries which satisfy the condition will be deleted. it will not delete any other data.
delete from ddtable where field1 = 'Test'.
In above statement the enties whose field1 = test will be deleted from dd table.
07-20-2009 2:54 PM
I think we need to know from wich table you are trying to delete the record. Is it a standard or Z ?
07-22-2009 12:55 PM
Hai,
Fetch your entry into work area say wa. Then use the delete statement: Delete Dbtab from wa.
Best Regards,
rama