Data

SAP Fiori Tips: Find the Underlying Bex Query and CDS View of a Fiori App

, Created on December 11, 2020
Last updated on May 18th, 2023 at 10:18 am by Kalyan Dittakavi


SAP Fiori can use a BEX Query as the source, based on a Transient provider. This Transient Info Provider is based on a CDS view. If you can find the underlying Bex Query and CDS view of an SAP Fiori app, that’s a good way to trace it back to the backend. As we’ll show, RSRT would provide useful information to find the underlying CDS view. This document will explain how to find the Bex Query, CDS view, and some important information from SAP Fiori Apps Library.

I am taking Journal Entry Analyzer (SAP S/4HANA) – Design Studio as an example. You can find the app in the SAP Fiori Apps Library. I am using SAP S/4HANA 1909 FPS02 version. Sample data looks like this:

Find the underlying Bex Query

How to Find the Underlying Bex Query and CDS View of a Fiori App

  • Scroll down to configuration in the implementation info:

Find the underlying Bex Query SAP Fiori

  • Under configuration, scroll all the way down, and you would see the BEX query:

  • Notice the 2C at the starting. This is a Transient provider. Copy the BEX Query tech name and logon to SAP S/4HANA, and go to RSRT T code.
  • In RSRT, once you give the query tech name (and hit enter), click on Technical Information:

Find the underlying Bex Query SAP Fiori

  • Under Technical Information, you would find DDL Source, which is the CDS view Tech name. Notice the Data Targets 2CIFIGLLITMCUBE, which has TRPR. This is the Transient Info Provider.

  • Take the DDL Source and go to ABAP Perspective in HANA Studio to find the CDS view definition: You can either go through the root package and find the CDS view, or an easier way is to push CNTL+SHIFT+A and paste the DDL here.

Find the underlying Bex Query SAP Fiori CDS View

Find the underlying Bex Query SAP Fiori CDS View

Keep Going

Now that you’ve gone through this step-by-step guide to find the underlying Bex Query and CDS View of a Fiori App, you can trace the origin of your Fiori Apps to backend development.

Talk to a Rizing Expert

Whether you’re just getting started or are well on your way, we can help.