MVVE

Sales Data for Material | #masterdata | Component: Material Master
Column Name Description
MANDT FK Client
MATNR FK Material Number
VKORG FK Sales Organization
VTWEG FK Distribution Channel
Column Name Description
Column Name Description
📏 Base Unit of Measure (MARA.MEINS):
AUMNG Minimum order quantity in base unit of measure
LFMNG Minimum Delivery Quantity in Delivery Note Processing
EFMNG Minimum make-to-order quantity
SCMNG Delivery unit
LFMAX Maximum delivery quantity in store order processing
Column Name Description
VMSTD Date from which distr.-chain-spec. material status is valid
LDVFL Date from which listed in the store
LDBFL Date to which listed in the store
LDVZL Date from which listed in the distribution center
LDBZL Date to which listed in the central warehouse/distr. center
VDVFL Date from which sold in the store
VDBFL Date to which sold in the store
VDVZL Date from which sold in the distribution center
VDBZL Date to which sold in the distribution center
Column Name Description
LVORM Ind.: Flag material for deletion at distribution chain level Show values
SKTOF Cash Discount Indicator Show values
IS_ENTLMNT_RLVT Relevant for Entitlement Generation Show values
LSTAK Listing functions (assortments) are active Show values
PRAT1 ID for product attribute 1 Show values
PRAT2 ID for product attribute 2 Show values
PRAT3 ID for product attribute 3 Show values
PRAT4 ID for product attribute 4 Show values
PRAT5 ID for product attribute 5 Show values
PRAT6 ID for product attribute 6 Show values
PRAT7 ID for product attribute 7 Show values
PRAT8 ID for product attribute 8 Show values
PRAT9 ID for product attribute 9 Show values
PRATA ID for product attribute 10 Show values
RJART Flag rackjobber material Show values
PBIND Indicator for price fixing Show values
VAVME Variable Sales Unit Not Allowed Show values
MATKC Competition characterization of a material Show values
/BEV1/EMDRCKSPL Print Column Empties Returns Block Show values
/BEV1/RPSNS No Allocation to Totals Field (Do not Total) Show values
/BEV1/RPSFA Assignment to Totals Field Category 1 Show values
/BEV1/RPSKI Assignment to Totals Field Category 2 Show values
/BEV1/RPSCO Assignment to Totals Field Category 3 Show values
/BEV1/RPSSO Assignment to Totals Field Category 4 Show values
NF_FLAG Indicator: Material Contains NF Metals Show values
CTR_TERM_UNIT Unit for Contract Term Show values
EXT_PERIOD_UNIT Unit for Extension Period Show values
Column Name Description Domain name
PVMSO Material sorting in product proposal PVMSO
DUMMY_SALD_INCL_EEW_PS MD Product Sales Delivery SALD_INCL_EEW
CTR_TERM_DEF Default Contract Term CRMT_CTR_DUR
CTR_TERM_ALT1 Alternative Contract Term 1 CRMT_CTR_DUR
CTR_TERM_ALT2 Alternative Contract Term 2 CRMT_CTR_DUR
EXT_PERIOD_DEF Default Extension Period CRMT_CTR_TRM_EXT
EXT_PERIOD_ALT1 Alternative Extension Period 1 CRMT_CTR_TRM_EXT
EXT_PERIOD_ALT2 Alternative Extension Period 2 CRMT_CTR_TRM_EXT
PACKAGE_TYPE Package Type LMD_MDE_PACKAGE_TYPE
PACKAGE_SIZE Package Size LMD_MDE_PACKAGE_SIZE
Master Data Relations Join Conditions
Empties Group
Volume rebate group
  • Volume rebate group
  • Client
  • MVVE.BONUS == TVBO.BONUS
  • MVVE.MANDT == TVBO.MANDT
Default plant
  • Sales Organization
  • Distribution Channel
  • Delivering Plant (Own or External)
  • MVVE.MANDT == TVKWZ.MANDT
  • MVVE.VKORG == TVKWZ.VKORG
  • MVVE.VTWEG == TVKWZ.VTWEG
  • MVVE.DWERK == TVKWZ.WERKS
Condition group
  • MVVE.MANDT == T178.MANDT
  • MVVE.KONDM == T178.KONDM
Account assignment group for this material
  • MVVE.MANDT == TVKM.MANDT
  • MVVE.KTGRM == TVKM.KTGRM
Listing procedure for store or other assortment categories
  • Listing procedure for store or other assortment categories
  • Client
  • MVVE.LSTFL == TWLV.LSTFL
  • MVVE.MANDT == TWLV.MANDT
Listing procedure for distr. center assortment categories
  • Listing procedure for distr. center assortment categories
  • Client
  • MVVE.LSTVZ == TWLV.LSTFL
  • MVVE.MANDT == TWLV.MANDT
Client MVVE.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • MVVE.MATNR == MARA.MATNR
  • MVVE.MANDT == MARA.MANDT
Item category group
  • Item Category Group from Material Master
  • Client
  • MVVE.MTPOS == TPTM.MTPOS
  • MVVE.MANDT == TPTM.MANDT
Material Group 1
  • Material Group 1
  • Client
  • MVVE.MVGR1 == TVM1.MVGR1
  • MVVE.MANDT == TVM1.MANDT
Material Group 2
  • Material Group 2
  • Client
  • MVVE.MVGR2 == TVM2.MVGR2
  • MVVE.MANDT == TVM2.MANDT
Material Group 3
  • MVVE.MANDT == TVM3.MANDT
  • MVVE.MVGR3 == TVM3.MVGR3
Material Group 4
  • MVVE.MANDT == TVM4.MANDT
  • MVVE.MVGR4 == TVM4.MVGR4
Material Group 5
  • MVVE.MANDT == TVM5.MANDT
  • MVVE.MVGR5 == TVM5.MVGR5
External assortment priority
  • MVVE.MANDT == TWSP.MANDT
  • MVVE.PFLKS == TWSP.PFLKS
Price Band Category
  • MVVE.MANDT == TWPT.MANDT
  • MVVE.PLGTP == TWPT.PLGTP
Price group
  • Pricing Reference Material
  • Client
  • MVVE.PMATN == MARA.MATNR
  • MVVE.MANDT == MARA.MANDT
Product Hierarchy
  • Product hierarchy
  • Client
  • MVVE.PRODH == T179.PRODH
  • MVVE.MANDT == T179.MANDT
Commission Group
  • Commission Group
  • Client
  • MVVE.PROVG == TVPR.PROVG
  • MVVE.MANDT == TVPR.MANDT
Rounding profile
  • Delivering Plant (Own or External)
  • Rounding Profile
  • ?
  • MVVE.MANDT == RDPR.MANDT
  • MVVE.DWERK == RDPR.WERKS
  • MVVE.RDPRF == RDPR.RDPRF
  • MVVE.[column in domain "RDZAE"] == RDPR.RDZAE
Unit of Measure
  • MVVE.MANDT == T006.MANDT
  • MVVE.SCHME == T006.MSEHI
Assortment grade
  • MVVE.MANDT == TWSS.MANDT
  • MVVE.SSTUF == TWSS.SSTUF
Shipping Statistics Group
  • Material statistics group
  • Client
  • MVVE.VERSG == TVSM.STGMA
  • MVVE.MANDT == TVSM.MANDT
Sales Organization
  • MVVE.MANDT == TVKO.MANDT
  • MVVE.VKORG == TVKO.VKORG
Material Status, Sales and Distribution
  • MVVE.MANDT == TVMS.MANDT
  • MVVE.VMSTA == TVMS.VMSTA
Unit of Measure
  • MVVE.MANDT == T006.MANDT
  • MVVE.VRKME == T006.MSEHI
Distribution Channel
  • Distribution Channel
  • Client
  • MVVE.VTWEG == TVTW.VTWEG
  • MVVE.MANDT == TVTW.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Units of Measure Group
  • Unit of Measure Group
  • ?
  • MVVE.MANDT == TWMEG.MANDT
  • MVVE.MEGRU == TWMEG.MEGRU
  • MVVE.[column in domain "LRMEI"] == TWMEG.MEINS