{"id":61379,"date":"2025-06-13T09:12:45","date_gmt":"2025-06-13T07:12:45","guid":{"rendered":"https:\/\/www.rapidviews.io\/?p=61379"},"modified":"2025-06-13T14:20:04","modified_gmt":"2025-06-13T12:20:04","slug":"find-the-standard-sap-cds-to-meet-my-functional-need","status":"publish","type":"post","link":"https:\/\/dev.rapidviews.io\/en\/blog\/bi-smart-repository\/find-the-standard-sap-cds-to-meet-my-functional-need","title":{"rendered":"Find the Standard SAP CDS to Meet My Functional Need"},"content":{"rendered":"\t\t
\n\t\t\t\t
\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

When analyzing SAP<\/a> data, identifying the right standard Core Data Services (CDS) view can quickly become a challenge, especially when trying to meet a specific functional requirement. The BI Smart Repository offers a powerful tool to simplify this task: the Analytics Wizard<\/strong><\/a>.<\/em>
This article explores how to leverage this feature to identify the most appropriate SAP CDS<\/a> view for a concrete use case: analyzing SD (Sales and Distribution) invoices<\/strong>. Thanks to the wizard, it becomes possible to efficiently navigate the complexity of available CDS views and pinpoint the one that meets your exact analytical needs.<\/em><\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t

\n\t\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

A Quick Look at the BI Smart Repository<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

The BI Smart Repository<\/a> is a Cloud-based solution that centralizes all your Analytics content (only metadata).
The goal of the platform is to provide a 360-degree view of your Analytics environment, helping to accelerate new developments and optimally maintain your BI landscape.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"Fiori\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

Build Your Business Requirement<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Within the BI Smart Repository, you can select the SAP fields and tables<\/strong> relevant to you. These fields may come from your business knowledge (e.g.: invoice number, document type, net amount, customer, currency\u2026), or simply from the items you want to analyze in your future report.<\/p>

Use Case:<\/strong>
I\u2019m a sales administrator<\/strong>, and as at the beginning of every month, I\u2019m asked to provide an analysis of issued invoices<\/strong>: total invoiced amount, breakdown by customer, types of invoices, monthly trends, etc.
Problem:<\/strong> SAP contains countless technical objects, and I don\u2019t know which CDS to use to quickly obtain the right data.
In the BI Smart Repository, I prepare my \u201cshopping list\u201d with the elements I want to see in my report: invoice number, item, customer, currency, invoice type, billing date, and net amount.<\/p>

To do this, I select the relevant SAP table:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"Fiori\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Then I select the field(s) related to my need:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"View\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Once my list is ready, I launch the Analytics Wizard<\/em> (right-hand panel on the screen) by clicking the \u201cShow Results\u201d button:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"Analytics\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t

The Analytics Wizard Does the Work<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Once your list is defined, the Analytics Wizard analyzes your selection and queries the RapidViews metadata database<\/strong>, which contains an intelligent mapping of SAP objects. It returns a list of objects (CDS views, views, or tables)<\/strong> compatible with your requirements.
Each result is ranked by relevance<\/strong>: the more fields from your list an object contains, the higher it appears in the suggestions.<\/p>

Use Case Continued:<\/strong>
Within seconds, it provides me with a list of SAP objects compatible with my needs, ranked by coverage rate. At the top of the list, I see the CDS view C_REVENUEFROMINVOICEQRY<\/code>, among others, which covers 100% of my requirement:<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\"Fiori\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
\n\t\t\t\t
\n\t\t\t\t\t\t\t\t\t

Thanks to RapidViews, I can now:<\/p>

  • Extract data<\/strong> from this CDS view<\/p><\/li>

  • Connect this view to a visualization tool<\/strong> (Power BI, Tableau, SAC\u2026)<\/p><\/li>

  • Build my dashboard: sales by customer, by month, by invoice type, etc.<\/p><\/li><\/ul>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t

    \n\t\t\t\t
    \n\t\t\t\t\t

    Conclusion<\/h2>\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t
    \n\t\t\t\t
    \n\t\t\t\t\t\t\t\t\t

    The BI Smart Repository, through its Analytics Wizard, allowed me to go from a clear business requirement to the right SAP CDS in just a few minutes<\/strong>. Translating a functional need into a technical object becomes accessible to everyone, even without advanced SAP expertise<\/strong>. A key tool to improve efficiency, autonomy, and the quality of analysis.<\/p>\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"

    When analyzing SAP data, identifying the right standard Core Data Services (CDS) view can quickly become a challenge, especially when trying to meet a specific functional requirement. The BI Smart Repository offers a powerful tool to simplify this task: the Analytics Wizard.This article explores how to leverage this feature to identify the most appropriate SAP […]<\/p>\n","protected":false},"author":19,"featured_media":61388,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[570],"tags":[606],"class_list":["post-61379","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-bi-smart-repository","tag-bi-smart-repository"],"_links":{"self":[{"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/posts\/61379","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/users\/19"}],"replies":[{"embeddable":true,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/comments?post=61379"}],"version-history":[{"count":0,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/posts\/61379\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/media\/61388"}],"wp:attachment":[{"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/media?parent=61379"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/categories?post=61379"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dev.rapidviews.io\/en\/wp-json\/wp\/v2\/tags?post=61379"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}