I_REIntegObjectObject2SrvcGrp

//@AbapCatalog.sqlViewName: 'IREINTOBJ2SRVGRP'

@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Object to Service Group'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@VDM.viewType: #COMPOSITE

@ObjectModel.supportedCapabilities:  [  #CDS_MODELING_ASSOCIATION_TARGET,
                                        #EXTRACTION_DATA_SOURCE,
                                        #SQL_DATA_SOURCE,
                                        #CDS_MODELING_DATA_SOURCE]

@Metadata.ignorePropagatedAnnotations: true

@Analytics:{
        dataCategory: #CUBE,
        technicalName: 'IREINTOBJ2SRVGRP',
        internalName:#LOCAL,
        dataExtraction: {
            enabled: true
    }

}

@Metadata.allowExtensions:true

define view entity I_REIntegObjectObject2SrvcGrp
  as select from I_RESrvcGrpObjectRelation   as _RESrvcGrpObjectRelation
    inner join   I_REServiceGroupBasicData   as _REServiceGroup      on _RESrvcGrpObjectRelation.InternalRealEstateNumber = _REServiceGroup.InternalRealEstateNumber
    inner join   I_REIntegrationObjectSubObj as _REIntegObjectSubObj on _RESrvcGrpObjectRelation.InternalRealEstateNumberRltn = _REIntegObjectSubObj.InternalRealEstateNumberLvl3
{
  key      _REServiceGroup.InternalRealEstateNumber              as InternalRealEstateNumberLvl0,
  key      _REIntegObjectSubObj.InternalRealEstateNumberLvl3     as InternalRealEstateNumberLvl3,
  key      _RESrvcGrpObjectRelation.ValidityEndDate,
           _RESrvcGrpObjectRelation.ValidityStartDate,
           _REIntegObjectSubObj.InternalRealEstateNumberLvl1     as InternalRealEstateNumberLvl1,
           _REIntegObjectSubObj.InternalRealEstateNumberLvl2     as InternalRealEstateNumberLvl2,
           _REIntegObjectSubObj.RealEstateExternalIDLvl1         as RealEstateExternalIDLvl1,
           _REIntegObjectSubObj.RealEstateExternalIDLvl2         as RealEstateExternalIDLvl2,
           _REIntegObjectSubObj.RealEstateExternalIDLvl3         as RealEstateExternalIDLvl3,
           _RESrvcGrpObjectRelation.InternalRealEstateNumberRltn as InternalRealEstateNumberRltn,
           _RESrvcGrpObjectRelation.REIsObjectRelationPartial
}
union select from I_RESrvcGrpObjectRelation   as _RESrvcGrpObjectRelation
  inner join      I_REServiceGroupBasicData   as _REServiceGroup      on _RESrvcGrpObjectRelation.InternalRealEstateNumber = _REServiceGroup.InternalRealEstateNumber
  inner join      I_REIntegrationObjectSubObj as _REIntegObjectSubObj on _RESrvcGrpObjectRelation.InternalRealEstateNumberRltn = _REIntegObjectSubObj.InternalRealEstateNumberLvl2
{
  key      _REServiceGroup.InternalRealEstateNumber              as InternalRealEstateNumberLvl0,
  key      _REIntegObjectSubObj.InternalRealEstateNumberLvl3     as InternalRealEstateNumberLvl3,
  key      _RESrvcGrpObjectRelation.ValidityEndDate,
           _RESrvcGrpObjectRelation.ValidityStartDate,
           _REIntegObjectSubObj.InternalRealEstateNumberLvl1     as InternalRealEstateNumberLvl1,
           _REIntegObjectSubObj.InternalRealEstateNumberLvl2     as InternalRealEstateNumberLvl2,
           _REIntegObjectSubObj.RealEstateExternalIDLvl1         as RealEstateExternalIDLvl1,
           _REIntegObjectSubObj.RealEstateExternalIDLvl2         as RealEstateExternalIDLvl2,
           _REIntegObjectSubObj.RealEstateExternalIDLvl3         as RealEstateExternalIDLvl3,
           _RESrvcGrpObjectRelation.InternalRealEstateNumberRltn as InternalRealEstateNumberRltn,
           _RESrvcGrpObjectRelation.REIsObjectRelationPartial
}
where
  _REIntegObjectSubObj.InternalRealEstateNumberLvl3 is not null

union select from I_RESrvcGrpObjectRelation   as _RESrvcGrpObjectRelation
  inner join      I_REServiceGroupBasicData   as _REServiceGroup      on _RESrvcGrpObjectRelation.InternalRealEstateNumber = _REServiceGroup.InternalRealEstateNumber
  inner join      I_REIntegrationObjectSubObj as _REIntegObjectSubObj on _RESrvcGrpObjectRelation.InternalRealEstateNumberRltn = _REIntegObjectSubObj.InternalRealEstateNumberLvl1
{
  key      _REServiceGroup.InternalRealEstateNumber              as InternalRealEstateNumberLvl0,
  key      _REIntegObjectSubObj.InternalRealEstateNumberLvl3     as InternalRealEstateNumberLvl3,
  key      _RESrvcGrpObjectRelation.ValidityEndDate,
           _RESrvcGrpObjectRelation.ValidityStartDate,
           _REIntegObjectSubObj.InternalRealEstateNumberLvl1     as InternalRealEstateNumberLvl1,
           _REIntegObjectSubObj.InternalRealEstateNumberLvl2     as InternalRealEstateNumberLvl2,
           _REIntegObjectSubObj.RealEstateExternalIDLvl1         as RealEstateExternalIDLvl1,
           _REIntegObjectSubObj.RealEstateExternalIDLvl2         as RealEstateExternalIDLvl2,
           _REIntegObjectSubObj.RealEstateExternalIDLvl3         as RealEstateExternalIDLvl3,
           _RESrvcGrpObjectRelation.InternalRealEstateNumberRltn as InternalRealEstateNumberRltn,
           _RESrvcGrpObjectRelation.REIsObjectRelationPartial
}
where
  _REIntegObjectSubObj.InternalRealEstateNumberLvl3 is not null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_REINTEGRATIONOBJECTSUBOBJ",
"I_RESERVICEGROUPBASICDATA",
"I_RESRVCGRPOBJECTRELATION"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/