SAP Table

T134 Material Types

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

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

/ Fields

T134 columns.

Field Description Data Type Length Decimals Checktable Data Element
KeyMANDT Client CLNT 3 0 MANDT
KeyMTART 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
BSINT Internal purchase orders allowed CHAR 1 0 BSINT
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
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
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
IZUST Initial status of a new batch CHAR 1 0 IZUST
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
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
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
/ Relationships

T134 foreign keys.

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