Application Development 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: 

delete one record from database table

Former Member
0 Kudos

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

10 REPLIES 10

Former Member
0 Kudos

use DELETE command with index or give the key.

it will delete particular record only.

Best Regards,

Pravin

Former Member
0 Kudos

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
Active Contributor
0 Kudos

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

Former Member
0 Kudos

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
0 Kudos

Hello Sridhar,

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

Thanks

Jayant

Former Member
0 Kudos

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

0 Kudos

Hi all ,

solved.

this is enough to delete a perticular record.

DELETE <table> FROM work-area.

UPDATE <table>.

Thanks,

sriiii...

0 Kudos

>

> 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
0 Kudos

solved.

0 Kudos

Was it a standard table or a Custom table?

pk