SAP ABAP Table TXW_MAT (Material master)

Hierarchy

☛ SAP_FIN (Software Component) SAP_FIN
   ⤷ CA-GTF-DRT (Application Component) Data Retention Tool
     ⤷ FTW1 (Package) Data Retention Tool

Basic Data

Table Category	INTTAB	Structure
Structure	TXW_MAT	Table Relationship Diagram
Short Description	Material master

Delivery and Maintenance

Pool/cluster
Delivery Class
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	*
2	MATNR	☐	MATNR	MATNR	CHAR	18	0	Material Number	*
3	WERKS	☐	WERKS_D	WERKS	CHAR	4	0	Plant	*
4	MTART	☐	MTART	MTART	CHAR	4	0	Material type	*
5	MATKL	☐	MATKL	MATKL	CHAR	9	0	Material Group	*
6	MAKTX	☐	MAKTX	TEXT40	CHAR	40	0	Material description
7	NORMT	☐	NORMT	NORMT	CHAR	18	0	Industry Standard Description (such as ANSI or ISO)
8	PRDHA	☐	PRODH_D	PRODH	CHAR	18	0	Product Hierarchy	*
9	ATTYP	☐	ATTYP	ATTYP	CHAR	2	0	Material Category
10	STOFF	☐	STOFF	STOFF	CHAR	18	0	Hazardous material number	*
11	KZUMW	☐	KZUMW	XFELD	CHAR	1	0	Indicator: Environmentally relevant
12	TAKLV	☐	TAKLV	TAXKM	CHAR	1	0	Tax Classification of Material	*
13	MEINS	☐	MEINS	MEINS	UNIT	3	0	Base Unit of Measure	*
14	PRCTR	☐	PRCTR	PRCTR	CHAR	10	0	Profit Center	*
15	ATPKZ	☐	ATPKZ	ATPKZ	CHAR	1	0	Replacement part
16	PRENG	☐	PRENG	PRENG	DATS	8	0	Validity date of vendor declaration
17	STDPD	☐	STDPD	MATNR	CHAR	18	0	Configurable material	*
18	EXPME	☐	EXPME	MEINS	UNIT	3	0	Unit of measure for commodity code (foreign trade)	*
19	MTVER	☐	MTVER	MTVER	CHAR	4	0	Export/import material group	*
20	PREFE	☐	PREFE	PREFE	CHAR	1	0	Preference indicator in export/import
21	PRENC	☐	PRENC	PRENC	CHAR	1	0	Exemption certificate: Indicator for legal control
22	PRENO	☐	PRENO	PRENO	NUMC	8	0	Number of exemption certificate in export/import
23	PREND	☐	PREND	PREND	DATS	8	0	Exemption certificate: Issue date of exemption certificate
24	PRENE	☐	PRENE	PRENE	CHAR	1	0	Indicator: Vendor declaration exists
25	HERBL	☐	HERBL	HERBL	CHAR	2	0	State of manufacture
26	HERKL	☐	HERKL	LAND1	CHAR	3	0	Country of origin of the material	*
27	HERKR	☐	HERKR	REGIO	CHAR	3	0	Region of origin of material (non-preferential origin)	*
28	CUOBJ	☐	CUOBJ	CUOBJ	NUMC	18	0	Configuration (internal object number)
29	OTYPE	☐	OTYPE	OTYPE	CHAR	2	0	Object Type	*
30	OBJID	☐	OBJEKTID	NUM08	NUMC	8	0	Object ID
31	EXTWG	☐	EXTWG	EXTWG	CHAR	18	0	External material group	*
32	SATNR	☐	SATNR	MATNR	CHAR	18	0	Cross-Plant Configurable Material	*
33	SCHGT	☐	SCHGT	XFELD	CHAR	1	0	Indicator: bulk material
34	BISMT	☐	BISMT	BISMT	CHAR	18	0	Old material number
35	ERSDA	☐	ERSDA	DATUM	DATS	8	0	Created On
36	BWTTY	☐	BWTTY_D	BWTTY	CHAR	1	0	Valuation Category	*
37	.INCLUDE	☐				0	0
38	MATNR_EXT	☐	MATNR_EXT	MATNR_EXT	CHAR	40	0	External Long Material Number
39	MATNR_VERS	☐	MATNR_VERS	MATNR_VERS	CHAR	10	0	Material Version Number
40	ERNAM	☐	ERNAM	USNAM	CHAR	12	0	Name of Person who Created the Object
41	STEUC	☐	STEUC	STEUC	CHAR	16	0	Control code for consumption taxes in foreign trade	*
42	CASNR	☐	CASNR	CASNR	CHAR	15	0	CAS number for pharmaceutical products in foreign trade	*

History

Last changed by/on	SAP	20110901
SAP Release Created in