I_MDQltyBusRuleCheckedField

DDL: I_MDQLTYBUSRULECHECKEDFIELD Type: view_entity BASIC

MDQ Business Rule Checked Field

I_MDQltyBusRuleCheckedField is a Basic CDS View that provides data about "MDQ Business Rule Checked Field" in SAP S/4HANA. It reads from 1 data source (mdc_model_fields) and exposes 6 fields with key fields MDQltyBusinessObjectTypeCode, MDQltyBusRuleCheckedFieldTable, MDQltyBusRuleCheckedField. It has 2 associations to related views.

1 data source(s) 6 fields

Data Sources (1)

SourceAliasJoin Type
mdc_model_fields mdc_model_fields from

Associations (2)

CardinalityTargetAliasCondition
[0..*] I_MDQltyBusRuleChkdFieldText _MDQltyBusRuleChkdFieldText $projection.MDQltyBusRuleCheckedField = _MDQltyBusRuleChkdFieldText.MDQltyBusRuleCheckedField and $projection.MDQltyBusRuleCheckedFieldTable = _MDQltyBusRuleChkdFieldText.MDQltyBusRuleCheckedFieldTable
[0..*] I_MDQltyBusinessRuleBaseTableT _MDQltyBusinessRuleBaseTableT $projection.MDQltyBusRuleCheckedFieldTable = _MDQltyBusinessRuleBaseTableT.MDQltyBusinessRuleBaseTable and $projection.MDQltyBusinessObjectTypeCode = _MDQltyBusinessRuleBaseTableT.MDQltyBusinessObjectTypeCode

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.representativeKey MDQltyBusRuleCheckedField view
Analytics.technicalName IMDQBRCHKFLD view
VDM.viewType #BASIC view
Search.searchable true view
EndUserText.label MDQ Business Rule Checked Field view

Fields (6)

KeyFieldSource TableSource FieldDescription
KEY MDQltyBusinessObjectTypeCode bo_type
KEY MDQltyBusRuleCheckedFieldTable
KEY MDQltyBusRuleCheckedField
MDQltyBusRuleChkdFieldAndTable
_MDQltyBusRuleChkdFieldText _MDQltyBusRuleChkdFieldText
_MDQltyBusinessRuleBaseTableT _MDQltyBusinessRuleBaseTableT 
@AccessControl.authorizationCheck: #CHECK
@ObjectModel.usageType: { dataClass: #MASTER, serviceQuality: #C, sizeCategory: #M }
@ObjectModel.representativeKey: 'MDQltyBusRuleCheckedField'
@Analytics.technicalName: 'IMDQBRCHKFLD'
@VDM.viewType: #BASIC
@Search.searchable: true
@EndUserText.label: 'MDQ Business Rule Checked Field'
define view entity I_MDQltyBusRuleCheckedField
  as select from mdc_model_fields
  association [0..*] to I_MDQltyBusRuleChkdFieldText   as _MDQltyBusRuleChkdFieldText   on  $projection.MDQltyBusRuleCheckedField      = _MDQltyBusRuleChkdFieldText.MDQltyBusRuleCheckedField
                                                                                        and $projection.MDQltyBusRuleCheckedFieldTable = _MDQltyBusRuleChkdFieldText.MDQltyBusRuleCheckedFieldTable
  association [0..*] to I_MDQltyBusinessRuleBaseTableT as _MDQltyBusinessRuleBaseTableT on  $projection.MDQltyBusRuleCheckedFieldTable = _MDQltyBusinessRuleBaseTableT.MDQltyBusinessRuleBaseTable
                                                                                        and $projection.MDQltyBusinessObjectTypeCode   = _MDQltyBusinessRuleBaseTableT.MDQltyBusinessObjectTypeCode
{
      //mdc_model_fields

  key bo_type                                                                                         as MDQltyBusinessObjectTypeCode,

      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.95, ranking: #MEDIUM }
      @ObjectModel.text.association: '_MDQltyBusinessRuleBaseTableT'
      @EndUserText: { label: 'Table', quickInfo: 'Table' }
  key cast( table_name as mdq_chkfld_tabname preserving type )                                        as MDQltyBusRuleCheckedFieldTable,

      @Search: { defaultSearchElement: true, fuzzinessThreshold: 0.95, ranking: #HIGH }
      @ObjectModel.text.association: '_MDQltyBusRuleChkdFieldText'
      @EndUserText: { label: 'Field Name', quickInfo: 'Field Name' }
  key cast( field_name as mdq_chkfld_fieldname preserving type )                                      as MDQltyBusRuleCheckedField,

      cast(concat(concat(table_name, '-'), field_name) as mdq_chkfld_tabandfieldname preserving type) as MDQltyBusRuleChkdFieldAndTable,

      _MDQltyBusRuleChkdFieldText,
      _MDQltyBusinessRuleBaseTableT
}

where
      technical != 'X'
  //  and immutable != 'X'

  //  and obscured != 'X'

  and field_name != 'SOURCE_RECENCY'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"MDC_MODEL_FIELDS"
],
"ASSOCIATED":
[
"I_MDQLTYBUSINESSRULEBASETABLET",
"I_MDQLTYBUSRULECHKDFIELDTEXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More