I_REIntegObjectObject2SpaceGrp

DDL: I_REINTEGOBJECTOBJECT2SPACEGRP SQL: IREINTOBJOBJ2GRP Type: view COMPOSITE Package: VDM_RE_IP

Real Estate Integ Object to Space Group

I_REIntegObjectObject2SpaceGrp is a Composite CDS View (Cube) that provides data about "Real Estate Integ Object to Space Group" in SAP S/4HANA. It reads from 9 data sources and exposes 62 fields with key fields InternalRealEstateNumberLvl0, InternalRealEstateNumberLvl3, ValidityEndDate, InternalRealEstateNumberLvl3, ValidityEndDate. Part of development package VDM_RE_IP.

9 data source(s) 62 fields

Data Sources (9)

SourceAliasJoin Type
I_REIntegObjectRltnValidity _REIntegObjectRelation from
I_REIntegObjectRltnValidity _REIntegObjectRelation union
I_REIntegObjectRltnValidity _REIntegObjectRelation union
I_REIntegObjectSubObjValidity _REIntegObjectSubObjValidity inner
I_REIntegObjectSubObjValidity _REIntegObjectSubObjValidity inner
I_REIntegObjectSubObjValidity _REIntegObjectSubObjValidity inner
I_REIntegrationObject _REIntegObjLvl0 inner
I_REIntegrationObject _REIntegObjLvl0 inner
I_REIntegrationObject _REIntegObjLvl0 inner

Annotations (15)

NameValueLevelField
AbapCatalog.sqlViewName IREINTOBJOBJ2GRP view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Real Estate Integ Object to Space Group view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
Analytics.dataCategory #CUBE view
Analytics.internalName #LOCAL view
Metadata.ignorePropagatedAnnotations true view
Analytics.dataExtraction.enabled true view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view
Metadata.allowExtensions true view

Fields (62)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumberLvl0 I_REIntegrationObject InternalRealEstateNumber
KEY InternalRealEstateNumberLvl3 I_REIntegObjectSubObjValidity InternalRealEstateNumberLvl3
KEY ValidityEndDate I_REIntegObjectRltnValidity ValidityEndDate
ValidityStartDate I_REIntegObjectRltnValidity ValidityStartDate
RealEstateExternalIDLvl0 I_REIntegrationObject RealEstateExternalID
InternalRealEstateNumberLvl1 I_REIntegObjectSubObjValidity InternalRealEstateNumberLvl1
InternalRealEstateNumberLvl2 I_REIntegObjectSubObjValidity InternalRealEstateNumberLvl2
RealEstateExternalIDLvl1 I_REIntegObjectSubObjValidity RealEstateExternalIDLvl1
RealEstateExternalIDLvl2 I_REIntegObjectSubObjValidity RealEstateExternalIDLvl2
RealEstateExternalIDLvl3 I_REIntegObjectSubObjValidity RealEstateExternalIDLvl3
ValidityStartDateLvl0 I_REIntegrationObject ValidityStartDate
ValidityEndDateLvl0 I_REIntegrationObject ValidityEndDate
ValidityStartDateLvl1 I_REIntegObjectSubObjValidity ValidityStartDateLvl1
ValidityEndDateLvl1 I_REIntegObjectSubObjValidity ValidityEndDateLvl1
ValidityStartDateLvl2 I_REIntegObjectSubObjValidity ValidityStartDateLvl2
ValidityEndDateLvl2 I_REIntegObjectSubObjValidity ValidityEndDateLvl2
ValidityStartDateLvl3 I_REIntegObjectSubObjValidity ValidityStartDateLvl3
ValidityEndDateLvl3 I_REIntegObjectSubObjValidity ValidityEndDateLvl3
InternalRealEstateNumberRltn I_REIntegObjectRltnValidity InternalRealEstateNumberRltn
REIsObjectRelationPartial I_REIntegObjectRltnValidity REIsObjectRelationPartial
REInternalNumberForUseEnable I_REIntegrationObject REInternalNumberForUseEnable
KEY InternalRealEstateNumberLvl3 I_REIntegObjectSubObjValidity InternalRealEstateNumberLvl3
KEY ValidityEndDate I_REIntegObjectRltnValidity ValidityEndDate
ValidityStartDate I_REIntegObjectRltnValidity ValidityStartDate
RealEstateExternalIDLvl0 I_REIntegrationObject RealEstateExternalID
InternalRealEstateNumberLvl1 I_REIntegObjectSubObjValidity InternalRealEstateNumberLvl1
InternalRealEstateNumberLvl2 I_REIntegObjectSubObjValidity InternalRealEstateNumberLvl2
RealEstateExternalIDLvl1 I_REIntegObjectSubObjValidity RealEstateExternalIDLvl1
RealEstateExternalIDLvl2 I_REIntegObjectSubObjValidity RealEstateExternalIDLvl2
RealEstateExternalIDLvl3 I_REIntegObjectSubObjValidity RealEstateExternalIDLvl3
ValidityStartDateLvl0 I_REIntegrationObject ValidityStartDate
ValidityEndDateLvl0 I_REIntegrationObject ValidityEndDate
ValidityStartDateLvl1 I_REIntegObjectSubObjValidity ValidityStartDateLvl1
ValidityEndDateLvl1 I_REIntegObjectSubObjValidity ValidityEndDateLvl1
ValidityStartDateLvl2 I_REIntegObjectSubObjValidity ValidityStartDateLvl2
ValidityEndDateLvl2 I_REIntegObjectSubObjValidity ValidityEndDateLvl2
ValidityStartDateLvl3 I_REIntegObjectSubObjValidity ValidityStartDateLvl3
ValidityEndDateLvl3 I_REIntegObjectSubObjValidity ValidityEndDateLvl3
InternalRealEstateNumberRltn I_REIntegObjectRltnValidity InternalRealEstateNumberRltn
REIsObjectRelationPartial I_REIntegObjectRltnValidity REIsObjectRelationPartial
REInternalNumberForUseEnable I_REIntegrationObject REInternalNumberForUseEnable
KEY InternalRealEstateNumberLvl3 I_REIntegObjectSubObjValidity InternalRealEstateNumberLvl3
KEY ValidityEndDate I_REIntegObjectRltnValidity ValidityEndDate
ValidityStartDate I_REIntegObjectRltnValidity ValidityStartDate
RealEstateExternalIDLvl0 I_REIntegrationObject RealEstateExternalID
InternalRealEstateNumberLvl1 I_REIntegObjectSubObjValidity InternalRealEstateNumberLvl1
InternalRealEstateNumberLvl2 I_REIntegObjectSubObjValidity InternalRealEstateNumberLvl2
RealEstateExternalIDLvl1 I_REIntegObjectSubObjValidity RealEstateExternalIDLvl1
RealEstateExternalIDLvl2 I_REIntegObjectSubObjValidity RealEstateExternalIDLvl2
RealEstateExternalIDLvl3 I_REIntegObjectSubObjValidity RealEstateExternalIDLvl3
ValidityStartDateLvl0 I_REIntegrationObject ValidityStartDate
ValidityEndDateLvl0 I_REIntegrationObject ValidityEndDate
ValidityStartDateLvl1 I_REIntegObjectSubObjValidity ValidityStartDateLvl1
ValidityEndDateLvl1 I_REIntegObjectSubObjValidity ValidityEndDateLvl1
ValidityStartDateLvl2 I_REIntegObjectSubObjValidity ValidityStartDateLvl2
ValidityEndDateLvl2 I_REIntegObjectSubObjValidity ValidityEndDateLvl2
ValidityStartDateLvl3 I_REIntegObjectSubObjValidity ValidityStartDateLvl3
ValidityEndDateLvl3 I_REIntegObjectSubObjValidity ValidityEndDateLvl3
InternalRealEstateNumberRltn I_REIntegObjectRltnValidity InternalRealEstateNumberRltn
REIsObjectRelationPartial I_REIntegObjectRltnValidity REIsObjectRelationPartial
REInternalNumberForUseEnable I_REIntegrationObject REInternalNumberForUseEnable
REIntegObjSpaceGroupType I_REIntegrationObject REIntegObjSpaceGroupType 
@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