MaterialsValuation
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (ecc) - MaterialsValuation
Overview
This reporting view provides a comprehensive overview of material valuation data from SAP ECC systems. It combines data from multiple tables, including MBEW, MBEWH, T001K, T001, and currency_decimal, to provide a detailed view of material valuation information for a specific point in time.
Data Sources
| Source Table/View | Description |
|---|---|
| mbew | Material Valuation Table |
| mbewh | Material Valuation Table for Current Period |
| t001k | Company Code Currency Table |
| t001 | Currency Table |
| currency_decimal | Currency Decimal Table |
| calendar_date_dim | Calendar Date Dimension Table |
Key Use Cases
- Analyze material valuation data for a specific point in time.
- Compare valuation data across different valuation areas, valuation types, and fiscal periods.
- Identify materials with high or low valuation values.
- Monitor changes in valuation prices and quantities over time.
- Support financial reporting and analysis.
Query Logic
The view uses a left join to combine data from the MBEW, MBEWH, T001K, T001, and currency_decimal tables. The join conditions ensure that the data is aligned based on common fields such as MANDT, MATNR, BWKEY, and BWTAR. The view also includes calculations for standard cost, moving average price, previous price, and future price, taking into account currency conversion if necessary.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| MM03 | Display Material Master |
| MB52 | Display Material Stock/Value List |
| MB5B | Material Valuation: Display Stock Value |
| FBL3N | Display Line Items: G/L Accounts |
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 | |
| DeletionFlagForAllMaterialDataOfValuationType_LVORM | Deletion Flag For All Material Data Of Valuation Type | |
| ValuationCategory_BWTTY | Valuation Category | |
| TotalValuatedStock_LBKUM | Total Valuated Stock | |
| ValueOfTotalValuatedStock_SALK3 | Value Of Total Valuated Stock | |
| PriceControlIndicator_VPRSV | Price Control Indicator | |
| PriceUnit_PEINH | Price Unit | |
| DateOfTheLastPriceChange_LAEPR | Date Of The Last Price Change | |
| DateAsOfWhichThePriceIsValid_ZKDAT | Date As Of Which The Price Is Valid | |
| FiscalYearOfCurrentPeriod_LFGJA | Fiscal Year Of Current Period | |
| CurrentPeriod_LFMON | Current Period | |
| ValuationClass_BKLAS | Valuation Class | |
| StandardCost_STPRS | Standard Cost | |
| MovingAveragePrice_VERPR | Moving Average Price | |
| PreviousPrice_STPRV | Previous Price | |
| FuturePrice_ZKPRS | Future Price | |
| StandardPrice_STPRS | Standard Price | |
| PeriodicUnitPrice_VERPR | Periodic Unit Price | |
| CurrencyKey_WAERS | Currency Key | |
| YearOfDateOfTheLastPriceChange_LAEPR | Year Of Date Of The Last Price Change | |
| MonthOfDateOfTheLastPriceChange_LAEPR | Month Of Date Of The Last Price Change | |
| WeekOfDateOfTheLastPriceChange_LAEPR | Week Of Date Of The Last Price Change | |
| QuarterOfDateOfTheLastPriceChange_LAEPR | Quarter Of Date Of The Last Price Change | |
| YearOfDateAsOfWhichThePriceIsValid_ZKDAT | Year Of Date As Of Which The Price Is Valid | |
| MonthOfDateAsOfWhichThePriceIsValid_ZKDAT | Month Of Date As Of Which The Price Is Valid | |
| WeekOfDateAsOfWhichThePriceIsValid_ZKDAT | Week Of Date As Of Which The Price Is Valid | |
| QuarterOfDateAsOfWhichThePriceIsValid_ZKDAT | Quarter Of Date As Of Which The Price Is Valid |