fiscal_case3

Source SQL File - Google Cloud Cortex Data Foundation

Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - fiscal_case3

Overview

This reporting view provides a consolidated view of data from the t009b table in the ECC system. It calculates the minimum value of a concatenated string for each combination of Mandt, Periv, and a date range derived from the Ip_Date field.

Data Sources

Source Table/View	Description
t009b	Table containing financial document header data in the ECC system.

Key Use Cases

Reporting on financial documents within a specified date range.
Analysis of financial data across multiple periods.

Query Logic

The query first calculates a concatenated string for each row in the t009b table, using the following logic:

If the Bdatj field is '0000', the year from the Ip_Date field is extracted and converted to a string.
Otherwise, the Bdatj field is used as is.

The concatenated string is then combined with the Reljr and Poper fields.

The query then filters the results to include only rows where the Mandt and Periv fields match the corresponding fields in the Ip_Date table, and where the concatenated string is greater than or equal to the date range derived from the Ip_Date field.

Possible relation with SAP Transactions

Transaction Code	Transaction Description

Data Lineage

Under Development

Table/View Fields

Field	Field Description	Description in SAP Dictionary (Comming soon)
Client_MANDT	Client
MaterialGroup_MATKL	Material Group
Division_SPART	Division
ReferenceGroupRefMaterial_WWGDA	Reference Group Ref Material
GroupMaterial_WWGPA	Group Material
DepartmentNumber_ABTNR	Department Number
AuthorizationGroup_BEGRU	Authorization Group
DefaultUnitofWeight_GEWEI	Default Unit of Weight
ValuationClass_BKLAS	Valuation Class
PurchasingValueKey_EKWSL	Purchasing Value Key
AssetClass_ANLKL	Asset Class
PriceLevelGroup_PRICE_GROUP	Price Level Group
MaterialGroupName_WGBEZ	Material Group Name
Language_SPRAS	Language