SAP ABAP Table T134 (Material Types)

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	T134	Table Relationship Diagram
Short Description	Material Types

Delivery and Maintenance

Pool/cluster
Delivery Class	G	Customizing table, protected against SAP Upd., only INS all.
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	*
2	MTART	☑	MTART	MTART	CHAR	4	0	Material type
3	MTREF	☐	MTREF	MAREF	CHAR	4	0	Reference material type
4	MBREF	☐	MBREF	MAREF	CHAR	4	0	Screen reference depending on the material type
5	FLREF	☐	FLREF_MG	FLREF_MG	CHAR	4	0	Field reference for material master	T130A
6	NUMKI	☐	NUMKR	CHAR2	CHAR	2	0	Number range
7	NUMKE	☐	NUMKR	CHAR2	CHAR	2	0	Number range
8	ENVOP	☐	ENVOP	XFELD	CHAR	1	0	External Number Assignment Without Validation
9	BSEXT	☐	BSEXT	BSEXT	CHAR	1	0	External Purchase Orders Allowed
10	BSINT	☐	BSINT	BSINT	CHAR	1	0	Internal purchase orders allowed
11	PSTAT	☐	PSTAT_D	PSTAT	CHAR	15	0	Maintenance status
12	KKREF	☐	KKREF	KKREF	CHAR	4	0	Account category reference	T025K
13	VPRSV	☐	VPRSV	VPRSV	CHAR	1	0	Price control indicator
14	KZVPR	☐	KZVPR	XFELD	CHAR	1	0	Price Control Mandatory
15	VMTPO	☐	VMTPO	MTPOS	CHAR	4	0	Default value for material item category group	TPTM
16	EKALR	☐	CK_EKALREL	XFELD	CHAR	1	0	Material Is Costed with Quantity Structure
17	KZGRP	☐	KZGRP	KZGRP	CHAR	1	0	Grouping indicator
18	KZKFG	☐	KZKFG	XFELD	CHAR	1	0	Configurable Material
19	BEGRU	☐	BEGRM	BEGRM	CHAR	4	0	Authorization group in the material master	*
20	KZPRC	☐	KZPRC	XFELD	CHAR	1	0	Material Master Record for a Process
21	KZPIP	☐	KZPIP	XFELD	CHAR	1	0	Pipeline Handling Mandatory
22	PRDRU	☐	POSPRDRUCK	XFELD	CHAR	1	0	Display price on cash register display and print on receipt
23	ARANZ	☐	POSARTANZ	XFELD	CHAR	1	0	Display material on cash register display
24	WMAKG	☐	WMAK	WMAK	CHAR	1	0	Material type ID
25	IZUST	☐	IZUST	IZUST	CHAR	1	0	Initial status of a new batch
26	ARDEL	☐	ARDEL	NUM4	NUMC	4	0	Time in days until a material is deleted
27	KZMPN	☐	MPNMTART	XFELD	CHAR	1	0	Manufacturer Part
28	MSTAE	☐	MSTAE	MMSTA	CHAR	2	0	Cross-Plant Material Status	T141
29	CCHIS	☐	CC_HIST_MAT	CC_HIST_MAT	CHAR	1	0	Control (time) of history requirement: Material
30	CTYPE	☐	KLASSENART_M	KLASSENART	CHAR	3	0	Class Type	TCLA
31	CLASS	☐	KLASSE_M	KLASSE	CHAR	18	0	Class number
32	CHNEU	☐	CHNEU	CHNEU	CHAR	1	0	Control: create batch (automatically/manually)
33	.INCLU--AP	☐				0	0	Version fields for T134
34	VTYPE	☐	VERSIONTYPE	VERSIONTYPE	CHAR	10	0	Version Category	MGVTYPE
35	VNUMKI	☐	NUMKR	CHAR2	CHAR	2	0	Number range
36	VNUMKE	☐	NUMKR	CHAR2	CHAR	2	0	Number range
37	.INCLU--AP	☐				0	0	Append Structure for Returnable Packaging Logistics
38	KZRAC	☐	KZRAC	XFELD	CHAR	1	0	Returnable Packaging Logistics is mandatory

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	T134	CTYPE	TCLA	KLART
2	T134	FLREF	T130A	FLREF	REF	1	CN
3	T134	KKREF	T025K	KKREF	REF	1	CN
4	T134	MSTAE	T141	MMSTA
5	T134	VMTPO	TPTM	MTPOS	REF	1	CN
6	T134	VTYPE	MGVTYPE	VTYPE

History

Last changed by/on	SAP	20050301
SAP Release Created in