Custom Report For AUDIT !

[Former Member]

Hello Experts,

I have a question regarding custom report in CLM.

We are trying to build a report for custom fields and standard fields where we want to get both old values maintained in the field (History) and new field values , so that the AUDIT person who reviews this report knows what was changed ,does the custom table or the standard tables in CLM holds both the values.

If yes, Can you please help me finding the tables?

Thanks,

Vinay

[Former Member]

Hello Experts,

Can any one through light on this ?

Thanks,
Vinay

[former_member227405]

HI Roopesh,

I want to tell you the approach for your requirement.

1)You have to create a custom collection for the attribute what you want to show in audit

like change FIELD_NAME,Changed by,Old value ,new value ,changes Date etc.

2)You have to write a java code for storing the old value by taking the DB reference and Current Value using DOC reference and definitely take help from RG to import the correct package.

like

import com.sap.odp.api.ibean.IBeanHomeIfc;

import com.sap.odp.api.ibean.IBeanHomeLocator;

import com.sap.odp.api.ibean.IBeanIfc;

import com.sap.odp.api.ibean.metadata.IBeanCollectionMdIfc;

after done with the code this Custom jar need to be deploy.

follow the step as Bogdan Toma suggested:

3)You have to call the class method from the Script written under script description  on Validate for The Document.

4)Write a query  under query definition by using the custom collection and main document and use the result filed as you want.

5) make this query as a reference Report  or query group.

Hope this will hep you.

Thanks

Sonu