I_MDQltyBusRuleChkdFieldText

DDL: I_MDQLTYBUSRULECHKDFIELDTEXT Type: view_entity BASIC

Master Data Quality Checked Field Text

I_MDQltyBusRuleChkdFieldText is a Basic CDS View that provides data about "Master Data Quality Checked Field Text" in SAP S/4HANA. It reads from 2 data sources (dd03l, I_DataElementLabelText) and exposes 6 fields with key fields MDQltyBusRuleCheckedFieldTable, MDQltyBusRuleCheckedField, Language. It has 2 associations to related views.

2 data source(s) 6 fields

Data Sources (2)

SourceAliasJoin Type
dd03l _TableField inner
I_DataElementLabelText _Text from

Associations (2)

CardinalityTargetAliasCondition
[0..1] I_Language _Language $projection.Language = _Language.Language
[1..*] I_MDQltyBusRuleCheckedField _MDQltyBusRuleCheckedField $projection.MDQltyBusRuleCheckedFieldTable = _MDQltyBusRuleCheckedField.MDQltyBusRuleCheckedFieldTable and $projection.MDQltyBusRuleCheckedField = _MDQltyBusRuleCheckedField.MDQltyBusRuleCheckedField

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.dataCategory #TEXT view
Analytics.technicalName IMDQBRCHKFLDT view
ObjectModel.representativeKey MDQltyBusRuleCheckedField view
VDM.viewType #BASIC view
Search.searchable true view
EndUserText.label Master Data Quality Checked Field Text view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY MDQltyBusRuleCheckedFieldTable
KEY MDQltyBusRuleCheckedField
KEY Language I_DataElementLabelText Language
MDQltyBusRuleCheckedFieldName I_DataElementLabelText ABAPDataElementDescription
_Language _Language
_MDQltyBusRuleCheckedField _MDQltyBusRuleCheckedField 
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ObjectModel.usageType: { dataClass: #MASTER, serviceQuality: #C, sizeCategory: #L }
@ObjectModel.dataCategory: #TEXT
@Analytics.technicalName: 'IMDQBRCHKFLDT'
@ObjectModel.representativeKey: 'MDQltyBusRuleCheckedField'
@VDM.viewType: #BASIC
@Search.searchable: true
@EndUserText.label: 'Master Data Quality Checked Field Text'
define view entity I_MDQltyBusRuleChkdFieldText
  as select from I_DataElementLabelText as _Text
    inner join   dd03l                  as _TableField on _Text.ABAPDataElement = _TableField.rollname

  //as select from ddftx

  association [0..1] to I_Language                  as _Language                  on  $projection.Language = _Language.Language
  association [1..*] to I_MDQltyBusRuleCheckedField as _MDQltyBusRuleCheckedField on  $projection.MDQltyBusRuleCheckedFieldTable = _MDQltyBusRuleCheckedField.MDQltyBusRuleCheckedFieldTable
                                                                                  and $projection.MDQltyBusRuleCheckedField      = _MDQltyBusRuleCheckedField.MDQltyBusRuleCheckedField
{
      //ddftx

  key cast( _TableField.tabname as mdq_chkfld_tabname preserving type )     as MDQltyBusRuleCheckedFieldTable,

      @ObjectModel.text.element: [ 'MDQltyBusRuleCheckedFieldName' ]
  key cast( _TableField.fieldname as mdq_chkfld_fieldname preserving type ) as MDQltyBusRuleCheckedField,

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

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

      /* Associations */
      //I_Language

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

Learn More