Enterprise Resource Planning Blogs by SAP
Get insights and updates about cloud ERP and RISE with SAP, SAP S/4HANA and SAP S/4HANA Cloud, and more enterprise management capabilities with SAP blog posts.
cancel
Showing results for 
Search instead for 
Did you mean: 
8,098
Use Case:

Jack is an Analytics Specialist with ABC company. He frequently needs to create queries and reports, but he didn’t find any suitable CDS view for his customer deal, so he is trying to create his own Custom CDS Views. So he decided to create a new CDS View using “Custom CDS View” App which was new and can suffices his requirement. Here he is trying to leverage Primary Data Source I_GLAccountLineItemCube.

Step 1:



  • Jack scrolls down and select the Business catalog “Extensibility” (1)

  • Afterwards he clicks on the Custom CDS Views Tile in order to start the Custom CDS Views App  (2)


Step 2:



  • In the Customer CDS View App, Jack clicks on “Create” to be able to access the window allowing him to create a new View. (1)


 

Step 3:



  • Now Jack want to create a new Custom CDS View. To achieve this after selecting the tab “General”, Jack has to achieve following activities:

  • In the tab “General” Jack has to maintain: (1)

    • Name with: “YY1_PROFITCENTER”

    • Label with: “Profit Center Line Item”



  • Additionally, Jack must:

    • Check the OData box as well as the Analytical box(2) (Here selecting OData will automatically create an OData service in backend system that could be consumed in Analytical Apps)

    • Insert a Primary Data Source(3)




Step 4:



  • The search field could be used to rapidly filter the appropriated Data Source by entering for e.g. for this test case “I_GLAccountLine”(1)

  • After the search, Jack has to select the Data Source “I_GLAccountLineItemCube”(2)

  • And hit the Add button(3)  to have “I_GLAccountLineItemCube” persisted as the Data Source for the Custom CDS View to be created.


Step 5:



  • Jack needs now to choose the relevant fields for his use case. For this purpose, Jack has to:

    • Select and click on the Data Source ”I_GLAccountLineItemCube”




Step 6:

  • After that Jack has to select the tab “Field Selection” to properly select the desired fields.


Step 7: 



  • When in the Tab “Field Selection” Jack is seeing two columns: one labeled with “Available Fields and Associations” and the other with “Selected Fields and Associations”

  • Checking the boxes of some fields from the type “Field” like the one marked in red from the “Available Fields and Associations” column, trigger the mapping with the “Selected Fields and Associations”. This means that those fields are immediately inserted in the column “Selected Fields and Associations” which are definitively the selected fields for the use case.


Step 8:



  • The same thing must be done by Jack with fields from type “Association” which should be selected for the use case as well.

  • Afterwards Jack has to click on the “Save Draft” button to have the mapping (selected fields) persisted.


Step 9:



  • To make further necessary adjustments, Jack has to select the tab “Field Properties” (1) where selected fields could be enhanced with properties like semantic, semantic value etc...


Step 10:



  • In the tab “Field Properties”(1)  Jack has enhanced the properties of the field LedgerFiscalYear by setting its “Semantic Value” to true .(2)


Step 11:



  • To make further necessary adjustments, Jack can still select others Tabs like “Parameters” (1) where selected fields could be enhanced with others properties (In Tab “Parameter” there is no entry to maintain for this particular use case)


Step 12:



  • In the tab “Filter “, identical to the tab “Parameters”, Jack has no entry to maintain for this use case

  • Afterwards Jack has to click on the Save Draft(1) button that will trigger a toast message “Saved successfully”

  • To make the created Custom View available and usable for creating reporting, Jack has to click on the “Publish” button .(2)


Step 13:



  • To have an overview on the data content, Jack has to click on the Preview button  (3)

  • After the click on the Preview button the preview should look similar to this(4)

5 Comments
Anneleen
Discoverer
0 Kudos
Hi,

 

I'm trying to use the app (Fiori 1609) but the screen in step 3 is not the same as mine.

I'm missing the "select additional scenarios", "status information" and "view properities". Which kind of app are you using?

If I would have "additional  scenario", I could add "Odata" and can create a KPI on the view. Now, I can activate a CDS view but can do nothing more. What am I doing wrong?

In attachement you can find my view.

Thanks ! 
faisal_khan
Participant
0 Kudos
Hi,

Can you share how to dd a nee Promary Data source?

Thanks

Faisal
abraham_mendez
Explorer
0 Kudos

Hi Jerome,

Thanks for sharing. Question for you:

In step 4, can you use a custom ABAP CDS View (e.g. Z_I_MyCDSView generated from ABAP Development Tools) as a Primary Data Source? 

If so, can you share how to achieve it? I’m only able to find standard CDS Views in that input help.

Thanks

Abraham

0 Kudos
Hi jerome.monteunana

thank you for great blog

please can we use CSD created in ADT here ?

because am unable to see CDS created in ADT in the app

 

Regards

Ghadeer
jasonmuzzy
Active Participant
0 Kudos
You can mark a custom CDS view as released by right-clicking it and choosing API State > Add Use System-Internally (Contract C1) and then set the Release State to "Released".