FSVTextsMD
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - FSVTextsMD
Overview
This reporting view provides access to the financial statement items in the SAP system. It includes information such as the client, financial statement version, language key, financial statement item, text type, financial statement item line number, and financial statement item text.
Data Sources
| Source Table/View | Description |
|---|---|
| fagl_011qt | Financial Statement Items |
Key Use Cases
- Can be used to extract financial statement items for reporting purposes.
- Can be used to analyze financial statement items by client, financial statement version, language key, financial statement item, text type, financial statement item line number, and financial statement item text.
Query Logic
The view is a simple select statement that retrieves all columns from the fagl_011qt table.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| FAGLL03 | Display G/L Accounts in Financial Statement Version |
| FAGLB03 | Display Balance Sheet |
| FAGLC03 | Display Profit and Loss Statement |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client | |
| FinancialStatementVersion_VERSN | Financial Statement Version | |
| LanguageKey_SPRAS | Language Key | |
| FinancialStatementItem_ERGSL | Financial Statement Item | |
| TextType_TXTYP | Text Type | |
| FinancialStatementItemLineNumber_ZEILE | Financial Statement Item Line Number | |
| FinancialStatementItemText_TXT45 | Financial Statement Item Text |