cancel
Showing results for 
Search instead for 
Did you mean: 

Master Agrement Search must include Perpetual Contracts

Former Member
0 Kudos

Hi Experts,

Please suggest I have new requirement in SAP CLM . I have code written in report for MA Search and and it is working fine however I need to Enhance the perpetual condition in the below mentioned creteria..

The master agreement advanced search report does not include Perpetual contracts. It must be updated to do so. 1) Add a check box next to the 'Expiration Date Before' along with "Include perpetual contracts?" 2) If the box is checked, the search results will include a) any regular contract with the user-inputted effective date & expiration date range and b) any perpetual contract with an effective date within the user-inputted effective date range

WHERE T1.INACTIVE=0

AND T1.IS_TEMPLATE = 0

AND T1.CONTEXTID = <%CONTEXT(contracts.Contract)%>

AND ((T1.EXPIRATION_DATE_DATE >= <%TODAY%>) OR(T1.PERPETUAL_TERM=1))

AND

WHERE T5.INACTIVE=0

AND T5.CONTEXTID = <%CONTEXT(contracts.Agreement)%>

AND ((T5.EXPIRATION_DATE_DATE >= <%TODAY%>) OR(T5.PERPETUAL_TERM=1))

AND ((?=0) OR T5.STATUS_OBJECT_ID= ?)

AND

Please help what/how to make logic/code for the above requirement in the mentioned code.

Many Thanks

Iqbal

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

hi