cancel
Showing results for 
Search instead for 
Did you mean: 

Issue: Data Not Displaying on CDS Endpoint Despite Presence in HANA Table

Jayanth_Kumar85
Explorer
0 Kudos
285

The Issue:

While working with SAP S/4HANA or SAP Cloud Platform, I encountered an issue where data in the HANA database table is not visible via the CDS endpoint, despite the data being present and accessible directly from the HANA table.


Here's a summary of the issue:

  • The data exists in the HANA table (Attached an image below).
  • A CDS view is defined to expose the data via an OData endpoint.
  • The OData service is properly registered, and the metadata is available.
  • However, when consuming the OData service, no data is returned, even though it should be.

Jayanth_Kumar85_0-1736706581076.png

 

Jayanth_Kumar85_1-1736706663437.png

 

Troubleshooting Steps We Tried:

Here are the troubleshooting steps we attempted to resolve the issue:

  1. Clearing Cache and Restarting Services
  2. Reviewing the CDS View Definition
  3. Verifying Service Registration
  4. Checking User Authorization

Investigating HANA CLI Query Results

Seeking Help from the SAP Community:

As I have encountered this issue in my own project, I would like to reach out to the SAP community for assistance. If anyone has experienced this problem or has insights on what might be causing this discrepancy, your input would be greatly appreciated.


I would love to hear from anyone in the SAP community who has encountered this issue before. Please share your insights, troubleshooting tips, or solutions to help resolve this issue. Your input will be invaluable in understanding and overcoming this challenge.

SAP Community

Node.js 

SAP HANA Cloud 

SAP HANA service for SAP BTP 

Accepted Solutions (0)

Answers (0)