MVKE SAP table for – Sales Data for Material

Here we would like to draw your attention to MVKE 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). MVKE is a SAP standard transparent table used for storing Sales Data for Material related data in SAP. It comes under the package MG.

SAP MVKE table

Table MVKE technical data

TableMVKE
Data storingSales Data for Material
ModuleLO
ComponentLO-MD
SAP PackageMG
Delivery ClassA – Application table (master and transaction data)
Table CategoryTRANSPARENT

SAP MVKE 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 MVKE table.

  • VMSTA
    Its data type is C (Character String) with field length 2
  • AUMNG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • EFMNG
    Its data type is P (Packed number (number with fixed number of decimal places)) with field length 7
  • SCHME
    Its data type is C (Character String) with field length 3
  • MTPOS
    Its data type is C (Character String) with field length 4
  • MATNR : Material Number
    Its a key field. Its data type is C (Character String) with field length 18
  • PRODH : Product Hierarchy
    Its data type is C (Character String) with field length 18
  • KONDM : Material pricing group
    Its data type is C (Character String) with field length 2
  • MVGR1
    Its data type is C (Character String) with field length 3
  • MVGR3
    Its data type is C (Character String) with field length 3
  • MVGR5
    Its data type is C (Character String) with field length 3
  • SSTUF
    Its data type is C (Character String) with field length 2
  • LSTFL
    Its data type is C (Character String) with field length 2
  • LSTAK
    Its data type is C (Character String) with field length 1
  • LDBFL
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • LDBZL
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • VTWEG : Distribution Channel
    Its a key field. Its data type is C (Character String) with field length 2
  • VDBFL
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • VDBZL
    Its data type is D (Date (Date: YYYYMMDD)) with field length 8
  • PRAT2
    Its data type is C (Character String) with field length 1
  • PRAT4
    Its data type is C (Character String) with field length 1
  • PRAT6
    Its data type is C (Character String) with field length 1
  • PRAT8
    Its data type is C (Character String) with field length 1
  • PRATA
    Its data type is C (Character String) with field length 1
  • MEGRU
    Its data type is C (Character String) with field length 4
  • RJART
    Its data type is C (Character String) with field length 1
  • VAVME
    Its data type is C (Character String) with field length 1
  • LVORM : Deletion Indicator
    Its data type is C (Character String) with field length 1
  • PVMSO
    Its data type is N (Character String with Digits Only) with field length 8
  • .INCLUDE : Key Fields of Database Tables for Multi-Value Attributes
    Its include structure/component is is /BEV1/EMGRP_I
  • /BEV1/EMDRCKSPL
    Its data type is N (Character String with Digits Only) with field length 1
  • /BEV1/RPSNS
    Its data type is C (Character String) with field length 1
  • VERSG
    Its data type is C (Character String) with field length 1
  • /BEV1/RPSKI
    Its data type is C (Character String) with field length 1
  • /BEV1/RPSSO
    Its data type is C (Character String) with field length 1
  • PROVG : Key for defining time intervals in a relationship
    Its data type is C (Character String) with field length 2