SAP CLM: Set correct filter to customized query

[Private_Member_113126]

Hello experts,

I try to build a query which shall be useable to search a specific field in the contract document section (contract document tab after a contract was uploaded). This query below is just only a draft. According to the results I’ve got redundant entries (see screenshot)and I don’t know how to set an additional filter which delivers me correct results by using this query for search.

SELECT <%RESULTS%>

FROM <%SCHEMA%>.FCI_CONGEN_CONTRACT_DOC T1,

<%SCHEMA%>.FCI_CONTRACT T2,

<%EXT_TABLE(userdefined.bizdoc1, FCI_DYN_$2147483146)%> T3

WHERE

T2.IS_TEMPLATE=0

AND T2.CONTEXTID=<%CONTEXT(userdefined.bizdoc1)%>

AND T2.OBJECTID=T1.PARENT_OBJECT_ID

AND T1.PARENT_CLASS_ID = 1004

AND T3.ZCLM_CMS_CONNO LIKE ?

Has somebody any idea what to do?

Thanks in advance

Heiko

[former_member188515 · Accepted solution]

Hi Heiko,

There is no link condition between the 3 tables which you have used. Might be the reason for redundant entries.

Regards,

Yeshwanth K.S

[Private_Member_113126 · Accepted solution]

Hello Yeshwanth,

thanks for the help Yeshwanth I don't see so far that the link was missing. But now I've got it.

Regards,
Heiko