C_REUsableObjectMeasurementDEX

DDL: C_REUSABLEOBJECTMEASUREMENTDEX Type: view_entity CONSUMPTION Package: ODATA_RE_GO

Extractor for RE Usable Obj Measurement

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

Data Sources (2)

SourceAliasJoin Type
I_REMeasurement _REMeasurement from
I_REUsableObject _REUsableObjectData inner

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Extractor for RE Usable Obj Measurement view
VDM.viewType #CONSUMPTION view
Analytics.dataExtraction.enabled true view
Analytics.technicalName CREUSABLEOBJMEASUREMENTDEX 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 RealEstateUsableObjectUUID I_REUsableObject RealEstateUsableObjectUUID
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
_REUsableObject _REUsableObject
_REMeasurementType I_REMeasurement _REMeasurementType
_UnitOfMeasure I_REMeasurement _UnitOfMeasure
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Extractor for RE Usable Obj Measurement'

@VDM.viewType: #CONSUMPTION
@Analytics:{ 
  dataExtraction:{enabled: true},
  technicalName: 'CREUSABLEOBJMEASUREMENTDEX',
//     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_REUsableObjectMeasurementDEX 
  as select from I_REMeasurement  as _REMeasurement
    inner join   I_REUsableObject as _REUsableObjectData on _REUsableObjectData.InternalRealEstateNumber = _REMeasurement.InternalRealEstateNumber
  association        to I_REUsableObject as _REUsableObject  on $projection.RealEstateUsableObjectUUID = _REUsableObject.RealEstateUsableObjectUUID
{
  key _REUsableObjectData.RealEstateUsableObjectUUID,
  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,

      _REUsableObject,
      _REMeasurement._REMeasurementType                      as _REMeasurementType,
      _REMeasurement._UnitOfMeasure                          as _UnitOfMeasure

    
}