C_RERntblObjectMeasurementDEX

DDL: C_RERNTBLOBJECTMEASUREMENTDEX Type: view_entity CONSUMPTION Package: ODATA_RE_GO

Extractor for RE Rntbl Obj Measurement

C_RERntblObjectMeasurementDEX is a Consumption CDS View that provides data about "Extractor for RE Rntbl Obj Measurement" in SAP S/4HANA. It reads from 2 data sources (I_REMeasurement, I_RERentableObject) and exposes 12 fields with key fields RealEstateRentableObjectUUID, InternalRealEstateNumber, REMeasurementType, ValidityEndDate. Part of development package ODATA_RE_GO.

Data Sources (2)

SourceAliasJoin Type
I_REMeasurement _REMeasurement from
I_RERentableObject _RERentableObject inner

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Extractor for RE Rntbl Obj Measurement view
VDM.viewType #CONSUMPTION view
Analytics.dataExtraction.enabled true view
Analytics.technicalName CRERNTBLOBJECTMEASUREMENTDEX view
Analytics.internalName #LOCAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY RealEstateRentableObjectUUID I_RERentableObject RealEstateRentableObjectUUID
KEY InternalRealEstateNumber I_REMeasurement InternalRealEstateNumber
KEY REMeasurementType I_REMeasurement REMeasurementType
KEY ValidityEndDate I_REMeasurement ValidityEndDate
ValidityStartDate I_REMeasurement ValidityStartDate
REMeasurementIsTotal
REMeasurementUnit I_REMeasurement REMeasurementUnit
REMeasurementQuantity I_REMeasurement REMeasurementQuantity
REMaximumMeasurementQuantity I_REMeasurement REMaximumMeasurementQuantity
_REGenericRentalObject _REGenericRentalObject
_REMeasurementType I_REMeasurement _REMeasurementType
_UnitOfMeasure I_REMeasurement _UnitOfMeasure
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Extractor for RE Rntbl Obj Measurement'

@VDM.viewType: #CONSUMPTION
@Analytics:{ 
  dataExtraction:{enabled: true},
  technicalName: 'CRERNTBLOBJECTMEASUREMENTDEX',
//     delta.changeDataCapture.automatic: true},

  internalName:#LOCAL 
}

@Metadata.ignorePropagatedAnnotations:true 
@ObjectModel.supportedCapabilities: [ #EXTRACTION_DATA_SOURCE,
                                      #CDS_MODELING_ASSOCIATION_TARGET]   
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L


define view entity C_RERntblObjectMeasurementDEX 
  as select from I_REMeasurement as _REMeasurement
    inner join   I_RERentableObject as _RERentableObject on _RERentableObject.InternalRealEstateNumber = _REMeasurement.InternalRealEstateNumber
  association    to I_REGenericRentalObject as _REGenericRentalObject on $projection.RealEstateRentableObjectUUID = _REGenericRentalObject.REGenericRentalObjectUUID

{
  key _RERentableObject.RealEstateRentableObjectUUID,
  key _REMeasurement.InternalRealEstateNumber,
  key _REMeasurement.REMeasurementType,
  key _REMeasurement.ValidityEndDate                        as ValidityEndDate,
      _REMeasurement.ValidityStartDate,
      _REMeasurement._REMeasurementType.REMeasurementIsTotal,
      _REMeasurement.REMeasurementUnit,
      @Semantics.quantity.unitOfMeasure: 'REMeasurementUnit'
      _REMeasurement.REMeasurementQuantity,
      @Semantics.quantity.unitOfMeasure: 'REMeasurementUnit'
      _REMeasurement.REMaximumMeasurementQuantity,

      _REGenericRentalObject,
      _REMeasurement._REMeasurementType                      as _REMeasurementType,
      _REMeasurement._UnitOfMeasure                          as _UnitOfMeasure

    
}