- SAP Managed Tags:
Since, most of our reporting requirements in SAP S/4HANA Public Cloud are met through CDS Views, I’m herewith sharing my experience on how end user life can be made easy, through usage of right CDS views, and converting the same into an easily consumable app!
Here we are creating a BOM report using custom CDS view and analytical query which will display the details of all existing Bill of materials for a range of materials within plant.
Check this out –
Step 1. Create custom CDS views to fetch data in custom analytical query.
Step 2. Create a custom analytical query.
Step 3. Create application (Fiori tile) for query and assign it to Business catalog.
Selection Screen:
Final Output of Report:
Steps 1. Create custom CDS views.
Within the SAP Fiori environment, open the app 'Custom CDS Views' which can be found in the category Extensibility.
Click on Create.
Fill Label (Name of CDS) and select scenario as ‘Standard CDS View’ and click on create.
*We are using the scenario as ‘standard CDS view’ because we will use this CDS in another custom CDS view using joint conditions.
Select Primary data source as ‘I_BillOfMaterialItemDEX_2’
Click on Add to an associate data source.
Click on Associate data source.
Select associate data source as ‘I_Product’
Click on Joint Condition
Click on Add
Select Product
Select Value type = Field
Value = I_BillOfMaterialItemDEX_2.BillOfMaterialComponent
Cardinality = Zero or One
Go to Element Tab: Click on Add – Elements
Add below mentioned elements.
Click on Check.
Once Check is successfully done, Click on Publish
Custom CDS Published Successfully.
Now we will create another CDS of scenario ‘Analytical cube’ which we will use in Analytical query.
Go to App: Custom CDS Views.
Click on Create
Fill Label and select scenario as ‘Analytical Cube.’
Select Primary data source as ‘I_MaterialBOMLink’
Click on Add an Associate data source.
Select CDS view which we have created earlier.
Click on Joint Condition
Add Joint condition- BillOfMaterial and BillOfMaterialVariant
Select value type as Field and value as BillOfMaterial & BillOfMaterialVariant
Cardinality= Zero and One
Go To Elementsà Click on Add Elements
Add below mentioned elements.
Go to Element Properties à Select ‘No Operation’ for ‘BillOfMaterialItemQuantity’
Click on Check
Click on Publish
Step 2. Create a custom analytical query.
Go to App: Custom Analytical Queries
Click on Create
Mention Query Name and Select Data source as CDS created in Step 1.
In General Tab: Give Label (Name of Query Report)
Go to Field Selection view and select required fields for report
Use Up Down Option in Display Tab to set sequence for fields in report.
Use Override label option to change the column name.
Go to Filter Option
Click on Field à Select User Unit Values
Selection type = Interval, select the multiple selection checkbox.
Click on Save Draft Option
Mention Plant and click on Go.
Report Displayed.
Come back to query screen and click on Publish.
Step 3. Create application (Fiori tile) for query and assign it to Business catalog.
Go to App: View browser – Browse Views
Search your custom analytical query, select, and click on create application.
Give Report title and subtitle and click on ok.
Application ID will generate for the query.
Click on Application ID and Go to ‘view in catalog’ option
Click on Add to add this application to business catalog.
Select Business catalog.
*You can assign this application to multiple business catalog.
Select the catalog and click on Publish.
App Published successfully for selected business catalog.
Click on Business catalog.
Go to More and select used in Business roles.
Now assign one of the business roles to your user ID.
Go to SAP Home screen.
Search App: BOM Report
Fill the selection parameter and click on Go.
Thanks & Regards,
Manish Sati
1 Comment
| User | Count |
|---|---|
| 4 | |
| 2 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 | |
| 1 |
