I_REINTEGRATIONOBJECTRELATION

CDS View

Real Estate Integ Object Relation

I_REINTEGRATIONOBJECTRELATION is a CDS View in S/4HANA. Real Estate Integ Object Relation. It contains 8 fields. 12 CDS views read from this table.

Used by 12 CDS view(s) 8 fields

CDS Views using this table (12)

ViewTypeJoinVDMDescription
I_REIntegObject2SpaceGrpHier view from COMPOSITE Real Estate Integ Object to Space Group Hierarchy
I_REIntegObject2SpaceGrpHier view union COMPOSITE Real Estate Integ Object to Space Group Hierarchy
I_REIntegObjectRelationAddl view from COMPOSITE Integration Object Relation Additional
I_REIntegObjectRltnValidity view_entity from COMPOSITE RE Integration Object Relation Validity
P_REIntegObjectValidityCalc3 view from COMPOSITE
P_REIntegObjMsmtHierCalc3 view_entity inner COMPOSITE Integration Object Measurement Hierarchy Calc View 3
P_REIntegObjMsmtHierCalc6 view_entity inner COMPOSITE Integration Object Measurement Hierarchy Date Calc View 5
P_REIntegObjMsmtHierCalc7 view_entity inner COMPOSITE Integration Object Measurement Hierarchy Date Calc View 7
P_REIntegObjMsmtHierDateCalc1 view_entity union_all COMPOSITE Integration Object Measurement Hierarchy Date Calc View 1
P_REIntegObjOccpcyHierCalc1 view_entity from COMPOSITE Integration Object Occupancy Hierarchy Calc View 1
P_REIntegObjOccpcyHierCalc1 view_entity union_all COMPOSITE Integration Object Occupancy Hierarchy Calc View 1
R_REIntegObjectObjRelationTP view_entity from TRANSACTIONAL IntegrationObject Relation TP

Fields (8)

KeyField CDS FieldsUsed in Views
KEY InternalRealEstateNumber InternalRealEstateNumber,InternalRealEstateNumberLvl0 4
KEY REIntegObjectRelationUUID REIntegObjectRelationUUID 1
KEY ValidityEndDate ValidityEndDate,ValidityEndDateLvl0 3
KEY ValidityStartDate ValidityStartDate,ValidityStartDateLvl0 4
InternalRealEstateNumberRltn InternalRealEstateNumberRltn 4
REIsObjectRelationPartial REIsObjectRelationPartial 2
REMeasurementPartialQuantity REMeasurementPartialQuantity 1
REMeasurementUnit REMeasurementPartialUnit 1 
@AbapCatalog.sqlViewName: 'IREINTOBJECTREL'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Integ Object Relation'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.representativeKey: 'REIntegObjectRelationUUID'
@ObjectModel.semanticKey: 'InternalRealEstateNumber'
@VDM.viewType: #BASIC
//@Search.searchable: true

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

define view I_REIntegrationObjectRelation
  as select from viipobjrel as _REIntegObjectRelation
  association [1..1] to I_REIntegrationObjectBasicData as _REIntegrationObject          on $projection.InternalRealEstateNumber     = _REIntegrationObject.InternalRealEstateNumber
  association [1..1] to I_REIntegrationObjectBasicData as _RERelatedIntegrationObject   on $projection.InternalRealEstateNumberRltn = _RERelatedIntegrationObject.InternalRealEstateNumber
  association [1..1] to I_REIntegrationObjectBasicData as _REUseEnableIntegrationObject on $projection.REInternalNumberForUseEnable = _REUseEnableIntegrationObject.InternalRealEstateNumber

  association [1..1] to I_REMeasurementType   as _REMeasurementType          on $projection.REMeasurementType = _REMeasurementType.REMeasurementType
  association [0..1] to I_UnitOfMeasure       as _UnitOfMeasure              on $projection.REMeasurementUnit = _UnitOfMeasure.UnitOfMeasure
{
  key objrelguid                                                  as REIntegObjectRelationUUID,
      intreno                                                     as InternalRealEstateNumber,
      intrenorel                                                  as InternalRealEstateNumberRltn,
      @Semantics.businessDate.from: true
      cast( validfrom as rebdvdmvalidfrom preserving type )       as ValidityStartDate,
      @Semantics.businessDate.to: true
      cast( validto as rebdvdmvalidto preserving type )           as ValidityEndDate,
      isobjectrelpart                                             as REIsObjectRelationPartial,
      meas                                                        as REMeasurementType,
      @Semantics.quantity.unitOfMeasure: 'REMeasurementUnit'
      measpart                                                    as REMeasurementPartialQuantity,
//      @Semantics.quantity.unitOfMeasure: 'REMeasurementUnit'

//      measfull                                                    as REMeasurementTotalQuantity,

      @ObjectModel.foreignKey.association: '_UnitOfMeasure'
      @Semantics.unitOfMeasure
      cast (measunit as msehiunit preserving type)                as REMeasurementUnit,
      _REIntegrationObject.REInternalNumberForUseEnable           as REInternalNumberForUseEnable,

      _REIntegrationObject,
      _RERelatedIntegrationObject,
      _REUseEnableIntegrationObject,
      _REMeasurementType,
      _UnitOfMeasure

} where $projection.internalrealestatenumber like 'J5%'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_REINTEGRATIONOBJECTBASICDATA",
"VIIPOBJREL"
],
"ASSOCIATED":
[
"I_REINTEGRATIONOBJECTBASICDATA",
"I_REMEASUREMENTTYPE",
"I_UNITOFMEASURE"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More