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