MAW1 SAP (Material Master: Default Fields and Special Retail Fields) Table details
Dictionary Type: Table
Description: Material Master: Default Fields and Special Retail Fields
Description: Material Master: Default Fields and Special Retail Fields
Table field list including key, data, relationships and ABAP select examples
MAW1 is a standard SAP Table which is used to store Material Master: Default Fields and Special Retail Fields data and is available within R/3 SAP systems depending on the version and release level.
The MAW1 table consists of various fields, each holding specific information or linking keys about Material Master: Default Fields and Special Retail Fields data available in SAP. These include MATNR (Material Number), BBTYP (Assortment List Type), SERVV (Service agreement for a retail material), WMAAB (ABC Indicator).. 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: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP MAW1 table 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 |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
MATNR | Material Number | MATNR | CHAR | 18 | MARA | MATN1 | MATNR | MAT | S_MAT1 |
BBTYP | Assortment List Type | BBTYP | CHAR | 1 | TWBB | BBTYP | WBB | ||
SERVV | Service agreement for a retail material | W_SERVV | CHAR | 2 | TWSV | W_SERVV | |||
WMAAB | ABC Indicator | MAABC | CHAR | 1 | TMABC | MAABC | |||
WEKGR | Purchasing Group | EKGRP | CHAR | 3 | T024 | EKGRP | EKG | ||
WVRKM | Sales unit | VRKME | UNIT | 3 | T006 | CUNIT | MEINS | ||
WAUSM | Unit of issue | AUSME | UNIT | 3 | T006 | CUNIT | MEINS | ||
WHERL | Country of origin of the material | HERKL | CHAR | 3 | T005 | LAND1 | LND | ||
WHERR | Region of origin of material (non-preferential origin) | HERKR | CHAR | 3 | T005S | REGIO | |||
WLADG | Loading Group | LADGR | CHAR | 4 | TLGR | LADGR | |||
SSTUF | Assortment grade | SSTUF | CHAR | 2 | TWSS | SSTUF | |||
PFLKS | External assortment priority | PFLKS | CHAR | 1 | TWSP | PFLKS | |||
LSTFL | Listing procedure for store or other assortment categories | LSTFL | CHAR | 2 | TWLV | LSTFL | WLV | ||
LSTVZ | Listing procedure for distr. center assortment categories | LSTVZ | CHAR | 2 | TWLV | LSTFL | |||
LSTAK | Listing functions (assortments) are active | LSTAK | CHAR | 1 | LSTAK | ||||
LDVFL | Date from which listed in the store | LDVFL | DATS | 8 | DATS | ||||
LDBFL | Date to which listed in the store | LDBFL | DATS | 8 | DATS | ||||
LDVZL | Date from which listed in the distribution center | LDVZL | DATS | 8 | DATS | ||||
LDBZL | Date to which listed in the central warehouse/distr. center | LDBZL | DATS | 8 | DATS | ||||
VDVFL | Date from which sold in the store | VDVFL | DATS | 8 | DATS | ||||
VDBFL | Date to which sold in the store | VDBFL | DATS | 8 | DATS | ||||
VDVZL | Date from which sold in the distribution center | VDVZL | DATS | 8 | DATS | ||||
VDBZL | Date to which sold in the distribution center | VDBZL | DATS | 8 | DATS | ||||
WBKLA | Valuation Class | BKLAS | CHAR | 4 | T025 | BKLAS | |||
WSTAW | Commodity Code/Import Code Number for Foreign Trade | STAWN | CHAR | 17 | T604 | STAWN | |||
WPSTA | Retail maintenance status | RPSTA | CHAR | 15 | PSTAT | ||||
WBWSP | Valuation margin | BWSPA | DEC | 6(2) | PRZ32V | ||||
WEXPM | Unit of measure for commodity code (foreign trade) | EXPME | UNIT | 3 | T006 | CUNIT | MEINS | ||
KWDHT | No repeat key | KWDHT | CHAR | 1 | KWDHT | ||||
PRERF | Price required | PRERF | CHAR | 1 | XFELD | ||||
RBZUL | Discount allowed | RBZUL | CHAR | 1 | XFELD | ||||
SCAGR | Scales group | SCAGR | CHAR | 4 | TWWAG | SCAGR | |||
CNPRO | Profile for distribution of coupon discounts in POS inbound | WCNPRO | CHAR | 4 | TWCP | CPRO |
Key field | Non-key field |
How do I retrieve data from SAP table MAW1 using ABAP code
The following ABAP code Example will allow you to do a basic selection on MAW1 to SELECT all data from the tableDATA: WA_MAW1 TYPE MAW1.
SELECT SINGLE *
FROM MAW1
INTO CORRESPONDING FIELDS OF WA_MAW1
WHERE...
How to access SAP table MAW1
Within an ECC or HANA version of SAP you can also view further information about MAW1 and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects