ANALYTICS

Sample SAP Data Warehouse Cloud Content for LoB Sales



This blog post describes the business data sales pipeline for the SAP Sample Content package in the SAP Data Warehouse Cloud.


Blog post overview

  1. SAP Data Warehouse Cloud Content Sample
  2. SAP Data Warehouse Content Sample for LoB Finance
  3. Sample SAP HR Data Warehouse Cloud Content in LoB
  4. SAP Data Warehouse Cloud Content Sample for LoB Sales (this blog post)

For questions on the topic, join the conversation in our SAP community.

You can also check out the SAP Community topic page for SAP Data Warehouse Cloud here.

Covered in this blog post

The LoB Sales sample data includes sales orders and sales order line data for the BestRun Bikes sample. LoB Sales data contains links to products, business partners, and sales pitch.

Architectural Engineering

The following diagram shows the table structure in the SAP Data Warehouse Cloud for LoB Sales.

For an overview of the data model, the entity relationship diagram provides useful insight into data modeling. In the following, you can see the relationship between the various tables and views.

Overview of all business objects and their types

The following table lists all the data objects for SD model data sorted by business name.

Trade Name Technical name Type
business partners SAP_SC_SALES_BusinessPartners local table (relational dataset)
Truth Sales (View) SAP_SC_SALES_V_Fact_Sales Presentation (analytical data set)
e-sales 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 (display) SAP_SC_SALES_V_SalesOrders Presentation (analytical data set)

summary

The SAP Finance, HR, and Sales model content is a great way to get started with SAP Data Warehouse Cloud data modeling. It helps you to easily understand the features of SAP Data Warehouse Cloud with a simple approach. You can quickly set yourself up by importing the content package into your space in SAP Data Warehouse Cloud. The basic ER model helps to easily understand and deploy the different entities included in this content package. In the final step, you load the sample data into the tables to prepare your model for data consumption.

In this blog post you learned the basic, detailed information about LoB Sales data. This scenario consists of different tables and views, while the ER model serves as the central entry point to the data model. Finally, all related entities used in this scenario are listed in the table above.

As shown, this sample content allows users to speed up the setup process and I hope it’s a good start on your data modeling journey in SAP Data Warehouse Cloud. Feel free to share your thoughts and feedback in the comments section.

Be sure to follow the tag to stay updated about SAP Data Warehouse Cloud.

For questions on the topic, join the conversation in our SAP community.

You can also check out the SAP Community topic page for SAP Data Warehouse Cloud here.



Source link

Related Articles

Leave a Reply

Your email address will not be published. Required fields are marked *

Back to top button