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

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ MG (Package) Application development R/3 material master prior to 3.0

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	MAW1	Table Relationship Diagram
Short Description	Material Master: Default Fields and Special Retail Fields

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	MATNR	☑	MATNR	MATNR	CHAR	18	0	Material Number	MARA
3	.INCLUDE	☐				0	0	Data Division MAW1
4	BBTYP	☐	BBTYP	BBTYP	CHAR	1	0	Assortment List Type	TWBB
5	SERVV	☐	W_SERVV	W_SERVV	CHAR	2	0	Service agreement for a retail material	TWSV
6	WMAAB	☐	MAABC	MAABC	CHAR	1	0	ABC indicator	TMABC
7	WEKGR	☐	EKGRP	EKGRP	CHAR	3	0	Purchasing group	T024
8	WVRKM	☐	VRKME	MEINS	UNIT	3	0	Sales unit	T006
9	WAUSM	☐	AUSME	MEINS	UNIT	3	0	Unit of issue	T006
10	WHERL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	T005
11	WHERR	☐	HERKR	REGIO	CHAR	3	0	Region of origin of material (non-preferential origin)	T005S
12	WLADG	☐	LADGR	LADGR	CHAR	4	0	Loading Group	TLGR
13	.INCLUDE	☐				0	0	Data Part MWLI
14	SSTUF	☐	SSTUF	SSTUF	CHAR	2	0	Assortment grade	TWSS
15	PFLKS	☐	PFLKS	PFLKS	CHAR	1	0	External assortment priority	TWSP
16	LSTFL	☐	LSTFL	LSTFL	CHAR	2	0	Listing procedure for store or other assortment categories	TWLV
17	LSTVZ	☐	LSTVZ	LSTFL	CHAR	2	0	Listing procedure for distr. center assortment categories	TWLV
18	LSTAK	☐	LSTAK	LSTAK	CHAR	1	0	Listing functions (assortments) are active
19	LDVFL	☐	LDVFL	DATS	DATS	8	0	Date from which listed in the store
20	LDBFL	☐	LDBFL	DATS	DATS	8	0	Date to which listed in the store
21	LDVZL	☐	LDVZL	DATS	DATS	8	0	Date from which listed in the distribution center
22	LDBZL	☐	LDBZL	DATS	DATS	8	0	Date to which listed in the central warehouse/distr. center
23	VDVFL	☐	VDVFL	DATS	DATS	8	0	Date from which sold in the store
24	VDBFL	☐	VDBFL	DATS	DATS	8	0	Date to which sold in the store
25	VDVZL	☐	VDVZL	DATS	DATS	8	0	Date from which sold in the distribution center
26	VDBZL	☐	VDBZL	DATS	DATS	8	0	Date to which sold in the distribution center
27	WBKLA	☐	BKLAS	BKLAS	CHAR	4	0	Valuation Class	T025
28	WSTAW	☐	STAWN	STAWN	CHAR	17	0	Commodity Code/Import Code Number for Foreign Trade	T604
29	WPSTA	☐	RPSTA	PSTAT	CHAR	15	0	Retail maintenance status
30	WBWSP	☐	BWSPA	PRZ32V	DEC	6	2	Valuation margin
31	WEXPM	☐	EXPME	MEINS	UNIT	3	0	Unit of measure for commodity code (foreign trade)	T006
32	.INCLUDE	☐				0	0	POS Data for Material
33	KWDHT	☐	KWDHT	KWDHT	CHAR	1	0	No repeat key
34	PRERF	☐	PRERF	XFELD	CHAR	1	0	Price required
35	RBZUL	☐	RBZUL	XFELD	CHAR	1	0	Discount allowed
36	SCAGR	☐	SCAGR	SCAGR	CHAR	4	0	Scales group	TWWAG
37	CNPRO	☐	WCNPRO	CPRO	CHAR	4	0	Profile for distribution of coupon discounts in POS inbound	TWCP

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	MAW1	BBTYP	TWBB	BBTYP
2	MAW1	CNPRO	TWCP	CNPRO
3	MAW1	LSTFL	TWLV	LSTFL
4	MAW1	LSTVZ	TWLV	LSTFL
5	MAW1	MANDT	T000	MANDT	KEY	1	CN
6	MAW1	MATNR	MARA	MATNR	KEY	1	CN
7	MAW1	PFLKS	TWSP	PFLKS
8	MAW1	SCAGR	TWWAG	SCAGR
9	MAW1	SERVV	TWSV	SERVV
10	MAW1	SSTUF	TWSS	SSTUF
11	MAW1	WAUSM	T006	MSEHI
12	MAW1	WBKLA	T025	BKLAS
13	MAW1	WEKGR	T024	EKGRP
14	MAW1	WEXPM	T006	MSEHI
15	MAW1	WHERL	T005	LAND1
16	MAW1	WHERR	T005S	BLAND
17	MAW1	WLADG	TLGR	LADGR
18	MAW1	WMAAB	TMABC	MAABC
19	MAW1	WSTAW	T604	STAWN
20	MAW1	WVRKM	T006	MSEHI

History

Last changed by/on	SAP	20110901
SAP Release Created in