Delete logs of one client from table DBTABLOG

[Former Member]

Dear all,

I have to delete one client's data from the table DBTABLOG (Log Records of Table Changes).

In the transaction SCU3 (and program RSTBPDEL) I can only select between tables and time period, but not between clients.

Moreover, this table does not have MANDT field, so by definition it is client-independent. However, in my opinion it must somehow contain the number of the client where the table modification occured.

Does anybody have an idea how to delete from this table in a client-dependent way?

Thanks,

Gabor

[Former Member]

HI Gabor,

Use T-code se16 and access the table. select the entries to be deleted and can delete the entries throug de-bugg mode, if required can take help of Abaper.

Can correct me if i am wrong, it may help

Thnks

Baba

[Former Member]

Dear Baba,

In our system the table DBTABLOGS contains more than 32 million entries, so unfortunatelly I can not delete them from tr. SE16. My biggest problem is still selecting the table modifications happened in one particular client.

Regards,

Gabor

[Former Member]

You need to check parameter rec/client if you do not want to record table changes for a specific client.

Options are: ALL, 010, 100 etc.

If there is no MANDT field then you won't be able to seperate the client data.

Archive the data.

Rgds