Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Adding Queries To The Top Level Navigation

Good evening Gurus,

I added a query definition(Assigned To Me) at top level navigation but for certain users it doesn't appear. The users that have the query(Assigned To Me) at top level navigation have the "create master agreement role" and the users that don't have the query(Assigned To Me) at the top level navigation don't and shouldn't have the "create master agreement role".

Attached are images to give more details.

Image with the query(Assigned To Me)

Image without the query(Assigned To Me)

The Assigned To Me Query Code:


SELECT <%RESULTS%>

FROM

<%SCHEMA%>.FCI_MAS_VALUE_LIST_VALUE T4,

<%SCHEMA%>.FCI_CONTRACT T1

JOIN

<%COLLABCHECK_TBL(T1.OBJECTID, 1004)%>

LEFT OUTER JOIN (SELECT PARENT_OBJECT_ID, COUNT(*)

AS AGR_COUNT FROM <%SCHEMA%>.FCI_AGREEMENT

GROUP BY PARENT_OBJECT_ID) T2

ON T1.OBJECTID = T2.PARENT_OBJECT_ID

LEFT OUTER JOIN <%SCHEMA%>.FCI_MAS_INTERNAL_CAT T3

ON T1.INT_CAT_OBJECT_ID = T3.OBJECTID

<%DYN_JOIN%>

WHERE

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

AND T1.IS_TEMPLATE =0

AND T1.STATUS_OBJECT_ID = T4.OBJECTID

<%AND_OP("UPPER(T1.DISPLAY_NAME)",<%?(T1.DISPLAY_NAME)%>)%>

<%AND_OP("UPPER(T1.VENDOR_OBJECT_NAME)",<%?(T1.VENDOR_OBJECT_NAME)%>)%>

<%AND_OP("T1.EXPIRATION_DATE_DATE",<%?(T1.EXPIRATION_DATE_DATE)%>)%>

<%AND_OP("T1.INT_CAT_OBJECT_ID",<%?(T1.INT_CAT_OBJECT_ID)%>)%>

<%AND_OP("T1.INACTIVE",<%?(T1.INACTIVE)%>)%>

<%AND_OP("T1.DOC_TYPE_OBJECT_ID",<%?(T1.DOC_TYPE_OBJECT_ID)%>)%>

AND

(

(<%?(MyOwnership)%> =2)

OR

(T1.DOC_OWNER_USER_OBJECT_ID=<%CURRENT_USER_ID%>)

)

<%DYN_FILTER%>

<%ORDERBY%>

Tags:
Former Member
Former Member replied

Hello Sabelo,

Add the query(Assigned To Me) in FCI-ContractBuyList Query Group. This resolves your issue.

Regards,

Vignesh

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question