1. Home
  2. Resources
  3. SAP Tables
  4. MAW1 - Material Master: Default Fields and Special Retail Fields

SAP Table MAW1

Material Master: Default Fields and Special Retail Fields

MAW1 (Material Master: Default Fields and Special Retail Fields) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link MAW1 to other SAP tables.

MAW1 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
MATNR Material Number MATNR MARA CHAR 18 0
BBTYP Assortment List Type BBTYP TWBB CHAR 1 0
SERVV Service agreement for a retail material W_SERVV TWSV CHAR 2 0
WMAAB ABC Indicator MAABC TMABC CHAR 1 0
WEKGR Purchasing Group EKGRP T024 CHAR 3 0
WVRKM Sales unit VRKME T006 UNIT 3 0
WAUSM Unit of issue AUSME T006 UNIT 3 0
WHERL Country of origin of the material HERKL T005 CHAR 3 0
WHERR Region of origin of material (non-preferential origin) HERKR T005S CHAR 3 0
WLADG Loading Group LADGR TLGR CHAR 4 0
SSTUF Assortment grade SSTUF TWSS CHAR 2 0
PFLKS External assortment priority PFLKS TWSP CHAR 1 0
LSTFL Listing procedure for store or other assortment categories LSTFL TWLV CHAR 2 0
LSTVZ Listing procedure for distr. center assortment categories LSTVZ TWLV CHAR 2 0
LSTAK Listing functions (assortments) are active LSTAK CHAR 1 0
NULL Listing not active
X Listing active
LDVFL Date from which listed in the store LDVFL DATS 8 0
LDBFL Date to which listed in the store LDBFL DATS 8 0
LDVZL Date from which listed in the distribution center LDVZL DATS 8 0
LDBZL Date to which listed in the central warehouse/distr. center LDBZL DATS 8 0
VDVFL Date from which sold in the store VDVFL DATS 8 0
VDBFL Date to which sold in the store VDBFL DATS 8 0
VDVZL Date from which sold in the distribution center VDVZL DATS 8 0
VDBZL Date to which sold in the distribution center VDBZL DATS 8 0
WBKLA Valuation Class BKLAS T025 CHAR 4 0
WSTAW Commodity Code/Import Code Number for Foreign Trade STAWN T604 CHAR 17 0
WPSTA Retail maintenance status RPSTA CHAR 15 0
WBWSP Valuation margin BWSPA DEC 6 2
WEXPM Unit of measure for commodity code (foreign trade) EXPME T006 UNIT 3 0
KWDHT No repeat key KWDHT CHAR 1 0
NULL Repeat key may be used
1 No repeat key allowed
2 Repeat key must be used
PRERF Price required PRERF CHAR 1 0
X Yes
NULL No
RBZUL Discount allowed RBZUL CHAR 1 0
X Yes
NULL No
SCAGR Scales group SCAGR TWWAG CHAR 4 0
CNPRO Profile for distribution of coupon discounts in POS inbound WCNPRO TWCP CHAR 4 0

MAW1 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
MAW1 BBTYP SY MANDT TWBB Assortment list type MANDT
MAW1 BBTYP MAW1 BBTYP TWBB Assortment list type BBTYP
MAW1 CNPRO MAW1 CNPRO TWCP Coupons: Profile for Distributing Discounts in POS Inbound CNPRO
MAW1 CNPRO SYST MANDT TWCP Coupons: Profile for Distributing Discounts in POS Inbound MANDT
MAW1 LSTFL SY MANDT TWLV Listing procedure, assortments MANDT
MAW1 LSTFL MAW1 LSTFL TWLV Listing procedure, assortments LSTFL
MAW1 LSTVZ SY MANDT TWLV Listing procedure, assortments MANDT
MAW1 LSTVZ MAW1 LSTVZ TWLV Listing procedure, assortments LSTFL
MAW1 MANDT MAW1 MANDT T000 Clients MANDT
MAW1 MATNR MAW1 MANDT MARA General Material Data MANDT
MAW1 MATNR MAW1 MATNR MARA General Material Data MATNR
MAW1 PFLKS MAW1 PFLKS TWSP Assortment priorities IS-R PFLKS
MAW1 PFLKS SY MANDT TWSP Assortment priorities IS-R MANDT
MAW1 SCAGR MAW1 MANDT TWWAG Scales group MANDT
MAW1 SCAGR MAW1 SCAGR TWWAG Scales group SCAGR
MAW1 SERVV SY MANDT TWSV Service agreement IS-R MANDT
MAW1 SERVV MAW1 SERVV TWSV Service agreement IS-R SERVV
MAW1 SSTUF SY MANDT TWSS Assortment grade IS-R MANDT
MAW1 SSTUF MAW1 SSTUF TWSS Assortment grade IS-R SSTUF
MAW1 WAUSM SY MANDT T006 Units of Measurement MANDT
MAW1 WAUSM MAW1 WAUSM T006 Units of Measurement MSEHI
MAW1 WBKLA SY MANDT T025 Valuation Classes MANDT
MAW1 WBKLA MAW1 WBKLA T025 Valuation Classes BKLAS
MAW1 WEKGR SY MANDT T024 Purchasing Groups MANDT
MAW1 WEKGR MAW1 WEKGR T024 Purchasing Groups EKGRP
MAW1 WEXPM SY MANDT T006 Units of Measurement MANDT
MAW1 WEXPM MAW1 WEXPM T006 Units of Measurement MSEHI
MAW1 WHERL SY MANDT T005 Countries MANDT
MAW1 WHERL MAW1 WHERL T005 Countries LAND1
MAW1 WHERR MAW1 WHERR T005S Taxes: Region (Province) Key BLAND
MAW1 WHERR SY MANDT T005S Taxes: Region (Province) Key MANDT
MAW1 WHERR MAW1 WHERL T005S Taxes: Region (Province) Key LAND1
MAW1 WLADG SY MANDT TLGR Routes: Loading Groups MANDT
MAW1 WLADG MAW1 WLADG TLGR Routes: Loading Groups LADGR
MAW1 WMAAB SYST MANDT TMABC Values Table for the ABC Indicator for Materials MANDT
MAW1 WMAAB MAW1 WMAAB TMABC Values Table for the ABC Indicator for Materials MAABC
MAW1 WSTAW SY MANDT T604 Foreign Trade: Commodity Code / Import Code Number MANDT
MAW1 WSTAW T130S LAND1 T604 Foreign Trade: Commodity Code / Import Code Number LAND1
MAW1 WSTAW MAW1 WSTAW T604 Foreign Trade: Commodity Code / Import Code Number STAWN
MAW1 WVRKM SY MANDT T006 Units of Measurement MANDT
MAW1 WVRKM MAW1 WVRKM T006 Units of Measurement MSEHI