BalanceSheet
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - 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 descriptions. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.fiscal_date_dim |
Provides fiscal date dimensions, including fiscal year and period. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.CompaniesMD |
Contains company-related information, such as fiscal year variant and currency code. |
{{ 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. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.FSVTextsMD |
Provides hierarchy node descriptions and GL account long texts in different languages. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.GLAccountsMD |
Contains GL account-related information, including chart of accounts and GL account numbers. |
Key Use Cases
- Financial reporting and analysis
- Consolidation of financial data across multiple companies and business areas
- Currency conversion and restatement of financial statements
- Drill-down analysis from summarized data to detailed transactions
Query Logic
The query combines data from multiple source tables using joins and aggregations. It calculates cumulative amounts, exchange rates, and text descriptions based on the specified parameters. The query also supports filtering by language and currency.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| FAGLB03 | Display G/L Accounts |
| FAGLL03 | Display Line Items |
| FS00 | Chart of Accounts |
| OB08 | Define 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 |