MBEW is an SAP table in package MG (Application development R/3 material master prior to 3.0), used in MM (Materials Management), LO-MD-MM (Material Master). View details, fields & related tables of MBEW in SAP.
- Table description : Material Valuation
- Module : MM (Materials Management)
- Component : LO-MD-MM (Material Master)
- Package : MG

Here is some free PDF files that you can download free for your reference.
Download Now
Definitions
What is SAP ?SAP is the short form of Systems, Applications & Products in Data Processing. It is one of the largest business process related software. This software focused on business processes on ERP & CRM.
What is table in SAP ?Like most other software, SAP also using database tables to store the data. In SAP thousands of tables are there to store different data. A table contains several fields and some of the fields will be key fields.
SAP MBEW Table Fields structure
| Field | Note | Data Element | Domain |
|---|---|---|---|
| MANDT | Client | MANDT | MANDT |
| MATNR | Material Number | MATNR | MATNR |
| BWKEY | Valuation area | BWKEY | BWKEY |
| BWTAR | Valuation type | BWTAR_D | BWTAR |
| .INCLUDE | Data Division MBEW | ||
| LVORM | Deletion flag for all material data of a valuation type | LVOBA | XFELD |
| .INCLUDE | Joint Data Part MBEW/EBEW/QBEW: Part 1 | ||
| LBKUM | Total Valuated Stock | LBKUM | MENG13V |
| SALK3 | Value of Total Valuated Stock | SALK3 | WERT13N |
| VPRSV | Price control indicator | VPRSV | VPRSV |
| VERPR | Moving Average Price/Periodic Unit Price | VERPR | WERT11V |
| STPRS | Standard price | STPRS | WERT11V |
| PEINH | Price unit | PEINH | PACK3 |
| BKLAS | Valuation Class | BKLAS | BKLAS |
| SALKV | Value based on moving average price (only with price ctrl S) | SALKV | WERT13N |
| VMKUM | Total valuated stock in previous period | VMKUM | MENG13V |
| VMSAL | Value of total valuated stock in previous period | VMSAL | WERT13N |
| VMVPR | Price control indicator for previous period | VMVPR | VPRSV |
| VMVER | Moving Average Price/Periodic Unit Price in Previous Period | VMVER | WERT11V |
| VMSTP | Standard price in the previous period | VMSTP | WERT11V |
| VMPEI | Price unit of previous period | VMPEI | PACK3 |
| VMBKL | Valuation class of previous period | VMBKL | BKLAS |
| VMSAV | Value based on moving average price (previous period) | VMSAV | WERT13N |
| VJKUM | Total valuated stock in previous year | VJKUM | MENG13V |
| VJSAL | Value of total valuated stock in previous year | VJSAL | WERT13N |
| VJVPR | Price control indicator for previous year | VJVPR | VPRSV |
| VJVER | Moving Average Price/Periodic Unit Price in Previous Year | VJVER | WERT11V |
| VJSTP | Standard price in previous year | VJSTP | WERT11V |
| VJPEI | Price unit of previous year | VJPEI | PACK3 |
| VJBKL | Valuation class from previous year | VJBKL | BKLAS |
| VJSAV | Value based on moving average price (previous year) | VJSAV | WERT13N |
| LFGJA | Fiscal Year of Current Period | LFGJA | GJAHR |
| LFMON | Current period (posting period) | LFMON | MONAT |
| BWTTY | Valuation Category | BWTTY_D | BWTTY |
| STPRV | Previous price | STPRV | WERT11V |
| LAEPR | Date of the last price change | LAEPR | DATUM |
| ZKPRS | Future price | DZKPRS | WERT11 |
| ZKDAT | Date as of which the price is valid | DZKDAT | DATUM |
| TIMESTAMP | UTC Time Stamp in Short Form (YYYYMMDDhhmmss) | TIMESTAMP | TZNTSTMPS |
| BWPRS | Valuation price based on tax law: level 1 | BWPRS | WERT11 |
| BWPRH | Valuation price based on commercial law: level 1 | BWPRH | WERT11 |
| VJBWS | Valuation price based on tax law: level 3 | VJBWS | WERT11 |
| VJBWH | Valuation price based on commercial law: level 3 | VJBWH | WERT11 |
| VVJSL | Value of total valuated stock in year before last | VVJSL | WERT13N |
| VVJLB | Total valuated stock in year before last | VVJLB | MENG13V |
| VVMLB | Total valuated stock in period before last | VVMLB | MENG13V |
| VVSAL | Value of total valuated stock in period before last | VVSAL | WERT13N |
| .INCLUDE | Joint Data Part MBEW/EBEW/QBEW: Part 2 | ||
| ZPLPR | Future planned price | DZPLPR | WERT11 |
| ZPLP1 | Future Planned Price 1 | DZPLP1 | WERT11 |
| ZPLP2 | Future Planned Price 2 | DZPLP2 | WERT11 |
| ZPLP3 | Future Planned Price 3 | DZPLP3 | WERT11 |
| ZPLD1 | Date from Which Future Planned Price 1 Is Valid | DZPLD1 | DATUM |
| ZPLD2 | Date from Which Future Planned Price 2 Is Valid | DZPLD2 | DATUM |
| ZPLD3 | Date from Which Future Planned Price 3 Is Valid | DZPLD3 | DATUM |
| PPERZ | Period for future standard cost estimate (deactivated) | PPERZ | BUPER |
| PPERL | Period for current standard cost estimate (deactivated) | PPERL | BUPER |
| PPERV | Period for previous standard cost estimate (deactivated) | PPERV | BUPER |
| .INCLUDE | Joint Data Part MBEW/EBEW/QBEW: Part 3 | ||
| KALKZ | Indicator: standard cost estimate for future period | KAXKZ | XFELD |
| KALKL | Indicator: standard cost estimate for current period | KALKL | XFELD |
| KALKV | Indicator: standard cost estimate for previous period | KALKV | XFELD |
| KALSC | Overhead key (deactivated) | KALSC | KALSC |
| XLIFO | LIFO/FIFO-relevant | XLIFO | LIFO_FIFO |
| MYPOL | Pool number for LIFO valuation | MYPOOL | LIFO_POOL |
| BWPH1 | Valuation price based on commercial law: level 2 | BWPH1 | WERT11 |
| BWPS1 | Valuation price based on tax law: level 2 | BWPS1 | WERT11 |
| ABWKZ | Lowest value: devaluation indicator | ABWKZ | NUMC2 |
| PSTAT | Maintenance status | PSTAT_D | PSTAT |
| .INCLUDE | Joint Data Part MBEW/EBEW/QBEW: Part 4 | ||
| KALN1 | Cost Estimate Number - Product Costing | CK_KALNR1 | CK_KALNR |
| KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | CK_KALNR |
| .INCLUDE | Joint Data Part MBEW/EBEW/QBEW: Part 5 | ||
| BWVA1 | Valuation variant for the future standard cost estimate | CK_BWVA1 | CK_BWVAR |
| BWVA2 | Valuation variant for the current standard cost estimate | CK_BWVA2 | CK_BWVAR |
| BWVA3 | Valuation variant for past standard cost estimate | CK_BWVA3 | CK_BWVAR |
| VERS1 | Costing version of the future standard cost estimate | CK_TVERS1 | CK_VERSION |
| VERS2 | Costing version of the current standard cost estimate | CK_TVERS2 | CK_VERSION |
| VERS3 | Costing version of the previous standard cost estimate | CK_TVERS3 | CK_VERSION |
| HRKFT | Origin Group as Subdivision of Cost Element | HRKFT | HRKFT |
| KOSGR | Costing overhead group | CK_KOSGR | CK_KOSGR |
| PPRDZ | Period of future cost estimate | CK_PPRDZ | POPER |
| PPRDL | Period of the current cost estimate | CK_PPRDL | POPER |
| PPRDV | Period of the previous cost estimate | CK_PPRDV | POPER |
| PDATZ | Future fiscal year | CK_PDATZ | GJAHR |
| PDATL | Fiscal year for current cost estimate | CK_PDATL | GJAHR |
| PDATV | Fiscal year of previous cost estimate | CK_PDATV | GJAHR |
| EKALR | Material Is Costed with Quantity Structure | CK_EKALREL | XFELD |
| VPLPR | Previous planned price | VPLPR | WERT11 |
| MLMAA | Material ledger activated at material level | CK_ML_MAAC | XFELD |
| MLAST | Material Price Determination: Control | CK_ML_ABST | CK_ML_ABST |
| LPLPR | Current Planned Price | CK_LPLPR | WERT11 |
| VKSAL | Value of Total Valuated Stock at Sales Price | VKSAL | WERT13N |
| HKMAT | Material-related origin | HKMAT | HKMAT |
| SPERW | Physical inventory blocking indicator | SPERR | SPERR |
| KZIWL | Phys. inventory indicator for value-only material | KZIWL | INVKZ |
| WLINL | Date of last physical inventory for unrestricted-use stock | DLINL | DATS |
| ABCIW | Physical inventory indicator for cycle counting | ABCIN | ABCIN |
| .INCLUDE | Joint Data Part MBEW/EBEW/QBEW: Part 6 | ||
| BWSPA | Valuation margin | BWSPA | PRZ32V |
| LPLPX | Fixed Portion of Current Planned Price | CK_LPLPX | WERT11V |
| VPLPX | Fixed Portion of Previous Planned Price | CK_VPLPX | WERT11V |
| FPLPX | Fixed Portion of Future Planned Price | CK_ZPLPX | WERT11V |
| LBWST | Val. strat. for current plan price, sales order/proj. stock | CK_LBWST | CK_BWST |
| VBWST | Valn. strategy for prev. planned price, restricted use stock | CK_VBWST | CK_BWST |
| FBWST | Valn strategy for future planned price, restr. use stock | CK_ZBWST | CK_BWST |
| EKLAS | Valuation Class for Sales Order Stock | EKLAS | BKLAS |
| QKLAS | Valuation Class for Project Stock | QKLAS | BKLAS |
| MTUSE | Usage of the material | J_1BMATUSE | J_1BMATUSE |
| MTORG | Origin of the material | J_1BMATORG | J_1BMATORG |
| OWNPR | Produced in-house | J_1BOWNPRO | XFELD |
| XBEWM | Valuation based on the batch-specific unit of measure | XBEWW | XFELD |
| BWPEI | Price unit for valuation prices based on tax/commercial law | BWPEI | PACK3 |
| .INCLUDE | Joint Data Part MBEW/EBEW/QBEW: Part 7 | ||
| MBRUE | MBEWH rec. already exists for per. before last of MBEW per. | MBRUE | XFELD |
| OKLAS | Valuation Class for Special Stock at the Vendor | OKLAS | BKLAS |
| .INCLU--AP | Joint Venture Extension to MBEW | ||
| OIPPINV | Prepaid Inventory Flag for Material Valuation Type Segment | JV_PPINV | JV_PPINV |
MBEW related tables
| Table | Note |
|---|---|
| TMY03 | Valuation Levels for FIFO Material Valuation |
| CKMLCT | Currency Types and Valuation Types in a Valuation Area |
| CNV_10994_T001Y | Valuation levels for LIFO stock valuation (before conv.) |
| CRMC_CRCDATI | Credit Rating Check: Status per Valuation Proc./Valuation |
| FAGL_FCV_ADMIN | Foreign Currency Valuation: ID Numbers of Valuation Runs |
| T001Y | Valuation Levels for LIFO Inventory Valuation |
| T044AB | Valuation Attributes for OI Valuation By Remaining Term |
| T149 | Valuation type/valuation class |
| T149A | Valuation types for valuation area |
| T149B | Valuation Category/Valuation type |
| T5EA4 | Associate valuation wage type with valuation method |
| TCKMLPR_EB | Customizing for Bal. Sheet Valuation: Define Valuation Areas |
| CKMLAB02 | Material Update Structure (Assignment to Valuation Area) |
| CKMLW | Material Ledger Currencies in Valuation Area |
| ESH_TST_PROP_VAL | ES Test Object Material - Property valuation |
Related tcodes for MBEW
Transaction codes in the same SAP package (MG) as the MBEW table.
| Tcode | Description |
|---|---|
| MM00 | (empty) |
| MM01 | Create Material & |
| MM02 | Change Material & |
| MM03 | Display Material & |
| MM04 | Display Material Change Documents |
| MM06 | Flag Material for Deletion |
| MM11 | Schedule Creation of Material & |
| MM12 | Schedule Changing of Material & |
| MM13 | Activate Planned Changes |
| MM14 | Display Planned Changes |
| MM15 | Display Changes (Migration) |
| MM16 | Schedule Material for Deletion |
Tutorials that mention MBEW
- SAP MM tables for Material Master, Vendor Master, Inventory management and purchasing
- SAP Fiscal Year tables, Tcodes & PDF reference guides
Latest Table Searches
Handling units sap table in SAPHow to display handling unit table in SAP
Sap handling unit zuordnung löschen table in SAP
Where to find handling unit table in SAP
Handling unit management configuration wm table in SAP
Handling unit wm table in SAP
What is sap handling unit table in SAP
Popular Table Searches
Hdfc bank ltd company code for zinghr table in SAPLink between sales order and production order f table in SAP
Teleperformance company code for zinghr table in SAP
Users list snc table in SAP
Business partner table in SAP
Country codes table in SAP
Shipping point table in SAP