I_REObjectType

DDL: I_REOBJECTTYPE SQL: IREOBJTYPE Type: view BASIC

Real Estate Object Type

I_REObjectType is a Basic CDS View that provides data about "Real Estate Object Type" in SAP S/4HANA. It reads from 1 data source (tbo00) and exposes 2 fields with key field RealEstateObjectType. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
tbo00 tbo00 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_REObjectTypeText _Text $projection.RealEstateObjectType = _Text.RealEstateObjectType

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IREOBJTYPE view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #BASIC view
EndUserText.label Real Estate Object Type view
ObjectModel.representativeKey RealEstateObjectType view
AbapCatalog.buffering.status #ACTIVE view
AbapCatalog.buffering.type #FULL view
ObjectModel.usageType.serviceQuality #A view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.sapObjectNodeType.name RealEstateObjectType view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #META view
ObjectModel.compositionRoot true view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.modelingPattern #ANALYTICAL_DIMENSION view
Analytics.dataExtraction.enabled true view

Fields (2)

KeyFieldSource TableSource FieldDescription
KEY RealEstateObjectType
_Text _Text
@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

}