MaterialLedger
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - MaterialLedger
Overview
This view is a reporting view for SAP systems that combines data from the mbew and mbewh tables to provide information about material valuation. It includes fields such as client, material number, valuation type, valuation area, price unit, posting period, fiscal year, price control indicator, standard cost, value of total valuated stock, moving average price, and currency key.
Data Sources
| Source Table/View | Description |
|---|---|
{{ project_id_src }}.{{ dataset_cdc_processed_ecc }}.mbew |
Material valuation data for the current period |
{{ project_id_src }}.{{ dataset_cdc_processed_ecc }}.mbewh |
Material valuation data for historical periods |
{{ project_id_src }}.{{ dataset_cdc_processed_ecc }}.t001k |
Company code currency data |
{{ project_id_src }}.{{ dataset_cdc_processed_ecc }}.t001 |
Currency data |
{{ project_id_tgt }}.{{ dataset_reporting_tgt }}.currency_decimal |
Currency decimal data |
Key Use Cases
- Can be used to analyze material valuation data over time.
- Can be used to compare material valuation data across different valuation areas.
- Can be used to identify trends in material valuation.
Query Logic
The view uses a UNION ALL statement to combine the data from the mbew and mbewh tables. The LEFT JOIN statements are used to bring in additional data from the t001k, t001, and currency_decimal tables.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| MM03 | Display Material |
| MB51 | Material Document List |
| MB52 | Material Stock Overview |
| MB5B | Stock Value List |
Data Lineage
Under Development
Table/View Fields
| Field | Field Description | Description in SAP Dictionary (Comming soon) |
|---|---|---|
| Client_MANDT | Client | |
| MaterialNumber_MATNR | Material Number | |
| ValuationType_BWTAR | Valuation Type | |
| ValuationArea_BWKEY | Valuation Area | |
| PriceUnit_PEINH | Price Unit | |
| PostingPeriod | Posting Period | |
| FiscalYear | Fiscal Year | |
| PriceControlIndicator_VPRSV | Price Control Indicator | |
| StandardCost_STPRS | Standard Cost | |
| ValueOfTotalValuatedStock_SALK3 | Value Of Total Valuated Stock | |
| MovingAveragePrice | Moving Average Price | |
| CurrencyKey_WAERS | Currency Key |