MaterialsValuation
Source SQL File - Google Cloud Cortex Data Foundation
Google Cloud Cortex Foudantion - Cortex Reporting - (s4) - MaterialsValuation
Overview
This reporting view provides a comprehensive overview of material valuation data from SAP S/4 HANA systems. It combines data from the MBEW and MBEWH tables, which have been replaced by CKMLHD and CKMLCR in newer versions of SAP. The view includes key information such as valuation type, valuation area, stock values, price control indicators, and price information.
Data Sources
| Source Table/View | Description |
|---|---|
| mbew | Material Valuation Table |
| mbewh | Material Valuation: Period/Fiscal Year |
| t001k | Company Code Currency |
| t001 | Company Codes |
| currency_decimal | Currency Decimal Table |
| currency_conversion | Currency Conversion Rates |
| calendar_date_dim | Calendar Date Dimension |
Key Use Cases
- Material valuation analysis
- Inventory management reporting
- Cost accounting
- Financial reporting
Query Logic
The query joins the MBEW and MBEWH tables on the fields MANDT, MATNR, BWKEY, and BWTAR to combine material valuation data. It also includes data from the T001K and T001 tables to obtain currency information. The query uses COALESCE to handle null values and applies currency conversion if necessary. Additionally, it incorporates data from the calendar_date_dim table to provide temporal context.
Possible relation with SAP Transactions
| Transaction Code | Transaction Description |
|---|---|
| MM03 | Display Material |
| MB51 | Material Document List |
| MB52 | Stock Overview: Material |
| CO03 | Display Cost Element |
| FBL3N | Display Line Items: G/L Account |
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 |