Skip to Content
Product Information
Author's profile photo Heiko Schneider
Heiko Schneider
March 9, 2023 2 minute read

SAP Datasphere Sample Content for LoB Sales

This blog post is describing the sales line of business data of the SAP Sample Content package in SAP Datasphere.

Blog posts overview

  1. SAP Datasphere Sample Content
  2. SAP Datasphere Sample Content for LoB Finance
  3. SAP Datasphere Sample Content for LoB Human Resources
  4. SAP Datasphere 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 Datasphere 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 Datasphere 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 SAP_SC_SALES_AM_SalesOrders View (AnalyticModel)

Summary

The SAP Sample Content for Finance, Human Resources and Sales is a great way to get started in SAP Datasphere data modelling. It helps you to easily understand the features of SAP Datasphere by following a simple approach. You can quickly onboard yourself by importing the content package to your Space in SAP Datasphere. 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 Datasphere. Feel free to share your thoughts and feedback in the comment section.

For questions about the topic join the conversation in our SAP Community.

You can also check our SAP Community topic page for SAP Datasphere here.

Assigned Tags

      3 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Mel Calucin
      Mel Calucin

      Hi Heiko,

      Thanks for the informative blog post.

      Someday, would there be content for Datasphere Glossary?   It would be nice to have Glossary content for S/4HANA terminology from Finance, Order to Cash, Supply Chain, PLM, etc.   It'll also be nice to have the glossary entries point to the corresponding S/4HANA CDS view Datasphere Data Catalog entries.

      Thanks!

      Regards,

      Mel Calucin

      Author's profile photo Heiko Schneider
      Heiko Schneider
      Blog Post Author

      Thanks Mel!

      What do you mean by "Glossary"? Basically there are already Business Content Scenarios available you can leverage from the existing Content of Data Warehouse Cloud as a starting point. Please have in mind: SAP Datasphere is a consequent and very substancial step forward into the journey we already started with further developments to come in all of the areas around our products and services. The Catalog of Datasphere (as one new component) will also grow as communicated in the launch event and according to the Roadmap.

      We will constantly share the developments we plan and envision through our official channels and events. Stay tuned 🙂

      Best regards

      Heiko Schneider

      SAP Product Management SAP Datashphere, SAP BW/4HANA

      Author's profile photo Xavier Polo
      Xavier Polo

      Hi Heiko Schneider

      I have imported the content into SAC but I don't see the connection to SAP Datasphere.

      It hasn't given any error, and I can't find any reference to the requirement that a connection must exist before installing it.

      Thanks,