SAP Table MBEW - Material Valuation

Field Key Data Element Type Offset Leng Decimals Check Table Text
MANDT X MANDT CLNT 0 3 0 T000 Client
MATNR X MATNR CHAR 3 18 0 MARA Material Number
BWKEY X BWKEY CHAR 21 4 0 T001K Valuation Area
BWTAR X BWTAR_D CHAR 25 10 0 T149D Valuation Type
LVORM LVOBA CHAR 35 1 0 Deletion flag for all material data of a valuation type
LBKUM LBKUM QUAN 36 13 3 Total Valuated Stock
SALK3 SALK3 CURR 43 13 2 Value of Total Valuated Stock
VPRSV VPRSV CHAR 50 1 0 Price Control Indicator
VERPR VERPR CURR 51 11 2 Moving Average Price/Periodic Unit Price
STPRS STPRS CURR 57 11 2 Standard price
PEINH PEINH DEC 63 5 0 Price Unit
BKLAS BKLAS CHAR 66 4 0 T025 Valuation Class
SALKV SALKV CURR 70 13 2 Value based on moving average price (only with price ctrl S)
VMKUM VMKUM QUAN 77 13 3 Total valuated stock in previous period
VMSAL VMSAL CURR 84 13 2 Value of total valuated stock in previous period
VMVPR VMVPR CHAR 91 1 0 Price Control Indicator in Previous Period
VMVER VMVER CURR 92 11 2 Moving Average Price/Periodic Unit Price in Previous Period
VMSTP VMSTP CURR 98 11 2 Standard price in the previous period
VMPEI VMPEI DEC 104 5 0 Price unit of previous period
VMBKL VMBKL CHAR 107 4 0 T025 Valuation Class in Previous Period
VMSAV VMSAV CURR 111 13 2 Value based on moving average price (previous period)
VJKUM VJKUM QUAN 118 13 3 Total Valuated Stock in Previous Year
VJSAL VJSAL CURR 125 13 2 Value of total valuated stock in previous year
VJVPR VJVPR CHAR 132 1 0 Price Control Indicator in Previous Year
VJVER VJVER CURR 133 11 2 Moving Average Price/Periodic Unit Price in Previous Year
VJSTP VJSTP CURR 139 11 2 Standard price in previous year
VJPEI VJPEI DEC 145 5 0 Price unit of previous year
VJBKL VJBKL CHAR 148 4 0 T025 Valuation Class in Previous Year
VJSAV VJSAV CURR 152 13 2 Value based on moving average price (previous year)
LFGJA LFGJA NUMC 159 4 0 Fiscal Year of Current Period
LFMON LFMON NUMC 163 2 0 Current period (posting period)
BWTTY BWTTY_D CHAR 165 1 0 T149C Valuation Category
STPRV STPRV CURR 166 11 2 Previous price
LAEPR LAEPR DATS 172 8 0 Date of the last price change
ZKPRS DZKPRS CURR 180 11 2 Future price
ZKDAT DZKDAT DATS 186 8 0 Date as of which the price is valid
TIMESTAMP TIMESTAMP DEC 194 15 0 UTC Time Stamp in Short Form (YYYYMMDDhhmmss)
BWPRS BWPRS CURR 202 11 2 Valuation price based on tax law: level 1
BWPRH BWPRH CURR 208 11 2 Valuation price based on commercial law: level 1
VJBWS VJBWS CURR 214 11 2 Valuation price based on tax law: level 3
VJBWH VJBWH CURR 220 11 2 Valuation price based on commercial law: level 3
VVJSL VVJSL CURR 226 13 2 Value of total valuated stock in year before last
VVJLB VVJLB QUAN 233 13 3 Total valuated stock in year before last
VVMLB VVMLB QUAN 240 13 3 Total valuated stock in period before last
VVSAL VVSAL CURR 247 13 2 Value of total valuated stock in period before last
ZPLPR DZPLPR CURR 254 11 2 Future planned price
ZPLP1 DZPLP1 CURR 260 11 2 Future Planned Price 1
ZPLP2 DZPLP2 CURR 266 11 2 Future Planned Price 2
ZPLP3 DZPLP3 CURR 272 11 2 Future Planned Price 3
ZPLD1 DZPLD1 DATS 278 8 0 Date from Which Future Planned Price 1 Is Valid
ZPLD2 DZPLD2 DATS 286 8 0 Date from Which Future Planned Price 2 Is Valid
ZPLD3 DZPLD3 DATS 294 8 0 Date from Which Future Planned Price 3 Is Valid
PPERZ PPERZ ACCP 302 6 0 Period for future standard cost estimate (deactivated)
PPERL PPERL ACCP 308 6 0 Period for current standard cost estimate (deactivated)
PPERV PPERV ACCP 314 6 0 Period for previous standard cost estimate (deactivated)
KALKZ KAXKZ CHAR 320 1 0 Indicator: standard cost estimate for future period
KALKL KALKL CHAR 321 1 0 Standard Cost Estimate for Current Period
KALKV KALKV CHAR 322 1 0 Indicator: standard cost estimate for previous period
KALSC KALSC CHAR 323 6 0 Overhead key (deactivated)
XLIFO XLIFO CHAR 329 1 0 LIFO/FIFO-Relevant
MYPOL MYPOOL CHAR 330 4 0 TPOOL Pool number for LIFO valuation
BWPH1 BWPH1 CURR 334 11 2 Valuation price based on commercial law: level 2
BWPS1 BWPS1 CURR 340 11 2 Valuation price based on tax law: level 2
ABWKZ ABWKZ NUMC 346 2 0 Lowest value: devaluation indicator
PSTAT PSTAT_D CHAR 348 15 0 Maintenance status
KALN1 CK_KALNR1 NUMC 363 12 0 Cost Estimate Number - Product Costing
KALNR CK_KALNR NUMC 375 12 0 Cost Estimate Number for Cost Est. w/o Qty Structure
BWVA1 CK_BWVA1 CHAR 387 3 0 TCK05 Valuation Variant for Future Standard Cost Estimate
BWVA2 CK_BWVA2 CHAR 390 3 0 TCK05 Valuation Variant for Current Standard Cost Estimate
BWVA3 CK_BWVA3 CHAR 393 3 0 TCK05 Valuation Variant for Previous Standard Cost Estimate
VERS1 CK_TVERS1 NUMC 396 2 0 Costing Version of Future Standard Cost Estimate
VERS2 CK_TVERS2 NUMC 398 2 0 Costing Version of Current Standard Cost Estimate
VERS3 CK_TVERS3 NUMC 400 2 0 Costing Version of Previous Standard Cost Estimate
HRKFT HRKFT CHAR 402 4 0 TKKH1 Origin Group as Subdivision of Cost Element
KOSGR CK_KOSGR CHAR 406 10 0 Costing Overhead Group
PPRDZ CK_PPRDZ NUMC 416 3 0 Period of Future Standard Cost Estimate
PPRDL CK_PPRDL NUMC 419 3 0 Period of Current Standard Cost Estimate
PPRDV CK_PPRDV NUMC 422 3 0 Period of Previous Standard Cost Estimate
PDATZ CK_PDATZ NUMC 425 4 0 Fiscal Year of Future Standard Cost Estimate
PDATL CK_PDATL NUMC 429 4 0 Fiscal Year of Current Standard Cost Estimate
PDATV CK_PDATV NUMC 433 4 0 Fiscal Year of Previous Standard Cost Estimate
EKALR CK_EKALREL CHAR 437 1 0 Material Is Costed with Quantity Structure
VPLPR VPLPR CURR 438 11 2 Previous planned price
MLMAA CK_ML_MAAC CHAR 444 1 0 Material ledger activated at material level
MLAST CK_ML_ABST CHAR 445 1 0 Material Price Determination: Control
LPLPR CK_LPLPR CURR 446 11 2 Current Planned Price
VKSAL VKSAL CURR 452 13 2 Value of Total Valuated Stock at Sales Price
HKMAT HKMAT CHAR 459 1 0 Material-related origin
SPERW SPERR CHAR 460 1 0 Physical Inventory Blocking Indicator
KZIWL KZIWL CHAR 461 3 0 Phys. inventory indicator for value-only material
WLINL DLINL DATS 464 8 0 Date of Last Posted Count for Unrestricted-Use Stock
ABCIW ABCIN CHAR 472 1 0 Physical inventory indicator for cycle counting
BWSPA BWSPA DEC 473 6 2 Valuation margin
LPLPX CK_LPLPX CURR 477 11 2 Fixed Portion of Current Planned Price
VPLPX CK_VPLPX CURR 483 11 2 Fixed Portion of Previous Planned Price
FPLPX CK_ZPLPX CURR 489 11 2 Fixed Portion of Future Planned Price
LBWST CK_LBWST CHAR 495 1 0 Val. Strat. for Current Plan Price, Sales Order/Proj. Stock
VBWST CK_VBWST CHAR 496 1 0 Valuation Strategy for Previous Plan Price, Special Stock
FBWST CK_ZBWST CHAR 497 1 0 Valuation Strategy for Future Planned Price, Special Stock
EKLAS EKLAS CHAR 498 4 0 T025 Valuation Class for Sales Order Stock
QKLAS QKLAS CHAR 502 4 0 T025 Valuation Class for Project Stock
MTUSE J_1BMATUSE CHAR 506 1 0 Usage of the material
MTORG J_1BMATORG CHAR 507 1 0 Origin of the material
OWNPR J_1BOWNPRO CHAR 508 1 0 Produced in-house
XBEWM XBEWW CHAR 509 1 0 Valuation based on the batch-specific unit of measure
BWPEI BWPEI DEC 510 5 0 Price unit for valuation prices based on tax/commercial law
MBRUE MBRUE CHAR 513 1 0 MBEWH rec. already exists for per. before last of MBEW per.
OKLAS OKLAS CHAR 514 4 0 T025 Valuation Class for Special Stock at the Vendor
OIPPINV JV_PPINV CHAR 518 1 0 Prepaid Inventory Flag for Material Valuation Type Segment

1737307EBP: Brazil specific fields in the Product Master
1227242FAQ: Differences between material master & article master
204393Inconsistencies between stocks of MARD and MBEW
735425OLI1(BW): BKLAS incorrect in project-/sales order stock
836968MR11: Incorrect valuation for value-only article
1305016MR11: Negative stock value for value-only article II
547351MM17:mass change price unit / ALE interface
690027FAQ: Reporting IM (no LIS)
1116512Valuated GR blocked stock and split valuation
1024725WRFMASSMAT: How to support customer defined fields
996306Documentation: BAdI CKML_SET_VPRSV
171465Period closing as of Release 4.5A
702433Avoiding CKMI1 entries with initial cost estimate number
203341Performance improvement: Prefetch on MBEW
604209Logical DB BMM: Preventing the DBIF_RSQL_INVALID_RSQL error
767786Stock in transit valued incorrectly with split valuation
762219RMCBINIT_BW: Value or quantity determined incorrectly
758863MIRO: Value-only material not in FI document
398941INFORMATION: CO-PC-ACT (Data structures)
663681PLUG: Rounding errors + valuation errors in initial stocks
443937MM_MATNR: History tables not deleted
616119PLUG: Stock initialization - Calculated special stocks
327964MM_MATNR: archiving of MBEWH entries
523033Downgrade of modifications in Transaction CKMM
392078MM_MATNR: No check of previous years´ balances
543722Incorrect valuation category in QBEW/EBEW
487243Update of MBEW during gain/loss does not occur
511255Incorrect valuation for exchange receipts
304424Transaction COGI:No lock for repetitive manufacturing
501773Material Valuation Problem
485830MCHA: Missing valuation type with single batch valuation
437613MR11: Clearing IR surplus with partial stock valuated mater
216783EWUMMPRS: Different price through changeover to the euro
339444Initial data creation: Field without foreign keys
380159MR11: Account maintenance creates no MBEWH records
323892MASS: Cannot select currency fields
303485Runtime problems during ATP check
206145Stock accounting view incorrect after R/2 migration
8696Valuation level can no longer be maintained