Custom Reporting
Create a custom CDS view to create an access to you data.
Overview
Prerequisites
Prerequisites
SAP_CORE_BC_EXT to your user.Steps
Intro
If you need access to data in your system in a way the system does not offer so far, you can create your own data access by making use of a Custom Core Data Services view (Custom CDS view). Usually, the data of an application is distributed across several database tables. Using CDS views allows you to model the data access without changing underlying database tables. In general, CDS views are intended to be consumed by a UI, analytics or other systems. CDS View can be built on CDS Views as well. To simplify the data access there are pre-delivered CDS Views, Custom CDS Views can only be built on.## You will learn
You will be able to see a preview of your generated Custom CDS View and your data at the end of this tutorial. First of all a Custom CDS View will be generated to have the access to your data. You will select fields and association properties in your Custom CDS View to see them later on in your preview.
Time to Complete
15 Min.
Navigate to the Extensibility category and press the Custom CDS Views tile to start the application.
Search for I_SalesOrderItemCube (1), select (2) it and click on Create(3) to create a new CDS View.
Give CDS the View Name: YY1_My_SalesOrder, Label: My Sales Order.
Checkmark Analytical and select Cube as additional Scenarios.
Now navigate to Field Selection and select following fields:
SalesOrderSalesOrderItemSalesOrderTypeSalesOrganizationDistributionChannelDivisionCreationDateYearQuarterCreationDateYearMonthSalesOrderDateYearSoldToPartyNameShipToPartyShipToPartyNameOrderQuantityUnitOrderQuantityTotalNetAmountTransactionCurrencyDisplayCurrencyNetAmountDisplayCurrency
Afterwards execute Save Draft.
In General tab add a secondary data source by clicking on Add. Afterwards click on Add Associated Data Source.
Search for the data source I_BusinessPartner and select the view. Then click on Add to append the associated data source.
Maintain the join conditions with clicking on the corresponding symbol.
Select the field SoldToParty in the primary data source and the field BusinessPartner in the associated data source and click on ok.
In Field Selection select additional fields from the associated data source. These fields are:
IndustryBusinessPartnerIsBlocked
And then click on Save Draft and Publish.
Click on Preview and fill Parameters
P_ExchangeRateTypewithMandP_DisplayCurrencywithEUR. Afterwards check the view.
Result: Result list of the CDS View.
Hint: To be able to see data in this preview you need sales order data in your system.
Resources
Discussion
Share feedback on this tutorial or join the conversation in SAP Community.