I_MaintPlanningBucketTypeText

@AbapCatalog: {sqlViewName: 'IPLNGBKTTYT', compiler.compareFilter, preserveKey }
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Maintenance Planning Bucket Type'
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel: {
  dataCategory: #TEXT,  
  usageType: {
    dataClass: #MASTER,
    serviceQuality: #A,
    sizeCategory: #S } }

@VDM.viewType: #BASIC

// Note: Reading of DD07L + Usage of coalesce is a temporary workaround until CE Content is delivered


define view I_MaintPlanningBucketTypeText
  as select from           dd07t
    left outer to one join eam_plngbktty_t on  eam_plngbktty_t.maintplanningbuckettype = dd07t.domvalue_l
                                           and eam_plngbktty_t.language                = dd07t.ddlanguage
  association [1] to I_Language                as _Language           on _Language.Language = $projection.Language
  association [1] to I_MaintPlanningBucketType as _PlanningBucketType on _PlanningBucketType.MaintPlanningBucketType = $projection.MaintPlanningBucketType
{
      @ObjectModel.foreignKey.association: '_PlanningBucketType'
      @ObjectModel.text.element: ['MaintPlanningBucketTypeText']
  key dd07t.domvalue_l           as MaintPlanningBucketType,
      --key maintplanningbuckettype     as MaintPlanningBucketType,
      @Semantics.language
      @ObjectModel.foreignKey.association: '_Language'
  key dd07t.ddlanguage           as Language,
      --key language                    as Language,

      @Semantics.text
      cast( coalesce( maintplanningbuckettypetext, dd07t.ddtext )
        as eam_plngbkttypetext ) as MaintPlanningBucketTypeText,
      --maintplanningbuckettypetext as MaintPlanningBucketTypeText,

      _PlanningBucketType,
      _Language
}
where
      dd07t.domname  = 'EAM_PLNGBKTTYPE'
  and dd07t.as4local = 'A'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"DD07T",
"EAM_PLNGBKTTY_T"
],
"ASSOCIATED":
[
"I_LANGUAGE",
"I_MAINTPLANNINGBUCKETTYPE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/