Advanced CDS Views Series: Part 2 – Analytical CDS Health Check
In the world of SAP data modeling and analytics, Core Data Services (CDS) views play a pivotal role in enabling real-time data access, semantic richness, and performance optimization. But just like any critical component in an SAP landscape, CDS views need regular monitoring and validation to ensure they remain reliable, performant, and aligned with business logic.
This is where a few lesser-known but incredibly powerful SAP tools come into play which will be introduced in this blog: T-code RSRTS_ODP_DIS and RSRTS_QUERY_CHECK. These utilities are vital for checking the health and runtime status of CDS-based queries, troubleshooting ODP (Operational Data Provisioning) connections, and validating backend consistency – all essential tasks for BW/4HANA and S/4HANA environments that rely heavily on virtual data models.
In this blog, we’ll explore how each of these tools works, when and why you should use them, and how they help prevent hidden issues that could compromise data accuracy or query performance. Whether you’re a BW consultant, a HANA developer, or a system administrator, understanding these transactions can save you hours of debugging and help ensure your CDS views remain in peak condition. Let’s dive in!
RSRTS_ODP_DIS(Display TransientProvider Preview for Operational Data Provider)
RSRTS_ODP_DIS is a diagnostic and testing tool used to display and validate Operational Data Provisioning (ODP) objects aka Analytical CDS Cubes. Its main purpose is to ensure that the ODP infrastructure is correctly delivering data from the source to target consumers like CDS queries, SAP Data Intelligence, or external tools via OData or RFC. For example, enter the name of the transient provider and it will display the key fields, key figures and dimensions along with information such as whether the fields have hierarchy association and text association
The result shown below is the output with different indicators:
Dark Yellow represents Key Fields
Light Yellow represents Dimensions or Key Figures
Green Box Icon represents that the field has associations defined
Green Quote Icon represents that the field has text associations defined
Green Tree Icon represents that the field has hierarchy associations defined
Another important feature here is the Check Metadata button. This will perform checks specificlly for analytical functionalities such as text/hierarchy associations and analytical annotations. (The same check can be performed in ABAP Development Tool)
RSRTS_ODP_DIS(Check for CDS Query Metadata)
RSRTS_ODP_DIS (Operational Data Provisioning – Display/Test) is a built‑in SAP diagnostics transaction designed to help BW / ABAP developers to inspect and validate ODP (Operational Data Provisioning) sources, particularly those exposed via Core Data Services (CDS) views or classic BW InfoProviders.
One thing to note here is that the title says it’s ‘Test for CDS based BW queries’, but the check tool performs doesn’t limit to BW queries but also ABAP CDS based embedded analytical queries.
To run the report, enter the CDS query or BW query name that needs to be checked. In below, I ran with standard CDS query C_GLLineItemsQ0001. The tool will check the metadata of the CDS query and return error, warning and information.
Check out other blog posts from Advanced CDS Views Series: