Symptom
After configuring an SAC Connection to S/4HANA using Data Service URL (OData), not all views are visible to use.
Environment
- SAP Analytics Cloud
- S/4HANA on-premise
Cause
- Create connection for S/4HANA on-premise
- Use this connection to create a story
- Find that not all views that exist in S/4HANA are visible
Resolution
The SAP S/4HANA administrator must use the ABAP Development Tools for SAP NetWeaver to add the "@Analytics.query: true" Annotation to the required CDS Views.
If this was not done, it should resolve the issue.
If not, please use a tool like Postman to test your Data Service URL (OData connection) with same credentials and see if the view or query is visible. If it is not, then it won't be an issue in SAC and it will need to be investigated from the S/4HANA side.
Keywords
S4 S/4HANA Missing view missing query sac , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , Problem
SAP Knowledge Base Article - Public