MAW1

Material Master: Default Fields and Special Retail Fields | #masterdata | Component: Material Master
Column Name Description
MANDT FK Client
MATNR FK Material Number
Column Name Description
Column Name Description
Column Name Description
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
LSTAK Listing functions (assortments) are active Show values
KWDHT No repeat key Show values
PRERF Price required Show values
RBZUL Discount allowed Show values
Column Name Description Domain name
WPSTA Retail maintenance status PSTAT
WBWSP Valuation margin PRZ32V
DUMMY_PRT_INCL_EEW_PS Dummy Field PRT_INCL_EEW
Master Data Relations Join Conditions
Assortment List Type
  • Assortment List Type
  • Client
  • MAW1.BBTYP == TWBB.BBTYP
  • MAW1.MANDT == TWBB.MANDT
Profile for distribution of coupon discounts in POS inbound
  • MAW1.MANDT == TWCP.MANDT
  • MAW1.CNPRO == TWCP.CNPRO
Listing procedure for the store
  • Listing procedure for store or other assortment categories
  • Client
  • MAW1.LSTFL == TWLV.LSTFL
  • MAW1.MANDT == TWLV.MANDT
Listing procedure for the distribution center
  • Listing procedure for distr. center assortment categories
  • Client
  • MAW1.LSTVZ == TWLV.LSTFL
  • MAW1.MANDT == TWLV.MANDT
Client MAW1.MANDT == T000.MANDT
Material Number
  • Material Number
  • Client
  • MAW1.MATNR == MARA.MATNR
  • MAW1.MANDT == MARA.MANDT
External assortment priority
  • MAW1.MANDT == TWSP.MANDT
  • MAW1.PFLKS == TWSP.PFLKS
Foreign key for scales group
  • MAW1.MANDT == TWWAG.MANDT
  • MAW1.SCAGR == TWWAG.SCAGR
Service agreement for a retail material
  • MAW1.MANDT == TWSV.MANDT
  • MAW1.SERVV == TWSV.SERVV
Assortment grade
  • MAW1.MANDT == TWSS.MANDT
  • MAW1.SSTUF == TWSS.SSTUF
Unit of issue
  • MAW1.MANDT == T006.MANDT
  • MAW1.WAUSM == T006.MSEHI
Valuation Class
  • Valuation Class
  • Client
  • MAW1.WBKLA == T025.BKLAS
  • MAW1.MANDT == T025.MANDT
Purchasing Group
  • Purchasing Group
  • Client
  • MAW1.WEKGR == T024.EKGRP
  • MAW1.MANDT == T024.MANDT
Unit of measure for commodity code (foreign trade)
  • MAW1.MANDT == T006.MANDT
  • MAW1.WEXPM == T006.MSEHI
Country/Region of Origin of Material (Non-Preferential Ori.)
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • Client
  • MAW1.WHERL == T005.LAND1
  • MAW1.MANDT == T005.MANDT
Region of Origin of Material (Non-Preferential Origin)
  • Country/Region of Origin of Material (Non-Preferential Ori.)
  • Region of Origin of Material (Non-Preferential Origin)
  • MAW1.MANDT == T005S.MANDT
  • MAW1.WHERL == T005S.LAND1
  • MAW1.WHERR == T005S.BLAND
Loading Group
  • MAW1.MANDT == TLGR.MANDT
  • MAW1.WLADG == TLGR.LADGR
Value Table for ABC Indicator
  • MAW1.MANDT == TMABC.MANDT
  • MAW1.WMAAB == TMABC.MAABC
Commodity Code
  • ?
  • Commodity Code
  • Client
  • MAW1.[column in domain "LAND1"] == T604.LAND1
  • MAW1.WSTAW == T604.STAWN
  • MAW1.MANDT == T604.MANDT
Sales unit
  • MAW1.MANDT == T006.MANDT
  • MAW1.WVRKM == T006.MSEHI