I_REIntegrationObject

DDL: I_REINTEGRATIONOBJECT SQL: IREINTOBJECT Type: view COMPOSITE Package: VDM_RE_IP

Real Estate Integration Object

I_REIntegrationObject is a Composite CDS View (Dimension) that provides data about "Real Estate Integration Object" in SAP S/4HANA. It reads from 1 data source (I_REIntegrationObjectBasicData) and exposes 58 fields with key field InternalRealEstateNumber. It has 2 associations to related views. Part of development package VDM_RE_IP.

1 data source(s) 58 fields

Data Sources (1)

SourceAliasJoin Type
I_REIntegrationObjectBasicData I_REIntegrationObjectBasicData from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_REIntegObjectValidity _REIntegObjectValidity $projection.InternalRealEstateNumber = _REIntegObjectValidity.InternalRealEstateNumber
[1..1] E_REIntegrationObject _Extension $projection.InternalRealEstateNumber = _Extension.InternalRealEstateNumber

Annotations (18)

NameValueLevelField
AbapCatalog.sqlViewName IREINTOBJECT view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Real Estate Integration Object view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.representativeKey InternalRealEstateNumber view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Analytics.internalName #LOCAL view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view
Analytics.dataExtraction.delta.changeDataCapture.automatic true view
ObjectModel.modelingPattern #NONE view
Metadata.ignorePropagatedAnnotations true view
Metadata.allowExtensions true view
VDM.viewType #COMPOSITE view

Fields (58)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumber InternalRealEstateNumber
RealEstateExternalID RealEstateExternalID
REStatusObject REStatusObject
REIntegrationObjectNumber REIntegrationObjectNumber
REIntegrationObjectType REIntegrationObjectType
REIntegObjectCtrlgObjectType REIntegObjectCtrlgObjectType
REIntegrationObjectName REIntegrationObjectName
REIntegObjectLongName REIntegObjectLongName
ValidityStartDate
ValidityEndDate
REIntegObjSpaceGroupType REIntegObjSpaceGroupType
RESpaceGroupUsageType RESpaceGroupUsageType
RESpaceGrpEnableUseType RESpaceGrpEnableUseType
REInternalNumberForUseEnable REInternalNumberForUseEnable
CompanyCode CompanyCode
REParentIntegObjectType REParentIntegObjectType
REParentIntegObjectExternalID REParentIntegObjectExternalID
REAreaUnit REAreaUnit
CreatedByUser CreatedByUser
CreationDate CreationDate
CreationTime CreationTime
RESourceOfCreation RESourceOfCreation
LastChangedByUser LastChangedByUser
LastChangeDate LastChangeDate
LastChangeTime LastChangeTime
RESourceOfChange RESourceOfChange
Responsible Responsible
REAuthorizationGroup REAuthorizationGroup
_CreatedByUser _CreatedByUser
_ChangedByUser _ChangedByUser
_ResponsibleUser _ResponsibleUser
_UnitOfMeasureArea _UnitOfMeasureArea
_REAuthorizationGroup _REAuthorizationGroup
_REIntegObjectType _REIntegObjectType
_REIntegObjCtrlgObjType _REIntegObjCtrlgObjType
_REParentIntegObjectType _REParentIntegObjectType
_REIntegObjSpaceGroupType _REIntegObjSpaceGroupType
_RESpaceGroupUsageType _RESpaceGroupUsageType
_RESpaceGrpEnableUseType _RESpaceGrpEnableUseType
_CompanyCode _CompanyCode
_REKeyAssgmt _REKeyAssgmt
_StatusObject _StatusObject
_StatusObjectStatus _StatusObjectStatus
_REObjectAddress _REObjectAddress
_REIntegObjectOccupancy _REIntegObjectOccupancy
_REIntegObjToContractAssgmt _REIntegObjToContractAssgmt
_REIntegrationObjSubObj _REIntegrationObjSubObj
_REParentIntegrationObject _REParentIntegrationObject
_REUseEnableIntegrationObject _REUseEnableIntegrationObject
_REIntegrationObjectRelation _REIntegrationObjectRelation
_REIntegObjectRelationPartial _REIntegObjectRelationPartial
_REPartnerAssgmt _REPartnerAssgmt
_REObjectAssgmt _REObjectAssgmt
_REReminderRule _REReminderRule
_REMeasurement _REMeasurement
_REIntegObjectAcctObjAssgmt _REIntegObjectAcctObjAssgmt
_REIntegrationObjectTimeline _REIntegrationObjectTimeline
_REIntegObjectValidity _REIntegObjectValidity 
@AbapCatalog.sqlViewName: 'IREINTOBJECT'

@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Real Estate Integration Object'
@ClientHandling.algorithm: #SESSION_VARIABLE

@ObjectModel.representativeKey: 'InternalRealEstateNumber'
@ObjectModel.semanticKey: ['RealEstateExternalID']
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L

@Analytics.internalName:#LOCAL
@Analytics:{
    dataCategory: #DIMENSION,
    dataExtraction: {
        enabled: true,
        delta.changeDataCapture: {
        automatic: true
        }
    }
}

@ObjectModel.modelingPattern: #NONE
@ObjectModel.supportedCapabilities:  [  #ANALYTICAL_DIMENSION,
                                        #CDS_MODELING_ASSOCIATION_TARGET,
                                        #EXTRACTION_DATA_SOURCE,
                                        #SQL_DATA_SOURCE,
                                        #CDS_MODELING_DATA_SOURCE,
                                        #SEARCHABLE_ENTITY      ]

@Metadata.ignorePropagatedAnnotations: true

@Metadata.allowExtensions: true

@VDM.viewType: #COMPOSITE

define view I_REIntegrationObject
  as select from I_REIntegrationObjectBasicData

  association [1..1] to I_REIntegObjectValidity as _REIntegObjectValidity on $projection.InternalRealEstateNumber = _REIntegObjectValidity.InternalRealEstateNumber

  //  extensibility

  association [1..1] to E_REIntegrationObject   as _Extension             on $projection.InternalRealEstateNumber = _Extension.InternalRealEstateNumber
{
  key InternalRealEstateNumber,
      RealEstateExternalID,
      @ObjectModel.foreignKey.association: '_StatusObject'
      REStatusObject,
      REIntegrationObjectNumber,
      @ObjectModel.foreignKey.association: '_REIntegObjectType'
      REIntegrationObjectType,
      @ObjectModel.foreignKey.association: '_REIntegObjCtrlgObjType'
      REIntegObjectCtrlgObjectType,
      REIntegrationObjectName,
      REIntegObjectLongName,
      @Semantics.businessDate.from: true
      cast( _REIntegObjectValidity.ValidityStartDate as rebdvdmvalidfrom preserving type ) as ValidityStartDate,
      @Semantics.businessDate.to: true
      cast( _REIntegObjectValidity.ValidityEndDate as rebdvdmvalidto preserving type )     as ValidityEndDate,
      @ObjectModel.foreignKey.association: '_REIntegObjSpaceGroupType'
      REIntegObjSpaceGroupType,
      @ObjectModel.foreignKey.association: '_RESpaceGroupUsageType'
      RESpaceGroupUsageType,
      @ObjectModel.foreignKey.association: '_RESpaceGrpEnableUseType'
      RESpaceGrpEnableUseType,
      @ObjectModel.foreignKey.association: '_REUseEnableIntegrationObject'
      REInternalNumberForUseEnable,
      @ObjectModel.foreignKey.association: '_CompanyCode'
      CompanyCode,
      @ObjectModel.foreignKey.association: '_REParentIntegObjectType'
      REParentIntegObjectType,
      REParentIntegObjectExternalID,
      @ObjectModel.foreignKey.association: '_UnitOfMeasureArea'
      REAreaUnit,
      CreatedByUser,
      CreationDate,
      CreationTime,
      RESourceOfCreation,
      LastChangedByUser,
      LastChangeDate,
      LastChangeTime,
      RESourceOfChange,
      Responsible,
      @ObjectModel.foreignKey.association: '_REAuthorizationGroup'
      REAuthorizationGroup,

      _CreatedByUser,
      _ChangedByUser,
      _ResponsibleUser,
      _UnitOfMeasureArea,
      _REAuthorizationGroup,
      _REIntegObjectType,
      _REIntegObjCtrlgObjType,
      _REParentIntegObjectType,
      _REIntegObjSpaceGroupType,
      _RESpaceGroupUsageType,
      _RESpaceGrpEnableUseType,
      _CompanyCode,
      _REKeyAssgmt,
      _StatusObject,
      _StatusObjectStatus,
      _REObjectAddress,
      _REIntegObjectOccupancy,
      _REIntegObjToContractAssgmt,
      _REIntegrationObjSubObj,

      _REParentIntegrationObject,
      _REUseEnableIntegrationObject,
      _REIntegrationObjectRelation,
      _REIntegObjectRelationPartial,
      _REPartnerAssgmt,
      _REObjectAssgmt,
      _REReminderRule,
      _REMeasurement,
      _REIntegObjectAcctObjAssgmt,
      _REIntegrationObjectTimeline,
      _REIntegObjectValidity

}

Learn More