topic Re: delete one record from database table in Application Development and Automation Discussions

delete one record from database table

Former Member — Mon, 01 Dec 2008 11:42:36 GMT

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

Re: delete one record from database table

Former Member — Mon, 01 Dec 2008 11:47:15 GMT

use DELETE command with index or give the key.

it will delete particular record only.

Best Regards,

Pravin

Re: delete one record from database table

Former Member — Mon, 01 Dec 2008 11:47:41 GMT

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

Re: delete one record from database table

rainer_hbenthal — Mon, 01 Dec 2008 11:53:47 GMT

Open the editor, type DELETE, position the cursor on the word and press F1. RTFOH

Re: delete one record from database table

Former Member — Mon, 01 Dec 2008 12:45:14 GMT

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.

Re: delete one record from database table

Former Member — Mon, 01 Dec 2008 12:46:56 GMT

Hello Sridhar,

Do you have the table maintanence view for that particular table? If yes delete the record from there.

Thanks

Jayant

Re: delete one record from database table

Former Member — Mon, 01 Dec 2008 12:53:44 GMT

you should not delete directly using delete command. look for some FM to delete that.

Re: delete one record from database table

Former Member — Tue, 02 Dec 2008 02:27:27 GMT

Hi all ,

solved.

this is enough to delete a perticular record.

DELETE <table> FROM work-area.

UPDATE <table>.

Thanks,

sriiii...

Re: delete one record from database table

Former Member — Tue, 02 Dec 2008 02:27:46 GMT

solved.

Re: delete one record from database table

Former Member — Tue, 02 Dec 2008 03:34:32 GMT

Was it a standard table or a Custom table?

Re: delete one record from database table

Former Member — Tue, 02 Dec 2008 03:38:08 GMT


> 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.