How to audit table in SAP

[Former Member]

Dear Guru,

I have some requirement to track who has accessed table (Read Only).

For example: who is read data from salary table or material price table?

If ABAPer write some abap code to select data from that table directly, how can auditor know?

Are there standard report to check?

Hope you can help us.

Thank you very much.

Saiyaman

[Former Member · Accepted solution]

Hi,

You can track tables via ST10 and any ABAP script via ST05.

Let me know for any further issues.

[Former Member · Accepted solution]

Dear Manaswi .

ST10 is look good I see how many record to read, update, insert but I can not found the username who access the table.

Please kindly advice step by step.

Thank you very much.

Saiya

[Former Member · Accepted solution]

Hi,

I hope SAP Note:Note 113008 - DB2/390: Maintaining Catalog Statistics can help you.

Let me know the result.

[Former Member · Accepted solution]

Okay. Thank you very much. I'll check the note

[nelis]

Hi,

As far as I know there is no way to track reads from a specific table only changes(update, delete) through enabling table logging(see parameter rec/client). However, if you have setup your authorizations correctly which should prevent any unwanted access to area's where an ABAP'er could access a table ie SE11/SE16 then the audit logs(SM20) would show those transactions being accessed by them.

Nelis

[Former Member]

Hi Nelis,

Thank you very much for your advice.

I'm waiting other advice.

Thank you.