Customizing Agreement Cover Page Query

[Former Member]

Hi Gurus

We are implementing SAP CLM 10

A newb question

I need to add an extension to the Agreement Cover page report.

The query is the following one :

SELECTFROM.FCI_AGREEMENT T1 LEFT OUTER JOIN.FCI_MAS_VALUE_LIST_VALUE T2 ON (T1.STATUS_OBJECT_ID = T2.OBJECTID) LEFT OUTER JOIN.FCI_MAS_VALUE_LIST_VALUE T3 ON (T1.REPLENISHMENT_OBJECT_ID = T3.OBJECTID) LEFT OUTER JOIN.FCI_MAS_VENDOR T4 ON (T1.VENDOR_OBJECT_ID = T4.OBJECTID) LEFT OUTER JOIN.FCI_MAS_PAYMENT_TERM T5 ON (T1.PAYTERMS_OBJECT_ID = T5.OBJECTID) LEFT OUTER JOIN.FCI_MAS_INTERNAL_CAT T6 ON (T1.INT_CAT_OBJECT_ID = T6.OBJECTID) LEFT OUTER JOIN.FCI_MAS_EXTERNAL_CAT T7 ON (T1.EXT_CAT_OBJECT_ID = T7.OBJECTID) LEFT OUTER JOIN.FCI_MAS_LOCATION T8 ON (T1.LOCATION_OBJECT_ID = T8.OBJECTID),.FCI_CONTRACT CON WHERE T1.CONTEXTID IN () AND T1.OBJECTID = ? AND T1.PARENT_OBJECT_ID = CON.OBJECTID

The extension field name is "TEST"

How can I insert that field in the report?

Thanks in advance

[Former Member]

Hi Le,

Add the following code to query, and use T2 to get the extension field.

LEFT OUTER JOIN <%EXT_TABLE(contracts.Agreement)%> T2 ON T2.PARENT_OBJECT_ID=TI.OBJCETID

Hope it helps!

Regards,

Geetika