FinancialStatement
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - FinancialStatement
Overview
This view provides a reporting layer for SAP systems, allowing users to analyze financial data by client, company, chart of accounts, hierarchy name, business area, ledger in general ledger accounting, profit center, cost center, fiscal year, fiscal period, and hierarchy node.
Data Sources
| Source Table/View | Description |
|---|---|
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.financial_statement |
Transaction data from the SAP system. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.fsv_glaccounts |
Hierarchy node data from the SAP system. |
Key Use Cases
- Financial reporting and analysis
- Budgeting and forecasting
- Compliance reporting
Query Logic
The query joins transaction data with hierarchy node data at the GLAccount level. It then groups the data by client, company code, chart of accounts, hierarchy name, business area, ledger in general ledger accounting, profit center, cost center, fiscal year, fiscal period, and node. Finally, it calculates the sum of the amount in local currency for each group and the cumulative amount in local currency for each group.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| FAGLL03 | Display G/L Account Line Items |
| FAGLFLEX | Flexible Analysis of G/L Accounts |
| FS00 | Create/Change Hierarchy |
| FS10N | Display Hierarchy |
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 | |
| HierarchyVersion | Hierarchy Version | |
| Parent | Parent Hierarchy Node | |
| FiscalQuarter | Fiscal Quarter | |
| FinancialStatementItem | Financial Statement Item | |
| Level | Hierarchy Level | |
| IsLeafNode | Is 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 |