SAP MVAL Table in S/4 HANA - Material Master Record Fields: Material Valuation reduced
MVAL is a standard SAP Table which is used to store Material Master Record Fields: Material Valuation reduced data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system
Even using an S/4 Hana system you can still view further information about the SAP MVAL table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).
Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Structure
Database Table: MVAL
MVAL table structure field list
Below is the full MVAL field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
ABCIW | Physical Inventory Indicator for Cycle Counting | ABCIN | CHAR | 1(0) | Assigned to domain | ABCIN | ||||
BKLAS | Valuation Class | BKLAS | CHAR | 4(0) | Assigned to domain | BKLAS | ||||
BWKEY | Valuation area | BWKEY | CHAR | 4(0) | Assigned to domain | BWKEY | BWK | |||
BWSPA | Valuation margin | BWSPA | DEC | 6(2) | PRZ32V | |||||
BWTAR | Valuation Type | BWTAR_D | CHAR | 10(0) | Assigned to domain | BWTAR | BWT | |||
BWTTY | Valuation Category | BWTTY_D | CHAR | 1(0) | Assigned to domain | BWTTY | ||||
EKALR | Material Is Costed with Quantity Structure | CK_EKALREL | CHAR | 1(0) | XFELD | |||||
EKLAS | Valuation Class for Sales Order Stock | EKLAS | CHAR | 4(0) | Assigned to domain | BKLAS | ||||
HKMAT | Material-related origin | HKMAT | CHAR | 1(0) | HKMAT | |||||
HRKFT | Origin Group as Subdivision of Cost Element | HRKFT | CHAR | 4(0) | Assigned to domain | HRKFT | ||||
KALN1 | Cost Estimate Number - Product Costing | CK_KALNR1 | NUMC | 12(0) | Assigned to domain | CK_KALNR | KNE | |||
KALNR | Cost Estimate Number for Cost Est. w/o Qty Structure | CK_KALNR | NUMC | 12(0) | Assigned to domain | CK_KALNR | KNR | |||
KZIWL | Phys. inventory indicator for value-only material | KZIWL | CHAR | 3(0) | INVKZ | |||||
LBKUM | Total Valuated Stock | LBKUM | QUAN | 13(3) | MENG13V | |||||
LFGJA | Fiscal Year of Current Period | LFGJA | NUMC | 4(0) | GJAHR | GJAHR | ||||
LFMON | Current period (posting period) | LFMON | NUMC | 2(0) | MONAT | |||||
LVORM | Deletion Indicator | LVORM | CHAR | 1(0) | XFELD | |||||
MATNR | Material Number | MATNR | CHAR | 40(0) | Assigned to domain | MATN1 | MATNR | MAT | S_MAT1 | MATNR |
MBRUE | MBEWH rec. already exists for per. before last of MBEW per. | MBRUE | CHAR | 1(0) | XFELD | |||||
MLAST | Material Price Determination: Control | CK_ML_ABST | CHAR | 1(0) | CK_ML_ABST | |||||
MLMAA | Material Ledger Activated at Material Level | CK_ML_MAAC | CHAR | 1(0) | XFELD | |||||
OKLAS | Valuation Class for Special Stock at the Vendor | OKLAS | CHAR | 4(0) | Assigned to domain | BKLAS | ||||
PEINH | Price unit | PEINH | DEC | 5(0) | PACK3 | |||||
PSTAT | Maintenance status | PSTAT_D | CHAR | 15(0) | PSTAT | |||||
QKLAS | Valuation Class for Project Stock | QKLAS | CHAR | 4(0) | Assigned to domain | BKLAS | ||||
SALK3 | Value of Total Valuated Stock | SALK3 | CURR | 13(2) | WERT13N | |||||
SALKV | Value based on moving average price (only with price ctrl S) | SALKV | CURR | 13(2) | WERT13N | |||||
SPERW | Physical Inventory Blocking Indicator | SPERR | CHAR | 1(0) | SPERR | |||||
STPRS | Standard price | STPRS | CURR | 11(2) | WERT11V | |||||
VERPR | Moving Average Price/Periodic Unit Price | VERPR | CURR | 11(2) | WERT11V | |||||
VKSAL | Value of Total Valuated Stock at Sales Price | VKSAL | CURR | 13(2) | WERT13N | |||||
VMBKL | Valuation Class in Previous Period | VMBKL | CHAR | 4(0) | Assigned to domain | BKLAS | ||||
VMKUM | Total valuated stock in previous period | VMKUM | QUAN | 13(3) | MENG13V | |||||
VMPEI | Price unit of previous period | VMPEI | DEC | 5(0) | PACK3 | |||||
VMSAL | Value of total valuated stock in previous period | VMSAL | CURR | 13(2) | WERT13N | |||||
VMSAV | Value based on moving average price (previous period) | VMSAV | CURR | 13(2) | WERT13N | |||||
VMSTP | Standard price in the previous period | VMSTP | CURR | 11(2) | WERT11V | |||||
VMVER | Moving Average Price/Periodic Unit Price in Previous Period | VMVER | CURR | 11(2) | WERT11V | |||||
VMVKS | Value of Tot. Valuated Stock at Sales Price in Previous Per. | VMVKS | CURR | 13(2) | WERT13N | |||||
VMVPR | Price Control Indicator in Previous Period | VMVPR | CHAR | 1(0) | VPRSV | |||||
VPRSV | Price control indicator | VPRSV | CHAR | 1(0) | VPRSV | |||||
WLINL | Date of Last Posted Count | DLINL | DATS | 8(0) | DATS | |||||
XBEWM | Valuation based on the batch-specific unit of measure | XBEWW | CHAR | 1(0) | XFELD | |||||
XLIFO | LIFO/FIFO-Relevant | XLIFO | CHAR | 1(0) | LIFO_FIFO | |||||
.INCLU--AP | 0(0) | |||||||||
OIPPINV | Prepaid Inventory Flag for Material Valuation Type Segment | JV_PPINV | CHAR | 1(0) | JV_PPINV |
Search for further information about these or an SAP related objects