I_REINTEGOBJECTOBJECT2SPACEGRP

CDS View

Real Estate Integ Object to Space Group

I_REINTEGOBJECTOBJECT2SPACEGRP is a CDS View in S/4HANA. Real Estate Integ Object to Space Group. It contains 8 fields. 4 CDS views read from this table.

Used by 4 CDS view(s) 8 fields

CDS Views using this table (4)

ViewTypeJoinVDMDescription
I_REIntegObjMsmtSpace2SpaceGrp view from COMPOSITE Real Estate Integ Meas Space 2 Space Grp
P_REIntegObjMsmtHierMsmtCalc2 view_entity union_all COMPOSITE Integration Object Measurement Hierarchy Msmt Calc View 2
P_REOccupancyValidityCalc1 view_entity from COMPOSITE RE Occpcy Validity Calc Helper 1
P_REOccupancyValidityCalc1 view_entity union_all COMPOSITE RE Occpcy Validity Calc Helper 1

Fields (8)

KeyField CDS FieldsUsed in Views
KEY InternalRealEstateNumberLvl0 InternalRealEstateNumberLvl0 2
KEY InternalRealEstateNumberLvl3 InternalRealEstateNumberLvl3 2
KEY ValidityEndDate REObjRltnValidityEndDate 1
ValidityEndDateLvl0 ValidityEndDateLvl0 1
ValidityEndDateLvl3 ValidityEndDateLvl3 1
ValidityStartDate REObjRltnValidityStartDate 1
ValidityStartDateLvl0 ValidityStartDateLvl0 1
ValidityStartDateLvl3 ValidityStartDateLvl3 1 
@AbapCatalog.sqlViewName: 'IREINTOBJOBJ2GRP'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Integ Object to Space Group'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
@Analytics.dataCategory: #CUBE
@Analytics.internalName:#LOCAL
//@ObjectModel.dataCategory: #VALUE_HELP


//@ObjectModel.representativeKey: ['REContractType']


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

@Analytics:{
    dataExtraction: {
        enabled: true
    }
}

@VDM.viewType: #COMPOSITE
//@Search.searchable: true

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true
@Metadata.allowExtensions:true

define view I_REIntegObjectObject2SpaceGrp
  as select from I_REIntegObjectRltnValidity   as _REIntegObjectRelation
    inner join   I_REIntegrationObject         as _REIntegObjLvl0              on _REIntegObjectRelation.InternalRealEstateNumber = _REIntegObjLvl0.InternalRealEstateNumber
    inner join   I_REIntegObjectSubObjValidity as _REIntegObjectSubObjValidity on _REIntegObjectRelation.InternalRealEstateNumberRltn = _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl3
{
  key      _REIntegObjLvl0.InternalRealEstateNumber                  as InternalRealEstateNumberLvl0,
  key      _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl3 as InternalRealEstateNumberLvl3,
  key      _REIntegObjectRelation.ValidityEndDate,
           _REIntegObjectRelation.ValidityStartDate,
           _REIntegObjLvl0.RealEstateExternalID                      as RealEstateExternalIDLvl0,
           _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl1 as InternalRealEstateNumberLvl1,
           _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl2 as InternalRealEstateNumberLvl2,
           _REIntegObjectSubObjValidity.RealEstateExternalIDLvl1     as RealEstateExternalIDLvl1,
           _REIntegObjectSubObjValidity.RealEstateExternalIDLvl2     as RealEstateExternalIDLvl2,
           _REIntegObjectSubObjValidity.RealEstateExternalIDLvl3     as RealEstateExternalIDLvl3,
           _REIntegObjLvl0.ValidityStartDate                         as ValidityStartDateLvl0,
           _REIntegObjLvl0.ValidityEndDate                           as ValidityEndDateLvl0,
           _REIntegObjectSubObjValidity.ValidityStartDateLvl1        as ValidityStartDateLvl1,
           _REIntegObjectSubObjValidity.ValidityEndDateLvl1          as ValidityEndDateLvl1,
           _REIntegObjectSubObjValidity.ValidityStartDateLvl2        as ValidityStartDateLvl2,
           _REIntegObjectSubObjValidity.ValidityEndDateLvl2          as ValidityEndDateLvl2,
           _REIntegObjectSubObjValidity.ValidityStartDateLvl3        as ValidityStartDateLvl3,
           _REIntegObjectSubObjValidity.ValidityEndDateLvl3          as ValidityEndDateLvl3,
           _REIntegObjectRelation.InternalRealEstateNumberRltn       as InternalRealEstateNumberRltn,
           _REIntegObjectRelation.REIsObjectRelationPartial,
           _REIntegObjLvl0.REInternalNumberForUseEnable,
           _REIntegObjLvl0.REIntegObjSpaceGroupType
}
union select from I_REIntegObjectRltnValidity   as _REIntegObjectRelation
  inner join      I_REIntegrationObject         as _REIntegObjLvl0              on _REIntegObjectRelation.InternalRealEstateNumber = _REIntegObjLvl0.InternalRealEstateNumber
  inner join      I_REIntegObjectSubObjValidity as _REIntegObjectSubObjValidity on _REIntegObjectRelation.InternalRealEstateNumberRltn = _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl2
{
  key      _REIntegObjLvl0.InternalRealEstateNumber                  as InternalRealEstateNumberLvl0,
  key      _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl3 as InternalRealEstateNumberLvl3,
  key      _REIntegObjectRelation.ValidityEndDate,
           _REIntegObjectRelation.ValidityStartDate,
           _REIntegObjLvl0.RealEstateExternalID                      as RealEstateExternalIDLvl0,
           _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl1 as InternalRealEstateNumberLvl1,
           _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl2 as InternalRealEstateNumberLvl2,
           _REIntegObjectSubObjValidity.RealEstateExternalIDLvl1     as RealEstateExternalIDLvl1,
           _REIntegObjectSubObjValidity.RealEstateExternalIDLvl2     as RealEstateExternalIDLvl2,
           _REIntegObjectSubObjValidity.RealEstateExternalIDLvl3     as RealEstateExternalIDLvl3,
           _REIntegObjLvl0.ValidityStartDate                         as ValidityStartDateLvl0,
           _REIntegObjLvl0.ValidityEndDate                           as ValidityEndDateLvl0,
           _REIntegObjectSubObjValidity.ValidityStartDateLvl1        as ValidityStartDateLvl1,
           _REIntegObjectSubObjValidity.ValidityEndDateLvl1          as ValidityEndDateLvl1,
           _REIntegObjectSubObjValidity.ValidityStartDateLvl2        as ValidityStartDateLvl2,
           _REIntegObjectSubObjValidity.ValidityEndDateLvl2          as ValidityEndDateLvl2,
           _REIntegObjectSubObjValidity.ValidityStartDateLvl3        as ValidityStartDateLvl3,
           _REIntegObjectSubObjValidity.ValidityEndDateLvl3          as ValidityEndDateLvl3,
           _REIntegObjectRelation.InternalRealEstateNumberRltn       as InternalRealEstateNumberRltn,
           _REIntegObjectRelation.REIsObjectRelationPartial,
           _REIntegObjLvl0.REInternalNumberForUseEnable,
           _REIntegObjLvl0.REIntegObjSpaceGroupType
}
where
  _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl3 like 'J5%'          

union select from I_REIntegObjectRltnValidity   as _REIntegObjectRelation
  inner join      I_REIntegrationObject         as _REIntegObjLvl0              on _REIntegObjectRelation.InternalRealEstateNumber = _REIntegObjLvl0.InternalRealEstateNumber
  inner join      I_REIntegObjectSubObjValidity as _REIntegObjectSubObjValidity on _REIntegObjectRelation.InternalRealEstateNumberRltn = _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl1
{
  key      _REIntegObjLvl0.InternalRealEstateNumber                  as InternalRealEstateNumberLvl0,
  key      _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl3 as InternalRealEstateNumberLvl3,
  key      _REIntegObjectRelation.ValidityEndDate,
           _REIntegObjectRelation.ValidityStartDate,
           _REIntegObjLvl0.RealEstateExternalID                      as RealEstateExternalIDLvl0,
           _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl1 as InternalRealEstateNumberLvl1,
           _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl2 as InternalRealEstateNumberLvl2,
           _REIntegObjectSubObjValidity.RealEstateExternalIDLvl1     as RealEstateExternalIDLvl1,
           _REIntegObjectSubObjValidity.RealEstateExternalIDLvl2     as RealEstateExternalIDLvl2,
           _REIntegObjectSubObjValidity.RealEstateExternalIDLvl3     as RealEstateExternalIDLvl3,
           _REIntegObjLvl0.ValidityStartDate                         as ValidityStartDateLvl0,
           _REIntegObjLvl0.ValidityEndDate                           as ValidityEndDateLvl0,
           _REIntegObjectSubObjValidity.ValidityStartDateLvl1        as ValidityStartDateLvl1,
           _REIntegObjectSubObjValidity.ValidityEndDateLvl1          as ValidityEndDateLvl1,
           _REIntegObjectSubObjValidity.ValidityStartDateLvl2        as ValidityStartDateLvl2,
           _REIntegObjectSubObjValidity.ValidityEndDateLvl2          as ValidityEndDateLvl2,
           _REIntegObjectSubObjValidity.ValidityStartDateLvl3        as ValidityStartDateLvl3,
           _REIntegObjectSubObjValidity.ValidityEndDateLvl3          as ValidityEndDateLvl3,
           _REIntegObjectRelation.InternalRealEstateNumberRltn       as InternalRealEstateNumberRltn,
           _REIntegObjectRelation.REIsObjectRelationPartial,
           _REIntegObjLvl0.REInternalNumberForUseEnable,
           _REIntegObjLvl0.REIntegObjSpaceGroupType
}
where
  _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl3 like 'J5%'

Learn More