I_ProdCmplncSrvcReqExtStatus

@AbapCatalog.sqlViewName: 'IPCSERVREQEXTS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Dimension view for PC Service Request External Status'

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #BASIC

@ObjectModel.representativeKey: 'ProdCmplncSrvcReqExtStatus'
@ObjectModel.usageType:{ serviceQuality: #A,        // < 1 msec

                         sizeCategory:  #S,         // < 1.000

                         dataClass: #META }

/*+[hideWarning] { "IDS" : [ "KEY_CHECK" ]  } */
define view I_ProdCmplncSrvcReqExtStatus
  as select from dd07l
  association [0..*] to I_ProdCmplncSrvcReqExtStatusT as _Text on $projection.ProdCmplncSrvcReqExtStatus = _Text.ProdCmplncSrvcReqExtStatus
{
      @ObjectModel.text.association: '_Text'
  key cast(dd07l.domvalue_l as prodcmplncsrvcreqextstatus) as ProdCmplncSrvcReqExtStatus,

      cast ( case dd07l.domvalue_l
            when 'NEW' then 0 // New                              -> Neutral (gray)

            when 'IN_PROCESS' then 0 // In Progress               -> Neutral (gray)

            when 'READY' then 3 // Ready                          -> Positive (green)

            when 'FINISHED' then 3 // Completed                   -> Positive (green)

            when 'FIN_WO_CHG' then 3 // Completed Without Change  -> Positive (green)

            when 'REJECTED' then 1 // Rejected                    -> Negative (red)

            when 'IN_CLFCTN' then 2 // In Clarification           -> Critical (orange)

            else 0
          end as prodcmplncsrvcreqextstscritlty ) as ProdCmplncSrvcReqExtStsCritlty,

      _Text
}
where
      dd07l.domname  = 'PRODCMPLNCSRVCREQEXTSTATUS'
  and dd07l.as4local = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07L"
],
"ASSOCIATED":
[
"I_PRODCMPLNCSRVCREQEXTSTATUST"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/