Technology Blogs by SAP
Learn how to extend and personalize SAP applications. Follow the SAP technology blog for insights into SAP BTP, ABAP, SAP Analytics Cloud, SAP HANA, and more.
cancel
Showing results for 
Search instead for 
Did you mean: 
heiko_schneider
Advisor
Advisor



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







    1. SAP Datasphere Sample Content

 

    1. SAP Datasphere Sample Content for LoB Finance

 

    1. SAP Datasphere Sample Content for LoB Human Resources

 

    1. 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 Datasphere 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 NameTechnical NameType
CustomersSAP_SC_FI_T_CustomersLocal Table (Dimension)
Customers Dimension (View)SAP_SC_FI_V_CustomersDimView (Dimension)
Customers HierarchySAP_SC_FI_T_CustomersHierarchyLocal Table (Dimension)
Customers Hierarchy (SQL View)SAP_SC_FI_V_CustomersHierarchyView (Hierarchy)
Customers TextsSAP_SC_FI_T_CustomersTextsLocal Table (Dimension)
Customers Texts (SQL Text View)SAP_SC_FI_V_CustomersTextsView (Text)
Customers TypeSAP_SC_FI_T_CustomersTypeLocal Table (Dimension)
Customers Type (SQL View)SAP_SC_FI_SQL_CustomersTypeView (Dimension)
Customers Type TextsSAP_SC_FI_T_CustomersTypeTextsLocal Table (Dimension)
Customers Types (Text View)SAP_SC_FI_V_CustomersTypeTextsView (Text)
Data Flow for Financial TransactionsSAP_SC_FI_DFData Flow
FI ER ModelSAP_SC_FI_ERME/R Model
Financial TransactionsSAP_SC_FI_FinTransactionsLocal Table (Analytical Dataset)
Financial Transactions (DF transformed)SAP_SC_FI_DF_FinTransactionsLocal Table (Analytical Dataset)
Financial Transactions (SQL View)SAP_SC_FI_AM_FinTransactionsView (AnalyticModel)
GL Account TypeSAP_SC_FI_T_GLAccTypeLocal Table (Dimension)
GL Account Type (SQL View)SAP_SC_FI_SQL_GLAccTypeView (Dimension)
GL Account Type TextsSAP_SC_FI_T_GLAccTypeTextsLocal Table (Dimension)
GL Account Types (Text View)SAP_SC_FI_V_GLAccTypeTextsView (Text)
GL AccountsSAP_SC_FI_T_GLAccLocal Table (Dimension)
GL Accounts (Text View)SAP_SC_FI_V_GLAccTextsView (Text)
GL Accounts Dimension (View)SAP_SC_FI_V_GLAccDimView (Dimension)
GL Accounts HierarchySAP_SC_FI_T_GLAccHierarchyLocal Table (Dimension)
GL Accounts Hierarchy (SQL View)SAP_SC_FI_V_GLAccHierarchyView (Hierarchy)
GL Accounts TextsSAP_SC_FI_T_GLAccTextsLocal Table (Dimension)
Product CategoriesSAP_SC_FI_T_ProductCategoriesLocal Table (Dimension)
Product Category (SQL View)SAP_SC_FI_SQL_ProdCatView (Dimension)
Product Category TextsSAP_SC_FI_T_ProdCatTextsLocal Table (Dimension)
Product Category Texts (Text View)SAP_SC_FI_V_ProdCatTextsView (Text)
Product HierarchySAP_SC_FI_T_ProductHierarchyLocal Table (Dimension)
Product Hierarchy (SQL View)SAP_SC_FI_SQL_ProductHierarchyView (Hierarchy)
Product TextsSAP_SC_FI_T_ProductTextsLocal Table (Dimension)
Product Texts (SQL Text View)SAP_SC_FI_SQL_ProductTextsView (Text)
ProductsSAP_SC_FI_T_ProductsLocal Table (Dimension)
Products Dimension (View)SAP_SC_FI_V_ProductsDimView (Dimension)
Profit CenterSAP_SC_FI_T_ProfitCenterLocal Table (Dimension)
Profit Center Dimension (View)SAP_SC_FI_V_ProfitCenterView (Dimension)
Profit Center Hierarchy (SQL View)SAP_SC_FI_SQL_ProfitCHierarchyView (Hierarchy)
Profit Center TextsSAP_SC_FI_T_ProfitCenterTextsLocal Table (Dimension)
Profit Center Texts (SQL Text View)SAP_SC_FI_SQL_ProfitCenterTextView (Text)
ProfitCenterHierarchySAP_SC_FI_T_ProfitCHierarchyLocal 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.

4 Comments