BalanceSheet
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - BalanceSheet
Overview
This view provides a reporting perspective for SAP systems. It offers a comprehensive view of financial data, organized by various dimensions such as client, company, chart of accounts, hierarchy name, business area, ledger, fiscal year, fiscal period, hierarchy node, language, and target currency.
Data Sources
| Source Table/View | Description |
|---|---|
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.Languages_T002 |
Contains language keys and their descriptions. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.fiscal_date_dim |
Provides fiscal date dimensions, including fiscal year, fiscal period, and date. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.CompaniesMD |
Contains company-related information, such as client, company code, and fiscal year variant. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.CurrencyConversion |
Provides currency conversion rates and exchange rates. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.FinancialStatement |
Contains financial statement data, including balance sheet account indicators, financial statement items, and hierarchy information. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.FSVTextsMD |
Stores financial statement texts in multiple languages. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.GLAccountsMD |
Contains general ledger account information, including chart of accounts and account numbers. |
Key Use Cases
- Financial reporting and analysis
- Consolidated financial statements
- Budgeting and forecasting
- Performance monitoring
- Regulatory compliance
Query Logic
The query combines data from multiple source tables using joins and aggregations. It calculates cumulative amounts, exchange rates, and text descriptions for financial statement items. The query also supports filtering and grouping by various dimensions.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| FAGLL03 | Display G/L Accounts Line Items |
| FAGLB03 | Display G/L Balances |
| FS00 | Maintain Chart of Accounts |
| FS10N | Display Hierarchy |
| OB08 | Maintain Exchange Rates |
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 | |
| Node | Node | |
| LanguageKey_SPRAS | Language Key | |
| Parent | Parent Node | |
| NodeText | Node Text | |
| ParentText | Parent Text | |
| Level | Level | |
| FiscalQuarter | Fiscal Quarter | |
| IsLeafNode | Is Leaf Node | |
| CompanyText | Company Text | |
| AmountInLocalCurrency | Amount in Local Currency | |
| CumulativeAmountInLocalCurrency | Cumulative Amount in Local Currency | |
| CurrencyKey | Currency Key | |
| ExchangeRate | Exchange Rate | |
| MaxExchangeRate | Maximum Exchange Rate | |
| AvgExchangeRate | Average Exchange Rate | |
| AmountInTargetCurrency | Amount in Target Currency | |
| CumulativeAmountInTargetCurrency | Cumulative Amount in Target Currency | |
| TargetCurrency_TCURR | Target Currency |