SAP Knowledge Base Article - Public

2911981 - Can Analytical Queries be published as OData APIs

Symptom

Is it possible to expose a Standard Query, such as the Project Profitability Query, an SAP Query, such as C_PROFITABILITY_Q0001, or a Custom Analytical Query as an OData API?

Environment

SAP S/4HANA Cloud

Resolution

  • External OData APIs require Communication Scenarios, Communication Arrangements, and Communication Users to be defined 
  • Analytical Queries including Custom Analytical Queries, use internal protocols to access HANA Databases
  • These protocols cannot be accessed by external users including Communication Users
  • Therefore, Communication Scenarios and Communication Arrangements cannot be created for Analytical Queries
  • There are currently no plans to enhance S/4HANA Cloud to enable this support

Keywords

Communication, Scenario, Arrangement, Custom, Analytical, Query, OData API , KBA , BC-SRV-APS-EXT-AQD , Fiori based Query Designer , BC-SRV-APS-GKE , Generic CDS Key User Editor , BC-SRV-APS-COM , Maintain Communication System and Arrangement , How To

Product

SAP S/4HANA Cloud Public Edition all versions ; SAP S/4HANA Cloud all versions