12-01-2008 11:42 AM
Hi,
How to delete one particular record from database table..?
by mistakenly one record is there in Production have to delete that entire record for ever..
thanks,
srriii
12-01-2008 11:47 AM
use DELETE command with index or give the key.
it will delete particular record only.
Best Regards,
Pravin
12-01-2008 11:47 AM
Hi,
You can modify/delete any records of database table only when you are authorized to do so. If you are having access key, then only you can perform all these operations.
Thanks
NK
12-01-2008 11:53 AM
Open the editor, type DELETE, position the cursor on the word and press F1. RTFOH
12-01-2008 12:45 PM
hi Sridhar Reddy,
Do u have access to production system.
if yes, follow this process.
go to se16n
enter table name ex : mara . press enter
type " &sap_edit " in command field , press enter
"sap editing function is activated" message is displayed. press f8 .
select that particular record and delete it .
Except for the primary key fields, all the values in other
fields could be edited and saved. You can add even new rows here by clicking .
Regards,
Aby.
Please close this thread as soon as your problem is solved.
12-01-2008 12:46 PM
Hello Sridhar,
Do you have the table maintanence view for that particular table? If yes delete the record from there.
Thanks
Jayant
12-01-2008 12:53 PM
you should not delete directly using delete command. look for some FM to delete that.
12-02-2008 2:27 AM
Hi all ,
solved.
this is enough to delete a perticular record.
DELETE <table> FROM work-area.
UPDATE <table>.
Thanks,
sriiii...
12-02-2008 3:38 AM
>
> Hi all ,
> solved.
> this is enough to delete a perticular record.
>
> DELETE <table> FROM work-area.
> UPDATE <table>.
>
> Thanks,
> sriiii...
....But you've done a more than Enough work,as There is no need to add UPDATE.
12-02-2008 2:27 AM
12-02-2008 3:34 AM