Product Information
SAP Data Warehouse Cloud 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.
Blog posts overview
- SAP Data Warehouse Cloud Sample Content
- SAP Data Warehouse Cloud Sample Content for LoB Finance (this blog post)
- SAP Data Warehouse Cloud Sample Content for LoB Human Resources
- SAP Data Warehouse Cloud Sample Content for LoB Sales
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.
SAP Data Warehouse Cloud 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 Data Warehouse Cloud 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 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 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 Data Warehouse Cloud. 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.