fiscal_case2
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - fiscal_case2
Overview
This reporting view provides a consolidated view of data from the t009b table in the ECC system. It combines the Bdatj and Reljr fields to create a unique identifier for each record, and includes the Poper field for additional context.
Data Sources
| Source Table/View | Description |
|---|---|
| t009b | Table containing financial data for each posting period. |
Key Use Cases
- Financial reporting and analysis
- Budgeting and forecasting
- Compliance and audit
Query Logic
The view filters the t009b table based on the following criteria:
- Mandt = Ip_Mandt
- Periv = Ip_Periv
- Bdatj = CAST(EXTRACT(YEAR FROM Ip_Date) AS STRING)
- Bumon = CAST(CAST(Ip_Date AS STRING FORMAT('MM')) AS STRING)
The resulting data is then used to create a unique identifier for each record by concatenating the Bdatj and Reljr fields, and the Poper field is included for additional context.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| FB01 | Enter G/L Account Document |
| FB02 | Change G/L Account Document |
| FB03 | Display G/L Account Document |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| CONCAT(CAST(Bdatj AS INT) + CAST(Reljr AS INT), Poper) | Concatenation of the fiscal year (Bdatj), the reporting period (Reljr), and the reporting period type (Poper) |