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 |
Possible values
|
||||||||||
| 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 |
Possible values
|
||||||||||
| 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 |
Possible values
|
||||||||||
| 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 |
Possible values
|
||||||||||
| PRAT2 | ID for product attribute 2 | PRAT2 | CHAR | 1 | 0 |
Possible values
|
||||||||||
| PRAT3 | ID for product attribute 3 | PRAT3 | CHAR | 1 | 0 |
Possible values
|
||||||||||
| PRAT4 | ID for product attribute 4 | PRAT4 | CHAR | 1 | 0 |
Possible values
|
||||||||||
| PRAT5 | ID for product attribute 5 | PRAT5 | CHAR | 1 | 0 |
Possible values
|
||||||||||
| PRAT6 | ID for product attribute 6 | PRAT6 | CHAR | 1 | 0 |
Possible values
|
||||||||||
| PRAT7 | ID for product attribute 7 | PRAT7 | CHAR | 1 | 0 |
Possible values
|
||||||||||
| PRAT8 | ID for product attribute 8 | PRAT8 | CHAR | 1 | 0 |
Possible values
|
||||||||||
| PRAT9 | ID for product attribute 9 | PRAT9 | CHAR | 1 | 0 |
Possible values
|
||||||||||
| PRATA | ID for product attribute 10 | PRATA | CHAR | 1 | 0 |
Possible values
|
||||||||||
| 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 |
Possible values
|
||||||||||
| PBIND | Indicator for price fixing | PBIND | CHAR | 1 | 0 |
Possible values
|
||||||||||
| VAVME | Variable Sales Unit Not Allowed | VAVME | CHAR | 1 | 0 |
Possible values
|
||||||||||
| MATKC | Competition characterization of a material | MATKC | CHAR | 1 | 0 |
Possible values
|
||||||||||
| 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 |
Possible values
|
||||||||||
| /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 |
Possible values
|
||||||||||
| /BEV1/RPSFA | Assignment to Totals Field Category 1 | /BEV1/RPSFA | CHAR | 1 | 0 |
Possible values
|
||||||||||
| /BEV1/RPSKI | Assignment to Totals Field Category 2 | /BEV1/RPSKI | CHAR | 1 | 0 |
Possible values
|
||||||||||
| /BEV1/RPSCO | Assignment to Totals Field Category 3 | /BEV1/RPSCO | CHAR | 1 | 0 |
Possible values
|
||||||||||
| /BEV1/RPSSO | Assignment to Totals Field Category 4 | /BEV1/RPSSO | CHAR | 1 | 0 |
Possible values
|
||||||||||
| 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 |
