T134

Transparent Table Customizing (protected)
35 Fields 9 CDS Views

Material Types

T134 is an SAP database table in S/4HANA. Material Types. It contains 35 fields. 9 CDS views read from this table.

CDS Views using this table (9)

ViewTypeJoinVDMDescription
I_MaterialType view from BASIC Material Type
I_Matlvaluationclass view_entity inner BASIC Valuation Class Based on Product Type
I_Producttype view from BASIC Product Type
I_ProductType_2 view from BASIC Product Type
I_ProductTypeNumberRanges view from BASIC Number ranges for product type
I_ProductTypeVH view from BASIC Product Type
I_VASProductVH view_entity inner BASIC Value Added Services Product
P_SubscrpnProdSpec view inner BASIC Subscription Product Specification
V_Mmim_DDL_Om_Param view left_outer Goods Movement Parameters

Fields (35)

KeyField Data ElementDescription DomainTypeLength
KEY mandt mandt Client
KEY mtart mtart Material Type
mtref mtref Ref. mat. type
mbref mbref SRef: matl type
flref flref_mg Field reference
numki numkr Number Range
numke numkr Number Range
envop envop Ext. NA w/o ck
bsext bsext External POs
bsint bsint Internal POs
pstat pstat_d Maint. Status
kkref kkref Acct cat. ref.
vprsv vprsv Price control
kzvpr kzvpr Pr. Ctrl Mand.
vmtpo vmtpo Item cat. group
ekalr ck_ekalrel Cost Est. w/QS
kzgrp kzgrp Grouping ind.
kzkfg kzkfg Configrable Material
begru begrm Auth. group
kzprc kzprc Process
kzpip kzpip Pipe. mandatory
prdru posprdruck Print price
aranz posartanz Display matl
wmakg wmak Material Type ID
izust izust Initial Status
ardel ardel Time till deleted
kzmpn mpnmtart Mfr part
mstae mstae X-Plant Status
cchis cc_hist_mat History reqmt
ctype klassenart_m Class type
class klasse_m Class
chneu chneu New Batch
prod_type_code product_type Product Type Group
conctd_matnr conctd_matnr Conctd Mat No.
wip_ind de_wip_indicator Only EWM Stock

Derived SQL schema, reconstructed from the indexed DDIC field metadata (field names, types, lengths and key flags) — a functional representation, not the verbatim SAP source.

-- Material Types
-- Category TRANSPARENT · Delivery class G
-- Derived schema, generated from indexed DDIC field metadata (not the verbatim SAP source).
CREATE TABLE T134 (
    MANDT,           -- Client [mandt]
    MTART,           -- Material Type [mtart]
    MTREF,           -- Ref. mat. type [mtref]
    MBREF,           -- SRef: matl type [mbref]
    FLREF,           -- Field reference [flref_mg]
    NUMKI,           -- Number Range [numkr]
    NUMKE,           -- Number Range [numkr]
    ENVOP,           -- Ext. NA w/o ck [envop]
    BSEXT,           -- External POs [bsext]
    BSINT,           -- Internal POs [bsint]
    PSTAT,           -- Maint. Status [pstat_d]
    KKREF,           -- Acct cat. ref. [kkref]
    VPRSV,           -- Price control [vprsv]
    KZVPR,           -- Pr. Ctrl Mand. [kzvpr]
    VMTPO,           -- Item cat. group [vmtpo]
    EKALR,           -- Cost Est. w/QS [ck_ekalrel]
    KZGRP,           -- Grouping ind. [kzgrp]
    KZKFG,           -- Configrable Material [kzkfg]
    BEGRU,           -- Auth. group [begrm]
    KZPRC,           -- Process [kzprc]
    KZPIP,           -- Pipe. mandatory [kzpip]
    PRDRU,           -- Print price [posprdruck]
    ARANZ,           -- Display matl [posartanz]
    WMAKG,           -- Material Type ID [wmak]
    IZUST,           -- Initial Status [izust]
    ARDEL,           -- Time till deleted [ardel]
    KZMPN,           -- Mfr part [mpnmtart]
    MSTAE,           -- X-Plant Status [mstae]
    CCHIS,           -- History reqmt [cc_hist_mat]
    CTYPE,           -- Class type [klassenart_m]
    CLASS,           -- Class [klasse_m]
    CHNEU,           -- New Batch [chneu]
    PROD_TYPE_CODE,  -- Product Type Group [product_type]
    CONCTD_MATNR,    -- Conctd Mat No. [conctd_matnr]
    WIP_IND,         -- Only EWM Stock [de_wip_indicator]
    PRIMARY KEY (MANDT, MTART)
);

Learn More