I_REINTEGRATIONOBJECT
Real Estate Integration Object
I_REINTEGRATIONOBJECT is a CDS View in S/4HANA. Real Estate Integration Object. It contains 11 fields. 11 CDS views read from this table.
CDS Views using this table (11)
| View | Type | Join | VDM | Description |
|---|---|---|---|---|
| ESH_N_REOCCUPANCY | view | from | ||
| ESH_N_REUSEENABLE | view | from | ||
| I_REIntegObjectObject2SpaceGrp | view | inner | COMPOSITE | Real Estate Integ Object to Space Group |
| I_REIntegObjectSiteVH | view | from | COMPOSITE | Real Estate Site Help |
| I_REIntegObjectSubObjValidity | view | from | COMPOSITE | Real Estate Integ Object Sub Validity |
| P_REIntegObjectOccpcyCalc1 | view | inner | COMPOSITE | |
| P_REIntegObjectOccpcyCalc3 | view | from | COMPOSITE | |
| P_REIntegObjectOccpcyCalc4 | view | from | COMPOSITE | |
| P_REIntegObjectOccpcyCalc5 | view | from | COMPOSITE | |
| P_REIntegObjectOccpcyCalc7 | view | from | COMPOSITE | |
| R_REIntegrationObjectTP | view_entity | from | TRANSACTIONAL | IntegrationObject TP |
Fields (11)
| Key | Field | CDS Fields | Used in Views |
|---|---|---|---|
| KEY | InternalRealEstateNumber | InternalRealEstateNumberLvl0,REIntegObjectInternalNumber | 7 |
| _UnitOfMeasureArea | _UnitOfMeasureArea | 1 | |
| RealEstateExternalID | RealEstateExternalIDLvl0 | 2 | |
| REAreaUnit | REAreaUnit | 1 | |
| REIntegObjSpaceGroupType | REIntegObjSpaceGroupType | 1 | |
| REIntegrationObjectName | REIntegObjectSiteName | 1 | |
| REIntegrationObjectNumber | REIntegrationObjectNumberLvl0 | 1 | |
| REInternalNumberForUseEnable | REInternalNumberForUseEnable | 1 | |
| REStatusObject | REIntegObjectStatusObject | 5 | |
| ValidityEndDate | REIntegObjectValidityEndDate,ValidityEndDateLvl0 | 7 | |
| ValidityStartDate | REIntegObjectValidityStartDate,ValidityStartDateLvl0 | 7 |
@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
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_REINTEGOBJECTVALIDITY",
"I_REINTEGRATIONOBJECTBASICDATA"
],
"ASSOCIATED":
[
"E_REINTEGRATIONOBJECT",
"I_COMPANYCODE",
"I_REAUTHORIZATIONGROUP",
"I_REINTEGOBJCTRLGOBJTYPE",
"I_REINTEGOBJECTACCTOBJASSGMT",
"I_REINTEGOBJECTMEASUREMENT",
"I_REINTEGOBJECTOCCUPANCY",
"I_REINTEGOBJECTRELATIONPARTIAL",
"I_REINTEGOBJECTTYPE",
"I_REINTEGOBJECTVALIDITY",
"I_REINTEGOBJSPACEGROUPTYPE",
"I_REINTEGOBJTOCONTRACTASSGMT",
"I_REINTEGRATIONOBJECTBASICDATA",
"I_REINTEGRATIONOBJECTRELATION",
"I_REINTEGRATIONOBJECTSUBOBJ",
"I_REINTEGRATIONOBJECTTIMELINE",
"I_REKEYASSGMT",
"I_REOBJECTADDRESS",
"I_REOBJECTASSGMT",
"I_REPARTNERASSGMT",
"I_REREMINDEROBJRULE",
"I_RESPACEGROUPUSAGETYPE",
"I_RESPACEGRPENABLEUSETYPE",
"I_STATUSOBJECT",
"I_STATUSOBJECTSTATUS",
"I_UNITOFMEASURE",
"I_USER"
],
"BASE":
[
"I_REINTEGRATIONOBJECTBASICDATA"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/