3792211 - HTTP 500 Error When Creating a Model from API_GRTRANSACTIONDATA_SRV in SAP Analytics Cloud

• When attempting to create a new model in SAP Analytics Cloud (SAC) using the OData Services connection to the S/4HANA service API_GRTRANSACTIONDATA_SRV, the import job fails with the following error: The following error message comes from the external data service: Response from external server has status code of 500.
• The error occurs specifically when using the Build a Query wizard and selecting the GRTransactionData entity set. The OData connection itself saves successfully, and the service metadata endpoint ($metadata) returns data without issues.

SAP Analytics Cloud 2026.8.17

Two factors combined cause this error:

1. GRTransactionData is a parameterized CDS view

The GRTransactionData entity in API_GRTRANSACTIONDATA_SRV is not a plain entity set — it is a parameterized CDS view that acts as an input parameter container. It requires the following four mandatory, non-nullable input parameters to be supplied with every request before S/4HANA will execute and return data: 

• P_KeyDate
• P_ConsolidationUnitHierId
• P_ConsolidationPrftCtrHierId
• P_ConsolidationSegmentHierId

When these parameters are not supplied, S/4HANA cannot process the request and returns an HTTP 500 error. This behaviour is documented in the SAP S/4HANA API reference: Transaction Data for Group Reporting - Read | SAP Help Portal 

The correct usage pattern for this entity is:

GRTransactionData(P_ConsolidationUnitHierId='...',P_ConsolidationPrftCtrHierId='...',P_ConsolidationSegmentHierId='...',P_KeyDate=datetime'...')/Results

The actual business data is returned via the OData navigation property /Results, not directly from the GRTransactionData entity itself.

2. The SAC Query Builder does not prompt for parameter values

The SAC Build a Query wizard correctly reads the mandatory parameters from the service metadata and includes them in the query definition. However, it does not prompt the user to supply values for these parameters before executing the data fetch job. As a result, the request is sent to S/4HANA with an empty filter set ("operands": []), which S/4HANA rejects with HTTP 500 because all four parameters are mandatory and non-nullable.

This is a known limitation of the Build a Query wizard when used with parameterized CDS-based OData services. The SAC documentation explicitly notes this for GRTransactionData and the related CnsldtnGrpJrnlItem service, directing users to supply the parameters manually: Import Data Source Reference for SAP S/4HANA

Use the Freehand Query option instead of the Build a Query wizard. Freehand Query allows the mandatory parameters to be supplied directly in the query string, bypassing the wizard limitation.

Steps:

1. In SAC, navigate to Files and open or create your model.
2. Under Data Management, choose Import Data > Data Source > OData Services.
3. Select your API_GRTRANSACTIONDATA_SRV connection and choose Create a new query.
4. On the New Query for OData Services dialog, select Freehand Query.
5. Enter a query name (e.g. GRTransactionDataQuery).
6. Paste the following into the Query box, adjusting the values for your system:
   GRTransactionData(P_ConsolidationUnitHierId='$',P_ConsolidationPrftCtrHierId='$',P_ConsolidationSegmentHierId='$',P_KeyDate=datetime'2024-01-01T00:00:00')/Results?$select=FiscalYearPeriod,ConsolidationUnit,FinancialStatementItem,ProfitCenter,SubItem,SubItemCategory,AmountInLocalCurrency,AmountInGroupCurrency&$filter=ConsolidationVersion eq 'Y10' and PeriodMode eq 'PER' and FiscalYear eq '2024' and (FiscalPeriod ge '000' and FiscalPeriod le '012')
7. Choose Create. The query will execute against S/4HANA and return a column preview for mapping.

Note: Using '$' as the value for the three hierarchy parameters is explicitly supported and means "no hierarchy restriction". This is documented in Transaction Data for Group Reporting - Read | SAP Help Portal

• Transaction Data for Group Reporting - Read | SAP Help Portal
• Import Data Source Reference | SAP Help Portal
• Importing Group Financial Actual Data to SAP Analytics Cloud | SAP Help Portal
• KBA 2569847 - Where can you find SAC user assistance (help) to use, configure, and operate it more effectively?
• KBA 2487011 - What information do I need to provide when opening a case for SAP Analytics Cloud?
• KBA 2511489 - Troubleshooting performance issues in SAP Analytics Cloud
• SAP Analytics Cloud Connection Guide
• SAP Analytics Cloud Get More Help and SAP Support
• Need More Help? Contact Support 

  Your feedback is important to help us improve our knowledge base.

SAP Analytics Cloud, SAC, OData, API_GRTRANSACTIONDATA_SRV, GRTransactionData, Group Reporting, S/4HANA, 500 error, HTTP 500, external server error, mandatory parameters, parameterized CDS view, P_KeyDate, P_ConsolidationUnitHierId, P_ConsolidationPrftCtrHierId, P_ConsolidationSegmentHierId, Build a Query, Freehand Query, model creation, import job, data acquisition, PLUGIN_ERROR, ERROR_FROM_EXTERNAL_SERVER, query builder limitation, CDS parameters, OData connection, data import, SAC modeler. , KBA , LOD-ANA-AQU-ODATA , Acquiring Data into SAC using an ODATA connection , LOD-ANA-AQU-CLD , Data acquisition from Cloud-based (non-OData) sources , LOD-ANA-AQU , Import Data Connections (Acquiring Data) , Known Error