Question Re: Administration Activity Audit(Archive Activity) in Financial Management Q&A

Administration Activity Audit(Archive Activity)

Former Member — Wed, 13 May 2015 19:43:40 GMT

Hi,

We are on SAP BPC NW10,SP10.

"Audit Administration Activity" is enabled in our environment.I am able to see the administration activity as well.

I have executed Archive Activity DMP(/CPMB/ARCHIVE_ACTIVITY).As per the time stamp given in the DMP audit data is being purged.

But where can we see the audit activity data?There is no data at all in "UJU_AUDDATAHDR_A".

After running this DMP where this archived data resides?How to delete the data from those archived tables?

I got good information for "Archive data" in http://scn.sap.com/docs/DOC-63571 document.

Can anybody help me with Archive Activity functionality?

Thanks,

Manohar

Re: Administration Activity Audit(Archive Activity)

Former Member — Thu, 14 May 2015 09:17:21 GMT

Hi Manohar,

the table you are looking at contains NOT the whole amount of audit data. If you wanna see the activity audit data itself you have to use the following tables:

UJU_AUDACTDET - Activity Audit Detail

UJU_AUDACTDET_A - Activity Audit Detail - Archived

From this tables you can delete all entries.

Best regards,

Karsten

Re: Administration Activity Audit(Archive Activity)

Former Member — Thu, 14 May 2015 12:46:04 GMT

Hi Karsten,

Thanks for the response.Yes,those tables have the data.

UJU_DELETE_AUDIT_DATA program can be used to delete the audit data.Do we have any such program/T code to delete the data from UJU_AUDACTDET,UJU_AUDACTDET_A tables?

I Don't have access to delete the entries manually from SE11.If I delete data from SE14,all data will be deleted right?

Thanks,

Manohar

Re: Administration Activity Audit(Archive Activity)

Former Member — Thu, 14 May 2015 12:46:47 GMT

Hi Karsten,

Thanks for the response.Yes,those tables have the data.

UJU_DELETE_AUDIT_DATA program can be used to delete the audit data.Do we have any such program/T code to delete the data from UJU_AUDACTDET,UJU_AUDACTDET_A tables?

I Don't have access to delete the entries manually from SE11.If I delete data from SE14,all data will be deleted right?

Thanks,

Manohar

Re: Administration Activity Audit(Archive Activity)

JefB — Wed, 08 Jun 2016 09:02:40 GMT

Hi Reddy,

Did you find a program to delete activity audit records?

Or any other solution?

Re: Administration Activity Audit(Archive Activity)

Former Member — Wed, 08 Jun 2016 12:46:22 GMT

Hi Jef,

SE14 is the only option.I am retaining 90 days data in UJU_AUDACTDET.Once I run DMP, deleting all the entries from UJU_AUDACTDET_A from SE14.

Regards,

Manohar