I_MDQualityRuleImplmtnStatus

@AccessControl.authorizationCheck: #NOT_REQUIRED
@Analytics.dataCategory: #DIMENSION
@Analytics.technicalName: 'IMDQRLIMPLSTS'
@Analytics.internalName:#LOCAL 
@ObjectModel.dataCategory: #VALUE_HELP
@ObjectModel.representativeKey: 'MDQltyRuleImplmtnStatus'
@ObjectModel.usageType: { sizeCategory: #S, dataClass: #CUSTOMIZING, serviceQuality: #C }
@ObjectModel.resultSet.sizeCategory: #XS
@VDM.viewType: #BASIC
@EndUserText.label: 'MDQ Rule Implementation Status'
/*+[hideWarning]{"IDS":["KEY_CHECK" ]} */
define view entity I_MDQualityRuleImplmtnStatus
  as select from dd07l
  association [0..*] to I_MDQualityRuleImplmtnStatusT as _MDQualityRuleImplmtnStatusT on $projection.MDQltyRuleImplmtnStatus = _MDQualityRuleImplmtnStatusT.MDQltyRuleImplmtnStatus
{
      @Consumption.filter.hidden: true
      @ObjectModel.text.association: '_MDQualityRuleImplmtnStatusT'
      @UI.textArrangement: #TEXT_ONLY
      @EndUserText: { label: 'Rule Implementation Status', quickInfo: 'Rule Implementation Status' }
  key cast( left( domvalue_l, 10 ) as mdq_tech_rule_status preserving type ) as MDQltyRuleImplmtnStatus,
      
      @Consumption.filter.hidden: true
      @ObjectModel.readOnly: true
      @UI.hidden: true
      case
          when domvalue_l = 'ACTIVE' then 3 
          when domvalue_l = 'INACTIVE' then 2
          when domvalue_l = 'INITIAL' or domvalue_l = 'NA' then 0
          else 0 end                                                    as MDQltyBusRuleStatusCriticality,

      @Consumption.filter.hidden: true
      _MDQualityRuleImplmtnStatusT
}
where
      domname  = 'MDQ_TECH_RULE_STATUS'
  and as4local = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L"
],
"ASSOCIATED":
[
"I_MDQUALITYRULEIMPLMTNSTATUST"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/