I_MaterialTypeText

DDL: I_MATERIALTYPETEXT Type: view BASIC

Material Type Text

I_MaterialTypeText is a Basic CDS View that provides data about "Material Type Text" in SAP S/4HANA. It reads from 1 data source (t134t) and exposes 4 fields with key fields MaterialType, Language. It has 1 association to related views.

1 data source(s) 4 fields

Data Sources (1)

SourceAliasJoin Type
t134t t134t from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_MaterialType _MaterialType $projection.MaterialType = _MaterialType.MaterialType

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IMATTYPETEXT view
AbapCatalog.preserveKey true view
ObjectModel.dataCategory #TEXT view
VDM.viewType #BASIC view
EndUserText.label Material Type Text view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.representativeKey MaterialType view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #MASTER view
ClientHandling.algorithm #SESSION_VARIABLE view

Fields (4)

KeyFieldSource TableSource FieldDescription
KEY MaterialType t134t mtart
KEY Language t134t spras
MaterialTypeName t134t mtbez
_MaterialType _MaterialType 
@AbapCatalog:{
sqlViewName: 'IMATTYPETEXT',
preserveKey: true
}
@ObjectModel.dataCategory: #TEXT
@VDM.viewType: #BASIC
@EndUserText.label: 'Material Type Text'
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.representativeKey: 'MaterialType'
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory : #M
@ObjectModel.usageType.dataClass: #MASTER
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_MaterialTypeText
  as select from t134t
  //   association [0..*] to I_Producttype as _ProductType           on $projection.ProductType = _ProductType.ProductType


  association [0..1] to I_MaterialType as _MaterialType on $projection.MaterialType = _MaterialType.MaterialType
{
  key t134t.mtart as MaterialType,
      @Semantics.language: true
  key t134t.spras as Language,
      @Semantics.text: true
      t134t.mtbez as MaterialTypeName,
      _MaterialType
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"T134T"
],
"ASSOCIATED":
[
"I_MATERIALTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More