1. Home
  2. Resources
  3. SAP Tables
  4. E1MVKEM - Master material sales data (MVKE)

SAP Table E1MVKEM

Master material sales data (MVKE)

E1MVKEM (Master material sales data (MVKE)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link E1MVKEM to other SAP tables.

E1MVKEM table fields

Field Data element Checktable Datatype Length Decimals
MSGFN Function MSGFN CHAR 3 0
003 Delete: Message contains objects to be deleted
004 Change: Message contains changes
005 Replace: This message replaces previous messages
009 Original: First message for process
023 Wait/Adjust: Data should not be imported
018 Resend
VKORG Sales Organization VKORG CHAR 4 0
VTWEG Distribution Channel VTWEG CHAR 2 0
LVORM Ind.: Flag material for deletion at distribution chain level LVOVK CHAR 1 0
X Yes
NULL No
VERSG Material statistics group STGMA CHAR 1 0
BONUS Volume rebate group BONUS CHAR 2 0
PROVG Commission group PROVG CHAR 2 0
SKTOF Cash discount indicator SKTOF CHAR 1 0
X Yes
NULL No
VMSTA Distribution-chain-specific material status VMSTA CHAR 2 0
VMSTD Character field, 8 characters long CHAR8 CHAR 8 0
AUMNG Text field length 14 CHAR14 CHAR 14 0
LFMNG Text field length 14 CHAR14 CHAR 14 0
EFMNG Text field length 14 CHAR14 CHAR 14 0
SCMNG Text field length 14 CHAR14 CHAR 14 0
SCHME 3-Byte field CHAR3 CHAR 3 0
VRKME 3-Byte field CHAR3 CHAR 3 0
MTPOS Item category group from material master MTPOS CHAR 4 0
DWERK Delivering Plant DWERK CHAR 4 0
PRODH Product hierarchy PRODH_D CHAR 18 0
PMATN Pricing Reference Material PMATN CHAR 18 0
KONDM Material Pricing Group KONDM CHAR 2 0
KTGRM Account assignment group for this material KTGRM CHAR 2 0
MVGR1 Material group 1 MVGR1 CHAR 3 0
MVGR2 Material group 2 MVGR2 CHAR 3 0
MVGR3 Material group 3 MVGR3 CHAR 3 0
MVGR4 Material group 4 MVGR4 CHAR 3 0
MVGR5 Material group 5 MVGR5 CHAR 3 0
SSTUF Assortment grade SSTUF CHAR 2 0
PFLKS External assortment priority PFLKS CHAR 1 0
LSTFL Listing procedure for store or other assortment categories LSTFL CHAR 2 0
LSTVZ Version Number Component CHAR2 CHAR 2 0
LSTAK Listing functions (assortments) are active LSTAK CHAR 1 0
NULL Listing not active
X Listing active
PRAT1 ID for product attribute 1 PRAT1 CHAR 1 0
NULL Product does not have this attribute
X Product has this attribute
PRAT2 ID for product attribute 2 PRAT2 CHAR 1 0
NULL Product does not have this attribute
X Product has this attribute
PRAT3 ID for product attribute 3 PRAT3 CHAR 1 0
NULL Product does not have this attribute
X Product has this attribute
PRAT4 ID for product attribute 4 PRAT4 CHAR 1 0
NULL Product does not have this attribute
X Product has this attribute
PRAT5 ID for product attribute 5 PRAT5 CHAR 1 0
NULL Product does not have this attribute
X Product has this attribute
PRAT6 ID for product attribute 6 PRAT6 CHAR 1 0
NULL Product does not have this attribute
X Product has this attribute
PRAT7 ID for product attribute 7 PRAT7 CHAR 1 0
NULL Product does not have this attribute
X Product has this attribute
PRAT8 ID for product attribute 8 PRAT8 CHAR 1 0
NULL Product does not have this attribute
X Product has this attribute
PRAT9 ID for product attribute 9 PRAT9 CHAR 1 0
NULL Product does not have this attribute
X Product has this attribute
PRATA ID for product attribute 10 PRATA CHAR 1 0
NULL Product does not have this attribute
X Product has this attribute
VAVME CHAR 1 0
RDPRF CHAR 4 0
MEGRU CHAR 4 0
PMATN_EXTERNAL CHAR 40 0
PMATN_VERSION CHAR 10 0
PMATN_GUID CHAR 32 0