SAP table MAW1 (Material Master: Default Fields and Special Retail Fields)

SAP table MAW1 has 2 primary key fields being MANDT,MATNR.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

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

MAW1 foreign key relationships

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