I_ChmlCmplncAddlPrptyStatus

@AbapCatalog:
{
  sqlViewName: 'ICCADLPTYSTATUS',
  compiler.compareFilter: true,
  preserveKey: true
}

--Access Control: Authorizations Checks
@AccessControl:
{
  // authorization check not required as view only reads domain values

  authorizationCheck: #NOT_REQUIRED
}

--Client Handling of the view
@ClientHandling.algorithm: #SESSION_VARIABLE

--VDM view type
@VDM.viewType: #BASIC

@ObjectModel:
{
  resultSet.sizeCategory: #XS,
  
  --Performance Annotations
  usageType:
  {
    dataClass: #META,
    sizeCategory: #S,
    serviceQuality: #B
  },
  representativeKey: 'ChmlCmplncAddlPrptyStatus'
}

@EndUserText.label: 'Chml Cmplnc Additional Property Status'
define view I_ChmlCmplncAddlPrptyStatus  
       as select from dd07l as Status
  left outer to one join dd07t as StatusText on Status.domname = StatusText.domname
                                             and Status.domvalue_l = StatusText.domvalue_l 
                                             and StatusText.ddlanguage = $session.system_language
{
  
  key  cast( Status.domvalue_l as ehfnd_cca_adlpr_status ) as ChmlCmplncAddlPrptyStatus,
  
       @Semantics.text: true
       StatusText.ddtext as ChmlCmplncAssgdObjStatusName 
}

where
      Status.domname  = 'EHFND_CCA_ADLPR_STATUS'
  and Status.as4local = 'A'
  and StatusText.domname  = 'EHFND_CCA_ADLPR_STATUS'
  and StatusText.as4local = 'A';