MBEW SAP table for – Material Valuation

Here we would like to draw your attention to MBEW table in SAP. As we know it is being mainly used with the SAP LO-MD (Logistics Basic Data in LO) component which is coming under LO module (Logistics). MBEW is a SAP standard transparent table used for storing Material Valuation related data in SAP. It comes under the package MG.

SAP MBEW table

Table MBEW technical data

TableMBEW
Data storingMaterial Valuation
ModuleLO
ComponentLO-MD
SAP PackageMG
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP MBEW Table Fields

Here is the details of each fields in this table.You can find the discription, data type and assigned lenth of each of the fields in MBEW table.

  • VPLPX
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • LBWST
    Its data type is C (Character String) with field length 1
  • FBWST
    Its data type is C (Character String) with field length 1
  • QKLAS
    Its data type is C (Character String) with field length 4
  • VERPR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • MTORG
    Its data type is C (Character String) with field length 1
  • XBEWM
    Its data type is C (Character String) with field length 1
  • OKLAS
    Its data type is C (Character String) with field length 4
  • OIPPINV
    Its data type is C (Character String) with field length 1
  • PEINH : Price unit
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • SALKV
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • VMVPR
    Its data type is C (Character String) with field length 1
  • MATNR : Material Number
    Its a key field. Its data type is C (Character String) with field length 18
  • VMSTP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • VMPEI
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • VMBKL
    Its data type is C (Character String) with field length 4
  • VJSAL
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • VJVER
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • VJSTP
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • VJPEI
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 3
  • VJSAV
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • LFMON
    Its data type is N (Character String with Digits Only) with field length 2
  • STPRV
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • ZKPRS
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • TIMESTAMP : UTC Time Stamp in Long Form (YYYYMMDDhhmmssmmmuuun)
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 8
  • BWTAR : Valuation type
    Its a key field. Its data type is C (Character String) with field length 10
  • BWPRH
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • VVJSL
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • VVMLB
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is EMBEW2
  • ZPLP1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • ZPLP3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • ZPLD2
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PPERZ
    Its data type is N (Character String with Digits Only) with field length 6
  • PPERV
    Its data type is N (Character String with Digits Only) with field length 6
  • LVORM : Deletion Indicator
    Its data type is C (Character String) with field length 1
  • KALKZ
    Its data type is C (Character String) with field length 1
  • KALKV
    Its data type is C (Character String) with field length 1
  • KALSC
    Its data type is C (Character String) with field length 6
  • MYPOL
    Its data type is C (Character String) with field length 4
  • BWPH1
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • ABWKZ
    Its data type is N (Character String with Digits Only) with field length 2
  • KALNR : Cost Estimate Number for Cost Est. w/o Qty Structure
    Its data type is N (Character String with Digits Only) with field length 12
  • BWVA1
    Its data type is C (Character String) with field length 3
  • BWVA3
    Its data type is C (Character String) with field length 3
  • VERS2
    Its data type is N (Character String with Digits Only) with field length 2
  • HRKFT : Origin Group as Subdivision of Cost Element
    Its data type is C (Character String) with field length 4
  • KOSGR
    Its data type is C (Character String) with field length 10
  • PPRDZ
    Its data type is N (Character String with Digits Only) with field length 3
  • PPRDV
    Its data type is N (Character String with Digits Only) with field length 3
  • PDATV : Valid-From Date
    Its data type is N (Character String with Digits Only) with field length 4
  • SALK3
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • MLMAA
    Its data type is C (Character String) with field length 1
  • LPLPR
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 6
  • VKSAL
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • SPERW
    Its data type is C (Character String) with field length 1
  • WLINL
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8