1. Home
  2. Resources
  3. SAP Tables
  4. MVKE - Sales Data for Material

SAP Table MVKE

Sales Data for Material

MVKE (Sales Data for Material) 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 MVKE to other SAP tables.

MVKE table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
MATNR Material Number MATNR MARA CHAR 18 0
VKORG Sales Organization VKORG TVKO CHAR 4 0
VTWEG Distribution Channel VTWEG TVTW 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 TVSM CHAR 1 0
BONUS Volume rebate group BONUS TVBO CHAR 2 0
PROVG Commission group PROVG TVPR CHAR 2 0
SKTOF Cash discount indicator SKTOF CHAR 1 0
X Yes
NULL No
VMSTA Distribution-chain-specific material status VMSTA TVMS CHAR 2 0
VMSTD Date from which distr.-chain-spec. material status is valid VMSTD DATS 8 0
AUMNG Minimum order quantity in base unit of measure MINAU QUAN 13 3
LFMNG Minimum delivery quantity in delivery note processing MINLF QUAN 13 3
EFMNG Minimum make-to-order quantity MINEF QUAN 13 3
SCMNG Delivery unit SCHRT QUAN 13 3
SCHME Unit of measure of delivery unit SCHME T006 UNIT 3 0
VRKME Sales unit VRKME T006 UNIT 3 0
MTPOS Item category group from material master MTPOS TPTM CHAR 4 0
DWERK Delivering Plant (Own or External) DWERK_EXT TVKWZ CHAR 4 0
PRODH Product hierarchy PRODH_D T179 CHAR 18 0
PMATN Pricing Reference Material PMATN MARA CHAR 18 0
KONDM Material Pricing Group KONDM T178 CHAR 2 0
KTGRM Account assignment group for this material KTGRM TVKM CHAR 2 0
MVGR1 Material group 1 MVGR1 TVM1 CHAR 3 0
MVGR2 Material group 2 MVGR2 TVM2 CHAR 3 0
MVGR3 Material group 3 MVGR3 TVM3 CHAR 3 0
MVGR4 Material group 4 MVGR4 TVM4 CHAR 3 0
MVGR5 Material group 5 MVGR5 TVM5 CHAR 3 0
SSTUF Assortment grade SSTUF TWSS CHAR 2 0
PFLKS External assortment priority PFLKS TWSP CHAR 1 0
LSTFL Listing procedure for store or other assortment categories LSTFL TWLV CHAR 2 0
LSTVZ Listing procedure for distr. center assortment categories LSTVZ TWLV CHAR 2 0
LSTAK Listing functions (assortments) are active LSTAK CHAR 1 0
NULL Listing not active
X Listing active
LDVFL Date from which listed in the store LDVFL DATS 8 0
LDBFL Date to which listed in the store LDBFL DATS 8 0
LDVZL Date from which listed in the distribution center LDVZL DATS 8 0
LDBZL Date to which listed in the central warehouse/distr. center LDBZL DATS 8 0
VDVFL Date from which sold in the store VDVFL DATS 8 0
VDBFL Date to which sold in the store VDBFL DATS 8 0
VDVZL Date from which sold in the distribution center VDVZL DATS 8 0
VDBZL Date to which sold in the distribution center VDBZL DATS 8 0
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
RDPRF Rounding Profile RDPRF RDPR CHAR 4 0
MEGRU Unit of Measure Group MEGRU TWMEG CHAR 4 0
LFMAX Maximum delivery quantity in store order processing MAXLF QUAN 13 3
RJART Flag rackjobber material RJART CHAR 1 0
X Yes
NULL No
PBIND Indicator for price fixing PBIND CHAR 1 0
NULL No price fixing
1 Suggested sales price
2 Fixed price
VAVME Variable Sales Unit Not Allowed VAVME CHAR 1 0
X Yes
NULL No
MATKC Competition characterization of a material MATKC CHAR 1 0
NULL No competition
A Weak competition
B Medium competition
C Strong competition
PVMSO Material sorting in product proposal PVMSO NUMC 8 0
/BEV1/EMLGRP Empties Group /BEV1/EMLGGRP /BEV1/EMGRP CHAR 4 0
/BEV1/EMDRCKSPL Print Column Empties Returns Block /BEV1/EMPRTCOL NUMC 1 0
1 Column 1
2 Column 2
3 Column 3
4 Column 4
/BEV1/RPBEZME Base Unit of Measure for Statistics Totals List/Planning /BEV1/RPBEZME UNIT 3 0
/BEV1/RPSNS No Allocation to Totals Field (Do not Total) /BEV1/RPSNS CHAR 1 0
X Yes
NULL No
/BEV1/RPSFA Assignment to Totals Field Category 1 /BEV1/RPSFA CHAR 1 0
X Yes
NULL No
/BEV1/RPSKI Assignment to Totals Field Category 2 /BEV1/RPSKI CHAR 1 0
X Yes
NULL No
/BEV1/RPSCO Assignment to Totals Field Category 3 /BEV1/RPSCO CHAR 1 0
X Yes
NULL No
/BEV1/RPSSO Assignment to Totals Field Category 4 /BEV1/RPSSO CHAR 1 0
X Yes
NULL No
PLGTP Price Band Category WRF_PLGTP TWPT CHAR 2 0

MVKE foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MVKE /BEV1/EMLGRP SYST MANDT /BEV1/EMGRP Empties Group MANDT
MVKE /BEV1/EMLGRP MVKE /BEV1/EMLGRP /BEV1/EMGRP Empties Group LGGRP
MVKE BONUS MVKE BONUS TVBO Sales Rebate Groups BONUS
MVKE BONUS MVKE MANDT TVBO Sales Rebate Groups MANDT
MVKE DWERK MVKE MANDT TVKWZ Org.Unit: Allowed Plants per Sales Organization MANDT
MVKE DWERK MVKE VKORG TVKWZ Org.Unit: Allowed Plants per Sales Organization VKORG
MVKE DWERK MVKE VTWEG TVKWZ Org.Unit: Allowed Plants per Sales Organization VTWEG
MVKE DWERK MVKE DWERK TVKWZ Org.Unit: Allowed Plants per Sales Organization WERKS
MVKE KONDM MVKE KONDM T178 Conditions: Groups for Materials KONDM
MVKE KONDM MVKE MANDT T178 Conditions: Groups for Materials MANDT
MVKE KTGRM MVKE MANDT TVKM Materials: Account Assignment Groups MANDT
MVKE KTGRM MVKE KTGRM TVKM Materials: Account Assignment Groups KTGRM
MVKE LSTFL SY MANDT TWLV Listing procedure, assortments MANDT
MVKE LSTFL MVKE LSTFL TWLV Listing procedure, assortments LSTFL
MVKE LSTVZ SY MANDT TWLV Listing procedure, assortments MANDT
MVKE LSTVZ MVKE LSTVZ TWLV Listing procedure, assortments LSTFL
MVKE MANDT MVKE MANDT T000 Clients MANDT
MVKE MATNR MVKE MANDT MARA General Material Data MANDT
MVKE MATNR MVKE MATNR MARA General Material Data MATNR
MVKE MEGRU MVKE MEGRU TWMEG Unit of measure group MEGRU
MVKE MEGRU * TWMEG Unit of measure group MEINS
MVKE MEGRU MVKE MANDT TWMEG Unit of measure group MANDT
MVKE MTPOS MVKE MANDT TPTM Materials: Item Category Groups in Material Master MANDT
MVKE MTPOS MVKE MTPOS TPTM Materials: Item Category Groups in Material Master MTPOS
MVKE MVGR1 MVKE MVGR1 TVM1 Material Pricing Group 1 MVGR1
MVKE MVGR1 MVKE MANDT TVM1 Material Pricing Group 1 MANDT
MVKE MVGR2 MVKE MANDT TVM2 Material Pricing Group 2 MANDT
MVKE MVGR2 MVKE MVGR2 TVM2 Material Pricing Group 2 MVGR2
MVKE MVGR3 MVKE MANDT TVM3 Material Pricing Group 3 MANDT
MVKE MVGR3 MVKE MVGR3 TVM3 Material Pricing Group 3 MVGR3
MVKE MVGR4 MVKE MVGR4 TVM4 Material Pricing Group 4 MVGR4
MVKE MVGR4 MVKE MANDT TVM4 Material Pricing Group 4 MANDT
MVKE MVGR5 MVKE MANDT TVM5 Material Pricing Group 5 MANDT
MVKE MVGR5 MVKE MVGR5 TVM5 Material Pricing Group 5 MVGR5
MVKE PFLKS MVKE PFLKS TWSP Assortment priorities IS-R PFLKS
MVKE PFLKS SY MANDT TWSP Assortment priorities IS-R MANDT
MVKE PLGTP SYST MANDT TWPT Price band categories MANDT
MVKE PLGTP MVKE PLGTP TWPT Price band categories PLGTP
MVKE PMATN MVKE MANDT MARA General Material Data MANDT
MVKE PMATN MVKE PMATN MARA General Material Data MATNR
MVKE PRODH MVKE MANDT T179 Materials: Product Hierarchies MANDT
MVKE PRODH MVKE PRODH T179 Materials: Product Hierarchies PRODH
MVKE PROVG MVKE MANDT TVPR Commission Groups MANDT
MVKE PROVG MVKE PROVG TVPR Commission Groups PROVG
MVKE RDPRF MVKE MANDT RDPR Rounding profile MANDT
MVKE RDPRF MVKE DWERK RDPR Rounding profile WERKS
MVKE RDPRF MVKE RDPRF RDPR Rounding profile RDPRF
MVKE RDPRF * RDPR Rounding profile RDZAE
MVKE SCHME MVKE MANDT T006 Units of Measurement MANDT
MVKE SCHME MVKE SCHME T006 Units of Measurement MSEHI
MVKE SSTUF SY MANDT TWSS Assortment grade IS-R MANDT
MVKE SSTUF MVKE SSTUF TWSS Assortment grade IS-R SSTUF
MVKE VERSG MVKE MANDT TVSM Material statistics groups MANDT
MVKE VERSG MVKE VERSG TVSM Material statistics groups STGMA
MVKE VKORG MVKE MANDT TVKO Organizational Unit: Sales Organizations MANDT
MVKE VKORG MVKE VKORG TVKO Organizational Unit: Sales Organizations VKORG
MVKE VMSTA MVKE MANDT TVMS Materials: Status in Sales and Distribution MANDT
MVKE VMSTA MVKE VMSTA TVMS Materials: Status in Sales and Distribution VMSTA
MVKE VRKME MVKE MANDT T006 Units of Measurement MANDT
MVKE VRKME MVKE VRKME T006 Units of Measurement MSEHI
MVKE VTWEG MVKE VTWEG TVTW Organizational Unit: Distribution Channels VTWEG
MVKE VTWEG MVKE MANDT TVTW Organizational Unit: Distribution Channels MANDT