SAP table T134 (Material Types)

SAP table T134 has 2 primary key fields being MANDT,MTART.

If you're only analyzing data from a single SAP instance you may omit field MANT in your relationships as it will we the same across the entire dataset. On the other hand, if you're combining data from multiple SAP instances you need to take MANDT into account.

Field Description Data Type Length Decimals Checktable Data Element
MANDT Client CLNT 3 0 MANDT
MTART Material type CHAR 4 0 MTART
MTREF Reference material type CHAR 4 0 MTREF
MBREF Screen reference depending on the material type CHAR 4 0 MBREF
FLREF Field reference for material master CHAR 4 0 T130A FLREF_MG
NUMKI Number Range CHAR 2 0 NUMKR
NUMKE Number Range CHAR 2 0 NUMKR
ENVOP External Number Assignment Without Validation CHAR 1 0 ENVOP
BSEXT External Purchase Orders Allowed CHAR 1 0 BSEXT
0 No external purchase orders allowed
1 External purchase orders allowed, but warning issued
2 External purchase orders allowed
BSINT Internal purchase orders allowed CHAR 1 0 BSINT
0 No internal purchase orders allowed
1 Internal purchase orders allowed, but warning issued
2 Internal purchase orders allowed
PSTAT Maintenance status CHAR 15 0 PSTAT_D
KKREF Account category reference CHAR 4 0 T025K KKREF
VPRSV Price control indicator CHAR 1 0 VPRSV
S Standard price
V Moving average price/periodic unit price
KZVPR Price Control Mandatory CHAR 1 0 KZVPR
VMTPO Default value for material item category group CHAR 4 0 TPTM VMTPO
EKALR Material Is Costed with Quantity Structure CHAR 1 0 CK_EKALREL
KZGRP Grouping indicator CHAR 1 0 KZGRP
1 Product group
2 Free grouping
KZKFG Configurable Material CHAR 1 0 KZKFG
BEGRU Authorization group in the material master CHAR 4 0 BEGRM
KZPRC Material Master Record for a Process CHAR 1 0 KZPRC
KZPIP Pipeline Handling Mandatory CHAR 1 0 KZPIP
PRDRU Display price on cash register display and print on receipt CHAR 1 0 POSPRDRUCK
ARANZ Display material on cash register display CHAR 1 0 POSARTANZ
WMAKG Material Type ID CHAR 1 0 WMAK
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 CHAR 1 0 IZUST
Intitial status <free>
X Intitial status <not free>
ARDEL Time in days until a material is deleted NUMC 4 0 ARDEL
KZMPN Manufacturer Part CHAR 1 0 MPNMTART
MSTAE Cross-Plant Material Status CHAR 2 0 T141 MSTAE
CCHIS Control (time) of history requirement: Material CHAR 1 0 CC_HIST_MAT
History requirement off
1 History requirement on
3 History requirement for changing
4 History requirement for creating
CTYPE Class Type CHAR 3 0 TCLA KLASSENART_M
CLASS Class number CHAR 18 0 KLASSE_M
CHNEU Batch Creation Control (Automatic/Manual) CHAR 1 0 CHNEU
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
PROD_TYPE_CODE Product Type Group CHAR 2 0 CMD_PRDTYPE PRODUCT_TYPE
CONCTD_MATNR Concatenated Material No. CHAR 2 0 CONCTD_MATNR
VTYPE Version Category CHAR 10 0 MGVTYPE VERSIONTYPE
VNUMKI Number Range CHAR 2 0 NUMKR
VNUMKE Number Range CHAR 2 0 NUMKR
KZFFF Indicator: FFF class CHAR 1 0 KZFFF
KZRAC Returnable Packaging Logistics is mandatory CHAR 1 0 KZRAC

T134 foreign key relationships

Table Field Check Table Check Field
0 T134 CTYPE TCLA Class Types MANDT
1 T134 FLREF T130A Material master field selection MANDT
0 T134 KKREF T025K Account Category Reference KKREF
1 T134 MSTAE T141 Material Status from Materials Management/PPC View MANDT
1 T134 MSTAE T141 Material Status from Materials Management/PPC View MMSTA
0 T134 PROD_TYPE_CODE CMD_PRDTYPE Code List: Product Type Code PROD_TYPE_CODE
1 T134 VMTPO TPTM Materials: Item Category Groups in Material Master MTPOS
0 T134 VTYPE MGVTYPE Table of version categories VTYPE