fiscal_case2
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - fiscal_case2
Overview
This reporting view provides a consolidated view of data from the t009b table in the {{ project_id_src }}.{{ dataset_cdc_processed_s4 }} dataset. It combines data from multiple rows in the t009b table to provide a single row for each unique combination of Mandt, Periv, Bdatj, and Bumon.
Data Sources
| Source Table/View | Description |
|---|---|
| t009b | The t009b table stores data related to posting periods in SAP systems. Each row in the table represents a posting period for a specific company code and fiscal year. |
Key Use Cases
- This view can be used to report on posting periods for a specific company code and fiscal year.
- It can also be used to compare posting periods across different company codes and fiscal years.
Query Logic
The query first selects the CONCAT(CAST(Bdatj AS INT) + CAST(Reljr AS INT), Poper) expression from the t009b table. This expression combines the Bdatj, Reljr, and Poper columns to create a unique identifier for each posting period. The query then filters the results to only include rows where the Mandt, Periv, Bdatj, and Bumon columns match the corresponding values in the Ip_Mandt, Ip_Periv, Ip_Date, and Ip_Date columns, respectively.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| FB01 | Create Document |
| FB02 | Change Document |
| FB03 | Display Document |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| field | CONCAT(CAST(Bdatj AS INT) + CAST(Reljr AS INT), Poper) |