Administration Activity Audit(Archive Activity)

[Former Member]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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

[Former Member · Accepted solution]

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

[JefB · Accepted solution]

Hi Reddy,

Did you find a program to delete activity audit records?

Or any other solution?

[Former Member · Accepted solution]

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