Skip to Content
Product Information
Author's profile photo Heiko Schneider

SAP Datasphere Sample Content for LoB Finance


This blog post is describing the financial line of business data of the SAP Sample Content package in SAP Data Warehouse Cloud.


  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 Data Warehouse Cloud here.

Covered in this blog post

The sample data of the LoB Finance includes financial transactions on a daily basis of the sample company BestRun Bikes. The transactional data contains associations to products, customers, general ledger accounts, and profit center dimensions. The financial transactions are booked onto the different accounts of the general ledger.

Architecture

The following diagram displays the table structure in SAP Data Warehouse Cloud of the LoB Finance.

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.

SAP Datasphere enables you to do ETL transformations within the tool. To demonstrate this capability, the LoB scenario for FI makes use of a simple example. As the source data has only the column DATE, but no column with the year only, the Data Flow in SAP Datasphere is used to convert the column ‘DATE’ and add a new one ‘YEAR’.

The Data Flow for the LoB FI includes a script in Python for the calculated column ‘Year’. This column converts the Date column into the date format and extracts only the year as can be seen in the following:

Python Script

# convert the Date to datetime
data[‘DATE’] = pd.to_datetime(data[‘DATE’])
# add a column for Year
data[‘YEAR’] = data[‘DATE’].dt.year

return data

Overview of all business objects and its types

The following table lists all data objects of the FI sample data sorted by Business Name.

Business Name Technical Name Type
Customers SAP_SC_FI_T_Customers Local Table (Dimension)
Customers Dimension (View) SAP_SC_FI_V_CustomersDim View (Dimension)
Customers Hierarchy SAP_SC_FI_T_CustomersHierarchy Local Table (Dimension)
Customers Hierarchy (SQL View) SAP_SC_FI_V_CustomersHierarchy View (Hierarchy)
Customers Texts SAP_SC_FI_T_CustomersTexts Local Table (Dimension)
Customers Texts (SQL Text View) SAP_SC_FI_V_CustomersTexts View (Text)
Customers Type SAP_SC_FI_T_CustomersType Local Table (Dimension)
Customers Type (SQL View) SAP_SC_FI_SQL_CustomersType View (Dimension)
Customers Type Texts SAP_SC_FI_T_CustomersTypeTexts Local Table (Dimension)
Customers Types (Text View) SAP_SC_FI_V_CustomersTypeTexts View (Text)
Data Flow for Financial Transactions SAP_SC_FI_DF Data Flow
FI ER Model SAP_SC_FI_ERM E/R Model
Financial Transactions SAP_SC_FI_FinTransactions Local Table (Analytical Dataset)
Financial Transactions (DF transformed) SAP_SC_FI_DF_FinTransactions Local Table (Analytical Dataset)
Financial Transactions (SQL View) SAP_SC_FI_SQL_FinTransactions View (Analytical Dataset)
GL Account Type SAP_SC_FI_T_GLAccType Local Table (Dimension)
GL Account Type (SQL View) SAP_SC_FI_SQL_GLAccType View (Dimension)
GL Account Type Texts SAP_SC_FI_T_GLAccTypeTexts Local Table (Dimension)
GL Account Types (Text View) SAP_SC_FI_V_GLAccTypeTexts View (Text)
GL Accounts SAP_SC_FI_T_GLAcc Local Table (Dimension)
GL Accounts (Text View) SAP_SC_FI_V_GLAccTexts View (Text)
GL Accounts Dimension (View) SAP_SC_FI_V_GLAccDim View (Dimension)
GL Accounts Hierarchy SAP_SC_FI_T_GLAccHierarchy Local Table (Dimension)
GL Accounts Hierarchy (SQL View) SAP_SC_FI_V_GLAccHierarchy View (Hierarchy)
GL Accounts Texts SAP_SC_FI_T_GLAccTexts Local Table (Dimension)
Product Categories SAP_SC_FI_T_ProductCategories Local Table (Dimension)
Product Category (SQL View) SAP_SC_FI_SQL_ProdCat View (Dimension)
Product Category Texts SAP_SC_FI_T_ProdCatTexts Local Table (Dimension)
Product Category Texts (Text View) SAP_SC_FI_V_ProdCatTexts View (Text)
Product Hierarchy SAP_SC_FI_T_ProductHierarchy Local Table (Dimension)
Product Hierarchy (SQL View) SAP_SC_FI_SQL_ProductHierarchy View (Hierarchy)
Product Texts SAP_SC_FI_T_ProductTexts Local Table (Dimension)
Product Texts (SQL Text View) SAP_SC_FI_SQL_ProductTexts View (Text)
Products SAP_SC_FI_T_Products Local Table (Dimension)
Products Dimension (View) SAP_SC_FI_V_ProductsDim View (Dimension)
Profit Center SAP_SC_FI_T_ProfitCenter Local Table (Dimension)
Profit Center Dimension (View) SAP_SC_FI_V_ProfitCenter View (Dimension)
Profit Center Hierarchy (SQL View) SAP_SC_FI_SQL_ProfitCHierarchy View (Hierarchy)
Profit Center Texts SAP_SC_FI_T_ProfitCenterTexts Local Table (Dimension)
Profit Center Texts (SQL Text View) SAP_SC_FI_SQL_ProfitCenterText View (Text)
ProfitCenterHierarchy SAP_SC_FI_T_ProfitCHierarchy Local Table (Dimension)

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 FI data. This scenario consists of different tables and views, whereas the ER-model serves as central entry point to the data model. The simple Data Flow presents ETL functionalities within SAP Datasphere. 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 Jozsef Zerczi
      Jozsef Zerczi

      Hello Heiko,

      Thanks for providing the sample content. Are there plans to provide the content with use of the new now recommended Analytical Model?

      For now I presume I can go ahead and convert the analytical datasets into analytical models? Is there anything I should be aware of when doing so?

      Thanks.

      Author's profile photo Shao-Chun Wu
      Shao-Chun Wu

      Hello Heiko,

      After the operation, the current status is as described. Is there any solution to overcome the issue mentioned below?

      Upon installing the package and uploading the *csv file in Datasphere, an error message appears when trying to open the story in SAC.

       

      However, it is still feasible to create a story using the same SQL view.

       

      Result

       

      Thanks.

       

       

      Author's profile photo Shao-Chun Wu
      Shao-Chun Wu

      Resolved. In my case, the SAP Datasphere Live Connection must be named as SAPDWC.