I_REObjectType

@AbapCatalog.sqlViewName: 'IREOBJTYPE'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
//@AccessControl.authorizationCheck: #CHECK

@AccessControl.authorizationCheck: #NOT_REQUIRED
@VDM.viewType: #BASIC
@EndUserText.label: 'Real Estate Object Type'
@ObjectModel.representativeKey: 'RealEstateObjectType'
@AbapCatalog.buffering.status: #ACTIVE
@AbapCatalog.buffering.type: #FULL
@ObjectModel.usageType.serviceQuality: #A
@ObjectModel.usageType.sizeCategory: #M
@ObjectModel.sapObjectNodeType.name: 'RealEstateObjectType'
@ClientHandling.algorithm: #SESSION_VARIABLE
@ObjectModel.usageType.dataClass:  #META
@ObjectModel.compositionRoot: true

@Metadata.ignorePropagatedAnnotations: true

@ObjectModel.modelingPattern:           #ANALYTICAL_DIMENSION
@ObjectModel.supportedCapabilities:  [  #ANALYTICAL_DIMENSION,
                                        #EXTRACTION_DATA_SOURCE,
                                        #CDS_MODELING_ASSOCIATION_TARGET,
                                        #SQL_DATA_SOURCE,
                                        #CDS_MODELING_DATA_SOURCE,
                                        #VALUE_HELP_PROVIDER,
                                        #SEARCHABLE_ENTITY ]
@Analytics:{
    dataExtraction: {
        enabled: true
    }
}
define view I_REObjectType
  as select from tbo00
  association [0..*] to I_REObjectTypeText as _Text on $projection.RealEstateObjectType = _Text.RealEstateObjectType
  //association [0..1] to tivcaobjtype as _tivcaobjtype on $projection.RealEstateObjectType = _tivcaobjtype.objtype

{
      @ObjectModel.text.association: '_Text'
  key cast(obart as recaobjtype preserving type ) as RealEstateObjectType,
      cast (case obart 
      when 'IS' then 'REContract'   //Contract 

      when 'I3' then 'REContract'   //Search Request  

      when 'I6' then 'REContract'   //Offered Object      

      
      when 'IW' then 'REMasterData' //Business Entity

      when 'IB' then 'REMasterData' //Building

      when 'IG' then 'REMasterData' //Property

      when 'IM' then 'REMasterData' //Rental Object

      when 'I0' then 'REMasterData' //Architectural Object

      when 'I5' then 'REMasterData' //Offered Object

      
      when 'I2' then 'REThirdParty' //Mandate

      
      when 'I8' then 'RELandUse'    //Parcel of Land

      when 'I9' then 'RELandUse'    //Public register

      when 'J1' then 'RELandUse'    //Notice of Assessment

      
      when 'I1' then 'REServiceCharge' //Settlement Unit

      when 'I4' then 'REServiceCharge' //Participation Group

      
      when 'J5' then 'RealEstateIntegrationObject'
      
      when 'AN' then 'FixedAsset'
      when 'KS' then 'CostCenter'
      when 'PR' then 'WBSElement'
      when 'OR' then 'InternalOrder'
      when 'IE' then 'Equipment'
      when 'IF' then 'FunctionalLocation'
      else '' 
      end as char40 ) as SemanticObject,
      
      @ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
      _Text
      
      //,

      //_tivcaobjtype

}