on 2016 May 31 6:46 PM
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
Hello Experts,
Can any one through light on this ?
Thanks,
Vinay
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.