R_REUsableObjectMeasurementTP

DDL: R_REUSABLEOBJECTMEASUREMENTTP Type: view_entity TRANSACTIONAL Package: RAP_RE_GO

RE Usable Object Measurement TP

R_REUsableObjectMeasurementTP is a Transactional CDS View that provides data about "RE Usable Object Measurement TP" in SAP S/4HANA. It reads from 2 data sources (I_REMeasurement, I_REUsableObject) and exposes 15 fields with key fields RealEstateUsableObjectUUID, InternalRealEstateNumber, REMeasurementType, ValidityEndDate. It has 1 association to related views. Part of development package RAP_RE_GO.

2 data source(s) 15 fields

Data Sources (2)

SourceAliasJoin Type
I_REMeasurement _REMeasurement from
I_REUsableObject _REUsableObjectData inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_REEntryValidity _REEntryValidity $projection.REEntryValidity = _REEntryValidity.REEntryValidity

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label RE Usable Object Measurement TP view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view

Fields (15)

KeyFieldSource TableSource FieldDescription
KEY RealEstateUsableObjectUUID I_REUsableObject RealEstateUsableObjectUUID
KEY InternalRealEstateNumber I_REMeasurement InternalRealEstateNumber
KEY REMeasurementType I_REMeasurement REMeasurementType
KEY ValidityEndDate
ValidityEndDateForEdit I_REMeasurement ValidityEndDate
ValidityStartDate I_REMeasurement ValidityStartDate
REMeasurementTypeForEdit I_REMeasurement REMeasurementType
REMeasurementIsTotal
REMeasurementUnit I_REMeasurement REMeasurementUnit
REMeasurementQuantity I_REMeasurement REMeasurementQuantity
REMaximumMeasurementQuantity I_REMeasurement REMaximumMeasurementQuantity
_REUsableObject _REUsableObject
_REMeasurementType I_REMeasurement _REMeasurementType
_UnitOfMeasure I_REMeasurement _UnitOfMeasure
_REEntryValidity _REEntryValidity 
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'RE Usable Object Measurement TP'
@ObjectModel.usageType: {
        serviceQuality: #C,
        dataClass: #TRANSACTIONAL,
        sizeCategory: #L
    }

@VDM: {
    viewType: #TRANSACTIONAL,
    lifecycle.contract.type: #SAP_INTERNAL_API,
    usage.type: [ #TRANSACTIONAL_PROCESSING_SERVICE ]
    }
define view entity R_REUsableObjectMeasurementTP
  as select from I_REMeasurement  as _REMeasurement
    inner join   I_REUsableObject as _REUsableObjectData on _REUsableObjectData.InternalRealEstateNumber = _REMeasurement.InternalRealEstateNumber
  association        to parent R_REUsableObjectTP as _REUsableObject  on $projection.RealEstateUsableObjectUUID = _REUsableObject.RealEstateUsableObjectUUID
  association [1..1] to I_REEntryValidity         as _REEntryValidity on $projection.REEntryValidity = _REEntryValidity.REEntryValidity
{
  key _REUsableObjectData.RealEstateUsableObjectUUID,
  key _REMeasurement.InternalRealEstateNumber,
  key _REMeasurement.REMeasurementType,
  key cast( _REMeasurement.ValidityEndDate as abap.char(8) ) as ValidityEndDate,
      @ObjectModel.editableFieldFor: 'ValidityEndDate'
      _REMeasurement.ValidityEndDate                         as ValidityEndDateForEdit,
      _REMeasurement.ValidityStartDate,

      @ObjectModel.editableFieldFor: 'REMeasurementType'
      _REMeasurement.REMeasurementType                       as REMeasurementTypeForEdit,
      _REMeasurement._REMeasurementType.REMeasurementIsTotal,
      _REMeasurement.REMeasurementUnit,
      _REMeasurement.REMeasurementQuantity,
      _REMeasurement.REMaximumMeasurementQuantity,

      @ObjectModel.foreignKey.association: '_REEntryValidity'
      case
          when _REMeasurement.ValidityStartDate is initial and _REMeasurement.ValidityEndDate is initial then cast (left('3',1) as recavdmentryvalidity preserving type )
          when _REMeasurement.ValidityStartDate > $session.system_date then cast (left('2',1) as recavdmentryvalidity preserving type )
          when _REMeasurement.ValidityStartDate <= $session.system_date and _REMeasurement.ValidityEndDate >= $session.system_date then cast(left('3',1) as recavdmentryvalidity preserving type )
          else cast (left('1',1) as recavdmentryvalidity preserving type )
      end                                                    as REEntryValidity,

      case
          when _REMeasurement.ValidityStartDate is initial and _REMeasurement.ValidityEndDate is initial then 3
          when _REMeasurement.ValidityStartDate > $session.system_date then 2
          when _REMeasurement.ValidityStartDate <= $session.system_date and _REMeasurement.ValidityEndDate >= $session.system_date then 3
      else 1
      end                                                    as REEntryValidityCriticality,

      /* Associations */
      _REUsableObject,
      _REMeasurement._REMeasurementType                      as _REMeasurementType,
      _REMeasurement._UnitOfMeasure                          as _UnitOfMeasure,
      _REEntryValidity
}

Learn More