Standard Query for My Opportunities in C4C

[ishwarya_doss]

Hi Experts,

Could you pls share how to find the underlying query for My Opportunities in C4C PDI??

I need to make changes to the standard query of My opportunities via PDI and not sure where to begin with.

[PrasanthArya]

Standard queries are hard coded and you will not be able to influence them even from PDI. Nevertheless you can try builing a new query by understanding the parameters

My Opportunities filter includes all Opportunities which you own (Where you are the owner), and all Opportunities in which you are maintained as Sales Employee.

[ishwarya_doss]

Appreciate the quick response! I see we can't view or copy the standard queries.. In case if I want to build a new query based on party role codes, which event will be ideal to trigger this new query on choosing My opportunities?

[PrasanthArya]

You can refer to https://blogs.sap.com/2016/06/01/how-to-add-custom-field-to-standard-query-as-parameter-2/

[ishwarya_doss]

Hi Prasanth,

I just checked this blog. But I'm not looking for adding any new fields.

I need to change the My opportunities query where the logged-in user is the Opportunity Owner or the owner of the Opportunity Account’s Territory or the Owner of Accounts in any Party Roles.

I'm trying to add the highlighted part to the standard My opportunities query. Any suggestions pls?

[former_member221362]

have a look at https://blogs.sap.com/2014/12/10/how-to-add-extension-fields-to-standard-queries-c4c-only/

https://answers.sap.com/questions/10496578/how-to-add-custom-query-parameters-to-standard-del.html

https://answers.sap.com/questions/12413706/change-the-my-opportunities-query.html