SAP Table T134

Material Types

T134 (Material Types) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link T134 to other SAP tables.

T134 table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT CLNT 3 0
MTART Material Type MTART CHAR 4 0
MTREF Reference material type MTREF CHAR 4 0
MBREF Screen reference depending on the material type MBREF CHAR 4 0
FLREF Field reference for material master FLREF_MG T130A CHAR 4 0
NUMKI Number range NUMKR CHAR 2 0
NUMKE Number range NUMKR CHAR 2 0
ENVOP External Number Assignment Without Validation ENVOP CHAR 1 0
X Yes
NULL No
BSEXT External Purchase Orders Allowed BSEXT CHAR 1 0
0 No external purchase orders allowed
1 External purchase orders allowed, but warning issued
2 External purchase orders allowed
BSINT Internal purchase orders allowed BSINT CHAR 1 0
0 No internal purchase orders allowed
1 Internal purchase orders allowed, but warning issued
2 Internal purchase orders allowed
PSTAT Maintenance status PSTAT_D CHAR 15 0
KKREF Account category reference KKREF T025K CHAR 4 0
VPRSV Price control indicator VPRSV CHAR 1 0
S Standard price
V Moving average price/periodic unit price
KZVPR Price Control Mandatory KZVPR CHAR 1 0
X Yes
NULL No
VMTPO Default value for material item category group VMTPO TPTM CHAR 4 0
EKALR Material Is Costed with Quantity Structure CK_EKALREL CHAR 1 0
X Yes
NULL No
KZGRP Grouping indicator KZGRP CHAR 1 0
1 Product group
2 Free grouping
KZKFG Configurable Material KZKFG CHAR 1 0
X Yes
NULL No
BEGRU Authorization group in the material master BEGRM CHAR 4 0
KZPRC Material Master Record for a Process KZPRC CHAR 1 0
X Yes
NULL No
KZPIP Pipeline Handling Mandatory KZPIP CHAR 1 0
X Yes
NULL No
PRDRU Display price on cash register display and print on receipt POSPRDRUCK CHAR 1 0
X Yes
NULL No
ARANZ Display material on cash register display POSARTANZ CHAR 1 0
X Yes
NULL No
WMAKG Material type ID WMAK CHAR 1 0
NULL General material type
1 Material type for value-only materials
2 Material type for empties
3 Material type for catalog variants
4 Material type for perishables
5 Material type for additionals
6 Material type for coupons
IZUST Initial status of a new batch IZUST CHAR 1 0
NULL Intitial status <free>
X Intitial status <not free>
ARDEL Time in days until a material is deleted ARDEL NUMC 4 0
KZMPN Manufacturer Part MPNMTART CHAR 1 0
X Yes
NULL No
MSTAE Cross-Plant Material Status MSTAE T141 CHAR 2 0
CCHIS Control (time) of history requirement: Material CC_HIST_MAT CHAR 1 0
NULL History requirement off
1 History requirement on
3 History requirement for changing
4 History requirement for creating
CTYPE Class Type KLASSENART_M TCLA CHAR 3 0
CLASS Class number KLASSE_M CHAR 18 0
CHNEU Batch Creation Control (Automatic/Manual) CHNEU CHAR 1 0
NULL Automatic / manual without check
A Automatic / manual and check against external number range
B Automatic / manual and check in USER EXIT
C Automatic / no manual creation
D Manual without check
E Manual and check against external number range
F Manual and check in USER EXIT
G No creation
VTYPE Version Category VERSIONTYPE MGVTYPE CHAR 10 0
VNUMKI Number range NUMKR CHAR 2 0
VNUMKE Number range NUMKR CHAR 2 0
KZRAC Returnable Packaging Logistics is mandatory KZRAC CHAR 1 0
X Yes
NULL No

T134 foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
T134 CTYPE T134 MANDT TCLA Class Types MANDT
T134 CTYPE T134 CTYPE TCLA Class Types KLART
T134 FLREF T134 MANDT T130A Material master field selection MANDT
T134 FLREF T134 FLREF T130A Material master field selection FLREF
T134 KKREF T134 MANDT T025K Account Category Reference MANDT
T134 KKREF T134 KKREF T025K Account Category Reference KKREF
T134 MSTAE T134 MANDT T141 Material Status from Materials Management/PPC View MANDT
T134 MSTAE T134 MSTAE T141 Material Status from Materials Management/PPC View MMSTA
T134 VMTPO T134 VMTPO TPTM Materials: Item Category Groups in Material Master MTPOS
T134 VMTPO T134 MANDT TPTM Materials: Item Category Groups in Material Master MANDT
T134 VTYPE SY MANDT MGVTYPE Table of version categories MANDT
T134 VTYPE T134 VTYPE MGVTYPE Table of version categories VTYPE