Menu

SAP Table MBEW

Material Valuation

Recommended Now

All-new Echo Dot Smart speaker with Alexa

This bundle includes Echo Dot (3rd Gen) Charcoal and Philips Hue White A19 Medium Lumen Smart Bulb, 1100 Lumens. Built in Smart Home hub. Ask Alexa to control Zigbee-compatible devices. No additional Philips Hue hub required. Two choices for easy smart lighting - Start setting the mood with Hue Smart bulbs and your Echo device, supporting up to 5 Hue Bluetooth & Zigbee smart bulbs. Add the Hue Hub for whole-home smart lighting (up to 50 light points) and bonus features.

Check it out on amazon.com →

The table MBEW (Material Valuation) is a standard table in SAP ERP. It belongs to the package MG.

Technical Information

Table MBEW
Short Text Material Valuation
Package MG
Table Type Transparent Table

Fields for Table MBEW

Field Name Key Description Data Element Type Length Check Table
MANDT Client MANDT CLNT 3 T000
MATNR Material Number MATNR CHAR 18 MARA
BWKEY Valuation Area BWKEY CHAR 4 T001K
BWTAR Valuation Type BWTAR_D CHAR 10 *
LVORM Deletion flag for all material data of a valuation type LVOBA CHAR 1
LBKUM Total Valuated Stock LBKUM QUAN 13
SALK3 Value of Total Valuated Stock SALK3 CURR 13
VPRSV Price control indicator VPRSV CHAR 1
VERPR Moving Average Price/Periodic Unit Price VERPR CURR 11
STPRS Standard price STPRS CURR 11
PEINH Price Unit PEINH DEC 5
BKLAS Valuation Class BKLAS CHAR 4 T025
SALKV Value based on moving average price (only with price ctrl S) SALKV CURR 13
VMKUM Total valuated stock in previous period VMKUM QUAN 13
VMSAL Value of total valuated stock in previous period VMSAL CURR 13
VMVPR Price Control Indicator in Previous Period VMVPR CHAR 1
VMVER Moving Average Price/Periodic Unit Price in Previous Period VMVER CURR 11
VMSTP Standard price in the previous period VMSTP CURR 11
VMPEI Price unit of previous period VMPEI DEC 5
VMBKL Valuation Class in Previous Period VMBKL CHAR 4 T025
VMSAV Value based on moving average price (previous period) VMSAV CURR 13
VJKUM Total Valuated Stock in Previous Year VJKUM QUAN 13
VJSAL Value of total valuated stock in previous year VJSAL CURR 13
VJVPR Price Control Indicator in Previous Year VJVPR CHAR 1
VJVER Moving Average Price/Periodic Unit Price in Previous Year VJVER CURR 11
VJSTP Standard price in previous year VJSTP CURR 11
VJPEI Price unit of previous year VJPEI DEC 5
VJBKL Valuation Class in Previous Year VJBKL CHAR 4 T025
VJSAV Value based on moving average price (previous year) VJSAV CURR 13
LFGJA Fiscal Year of Current Period LFGJA NUMC 4
LFMON Current period (posting period) LFMON NUMC 2
BWTTY Valuation Category BWTTY_D CHAR 1 T149
STPRV Previous price STPRV CURR 11
LAEPR Date of the last price change LAEPR DATS 8
ZKPRS Future price DZKPRS CURR 11
ZKDAT Date as of which the price is valid DZKDAT DATS 8
TIMESTAMP UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TIMESTAMP DEC 15
BWPRS Valuation price based on tax law: level 1 BWPRS CURR 11
BWPRH Valuation price based on commercial law: level 1 BWPRH CURR 11
VJBWS Valuation price based on tax law: level 3 VJBWS CURR 11
VJBWH Valuation price based on commercial law: level 3 VJBWH CURR 11
VVJSL Value of total valuated stock in year before last VVJSL CURR 13
VVJLB Total valuated stock in year before last VVJLB QUAN 13
VVMLB Total valuated stock in period before last VVMLB QUAN 13
VVSAL Value of total valuated stock in period before last VVSAL CURR 13
ZPLPR Future planned price DZPLPR CURR 11
ZPLP1 Future Planned Price 1 DZPLP1 CURR 11
ZPLP2 Future Planned Price 2 DZPLP2 CURR 11
ZPLP3 Future Planned Price 3 DZPLP3 CURR 11
ZPLD1 Date from Which Future Planned Price 1 Is Valid DZPLD1 DATS 8
ZPLD2 Date from Which Future Planned Price 2 Is Valid DZPLD2 DATS 8
ZPLD3 Date from Which Future Planned Price 3 Is Valid DZPLD3 DATS 8
PPERZ Period for future standard cost estimate (deactivated) PPERZ ACCP 6
PPERL Period for current standard cost estimate (deactivated) PPERL ACCP 6
PPERV Period for previous standard cost estimate (deactivated) PPERV ACCP 6
KALKZ Indicator: standard cost estimate for future period KAXKZ CHAR 1
KALKL Standard Cost Estimate for Current Period KALKL CHAR 1
KALKV Indicator: standard cost estimate for previous period KALKV CHAR 1
KALSC Overhead key (deactivated) KALSC CHAR 6
XLIFO LIFO/FIFO-Relevant XLIFO CHAR 1
MYPOL Pool number for LIFO valuation MYPOOL CHAR 4 TPOOL
BWPH1 Valuation price based on commercial law: level 2 BWPH1 CURR 11
BWPS1 Valuation price based on tax law: level 2 BWPS1 CURR 11
ABWKZ Lowest value: devaluation indicator ABWKZ NUMC 2
PSTAT Maintenance status PSTAT_D CHAR 15
KALN1 Cost Estimate Number - Product Costing CK_KALNR1 NUMC 12 *
KALNR Cost Estimate Number for Cost Est. w/o Qty Structure CK_KALNR NUMC 12 *
BWVA1 Valuation Variant for Future Standard Cost Estimate CK_BWVA1 CHAR 3 TCK05
BWVA2 Valuation Variant for Current Standard Cost Estimate CK_BWVA2 CHAR 3 TCK05
BWVA3 Valuation Variant for Previous Standard Cost Estimate CK_BWVA3 CHAR 3 TCK05
VERS1 Costing Version of Future Standard Cost Estimate CK_TVERS1 NUMC 2
VERS2 Costing Version of Current Standard Cost Estimate CK_TVERS2 NUMC 2
VERS3 Costing Version of Previous Standard Cost Estimate CK_TVERS3 NUMC 2
HRKFT Origin Group as Subdivision of Cost Element HRKFT CHAR 4 TKKH1
KOSGR Costing Overhead Group CK_KOSGR CHAR 10 TCK14
PPRDZ Period of Future Standard Cost Estimate CK_PPRDZ NUMC 3
PPRDL Period of Current Standard Cost Estimate CK_PPRDL NUMC 3
PPRDV Period of Previous Standard Cost Estimate CK_PPRDV NUMC 3
PDATZ Fiscal Year of Future Standard Cost Estimate CK_PDATZ NUMC 4
PDATL Fiscal Year of Current Standard Cost Estimate CK_PDATL NUMC 4
PDATV Fiscal Year of Previous Standard Cost Estimate CK_PDATV NUMC 4
EKALR Material Is Costed with Quantity Structure CK_EKALREL CHAR 1
VPLPR Previous planned price VPLPR CURR 11
MLMAA Material ledger activated at material level CK_ML_MAAC CHAR 1
MLAST Material Price Determination: Control CK_ML_ABST CHAR 1
LPLPR Current Planned Price CK_LPLPR CURR 11
VKSAL Value of Total Valuated Stock at Sales Price VKSAL CURR 13
HKMAT Material-related origin HKMAT CHAR 1
SPERW Physical Inventory Blocking Indicator SPERR CHAR 1
KZIWL Phys. inventory indicator for value-only material KZIWL CHAR 3
WLINL Date of Last Posted Count for Unrestricted-Use Stock DLINL DATS 8
ABCIW Physical inventory indicator for cycle counting ABCIN CHAR 1 *
BWSPA Valuation margin BWSPA DEC 6
LPLPX Fixed Portion of Current Planned Price CK_LPLPX CURR 11
VPLPX Fixed Portion of Previous Planned Price CK_VPLPX CURR 11
FPLPX Fixed Portion of Future Planned Price CK_ZPLPX CURR 11
LBWST Val. Strat. for Current Plan Price, Sales Order/Proj. Stock CK_LBWST CHAR 1
VBWST Valuation Strategy for Previous Plan Price, Special Stock CK_VBWST CHAR 1
FBWST Valuation Strategy for Future Planned Price, Special Stock CK_ZBWST CHAR 1
EKLAS Valuation Class for Sales Order Stock EKLAS CHAR 4 T025
QKLAS Valuation Class for Project Stock QKLAS CHAR 4 T025
MTUSE Usage of the material J_1BMATUSE CHAR 1
MTORG Origin of the material J_1BMATORG CHAR 1
OWNPR Produced in-house J_1BOWNPRO CHAR 1
XBEWM Valuation based on the batch-specific unit of measure XBEWW CHAR 1
BWPEI Price unit for valuation prices based on tax/commercial law BWPEI DEC 5
MBRUE MBEWH rec. already exists for per. before last of MBEW per. MBRUE CHAR 1
OKLAS Valuation Class for Special Stock at the Vendor OKLAS CHAR 4 T025
OIPPINV Prepaid Inventory Flag for Material Valuation Type Segment JV_PPINV CHAR 1