I_REMEASUREMENT

CDS View

Real Estate Measurement

I_REMEASUREMENT is a CDS View in S/4HANA. Real Estate Measurement. It contains 9 fields. 13 CDS views read from this table.

Used by 13 CDS view(s) 9 fields

CDS Views using this table (13)

ViewTypeJoinVDMDescription
C_RERntblObjectMeasurementDEX view_entity from CONSUMPTION Extractor for RE Rntbl Obj Measurement
C_REUsableObjectMeasurementDEX view_entity from CONSUMPTION Extractor for RE Usable Obj Measurement
I_REIntegObjectMsmtSubObj view inner COMPOSITE Real Estate Integ Measurement Subobject
I_REIntegObjMsmtSpace2SpaceGrp view inner COMPOSITE Real Estate Integ Meas Space 2 Space Grp
I_RERntblObjectMeasurement view_entity from COMPOSITE Real Estate Rentable Object Measurement
I_REUsableObjectMeasurement view_entity from COMPOSITE Real Estate Usable Object Measurement
P_REIntegObjMsmtHierCalc5 view_entity inner COMPOSITE Integration Object Measurement Hierarchy Date Calc View 5
P_REIntegObjMsmtHierDateCalc1 view_entity from COMPOSITE Integration Object Measurement Hierarchy Date Calc View 1
P_REIntegObjMsmtHierMsmtCalc1 view_entity from COMPOSITE Integration Object Measurement Hierarchy Msmt Calc View 1
P_REIntegObjOccpcyHierCalc1 view_entity union_all COMPOSITE Integration Object Occupancy Hierarchy Calc View 1
R_REIntegObjectMeasurementTP view_entity from TRANSACTIONAL IntegrationObject Measurement TP
R_RERntblObjectMeasurementTP view_entity from TRANSACTIONAL RE Rentable Object Measurement TP
R_REUsableObjectMeasurementTP view_entity from TRANSACTIONAL RE Usable Object Measurement TP

Fields (9)

KeyField CDS FieldsUsed in Views
KEY InternalRealEstateNumber InternalRealEstateNumber 7
KEY REMeasurementType REMeasurementType,REMeasurementTypeForEdit 9
KEY ValidityEndDate ValidityEndDate,ValidityEndDateForEdit 6
KEY ValidityStartDate ValidityStartDate 7
_REMeasurementType _REMeasurementType 6
_UnitOfMeasure _UnitOfMeasure 6
REMaximumMeasurementQuantity REMaximumMeasurementQuantity 6
REMeasurementQuantity REMeasurementQuantity 7
REMeasurementUnit REMeasurementUnit 8 
@AbapCatalog.sqlViewName: 'IREMEASUREMENT'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE
@EndUserText.label: 'Real Estate Measurement'
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #B
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.semanticKey: ['InternalRealEstateNumber', 'REMeasurementType', 'ValidityEndDate']
@VDM.viewType: #BASIC

//@Metadata.allowExtensions: true

define root view I_REMeasurement
  as select from vibdmeas
  association [1..1] to I_REKeyAssgmt       as _REKeyAssgmt       on $projection.InternalRealEstateNumber = _REKeyAssgmt.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
{
      @ObjectModel.foreignKey.association: '_REKeyAssgmt'
  key intreno                                      as InternalRealEstateNumber,
      @ObjectModel.foreignKey.association: '_REMeasurementType'
  key meas                                         as REMeasurementType,
      @Semantics.businessDate.to: true
  key cast(validto as rebdvdmvalidto)              as ValidityEndDate,
      @Semantics.businessDate.from: true
      cast(validfrom as rebdvdmvalidfrom)          as ValidityStartDate,
      @Semantics.quantity.unitOfMeasure: 'REMeasurementUnit'
      measvalue                                    as REMeasurementQuantity,
      @Semantics.quantity.unitOfMeasure: 'REMeasurementUnit'
      measvaluecmpl                                as REMaximumMeasurementQuantity,
      @ObjectModel.foreignKey.association: '_UnitOfMeasure'
      @Semantics.unitOfMeasure
      cast (measunit as msehiunit preserving type) as REMeasurementUnit,
      ismanuallyset                                as REMeasurementIsManuallySet,
      ishierarchical                               as REMsmtHasSubordinateObject,
 
      _REKeyAssgmt,
      _REMeasurementType,
      _UnitOfMeasure  
}

Learn More