Which tables does I_REIntegObject2SpaceGrpHier use?

I_REIntegObject2SpaceGrpHier reads from 9 data source(s): I_REIntegrationObjectRelation, I_REIntegrationObjectRelation, I_REIntegrationObjectRelation, I_REIntegrationObjectSubObj, I_REIntegrationObjectSubObj, I_REIntegrationObjectSubObj, I_REIntegrationObjectBasicData, I_REIntegrationObjectBasicData, I_REIntegrationObjectBasicData.

I_REIntegObject2SpaceGrpHier

Q: How many fields does I_REIntegObject2SpaceGrpHier have?

I_REIntegObject2SpaceGrpHier has 38 fields. Key fields: InternalRealEstateNumberLvl0, InternalRealEstateNumberLvl3, ValidityEndDate, InternalRealEstateNumberLvl3, ValidityEndDate.

DDL: I_REINTEGOBJECT2SPACEGRPHIER SQL: IREINTOBJOB2GRPH Type: view COMPOSITE

Real Estate Integ Object to Space Group Hierarchy

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

Data Sources (9)

Source	Alias	Join Type
I_REIntegrationObjectRelation	_REIntegObjectRelation	from
I_REIntegrationObjectRelation	_REIntegObjectRelation	union
I_REIntegrationObjectRelation	_REIntegObjectRelation	union
I_REIntegrationObjectSubObj	_REIntegObjectSubObjValidity	inner
I_REIntegrationObjectSubObj	_REIntegObjectSubObjValidity	inner
I_REIntegrationObjectSubObj	_REIntegObjectSubObjValidity	inner
I_REIntegrationObjectBasicData	_REIntegObjLvl0	inner
I_REIntegrationObjectBasicData	_REIntegObjLvl0	inner
I_REIntegrationObjectBasicData	_REIntegObjLvl0	inner

Annotations (15)

Name	Value	Level
AbapCatalog.sqlViewName	IREINTOBJOB2GRPH	view
AbapCatalog.compiler.compareFilter	true	view
AccessControl.authorizationCheck	#NOT_REQUIRED	view
EndUserText.label	Real Estate Integ Object to Space Group Hierarchy	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 (38)

Key	Field	Source Table	Source Field
KEY	InternalRealEstateNumberLvl0	I_REIntegrationObjectBasicData	InternalRealEstateNumber
KEY	InternalRealEstateNumberLvl3	I_REIntegrationObjectSubObj	InternalRealEstateNumberLvl3
KEY	ValidityEndDate	I_REIntegrationObjectRelation	ValidityEndDate
	ValidityStartDate	I_REIntegrationObjectRelation	ValidityStartDate
	RealEstateExternalIDLvl0	I_REIntegrationObjectBasicData	RealEstateExternalID
	InternalRealEstateNumberLvl1	I_REIntegrationObjectSubObj	InternalRealEstateNumberLvl1
	InternalRealEstateNumberLvl2	I_REIntegrationObjectSubObj	InternalRealEstateNumberLvl2
	RealEstateExternalIDLvl1	I_REIntegrationObjectSubObj	RealEstateExternalIDLvl1
	RealEstateExternalIDLvl2	I_REIntegrationObjectSubObj	RealEstateExternalIDLvl2
	RealEstateExternalIDLvl3	I_REIntegrationObjectSubObj	RealEstateExternalIDLvl3
	InternalRealEstateNumberRltn	I_REIntegrationObjectRelation	InternalRealEstateNumberRltn
	REIsObjectRelationPartial	I_REIntegrationObjectRelation	REIsObjectRelationPartial
	REInternalNumberForUseEnable	I_REIntegrationObjectBasicData	REInternalNumberForUseEnable
KEY	InternalRealEstateNumberLvl3	I_REIntegrationObjectSubObj	InternalRealEstateNumberLvl3
KEY	ValidityEndDate	I_REIntegrationObjectRelation	ValidityEndDate
	ValidityStartDate	I_REIntegrationObjectRelation	ValidityStartDate
	RealEstateExternalIDLvl0	I_REIntegrationObjectBasicData	RealEstateExternalID
	InternalRealEstateNumberLvl1	I_REIntegrationObjectSubObj	InternalRealEstateNumberLvl1
	InternalRealEstateNumberLvl2	I_REIntegrationObjectSubObj	InternalRealEstateNumberLvl2
	RealEstateExternalIDLvl1	I_REIntegrationObjectSubObj	RealEstateExternalIDLvl1
	RealEstateExternalIDLvl2	I_REIntegrationObjectSubObj	RealEstateExternalIDLvl2
	RealEstateExternalIDLvl3	I_REIntegrationObjectSubObj	RealEstateExternalIDLvl3
	InternalRealEstateNumberRltn	I_REIntegrationObjectRelation	InternalRealEstateNumberRltn
	REIsObjectRelationPartial	I_REIntegrationObjectRelation	REIsObjectRelationPartial
	REInternalNumberForUseEnable	I_REIntegrationObjectBasicData	REInternalNumberForUseEnable
KEY	InternalRealEstateNumberLvl3	I_REIntegrationObjectSubObj	InternalRealEstateNumberLvl3
KEY	ValidityEndDate	I_REIntegrationObjectRelation	ValidityEndDate
	ValidityStartDate	I_REIntegrationObjectRelation	ValidityStartDate
	RealEstateExternalIDLvl0	I_REIntegrationObjectBasicData	RealEstateExternalID
	InternalRealEstateNumberLvl1	I_REIntegrationObjectSubObj	InternalRealEstateNumberLvl1
	InternalRealEstateNumberLvl2	I_REIntegrationObjectSubObj	InternalRealEstateNumberLvl2
	RealEstateExternalIDLvl1	I_REIntegrationObjectSubObj	RealEstateExternalIDLvl1
	RealEstateExternalIDLvl2	I_REIntegrationObjectSubObj	RealEstateExternalIDLvl2
	RealEstateExternalIDLvl3	I_REIntegrationObjectSubObj	RealEstateExternalIDLvl3
	InternalRealEstateNumberRltn	I_REIntegrationObjectRelation	InternalRealEstateNumberRltn
	REIsObjectRelationPartial	I_REIntegrationObjectRelation	REIsObjectRelationPartial
	REInternalNumberForUseEnable	I_REIntegrationObjectBasicData	REInternalNumberForUseEnable
	REIntegObjSpaceGroupType	I_REIntegrationObjectBasicData	REIntegObjSpaceGroupType

@AbapCatalog.sqlViewName: 'IREINTOBJOB2GRPH'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Integ Object to Space Group Hierarchy'
@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_REIntegObject2SpaceGrpHier
  as select from I_REIntegrationObjectRelation  as _REIntegObjectRelation
    inner join   I_REIntegrationObjectBasicData as _REIntegObjLvl0              on _REIntegObjectRelation.InternalRealEstateNumber = _REIntegObjLvl0.InternalRealEstateNumber
    inner join   I_REIntegrationObjectSubObj    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,
           _REIntegObjectRelation.InternalRealEstateNumberRltn       as InternalRealEstateNumberRltn,
           _REIntegObjectRelation.REIsObjectRelationPartial,
           _REIntegObjLvl0.REInternalNumberForUseEnable,
           _REIntegObjLvl0.REIntegObjSpaceGroupType
}
union select from I_REIntegrationObjectRelation  as _REIntegObjectRelation
  inner join      I_REIntegrationObjectBasicData as _REIntegObjLvl0              on _REIntegObjectRelation.InternalRealEstateNumber = _REIntegObjLvl0.InternalRealEstateNumber
  inner join      I_REIntegrationObjectSubObj    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,
           _REIntegObjectRelation.InternalRealEstateNumberRltn       as InternalRealEstateNumberRltn,
           _REIntegObjectRelation.REIsObjectRelationPartial,
           _REIntegObjLvl0.REInternalNumberForUseEnable,
           _REIntegObjLvl0.REIntegObjSpaceGroupType
}
where
  _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl3 is not null           

union select from I_REIntegrationObjectRelation  as _REIntegObjectRelation
  inner join      I_REIntegrationObjectBasicData as _REIntegObjLvl0              on _REIntegObjectRelation.InternalRealEstateNumber = _REIntegObjLvl0.InternalRealEstateNumber
  inner join      I_REIntegrationObjectSubObj    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,
           _REIntegObjectRelation.InternalRealEstateNumberRltn       as InternalRealEstateNumberRltn,
           _REIntegObjectRelation.REIsObjectRelationPartial,
           _REIntegObjLvl0.REInternalNumberForUseEnable,
           _REIntegObjLvl0.REIntegObjSpaceGroupType
}
where
  _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl3 is not null
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_REINTEGRATIONOBJECTBASICDATA",
"I_REINTEGRATIONOBJECTRELATION",
"I_REINTEGRATIONOBJECTSUBOBJ"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Depth:

I_REIntegObject2SpaceGrpHier view