delete one record from database table

[Former Member]

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

[Former Member]

use DELETE command with index or give the key.

it will delete particular record only.

Best Regards,

Pravin

[Former Member]

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

[rainer_hbenthal]

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

[Former Member]

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.

[Former Member]

Hello Sridhar,

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

Thanks

Jayant

[Former Member]

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

[Former Member]

Hi all ,

solved.

this is enough to delete a perticular record.

DELETE <table> FROM work-area.

UPDATE <table>.

Thanks,

sriiii...

[Former Member]

>

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

[Former Member]

solved.

[Former Member]

Was it a standard table or a Custom table?

pk