Viewing Source Data

Accounting master data in SAP S/4HANA Accounting is stored in dimensions such as account, profit center, and cost center. They have member IDs, text, properties, and hierarchy data that you will need to import to SAP Analytics Cloud to perform planning activities.

In the examples used in this course, G/L Account is often used. You can see the list of G/L accounts in the CONS (Group Chart of Accounts) in SAP S/4HANA in the Manage Chart of Accounts app in SAP Fiori.

CDS views are used to import data from SAP S/4HANA into SAP Analytics Cloud. In the example below, you can see the CDS view for G/L Account.

In the following example, you can see the G/L accounts displayed in the A_GLAccountInChartOfAccounts CDS view.

The hierarchies for G/L accounts SAP S/4HANA are referred to as Financial Statement Versions (FSV). They can be viewed in the Change Financial Statement Version app in SAP Fiori.

In the following image, you can see that the Net Revenue node includes G/L accounts 41000000, 41090000, and 41312000.

Semantic tags are used to derive Account Types during the import process into SAP Analytics Cloud.

They are held in the master data and while not visible in the example below, note that the Assets node has a semantic tag of ASSET and the Liabilities and Equity node has a semantic tag of LIAB_EQUIT. They are visible in the C_GLACCOUNTHIERARCHYNODE CDS view.

The logic that is used derive the account types for hierarchies is included in the C_GLACCOUNTHIERARCHYNODE CDS view.

If the semantic tag is ASSET, then the AST account type will be assigned to those accounts. If the semantic tag, is LIAB_EQUIT, then the LEQ account type will be assigned to those accounts.

The account type for income statement accounts is based on the +/- Sign Change.

If the nodes in the income statement have the +/- Sign Change turned on, then those accounts will be assigned to the INC account type. If it is turned off, then the account will be assigned to the EXP account type.

In the following example, you can see that the Net Revenue node has the +/- Sign Change turned on so it will be assigned the INC account type.

Group reporting master data in SAP S/4HANA Finance for group reporting is stored in dimensions such as financial statement (FS) item and consolidation unit. They have member IDs, text, properties, and hierarchy data that you will need to import to SAP Analytics Cloud to perform planning activities.

Financial statement (FS) items can be maintained in the Define Financial Statement Items app in SAP Fiori.

FS item hierarchies can be accessed from the Manage Global Hierarchies SAP Fiori app.

Accounting transaction data is stored in the ACDOCA table in SAP S/4HANA. You can view it with the Balance Sheet/Income Statement app in SAP Fiori.

Group reporting transaction data is stored in the ACDOCU table in SAP S/4HANA. You can use the Group Data Analysis app to view the group reporting transaction data.