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.
@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
}
}
defineview I_REObjectType
asselectfrom 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'
keycast(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 Entitywhen '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 Groupwhen '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 ''
endas char40 ) as SemanticObject,
@ObjectModel.association.type: [#TO_COMPOSITION_CHILD]
_Text
//,
//_tivcaobjtype
}