FinancialStatement
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - FinancialStatement
Overview
This view provides financial statement data at the hierarchy node level for SAP systems. It includes information such as client, company code, chart of accounts, hierarchy name, business area, ledger, profit center, cost center, fiscal year, fiscal period, hierarchy node, parent node, financial statement item, level, leaf node indicator, balance sheet account indicator, profit and loss account indicator, company text, currency key, amount in local currency, and cumulative amount in local currency.
Data Sources
| Source Table/View | Description |
|---|---|
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.financial_statement |
Transaction data table |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.fsv_glaccounts |
Financial statement version table |
Key Use Cases
- Reporting financial statement data at the hierarchy node level
- Analyzing financial performance by client, company code, business area, ledger, profit center, cost center, and hierarchy node
- Tracking financial transactions over time using fiscal year and fiscal period
Query Logic
The query first joins the transaction data table with the financial statement version table at the GL account level. It then selects the desired columns and groups the results by client, company code, chart of accounts, hierarchy name, business area, ledger, profit center, cost center, fiscal year, fiscal period, and hierarchy node. Finally, it calculates the cumulative amount in local currency for each group.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client | Client ID | |
| CompanyCode | Company Code | |
| FiscalYear | Fiscal Year | |
| FiscalPeriod | Fiscal Period | |
| ChartOfAccounts | Chart of Accounts | |
| HierarchyName | Hierarchy Name | |
| BusinessArea | Business Area | |
| LedgerInGeneralLedgerAccounting | Ledger in General Ledger Accounting | |
| ProfitCenter | Profit Center | |
| CostCenter | Cost Center | |
| Node | Hierarchy Node | |
| Parent | Parent Hierarchy Node | |
| FiscalQuarter | Fiscal Quarter | |
| FinancialStatementItem | Financial Statement Item | |
| Level | Hierarchy Level | |
| IsLeafNode | Indicates if the node is a leaf node | |
| BalanceSheetAccountIndicator | Balance Sheet Account Indicator | |
| PLAccountIndicator | Profit and Loss Account Indicator | |
| CompanyText | Company Text | |
| CurrencyKey | Currency Key | |
| AmountInLocalCurrency | Amount in Local Currency | |
| CumulativeAmountInLocalCurrency | Cumulative Amount in Local Currency |