5Steps2Analytics – Technical Objects

Understanding technical objects of embedded analytics

Public

Brought to you by:

SAP Enterprise Support Value Maps SAP Analytics Solutions

SAP S/4HANA Regional Implementation Group

1
Table of Contents

INTRODUCTION .............................................................................................................................................. 3
EXERCISE 1 – KPI application F1733 Aging Analysis ................................................................................... 4
EXERCISE 2 – WebDynpro Grid F0996 Trial Balance .................................................................................. 34

2
INTRODUCTION
By executing the steps described in this document you (typically as an analytics expert) will understand the following technical objects of SAP Fiori analytical apps.
1. CDS View
2. Fiori Tile
3. Catalog
4. Group

3
EXERCISE 1 – KPI APPLICATION F1733 AGING ANALYSIS
In this exercise, we will open the technical objects used in a standard SAP Fiori app F1733 Aging Analysis to understand the technical
objects used in the KPI application.

4
 ü CDS View as the source
ü Consumption View: C_APFlexibleAging
ü Interface View: I_APFlexibleAging
ü App and Tile
ü KPIs: Aging Analysis (ID: “.SAP.AP.FLEXAGING.AMOUNT”)
ü Visualize: Aging Analysis
ü Report Name: Aging Analysis
ü Semantic/Action: AgingAnalysisKPI/analyzeSBKPIAgingAnalysis
ü Role: SAP_BR_AP_MANAGER
ü Catalog: SAP_SFIN_BC_AP_ANALYTICS (Accounts Payable – Analytics)
ü Group: SAP_SFIN_BCG_AP_ANALYTIC (Analytics for Accounts Payable)

What to understand in this exercise:

ü Find the VDM (CDS View) with View Browser
ü Test OData Service with Transaction /IWFND/MAINT_SERVICE
ü Find KPI app definition with Manage KPIs and Reports
ü Find Catalog and Group in Launchpad Designer
ü Find Catalog and Group in PFCG Role menu.
ü Find Catalog with Manage Launchpad Business Catalogs (S/4HANA 2020)
ü Find Catalog and Group in Fiori launchpad (S/4HANA1909)

5
Steps / Comments Screenshot

1. Firstly, check the objects in F1733 Aging

Analysis.
URL:
https://fioriappslibrary.hana.ondemand.c
om/sap/fix/externalViewer/#/detail/Apps
('F1733')/S19OP
Ø Go to IMPLEMENTATION
INFORMATION > Configuration
We find the following objects are used
in the app F1733.
OData: C_APFLEXIBLEAGING_CDS
Target Mapping:
AgingAnalysisKPI
/analyzeSBKPIAgingAnalysis
Business Catalog:
SAP_SFIN_BC_AP_ANALYTICS
Business Group:
SAP_SFIN_BCG_AP_ANALYTIC
Business Role:
SAP_hBR_AP_MANAGER

6
Steps / Comments Screenshot

1. Launch View Browser in GROUP “Query

Design”.

URL
https://<Server
name>:<Port>/sap/bc/ui2/flp#Shell-
home

CAL instance
https://vhcals4hcs.dummy.nodomain:4
4301/sap/bc/ui2/flp#Shell-home

Information provided here is an example only. Same applies throughout document.

If you would like to use the Cloud Appliance Library you will need to subscribe and set up your
account: https://cal.sap.com/

7
Steps / Comments Screenshot

2. Search with the VDM name

“C_APFlexibleAging”. This View is the
consumption View of the App F1733
Aging Analysis.

8
3. Now we can see the content the VDM Definition
(Definition (Fields), Annotation, Cross
Reference (Associated Views)).

In the annotation, you can find

ODATA.PUBLISH True
ANALYTICS.QUERY True
VDM.VIEWTYPE #Consumption

Annotation

Cross Reference

9
Steps / Comments Screenshot

4. Push “Back”

10
Steps / Comments Screenshot

5. Search with “I_APFlexibleAging” and

select the entry in the table. This View
is the Interface View of the
Consumption View
“C_APFlexibleAging”.

6. Detail of the view is displayed. DEFINITION

ANNOTATION

11
Steps / Comments Screenshot

7. Now we can see the content the VDM ANNOTATIOn

(Definition (Fields), Annotation, Cross
Reference (Associated Views)).

In the annotation, you can find

ODATA.PUBLISH True
ANALYTICS.QUERY True
VDM.VIEWTYPE #Composite

12
Steps / Comments Screenshot

8. Push “Back“.

9. It is possible to search the CDS Views

with the table or column name. Search
with “BSEG“.
The CDS Views which uses the object
whose name include “BSEG“ are listed.

13
10. The OData Service can be activated and
tested with SAPGUI Transaction
/IWFND/MAINT_SERVICE. Run this
transaction in SAPGUI.
Launch WebGui and enter user/PW.

URL
https://<Server
name>:<Port>/sap/bc/ui2/flp#Shell-
home.dummy.nodomain:44301/sap/bc/
gui/sap/its/webgui#

CAL
https://vhcals4hcs.dummy.nodomain:4
4301/sap/bc/gui/sap/its/webgui#

Information provided here is an example only.

If you would like to use the Cloud Appliance Library you will need to subscribe and set up your
account: https://cal.sap.com/

14
Steps / Comments Screenshot

11. For displaying the field for transaction,

after logging in, go More > GUI Actions
and Settings > Settings

15
Steps / Comments Screenshot

12. Set Show OK Code fields to ON and

push Save

16
Steps / Comments Screenshot

13. Now the transaction field appears. Enter

“/n/IWFND/MAINT_SERVICE“ to test
OData service.

14. Push (Find) and search with

“C_APFlexibleAging“.

17
Steps / Comments Screenshot

15. After selecting the searched OData

Service, Push “Call Browser“.

18
Steps / Comments Screenshot

16. The metadata of the OData Service

C_APFLEXIBLEAGING_CDS is
retrieved directly to the browser with
XML format.

URL.
http://<Server
name>:<Port>/sap/opu/odata/sap/C_A
PFLEXIBLEAGING_CDS/?$format=xm
l

URL of CAL instance:

http://vhcals4hcs.dummy.nodomain:50
000/sap/opu/odata/sap/C_APFLEXIBL
EAGING_CDS/?$format=xml

17. As is OData Service, it is possible to set

the data and the format in the URL. In
the following URL, the data of
Company code is retrieved with json
format.
URL of CAL instance:
http://vhcals4hcs.dummy.nodomain:50
000/sap/opu/odata/sap/C_APFLEXIBL
EAGING_CDS/?$format=json

19
Steps / Comments Screenshot

18. Open the application definition with

“Manage KPIs and Reports“.

Launch “Manage KPIs and Reports“ by

logging in FIori launchpad and slect
KPI Design and run “Manage KPIs and
Reports“.

URL
https://<Server
name>:<Port>/sap/bc/ui2/flp#Shell-
home

CAL instance
https://vhcals4hcs.dummy.nodomain:4
4301/sap/bc/ui2/flp#Shell-home

20
Steps / Comments Screenshot

19. Go to KPIs tag and search with “Aging

Analysis“ (or CDS View name), and
click the entry in the table.

20. Now the KPI definition is displayed. Go

to “Visualize“ tab and click “Aging
Analysis“ tab. We can see the detail oft
he tile.

21. Click report name “Aging Analysis“

21
Steps / Comments Screenshot

22. In the definition of the report, click “Show

Preview“

23. Now the KPI app is displayed.

By clicking the home log in top left, go
back to the home in Fiori launchpad.

22
Steps / Comments Screenshot

24. (For S/4HANA~1909) To check the

Catalog and Group, launch Launchpad
Designer.

URL:
https://<host
name>:<Port>/sap/bc/ui5_ui5/sap/arsr
vc_upb_admn/main.html?scope=CUST
&sap-client=<Client>&sap-
language=<Language Key>

URL in CAL:
https://vhcals4hcs.dummy.nodomain:4
4301/sap/bc/ui5_ui5/sap/arsrvc_upb_a
dmn/main.html?scope=CUST&sap-
client=100&sap-language=EN

25. (For S/4HANA~1909) Search with the

catalog name
“SAP_SFIN_BC_AP_ANALYTICS”,
and select the searched entry.
Then the tiles in the catalog are
displayed in the right side..

The tile of Aging Analysis is there in

the right side.

23
Steps / Comments Screenshot

26. (For S/4HANA~1909) Click the icon

Target Mapping, and select semantic
tag “AgingAnalysisKPI” and push
“Configure” at the buttom.

24
Steps / Comments Screenshot

27. (For S/4HANA~1909) Now the

definition of the target mapping is
displayed.

Evaluationid :
“.SAP.AP.FLEXAGING.AMOUNT”
(KPI ID in Manage KPIs and Reports)

Push Navigate back.

28. (For S/4HANA~1909/2020~) Push

“Group” on top left, and search with
“SAP_SFIN_BCG_AP_ANALYTIC”,
and choose the searched entry
“Analytics for Accountants Payable”.
We will find the “Aging Analysis” in
right side.

URL:
https://<host
name>:<Port>/sap/bc/ui5_ui5/sap/arsr
vc_upb_admn/main.html?scope=CUST
&sap-client=<Client>&sap-
language=<Language Key>

URL in CAL:
https://vhcals4hcs.dummy.nodomain:4
4301/sap/bc/ui5_ui5/sap/arsrvc_upb_a
dmn/main.html?scope=CUST&sap-
client=100&sap-language=EN

25
Steps / Comments Screenshot

29. (For S/4HANA2020~) Login Fiori

launchpad and launch Manage
launchpad Business Catalog under
Fiori launchpad tab.
With this tool, the Tile and Target
mapping can be included in Business
Catalog.

URL
https://<Server
name>:<Port>/sap/bc/ui2/flp#Shell-
home

CAL instance
https://vhcals4hcs.dummy.nodomain:4
4301/sap/bc/ui2/flp#Shell-home

26
Steps / Comments Screenshot

30. (for S/4HANA2020~) Search in

“Search Catalog” with
“SAP_SFIN_BC_AP_ANALYTICS” and
select the entry in Catalogs. In the
Content in Catalog section, select the
combination of Semantic Object and
Action
AgingAnalysisKPI/analyzeSBKPIAging
Analysis, and push “Details” .

27
Steps / Comments Screenshot

31. (For S/4HANA2020~) We can find Tile

Semantic Parameters
EvaluationId=.SAP.AP.FLEXAGIN
G.AMOUNT.

28
Steps / Comments Screenshot

32. Launch WebGUI. Run the transaction

PFCG and open the role
SAP_BR_AP_MANAGER (Edit).

WebGUI
URL
https://<Server
name>:<Port>/sap/bc/ui2/flp#Shell-
home.dummy.nodomain:44301/sap/bc/
gui/sap/its/webgui#

CAL
https://vhcals4hcs.dummy.nodomain:4
4301/sap/bc/gui/sap/its/webgui#

29
Steps / Comments Screenshot

33. In the menu tab, we can find the

Catalog
SAP_SFIN_BC_AP_ANALYTICS
And Group
SAP_SFIN_BCG_AP_ANALYTIC
are in the menu.

30
Steps / Comments Screenshot

34. Go to User tab and confirm this role is

assigned to your user.

31
Steps / Comments Screenshot

35. Launch Fiori launchpad, and point User

icon and select App Finder.

Fiori launchpad:

URL
https://<Server
name>:<Port>/sap/bc/ui2/flp#Shell-
home

CAL instance
https://vhcals4hcs.dummy.nodomain:4
4301/sap/bc/ui2/flp#Shell-home

36. We find the catalog “Accounts Payable

– Analytics”. After selecting the
Catalog, the tiles in the catalog are
displayed in the right side.
The tile can be assigned to the Group,
but nothing needs to be done as the
tile has been in a GROUP.

Click the company logo at the top left

and go back to the home.

32
Steps / Comments Screenshot

37. In Fiori launchpad, select Group

“Analytics for Accounts payable” and
the tiles in the group are displayed.
Click “Aging Analysis” to launch the
app.

38. The app is launched.

33
EXERCISE 2 – WEBDYNPRO GRID F0996 TRIAL BALANCE
In this exercise, we will open the technical objects used in a standard SAP Fiori app F0996 Trial Balance to understand the technical
objects used in Web Dynpro Grid application.

ü CDS View as the source

ü Consumption View: C_Trialbalanceq0001 (Bex Query: 2CCFITRIALBALQ0001)

34
 ü Interface View: I_GLAcctBalanceCube
ü Tile
ü Semantic/Action: AgingAnalysisKPI/analyzeSBKPIAgingAnalysis
ü WebDynpro Application: FIS_FPM_OVP_TRIAL1
ü Role: SAP_BR_GL_ACCOUNTANT
ü Catalog: SAP_SFIN_BC_GL_REPORTING (General Ledger – Reporting)

What to understand in this exercise:

ü Find the VDM (CDS View) with ADT and understand how to operate ADT.
ü Find the VDM (CDS View) with transaction SDDLAR in SAPGUI.
ü Run Analytic Query with Transaction RSRT.
ü Find Catalog and Group in Launchpad Designer (~S/4HANA1909)
ü Find Catalog with Manage Launchpad Apps (S/4HANA 2020~)
ü Find Catalog and Group in PFCG Role menu.
ü Find tile in a Catalog and assign to a Group to run the app (Personalize in Fiori launchpad).

35
Steps / Comments Screenshot

1. Firstly, check the objects in F0996 Trial

Balance.
URL:
https://fioriappslibrary.hana.ondemand.c
om/sap/fix/externalViewer/#/detail/Apps
('F0996')/S19OP

Ø Go to IMPLEMENTATION
INFORMATION > Configuration
We find the following objects are used
in the app F0996
Bex Query: 2CCFITRIALBALQ0001
Semantic Object/Action:
GLAccount/analyzeTrialBalance
Business Catalog:
SAP_SFIN_BC_GL_REPORTING
(General Ledger – Reporting)
Business Group:
SAP_SFIN_BCG_AP_ANALYTIC
Business Role:
SAP_BR_GL_ACCOUNTANT

36
Steps / Comments Screenshot

(If you don’t install ADT in your PC, please

skips and jump to step 16.)
2. Login the system with ADT. Register the
system. In the left side, from the context
menu, select Next > Project.

37
Steps / Comments Screenshot

3. Click “New system connection“.

38
Steps / Comments Screenshot

4. Enter the system info

System ID
Connectoin Type:
Application Server:
<Application server name>
vhcals4hci.dummy.nodomain (CAL)
Instance:
<Instance number>
00 (CAL)
Uncheck “Activate Secure network
Communication (SNC)

39
Steps / Comments Screenshot

5. Enter User name/Passowrd.

40
Steps / Comments Screenshot

6. Open The CDS View

“C_Trialbalanceq0001“.
Click “Open ABAP Development
Object“ and enter
“C_Trialbalanceq0001“

41
Steps / Comments Screenshot

7. The definition of the CDS View is

displayed.

@AbapCatalog.sqlViewName:
'CFITRIALBALQ0001'
@VDM.viewType: #CONSUMPTION
@Analytics.query: true

42
Steps / Comments Screenshot

8. Select “I_GLAcctBalanceCube“ and from

the context menu, select “Navigate To“.

43
Steps / Comments Screenshot

9. The Interface View

“I_GLAcctBalanceCube“.

44
Steps / Comments Screenshot

10. Data Preview: From the context menu,

select Open with > Data Preview.

45
Steps / Comments Screenshot

11. Enter the parameter values, and the data

is displayed.

46
Steps / Comments Screenshot

12. After pushing “SQL Console“, we can Y

edit the SELECT statement to retrieve
the data.

47
Steps / Comments Screenshot

13. After going back to the CDS view

definition, point the mouse on a column
(CompanyCode) and push F2. We can
find the data type and length, with which
we may be able to guess the field in the
source table.

48
Steps / Comments Screenshot

14. After Pointing the mouse on the View

name, by pushing F2, View definition is
displayed.

49
Steps / Comments Screenshot

15. The source Views/Tables can be

displayed. From the context menu,
Open with > Dependency Analyzer.
Under the View I_GLAcctBalanceCube,
other views are used, e.g.
I_GLAccountLineItem, and table like
ACDOCA.

50
Steps / Comments Screenshot

51
Steps / Comments Screenshot

16. The CDS View definition can be opened

with SAPGUI.
After launching WebGUI, run
transaction SDDLAR and select Display
DDL Source.

URL
https://<Server
name>:<Port>/sap/bc/ui2/flp#Shell-
home.dummy.nodomain:44301/sap/bc/
gui/sap/its/webgui#

CAL
https://vhcals4hcs.dummy.nodomain:4
4301/sap/bc/gui/sap/its/webgui#

52
Steps / Comments Screenshot

17. Enter “C_Trialbalanceq0001“ and push

“Execute“ on bottom

The data source of the CIDS View is

displayed.

53
Steps / Comments Screenshot

54
Steps / Comments Screenshot

18. The analytic query of CDS view can be

run like BW Query. Run transaction
RSRT.

Select “WD Grid“ in Query Display and

enter Query field with
“2CCFITRIALBALQ0001“ (2C<SQL
View name of CDS View
C_Trialbalanceq0001>)
And push Execute

19. Enter the parameter values on Company

Code, Ledger, Posting Data From,
Posting Data To, and push Enter (or
“OK“ button).
The data is retrieved by pushing “Hide
Filter Bar“, the result is displayed.

55
Steps / Comments Screenshot

56
Steps / Comments Screenshot

20. (~S/4HANA 1909) See tile definition

with Launchpad Designer,
Search the catalog with the name
“SAP_SFIN_BC_GL_REPORTING”Clic
k the searched entry and the tiles in the
catalog are displayed in the right side.
Click Trial Balance tile..
.
URL:
https://<host
name>:<Port>/sap/bc/ui5_ui5/sap/arsr
vc_upb_admn/main.html?scope=CUST
&sap-client=<Client>&sap-
language=<Language Key>

URL in CAL:
https://vhcals4hcs.dummy.nodomain:4
4301/sap/bc/ui5_ui5/sap/arsrvc_upb_a
dmn/main.html?scope=CUST&sap-
client=100&sap-language=EN

21. (~S/4HANA 1909) The configuration of

the tile is displayed.
Semantic Object:
GLAccount
Action:
analyzeTrialBalance

Push Navigation back button in top left.

57
Steps / Comments Screenshot

22. (~S/4HANA 1909) Go “Target

Mapping“ tab and select the entry of
GLAccount/analyzeTrialBalance, and
push Configure at the buttom,

58
Steps / Comments Screenshot

23. (~S/4HANA 1909) We can see the

configuration of the target mapping.
Application type:
Web Dynpro
Application and Configuration:
FIS_FPM_OVP_TRIAL1
In the Parameters,
bsa_query: 2CCFITRIALBALQ0001
(2C<SQL View name oft he CDS view
name>.

Push Navigation Back (top left.

59
Steps / Comments Screenshot

24. (for S/4HANA2020~) Login Fiori

launchpad and launch Manage
launchpad Apps under Fiori launchpad
tab.
With the tool, Catalog and launchpad
app descriptor item (Tile and Semantic
Object) can be created.

URL
https://<Server
name>:<Port>/sap/bc/ui2/flp#Shell-
home

CAL instance
https://vhcals4hcs.dummy.nodomain:44
301/sap/bc/ui2/flp#Shell-home

25. (for S/4HANA2020~) Search in Catalog

with “SAP_TC_FIN_ACC_BE_APPS”
and Semantic Object with “GLAccount“.
In this Tool, Technical Catalog is
searched.

60
Steps / Comments Screenshot

26. (for S/4HANA2020~) Select the entry of

GLAccount/analyzeTrialBalance as
Semantic Object/Action (App type =
Web Dynpro Application) in upper
table, then the detail of this Semantic
Object/Action is displayed in the lower
part.

Web Dynpro Application is

FIS_FPM_OVP_TRIAL1

27. (for S/4HANA2020~) Go to the

Parameters tab, and we can find the
parameters oft he app.
Query name 2CCFITRIALBALQ0001 is
set as the parameter value of
bsa_query.

61
Steps / Comments Screenshot

28. (for S/4HANA2020~) Go to Tiles tab, and

we can find the tile using this
launchpad app descriptor item.

29. Launch Fiori launchpad and go “App

Finder“ via user icon on top right.

62
Steps / Comments Screenshot

30. Select the catalog “General Ledger –

Reporting“ and include this tile in My
Home Group.

Go back to the home by clicking the

logo on top left.

63
Steps / Comments Screenshot

31. In the Launchpad home, click “Trial

Balance“ in My Home Group to launch
the app.

In the app, entert he parameter values

and push Enter key.

Now we get the result

64
Steps / Comments Screenshot

32.

65
www.sap.com/contactsap

© 2021 SAP SE or an SAP affiliate company. All rights reserved.

No part of this publication may be reproduced or transmitted in any form or for any purpose without the express permission of SAP SE or an SAP affiliate company.

The information contained herein may be changed without prior notice. Some software products marketed by SAP SE and its distributors contain proprietary software components of other software vendors. National product
specifications may vary.

These materials are provided by SAP SE or an SAP affiliate company for informational purposes only, without representation or warranty of any kind, and SAP or its affiliated companies shall not be liable for errors or
omissions with respect to the materials. The only warranties for SAP or SAP affiliate company products and services are those that are set forth in the express warranty statements accompanying such products and services, if
any. Nothing herein should be construed as constituting an additional warranty.

In particular, SAP SE or its affiliated companies have no obligation to pursue any course of business outlined in this document or any related presentation, or to develop or release any functionality mentioned therein. This
document, or any related presentation, and SAP SE’s or its affiliated companies’ strategy and possible future developments, products, and/or platform directions and functionality are all subject to change and may be changed by
SAP SE or its affiliated companies at any time for any reason without notice. The information in this document is not a commitment, promise, or legal obligation to deliver any material, code, or functionality. All forward-
looking statements are subject to various risks and uncertainties that could cause actual results to differ materially from expectations. Readers are cautioned not to place undue reliance on these forward-looking statements, and
they should not be relied upon in making purchasing decisions.

SAP and other SAP products and services mentioned herein as well as their respective logos are trademarks or registered trademarks of SAP SE (or an SAP affiliate company) in Germany and other countries. All other product
and service names mentioned are the trademarks of their respective companies. See www.sap.com/trademark for additional trademark information and notices.