topic Re: Data deletion in DB table in Application Development and Automation Discussions

Data deletion in DB table

Former Member — Thu, 19 Jun 2014 09:55:17 GMT

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?

Re: Data deletion in DB table

Former Member — Thu, 19 Jun 2014 10:06:02 GMT

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.

Re: Data deletion in DB table

naveenvishal — Thu, 19 Jun 2014 10:08:37 GMT

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

Re: Data deletion in DB table

Former Member — Thu, 19 Jun 2014 10:18:15 GMT

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?

Re: Data deletion in DB table

Former Member — Thu, 19 Jun 2014 10:19:43 GMT

Hi D MS,

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

This will enable us to clarify your doubt.

Regards,

Sheetal.

Re: Data deletion in DB table

Former Member — Thu, 19 Jun 2014 10:20:27 GMT

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?

Re: Data deletion in DB table

Former Member — Thu, 19 Jun 2014 10:21:06 GMT

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.

Re: Data deletion in DB table

Former Member — Thu, 19 Jun 2014 10:23:03 GMT

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

Re: Data deletion in DB table

Former Member — Thu, 19 Jun 2014 10:23:39 GMT

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

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

Re: Data deletion in DB table

Former Member — Thu, 19 Jun 2014 10:25:26 GMT

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

And i want this action for one time.

Re: Data deletion in DB table

Former Member — Thu, 19 Jun 2014 10:27:50 GMT

Hi D MS,

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

Regards,

Sheetal

Re: Data deletion in DB table

pavanm592 — Thu, 19 Jun 2014 10:28:46 GMT

Hi ,

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

Regards,

Pavan

Re: Data deletion in DB table

Former Member — Thu, 19 Jun 2014 10:42:58 GMT

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.

Re: Data deletion in DB table

Former Member — Thu, 19 Jun 2014 11:33:23 GMT

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.

Re: Data deletion in DB table

Former Member — Thu, 19 Jun 2014 17:24:23 GMT

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.