SAP CLM: Set correct filter to customized query

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 😊