MVKE Table in SAP MM (Material Sales Data Table)

The MVKE Table in SAP MM (Material Sales Data Table). Here all the detail about this MVKE Tables.

What MVKE Table in SAP MM ?

The best answer I found for the “What is MVKE table in SAP ?” is :

“MVKE is just a table that stores the content of material master sales organisation views.
As you checked for your material, no sales data avialable then you can extends sales views for material with t.code:MM50 or MM01” (source)

MVKE Tables in SAP MM Fields

Let’s start by list the main fields for SAP MVKE table the Material Sales Data Table in SAP MM (Material Management)

FieldsDescription
MANDTClient
MATNRMaterial Number
VKORGSales Organization
VTWEGDistribution Channel
.INCLUDEData Division MVKE
LVORMInd.: Flag material for deletion at distribution chain level
VERSGMaterial statistics group
BONUSVolume rebate group
PROVGCommission group
SKTOFCash discount indicator
VMSTADistribution-chain-specific material status
VMSTDDate from which distr.-chain-spec. material status is valid
AUMNGMinimum order quantity in base unit of measure
LFMNGMinimum delivery quantity in delivery note processing
EFMNGMinimum make-to-order quantity
SCMNGDelivery unit
SCHMEUnit of measure of delivery unit
VRKMESales unit
MTPOSItem category group from material master
DWERKDelivering Plant (Own or External)
PRODHProduct hierarchy
PMATNPricing Reference Material
KONDMMaterial Pricing Group
KTGRMAccount assignment group for this material
MVGR1Material group 1
MVGR2Material group 2
MVGR3Material group 3
MVGR4Material group 4
MVGR5Material group 5
.INCLUDEData Part MWLI
SSTUFAssortment grade
PFLKSExternal assortment priority
LSTFLListing procedure for store or other assortment categories
LSTVZListing procedure for distr. center assortment categories
LSTAKListing functions (assortments) are active
LDVFLDate from which listed in the store
LDBFLDate to which listed in the store
LDVZLDate from which listed in the distribution center
LDBZLDate to which listed in the central warehouse/distr. center
VDVFLDate from which sold in the store
VDBFLDate to which sold in the store
VDVZLDate from which sold in the distribution center
VDBZLDate to which sold in the distribution center
PRAT1ID for product attribute 1
PRAT2ID for product attribute 2
PRAT3ID for product attribute 3
PRAT4ID for product attribute 4
PRAT5ID for product attribute 5
PRAT6ID for product attribute 6
PRAT7ID for product attribute 7
PRAT8ID for product attribute 8
PRAT9ID for product attribute 9
PRATAID for product attribute 10
RDPRFRounding Profile
MEGRUUnit of Measure Group
LFMAXMaximum delivery quantity in store order processing
RJARTFlag rackjobber material
PBINDIndicator for price fixing
VAVMEVariable Sales Unit Not Allowed
MATKCCompetition characterization of a material
PVMSOMaterial sorting in product proposal
Check also   List of important SAP HCM Tables (Human Capital Management)

More SAP Material Master Data Tables

Check more about SAP Material in SAP MM :

Related SCN Discussion about MVKE Tables

In SCN, check the following threads about MVKE Tables in SAP MM:

Sab125

Hi. I have been working as SAP Technical and functional for a decade. Through this blog, I am trying to share with you my experience. Hopefull, it makes your ways easier path ...Sab

Leave a Reply

Your email address will not be published. Required fields are marked *