I_MDQltyModelFieldText

DDL: I_MDQLTYMODELFIELDTEXT SQL: IMDQMODFLDTXT Type: view BASIC

Text for Model Fields

I_MDQltyModelFieldText is a Basic CDS View that provides data about "Text for Model Fields" in SAP S/4HANA. It reads from 2 data sources (dd03l, I_DataElementLabelText) and exposes 5 fields with key fields MDQltyModelTable, MDQltyModelField, Language. It has 1 association to related views.

2 data source(s) 5 fields

Data Sources (2)

SourceAliasJoin Type
dd03l _TableField inner
I_DataElementLabelText _Text from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName IMDQMODFLDTXT view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #TEXT view
ObjectModel.representativeKey MDQltyModelField view
EndUserText.label Text for Model Fields view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable true view

Fields (5)

KeyFieldSource TableSource FieldDescription
KEY MDQltyModelTable dd03l tabname
KEY MDQltyModelField dd03l fieldname
KEY Language I_DataElementLabelText Language
MDQltyModelDataElementName I_DataElementLabelText ABAPDataElementDescription
_Language _Language 
@AbapCatalog.sqlViewName: 'IMDQMODFLDTXT'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: { dataClass: #MASTER, serviceQuality: #C, sizeCategory: #L }
@ObjectModel.dataCategory: #TEXT
@ObjectModel.representativeKey: 'MDQltyModelField'
@EndUserText.label: 'Text for Model Fields'
@VDM.viewType: #BASIC
@ClientHandling.algorithm: #SESSION_VARIABLE
@Search.searchable: true
define view I_MDQltyModelFieldText
  as select from I_DataElementLabelText as _Text
    inner join   dd03l                  as _TableField on _Text.ABAPDataElement = _TableField.rollname
  association [0..1] to I_Language as _Language on $projection.Language = _Language.Language

{
      //ddftx

  key _TableField.tabname              as MDQltyModelTable,
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.8, ranking: #HIGH }
      @ObjectModel.text.element: [ 'MDQltyModelDataElementName' ]
  key _TableField.fieldname            as MDQltyModelField,

      @ObjectModel.foreignKey.association: '_Language'
      @Semantics.language
  key _Text.Language,

      @Semantics.text
      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.7, ranking: #LOW}
      @EndUserText: { label: 'Field Description', quickInfo: 'Field Description' }
      _Text.ABAPDataElementDescription as MDQltyModelDataElementName,

      /* Associations */
      //I_Language

      _Language
}
where
      _TableField.as4local = 'A'
  and _TableField.as4vers  = '0000'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_DATAELEMENTLABELTEXT",
"DD03L"
],
"ASSOCIATED":
[
"I_LANGUAGE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More