MDG_BS_MAT_S_MVKE SAP (MDG BS MAT: Sales Data for Material Structure) Structure details

Dictionary Type: Structure
Description: MDG BS MAT: Sales Data for Material Structure




ABAP Code to SELECT data from MDG_BS_MAT_S_MVKE
Related tables to MDG_BS_MAT_S_MVKE
Access table MDG_BS_MAT_S_MVKE




Structure field list including key, data, relationships and ABAP select examples

MDG_BS_MAT_S_MVKE is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "MDG BS MAT: Sales Data for Material Structure" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_MDG_BS_MAT_S_MVKE TYPE MDG_BS_MAT_S_MVKE.

The MDG_BS_MAT_S_MVKE table consists of various fields, each holding specific information or linking keys about MDG BS MAT: Sales Data for Material Structure data available in SAP. These include MANDT (Client), MATNR (Material Number), VKORG (Sales Organization), VTWEG (Distribution Channel).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP MDG_BS_MAT_S_MVKE structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
MATNRMaterial Number MATNRCHAR18MARAMATN1MATNRMATS_MAT1
VKORGSales Organization VKORGCHAR4TVKOVKORGVKOC_VKORG
VTWEGDistribution Channel VTWEGCHAR2TVTWVTWEGVTWC_VTWEG
LVORMInd.: Flag material for deletion at distribution chain level LVOVKCHAR1XFELD
VERSGMaterial statistics group STGMACHAR1TVSMSTGMA
BONUSVolume rebate group BONUSCHAR2TVBOBONUS
PROVGCommission group PROVGCHAR2TVPRPROVG
SKTOFCash discount indicator SKTOFCHAR1XFELD
VMSTADistribution-chain-specific material status VMSTACHAR2TVMSVMSTA
VMSTDDate from which distr.-chain-spec. material status is valid VMSTDDATS8DATUM
AUMNGMinimum order quantity in base unit of measure MINAUQUAN13(3) MENG13
LFMNGMinimum delivery quantity in delivery note processing MINLFQUAN13(3) MENG13
EFMNGMinimum make-to-order quantity MINEFQUAN13(3) MENG13
SCMNGDelivery unit SCHRTQUAN13(3) MENG13
SCHMEUnit of measure of delivery unit SCHMEUNIT3T006CUNITMEINS
VRKMESales unit VRKMEUNIT3T006CUNITMEINS
MTPOSItem category group from material master MTPOSCHAR4TPTMMTPOS
DWERKDelivering Plant (Own or External) DWERK_EXTCHAR4TVKWZWERKSSH_DWERK_EXTS
PRODHProduct hierarchy PRODH_DCHAR18T179PRODHVPR
PMATNPricing Reference Material PMATNCHAR18MARAMATN1MATNRMAT
KONDMMaterial Pricing Group KONDMCHAR2T178KONDMVKM
KTGRMAccount assignment group for this material KTGRMCHAR2TVKMKTGRM
MVGR1Material group 1 MVGR1CHAR3TVM1MVGR1
MVGR2Material group 2 MVGR2CHAR3TVM2MVGR2
MVGR3Material group 3 MVGR3CHAR3TVM3MVGR3
MVGR4Material group 4 MVGR4CHAR3TVM4MVGR4
MVGR5Material group 5 MVGR5CHAR3TVM5MVGR5
SSTUFAssortment grade SSTUFCHAR2TWSSSSTUF
PFLKSExternal assortment priority PFLKSCHAR1TWSPPFLKS
LSTFLListing procedure for store or other assortment categories LSTFLCHAR2TWLVLSTFLWLV
LSTVZListing procedure for distr. center assortment categories LSTVZCHAR2TWLVLSTFL
LSTAKListing functions (assortments) are active LSTAKCHAR1LSTAK
LDVFLDate from which listed in the store LDVFLDATS8DATS
LDBFLDate to which listed in the store LDBFLDATS8DATS
LDVZLDate from which listed in the distribution center LDVZLDATS8DATS
LDBZLDate to which listed in the central warehouse/distr. center LDBZLDATS8DATS
VDVFLDate from which sold in the store VDVFLDATS8DATS
VDBFLDate to which sold in the store VDBFLDATS8DATS
VDVZLDate from which sold in the distribution center VDVZLDATS8DATS
VDBZLDate to which sold in the distribution center VDBZLDATS8DATS
PRAT1ID for product attribute 1 PRAT1CHAR1PRATA
PRAT2ID for product attribute 2 PRAT2CHAR1PRATA
PRAT3ID for product attribute 3 PRAT3CHAR1PRATA
PRAT4ID for product attribute 4 PRAT4CHAR1PRATA
PRAT5ID for product attribute 5 PRAT5CHAR1PRATA
PRAT6ID for product attribute 6 PRAT6CHAR1PRATA
PRAT7ID for product attribute 7 PRAT7CHAR1PRATA
PRAT8ID for product attribute 8 PRAT8CHAR1PRATA
PRAT9ID for product attribute 9 PRAT9CHAR1PRATA
PRATAID for product attribute 10 PRATACHAR1PRATA
RDPRFRounding Profile RDPRFCHAR4RDPRRDPRF
MEGRUUnit of Measure Group MEGRUCHAR4TWMEGMEGRU
LFMAXMaximum delivery quantity in store order processing MAXLFQUAN13(3) MENG13
RJARTFlag rackjobber material RJARTCHAR1XFELD
PBINDIndicator for price fixing PBINDCHAR1PBIND
VAVMEVariable Sales Unit Not Allowed VAVMECHAR1XFELD
MATKCCompetition characterization of a material MATKCCHAR1MATKC
PVMSOMaterial sorting in product proposal PVMSONUMC8Assigned to domainPVMSO
.INCLU--AP 0
/BEV1/EMLGRPEmpties Group /BEV1/EMLGGRPCHAR4/BEV1/EMGRP/BEV1/EMLGGRP
/BEV1/EMDRCKSPLPrint Column Empties Returns Block /BEV1/EMPRTCOLNUMC1/BEV1/EMPRTCOL
.INCLU--AP 0
/BEV1/RPBEZMEBase Unit of Measure for Statistics Totals List/Planning /BEV1/RPBEZMEUNIT3Assigned to domainCUNITMEINS
/BEV1/RPSNSNo Allocation to Totals Field (Do not Total) /BEV1/RPSNSCHAR1/BEV1/RPJANEIN
/BEV1/RPSFAAssignment to Totals Field Category 1 /BEV1/RPSFACHAR1/BEV1/RPJANEIN
/BEV1/RPSKIAssignment to Totals Field Category 2 /BEV1/RPSKICHAR1/BEV1/RPJANEIN
/BEV1/RPSCOAssignment to Totals Field Category 3 /BEV1/RPSCOCHAR1/BEV1/RPJANEIN
/BEV1/RPSSOAssignment to Totals Field Category 4 /BEV1/RPSSOCHAR1/BEV1/RPJANEIN
.INCLU--AP 0
NF_FLAGIndicator: Material Contains NF Metals /NFM/NFMATCHAR1FLAG
.INCLU--AP 0
PLGTPPrice Band Category WRF_PLGTPCHAR2TWPTPLGTP
MTARTMaterial Type MTARTCHAR4Assigned to domainMTARTMTA

Key field Non-key field



How do I retrieve data from SAP structure MDG_BS_MAT_S_MVKE using ABAP code?

As MDG_BS_MAT_S_MVKE is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on MDG_BS_MAT_S_MVKE as there is no data to select.

How to access SAP table MDG_BS_MAT_S_MVKE

Within an ECC or HANA version of SAP you can also view further information about MDG_BS_MAT_S_MVKE and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!