Data deletion in DB table

[Former Member]

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?

[Former Member]

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?

[Former Member]

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.

[Former Member]

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?

[Former Member]

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]

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

[Former Member]

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]

Hi D MS,

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

This will enable us to clarify your doubt.

Regards,

Sheetal.

[Former Member]

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

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

[Former Member]

Hi D MS,

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

Regards,

Sheetal

[Former Member]

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

[Former Member]

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

And i want this action for one time.

[pavanm592]

Hi ,

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

Regards,

Pavan

[Former Member]

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.

[Former Member]

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]

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.