ProfitAndLoss
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - ProfitAndLoss
Overview
This view provides a reporting perspective for SAP systems. It offers a comprehensive view of financial data, including profit and loss statements, balance sheets, and cash flow statements. The view is designed to support various reporting requirements, such as financial analysis, budgeting, and forecasting.
Data Sources
| Source Table/View | Description |
|---|---|
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.Languages_T002 |
Contains language keys and their corresponding language 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 profit and loss accounts, balance sheet accounts, and cash flow items. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.FSVTextsMD |
Provides text descriptions for financial statement items and nodes. |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.GLAccountsMD |
Contains master data for general ledger accounts, including account numbers and descriptions. |
Key Use Cases
- Financial reporting and analysis
- Budgeting and forecasting
- Compliance reporting
- Management reporting
- Ad hoc reporting
Query Logic
The query combines data from multiple SAP tables to create a comprehensive view of financial data. It uses common table expressions (CTEs) to derive intermediate results, such as language keys, currency conversion rates, and parent-child relationships for financial statement items. The main query then joins these CTEs to retrieve the final result set, which includes financial data, text descriptions, and currency conversion information.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| FAGLB03 | Display G/L Accounts |
| FAGLL03 | Display Line Items |
| FS00 | Maintain Chart of Accounts |
| FS10N | Display Balance Sheet |
| FBL3N | Display Document List |
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 | |
| GLHierarchy | GL Hierarchy Name | |
| BusinessArea | Business Area | |
| LedgerInGeneralLedgerAccounting | Ledger in General Ledger Accounting | |
| ProfitCenter | Profit Center | |
| CostCenter | Cost Center | |
| GLNode | GL Node | |
| LanguageKey_SPRAS | Language Key | |
| GLParent | GL Parent | |
| GLFinancialItem | GL Financial Item | |
| GLNodeText | GL Node Text | |
| GLParentText | GL Parent Text | |
| GLLevel | GL Level | |
| FiscalQuarter | Fiscal Quarter | |
| GLIsLeafNode | GL Is Leaf Node | |
| CompanyText | Company Text | |
| AmountInLocalCurrency | Amount in Local Currency | |
| CumulativeAmountInLocalCurrency | Cumulative Amount in Local Currency | |
| CurrencyKey | Currency Key | |
| ExchangeRate | Exchange Rate | |
| MaxExchangeRate | Max Exchange Rate | |
| AvgExchangeRate | Avg Exchange Rate | |
| AmountInTargetCurrency | Amount in Target Currency | |
| CumulativeAmountInTargetCurrency | Cumulative Amount in Target Currency | |
| TargetCurrency_TCURR | Target Currency |