@AbapCatalog.sqlViewName: 'IREINTOBJMEAS'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Integ Object Measurement'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
//@ObjectModel.dataCategory: #VALUE_HELP
@Analytics.dataCategory: #CUBE
@Analytics.internalName: #LOCAL
@VDM.viewType: #COMPOSITE
//@Search.searchable: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true
define view I_REIntegObjectMeasurement
as select from P_REIntegObjMsmtHierarchyCalc as _REIntegObjMsmtHierarchyCalc
association [1..1] to I_REIntegrationObject as _REIntegrationObject on _REIntegObjMsmtHierarchyCalc.InternalRealEstateNumber = _REIntegrationObject.InternalRealEstateNumber
association [1..1] to I_REMeasurementType as _REMeasurementType on _REIntegObjMsmtHierarchyCalc.REMeasurementType = _REMeasurementType.REMeasurementType
association [0..1] to I_UnitOfMeasure as _UnitOfMeasure on _REIntegObjMsmtHierarchyCalc.REMeasurementUnit = _UnitOfMeasure.UnitOfMeasure
{
key InternalRealEstateNumber,
@ObjectModel.foreignKey.association: '_REMeasurementType'
key REMeasurementType,
@Semantics.businessDate.from: true
key ValidityStartDate,
@Semantics.businessDate.to: true
key ValidityEndDate,
@ObjectModel.foreignKey.association: '_UnitOfMeasure'
REMeasurementUnit,
@Semantics.quantity.unitOfMeasure: 'REMeasurementUnit'
cast( REMeasurementQuantity as rebdmeasvalue preserving type ) as REMeasurementQuantity,
/* Associations */
_REIntegrationObject,
_REMeasurementType,
_UnitOfMeasure
}
// as select from I_REIntegObjMsmtLevel0 as _REIntegObjMsmtLevel0
// association [0..1] to I_REIntegrationObject as _REIntegrationObject on $projection.InternalRealEstateNumber = _REIntegrationObject.InternalRealEstateNumber
//{
//
// key _REIntegObjMsmtLevel0.InternalRealEstateNumberLvl0 as InternalRealEstateNumber,
// @ObjectModel.foreignKey.association: '_REMeasurementType'
// key _REIntegObjMsmtLevel0.REMeasurementType,
// @Semantics.businessDate.to: true
// key _REIntegObjMsmtLevel0.ValidityEndDate,
// @Semantics.businessDate.from: true
// _REIntegObjMsmtLevel0.ValidityStartDate,
// @ObjectModel.foreignKey.association: '_UnitOfMeasure'
// @Semantics.unitOfMeasure
// _REIntegObjMsmtLevel0.REMeasurementUnit,
// @Semantics.quantity.unitOfMeasure: 'REMeasurementUnit'
// _REIntegObjMsmtLevel0.REMeasurementQuantity,
// _REIntegrationObject,
// _REMeasurementType,
// _UnitOfMeasure
//
//}
//
//union select from I_REIntegObjMsmtLevel1 as _REIntegObjMsmtLevel1
//association [0..1] to I_REIntegrationObject as _REIntegrationObject on $projection.InternalRealEstateNumber = _REIntegrationObject.InternalRealEstateNumber
//{
//
// key _REIntegObjMsmtLevel1.InternalRealEstateNumberLvl1 as InternalRealEstateNumber,
// @ObjectModel.foreignKey.association: '_REMeasurementType'
// key _REIntegObjMsmtLevel1.REMeasurementType,
// @Semantics.businessDate.to: true
// key _REIntegObjMsmtLevel1.ValidityEndDate,
// @Semantics.businessDate.from: true
// _REIntegObjMsmtLevel1.ValidityStartDate,
// @ObjectModel.foreignKey.association: '_UnitOfMeasure'
// @Semantics.unitOfMeasure
// _REIntegObjMsmtLevel1.REMeasurementUnit,
// @Semantics.quantity.unitOfMeasure: 'REMeasurementUnit'
// _REIntegObjMsmtLevel1.REMeasurementQuantity,
// _REIntegrationObject,
// _REMeasurementType,
// _UnitOfMeasure
//
//}
//
//union select from I_REIntegObjMsmtLevel2 as _REIntegObjMsmtLevel2
//association [0..1] to I_REIntegrationObject as _REIntegrationObject on $projection.InternalRealEstateNumber = _REIntegrationObject.InternalRealEstateNumber
//{
//
// key _REIntegObjMsmtLevel2.InternalRealEstateNumberLvl2 as InternalRealEstateNumber,
// @ObjectModel.foreignKey.association: '_REMeasurementType'
// key _REIntegObjMsmtLevel2.REMeasurementType,
// @Semantics.businessDate.to: true
// key _REIntegObjMsmtLevel2.ValidityEndDate,
// @Semantics.businessDate.from: true
// _REIntegObjMsmtLevel2.ValidityStartDate,
// @ObjectModel.foreignKey.association: '_UnitOfMeasure'
// @Semantics.unitOfMeasure
// _REIntegObjMsmtLevel2.REMeasurementUnit,
// @Semantics.quantity.unitOfMeasure: 'REMeasurementUnit'
// _REIntegObjMsmtLevel2.REMeasurementQuantity,
// _REIntegrationObject,
// _REMeasurementType,
// _UnitOfMeasure
//
//}
//
//union select from I_REIntegObjMsmtSpaceGroup as _REIntegObjMsmtSpaceGroup
//association [0..1] to I_REIntegrationObject as _REIntegrationObject on $projection.InternalRealEstateNumber = _REIntegrationObject.InternalRealEstateNumber
//{
//
// key _REIntegObjMsmtSpaceGroup.InternalRealEstateNumberLvl0 as InternalRealEstateNumber,
// @ObjectModel.foreignKey.association: '_REMeasurementType'
// key _REIntegObjMsmtSpaceGroup.REMeasurementType,
// @Semantics.businessDate.to: true
// key _REIntegObjMsmtSpaceGroup.ValidityEndDate,
// @Semantics.businessDate.from: true
// _REIntegObjMsmtSpaceGroup.ValidityStartDate,
// @ObjectModel.foreignKey.association: '_UnitOfMeasure'
// @Semantics.unitOfMeasure
// _REIntegObjMsmtSpaceGroup.REMeasurementUnit,
// @Semantics.quantity.unitOfMeasure: 'REMeasurementUnit'
// _REIntegObjMsmtSpaceGroup.REMeasurementQuantity,
// _REIntegrationObject,
// _REMeasurementType,
// _UnitOfMeasure
//
//}
//
//union select from I_REMeasurement as _REMeasurement
//association [0..1] to I_REIntegrationObject as _REIntegrationObject on $projection.InternalRealEstateNumber = _REIntegrationObject.InternalRealEstateNumber
//{
// key _REMeasurement.InternalRealEstateNumber,
// @ObjectModel.foreignKey.association: '_REMeasurementType'
// key _REMeasurement.REMeasurementType,
// @Semantics.businessDate.to: true
// key _REMeasurement.ValidityEndDate,
// @Semantics.businessDate.from: true
// _REMeasurement.ValidityStartDate,
// @ObjectModel.foreignKey.association: '_UnitOfMeasure'
// @Semantics.unitOfMeasure
// _REMeasurement.REMeasurementUnit,
// @Semantics.quantity.unitOfMeasure: 'REMeasurementUnit'
// _REMeasurement.REMeasurementQuantity,
// // @Semantics.quantity.unitOfMeasure: 'REMeasurementUnit'
// // REMaximumMeasurementQuantity
// // REMeasurementIsManuallySet,
// // REMsmtHasSubordinateObject,
// _REIntegrationObject,
// _REMeasurementType,
// _UnitOfMeasure
//}
//where
// _REKeyAssgmt.RealEstateObjectType = 'J5'