The source for Standard query fields

[Joanna]

Hi, Experts,

For standard query created by SAP, I want to check for some fields, which cds view is come from,

how to check the source for Standard query fields?

RGDS

Joanna Qiu

[JZijderveld · Accepted solution]

Hi Joanna,

Although I can't find the same query in my system and check it, I see all standard queries available in the app 'Custom Analytical Queries' There you have all the details of the data source. SAP has only limited editing the standard queries and mentions 'You do not have authorization to edit this query' but viewing and copying is allowed.

Can you find your query there?

rgds,

Jeroen

[Joanna · Accepted solution]

Hi, Jeroen,

I use APP: View Browser can see this query, but I find this query not released, so you can not see in the app 'Custom Analytical Queries'.

Yes , You are right, I can see all the details of the data source for all released standard queries.

Thanks a lot

RGDS

Joanna Qiu

[Amith_Nair · Accepted solution]

Hi Joanna,

Yes, your understanding is right! Because this is not released( and hence not standard) by SAP, you will not find this query in the custom Analytical Queries app. But in general, if you want to know the source- like which CDS view this is coming from, you should navigate to the section- Cross Reference tab which can be seen from your Screenshot.

Thanks! Amith Nair

[former_member132363]

You could make a CDS view that holds the requested data and then publish this as an odata API. I'd recommend a separate communication user to allow your supplier access the odata service.

[View Article](https://answers.sap.com/questions/13243232/view.html)

I hope this answered your question! If it did, please mark it as the 'Best Answer' so I can continue learning and answering questions in the community.