SAP table MVKE (Sales Data for Material)

SAP table MVKE has 4 primary key fields being MANDT,MATNR,VKORG,VTWEG.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 T000 MANDT
MATNR Material Number CHAR 40 0 MARA MATNR
VKORG Sales Organization CHAR 4 0 TVKO VKORG
VTWEG Distribution Channel CHAR 2 0 TVTW VTWEG
LVORM Ind.: Flag material for deletion at distribution chain level CHAR 1 0 LVOVK
VERSG Material statistics group CHAR 1 0 TVSM STGMA
BONUS Volume rebate group CHAR 2 0 TVBO BONUS
PROVG Commission Group CHAR 2 0 TVPR PROVG
SKTOF Cash Discount Indicator CHAR 1 0 SKTOF
VMSTA Distribution-chain-specific material status CHAR 2 0 TVMS VMSTA
VMSTD Date from which distr.-chain-spec. material status is valid DATS 8 0 VMSTD
AUMNG Minimum order quantity in base unit of measure QUAN 13 3 MINAU
LFMNG Minimum Delivery Quantity in Delivery Note Processing QUAN 13 3 MINLF
EFMNG Minimum make-to-order quantity QUAN 13 3 MINEF
SCMNG Delivery unit QUAN 13 3 SCHRT
SCHME Unit of measure of delivery unit UNIT 3 0 T006 SCHME
VRKME Sales unit UNIT 3 0 T006 VRKME
MTPOS Item Category Group from Material Master CHAR 4 0 TPTM MTPOS
DWERK Delivering Plant (Own or External) CHAR 4 0 TVKWZ DWERK_EXT
PRODH Product hierarchy CHAR 18 0 T179 PRODH_D
PMATN Pricing Reference Material CHAR 40 0 MARA PMATN
KONDM Material Price Group CHAR 2 0 T178 KONDM
KTGRM Account Assignment Group for Material CHAR 2 0 TVKM KTGRM
MVGR1 Material Group 1 CHAR 3 0 TVM1 MVGR1
MVGR2 Material Group 2 CHAR 3 0 TVM2 MVGR2
MVGR3 Material Group 3 CHAR 3 0 TVM3 MVGR3
MVGR4 Material Group 4 CHAR 3 0 TVM4 MVGR4
MVGR5 Material Group 5 CHAR 3 0 TVM5 MVGR5
IS_ENTLMNT_RLVT Relevant for Entitlement Generation CHAR 1 0 CMD_PRD_IS_ENTLMNT_RLVT
SSTUF Assortment grade CHAR 2 0 TWSS SSTUF
PFLKS External assortment priority CHAR 1 0 TWSP PFLKS
LSTFL Listing procedure for store or other assortment categories CHAR 2 0 TWLV LSTFL
LSTVZ Listing procedure for distr. center assortment categories CHAR 2 0 TWLV LSTVZ
LSTAK Listing functions (assortments) are active CHAR 1 0 LSTAK
Listing not active
X Listing active
LDVFL Date from which listed in the store DATS 8 0 LDVFL
LDBFL Date to which listed in the store DATS 8 0 LDBFL
LDVZL Date from which listed in the distribution center DATS 8 0 LDVZL
LDBZL Date to which listed in the central warehouse/distr. center DATS 8 0 LDBZL
VDVFL Date from which sold in the store DATS 8 0 VDVFL
VDBFL Date to which sold in the store DATS 8 0 VDBFL
VDVZL Date from which sold in the distribution center DATS 8 0 VDVZL
VDBZL Date to which sold in the distribution center DATS 8 0 VDBZL
PRAT1 ID for product attribute 1 CHAR 1 0 PRAT1
PRAT2 ID for product attribute 2 CHAR 1 0 PRAT2
PRAT3 ID for product attribute 3 CHAR 1 0 PRAT3
PRAT4 ID for product attribute 4 CHAR 1 0 PRAT4
PRAT5 ID for product attribute 5 CHAR 1 0 PRAT5
PRAT6 ID for product attribute 6 CHAR 1 0 PRAT6
PRAT7 ID for product attribute 7 CHAR 1 0 PRAT7
PRAT8 ID for product attribute 8 CHAR 1 0 PRAT8
PRAT9 ID for product attribute 9 CHAR 1 0 PRAT9
PRATA ID for product attribute 10 CHAR 1 0 PRATA
Product does not have this attribute
X Product has this attribute
RDPRF Rounding Profile CHAR 4 0 RDPR RDPRF
MEGRU Unit of Measure Group CHAR 4 0 TWMEG MEGRU
LFMAX Maximum delivery quantity in store order processing QUAN 13 3 MAXLF
RJART Flag rackjobber material CHAR 1 0 RJART
PBIND Indicator for price fixing CHAR 1 0 PBIND
No price fixing
1 Suggested sales price
2 Fixed price
VAVME Variable Sales Unit Not Allowed CHAR 1 0 VAVME
MATKC Competition characterization of a material CHAR 1 0 MATKC
No competition
A Weak competition
B Medium competition
C Strong competition
PVMSO Material sorting in product proposal NUMC 8 0 * PVMSO
DUMMY_SALD_INCL_EEW_PS MD Product Sales Delivery CHAR 1 0 SALD_INCL_EEW
/BEV1/EMLGRP Empties Group CHAR 4 0 /BEV1/EMGRP /BEV1/EMLGGRP
/BEV1/EMDRCKSPL Print Column Empties Returns Block NUMC 1 0 /BEV1/EMPRTCOL
1 Column 1
2 Column 2
3 Column 3
4 Column 4
/BEV1/RPBEZME Base Unit of Measure for Statistics Totals List/Planning UNIT 3 0 * /BEV1/RPBEZME
/BEV1/RPSNS No Allocation to Totals Field (Do not Total) CHAR 1 0 /BEV1/RPSNS
/BEV1/RPSFA Assignment to Totals Field Category 1 CHAR 1 0 /BEV1/RPSFA
/BEV1/RPSKI Assignment to Totals Field Category 2 CHAR 1 0 /BEV1/RPSKI
/BEV1/RPSCO Assignment to Totals Field Category 3 CHAR 1 0 /BEV1/RPSCO
/BEV1/RPSSO Assignment to Totals Field Category 4 CHAR 1 0 /BEV1/RPSSO
NF_FLAG Indicator: Material Contains NF Metals CHAR 1 0 /NFM/NFMAT
CTR_TERM_DEF Default Contract Term NUMC 3 0 CRMS4_SOM_CTR_DUR_DEF
CTR_TERM_ALT1 Alternative Contract Term 1 NUMC 3 0 CRMS4_SOM_CTR_DUR_1
CTR_TERM_ALT2 Alternative Contract Term 2 NUMC 3 0 CRMS4_SOM_CTR_DUR_2
CTR_TERM_UNIT Unit for Contract Term CHAR 1 0 CRMS4_SOM_CTR_TERM_UNIT
EXT_PERIOD_DEF Default Extension Period NUMC 3 0 CRMS4_SOM_CTR_TRM_EXT_DEF
EXT_PERIOD_ALT1 Alternative Extension Period 1 NUMC 3 0 CRMS4_SOM_CTR_TRM_EXT_1
EXT_PERIOD_ALT2 Alternative Extension Period 2 NUMC 3 0 CRMS4_SOM_CTR_TRM_EXT_2
EXT_PERIOD_UNIT Unit for Extension Period CHAR 1 0 CRMS4_SOM_EXT_PERIOD_UNIT
PACKAGE_TYPE Package Type CHAR 3 0 * LMD_MDE_PACKAGE_TYPE
PACKAGE_SIZE Package Size CHAR 3 0 * LMD_MDE_PACKAGE_SIZE
PLGTP Price Band Category CHAR 2 0 TWPT WRF_PLGTP

MVKE foreign key relationships

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