on 06-29-2011 12:57 AM
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
hi
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.