Product Information
SAP Data Warehouse Cloud Sample Content for LoB Sales
This blog post is describing the sales line of business data of the SAP Sample Content package in SAP Data Warehouse Cloud.
Blog posts overview
- SAP Data Warehouse Cloud Sample Content
- SAP Data Warehouse Cloud Sample Content for LoB Finance
- SAP Data Warehouse Cloud Sample Content for LoB Human Resources
- SAP Data Warehouse Cloud Sample Content for LoB Sales (this blog post)
For questions about the topic join the conversation in our SAP Community.
You can also check our SAP Community topic page for SAP Data Warehouse Cloud here.
Covered in this blog post
The sample data of the LoB Sales includes sales orders and sales orders items data of the sample company BestRun Bikes. The data of the LoB Sales contains associations to products, business partners and the fact sales view.
Architecture
The following diagram displays the table structure in SAP Data Warehouse Cloud of the LoB Sales.
To get an overview of the data model, the entity-relationship diagram delivers helpful insight into the modelling of the data. In the following you can see the relationship among the different tables and views.
Overview of all business objects and its types
The following table lists all data objects of the SD sample data sorted by Business Name.
| Business Name | Technical Name | Type |
| Business Partners | SAP_SC_SALES_BusinessPartners | Local Table (Relational Dataset) |
| Fact Sales (View) | SAP_SC_SALES_V_Fact_Sales | View (Analytical Dataset) |
| Sales ER Model | SAP_SC_SALES_ERM | E/R Model |
| Sales Order Items | SAP_SC_SALES_SalesOrderItems | Local Table (Relational Dataset) |
| Sales Orders | SAP_SC_SALES_SalesOrders | Local Table (Relational Dataset) |
| Sales Orders with Products (View) | SAP_SC_SALES_V_SalesOrders | View (Analytical Dataset) |
Summary
The SAP Sample Content for Finance, Human Resources and Sales is a great way to get started in SAP Data Warehouse Cloud data modelling. It helps you to easily understand the features of SAP Data Warehouse Cloud by following a simple approach. You can quickly onboard yourself by importing the content package to your Space in SAP Data Warehouse Cloud. The underlying ER-model helps to understand and easily deploy the different entities included in this content package. In a final step you upload the sample data into the tables to prepare your model for data consumption.
In this blog post you learned the detailed background information about the LoB Sales data. This scenario consists of different tables and views, whereas the ER-model serves as central entry point to the data model. Finally, all related entities used in this scenario are listed in the above table.
As illustrated, this sample content enables users to speed up the onboarding process and I hope you have a good start on your data modelling journey in SAP Data Warehouse Cloud. Feel free to share your thoughts and feedback in the comment section.
Make sure to follow the tag to stay updated about SAP Data Warehouse Cloud.
For questions about the topic join the conversation in our SAP Community.
You can also check our SAP Community topic page for SAP Data Warehouse Cloud here.
Quite an interesting example.
Hi,
Tx for this. How do we get the sample content SAC report activated? I suppose we need to import a package in our SAC environment?
Hi Ronald,
thanks for your feedback. You need to be on SAC release 2020.20.01 to import the SAC related content from the Content Network.
Hope this helps.
Harun