Customized Audit Trail report

[Former Member]

Hi Expert,

Instead of using the existing audit report "S_AHR_61016380", I would like to create a customized report for this. I try to go throguh the source code in this report, but no luck for me.

Could you please let me know the table name to store the audit trail data? I need to extract it myself and put it into my company's format.

Million thanks,

WF

[Former Member]

Hi Expert,

Instead of using the existing audit report "S_AHR_61016380", I would like to create a customized report for this. I try to go throguh the source code in this report, but no luck for me.

Could you please let me know the table name to store the audit trail data? I need to extract it myself and put it into my company's format.

Million thanks,

WF

[mvoros]

Hi,

one of the easiest way of figuring out which tables are used is using SQL trace (ST05). Simply activate trace for your transaction inST05, run your transaction and you will get list of all SQL queries performed in this report.

Cheers

[Former Member]

Hi

Just have a look at the view V_PTRV_APPR. Its a view combining PTRV_PERIO and PTRV_HEAD Tables.

We have used these two tables for our Audit Trail Report.

Hope this helps.

Harsh

[Former Member]

Hi Harsh,

I have lots of record from the standard audit report, but I cannot find any record in view V_PTRV_APPR.

Could you please let me know how to get record from these table?

Thanks,

WF

[Former Member]

Dear all,

I am now able to create my own report by using FM HR_INFOTYPE_LOG_GET_LIST & HR_INFOTYPE_LOG_GET_DETAIL.

Thanks a lot,

WF