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: 

Data deletion in DB table

Former Member
0 Kudos
295

Hi,

I have given maintenance allowed as a setting in delivery & maintenace of DB table.

But still i couldn't delete data from the table. what will be the reason? should i change

some other settings of DB table?

1 ACCEPTED SOLUTION

Former Member
0 Kudos
245


Have you created table maintenece generator for your database table?

If you have created .. then Go to transaction SM30 and delete all the entries. It will empty your db table.

14 REPLIES 14

Former Member
0 Kudos
246


Have you created table maintenece generator for your database table?

If you have created .. then Go to transaction SM30 and delete all the entries. It will empty your db table.

0 Kudos
245

Hi pravin,

Thanks for your response.

actually table maintenance is not required for this table.

Normally if we give maintenance allowed in delivery & maintenance tab,

if should allow us to delete the entries right?

0 Kudos
245

Hi D MS,

No. You will still need to create table maintenance to delete, edit etc for entries in table. Its precisely for same reason you give Delivery and Maintenance allowed.

Regards,

Sheetal.

naveenvishal
Contributor
0 Kudos
245

Hi DMS,

It is recommended to create a Maintenance View of the Table for the activity. Pl use TMG (Table Maintenance Generator) for the same.

Refer this wiki link for TMG generation.

http://wiki.scn.sap.com/wiki/pages/viewpage.action?pageId=79953931

Hope this helps.

Regards,

Naveen

0 Kudos
245

Hi naveen,

Thanks for your response.

actually table maintenance is not required for this table.

I have created other tables in same way and i could delete

entries from table. But i'm facing issue only for this table.

what will be the reason?

Former Member
0 Kudos
245

Hi D MS,

Please specify how you are deleting the data? Using table maintenance?

This will enable us to clarify your doubt.

Regards,

Sheetal.

0 Kudos
245

In se16, After displaying the table contents, i'm trying to delete through

Table Entry -> Delete. But that option is inactive.

0 Kudos
245

Hi D MS,

Then it may be an authorization issue. Check if your user has access for deletion

Regards,

Sheetal

Former Member
0 Kudos
245

Hi,

First of all, You should NEVER directly delete entries from a standard SAP table.

(1) Delete the row by row entry through SE16N OR

(2) Delete by SQL delete query ,

        Delete from tablename where condition.

Regards,

Hardik B

0 Kudos
245

No this is not a standard table. Its a z table only.

And i want this action for one time.

0 Kudos
245

Hi ,

then use a small program and use delete <DB TABLE> from <Internal Table>.

Regards,

Pavan

0 Kudos
245

Hi

Please pick a custom table for which deletion is working fine, compareyour current table and double check all your settings and see if that helps.

Thank You,
Gajendra.

0 Kudos
245

Thanks for all ur reply.

Actually it is working fine in dev but not in QA.

So i have created a table maintanance and now i can delete

the entry in table from QA too.

And Sheetal Naidu,

As u said, i think its of authorisation issue.

Thanks.

Former Member
0 Kudos
245

Hi

in the maintenance allowed read and change will be allowed so just create the table maintenance generator for the table and create the transaction for that,there we can delete the table contents or change the data.

Regards

Karthikeyan RV.