I_HdrGenIncompletionStatus

@ClientHandling.algorithm: #SESSION_VARIABLE

@VDM.viewType: #BASIC

@AccessControl.authorizationCheck:  #NOT_REQUIRED

@Analytics: { dataCategory: #DIMENSION}

@ObjectModel: {
  representativeKey: 'HdrGeneralIncompletionStatus',
  usageType: {
    dataClass: #META,
    serviceQuality: #A,
    sizeCategory: #S
  }, 
  resultSet.sizeCategory: #XS,
  supportedCapabilities: [ #ANALYTICAL_DIMENSION, 
                           #CDS_MODELING_ASSOCIATION_TARGET, 
                           #SQL_DATA_SOURCE, 
                           #CDS_MODELING_DATA_SOURCE, 
                           #SEARCHABLE_ENTITY ],
  modelingPattern: #ANALYTICAL_DIMENSION
}

@AbapCatalog: {
  sqlViewName: 'ISDHDGENINCLSTS',
  preserveKey: true
}

@Search.searchable: true

@Consumption.ranked: true

@Metadata.ignorePropagatedAnnotations:true

@EndUserText.label: 'Header General Incompletion Status'
define view I_HdrGenIncompletionStatus
as select from dd07l 

association [0..*] to I_HdrGenIncompletionStatusT as _Text on $projection.HdrGeneralIncompletionStatus = _Text.HdrGeneralIncompletionStatus
{
    @ObjectModel.text.association: '_Text'
    key cast( substring (dd07l.domvalue_l, 1, 1) as hdr_general_incompltn_status preserving type ) as HdrGeneralIncompletionStatus,
    
    @Analytics.hidden: true
    @Consumption.hidden: true
    @Search.defaultSearchElement: true
    @Search.ranking: #HIGH
    domvalue_l as DomainValue,
    
    _Text  
}
where (dd07l.domname = 'STATV') and (dd07l.as4local = 'A')
  and ((dd07l.domvalue_l = 'A') or (dd07l.domvalue_l = 'C'));