I_REIntegObjectMsmtSubObj

DDL: I_REINTEGOBJECTMSMTSUBOBJ SQL: IREINTOBMSSUBOBJ Type: view COMPOSITE

Real Estate Integ Measurement Subobject

I_REIntegObjectMsmtSubObj is a Composite CDS View that provides data about "Real Estate Integ Measurement Subobject" in SAP S/4HANA. It reads from 2 data sources (I_REIntegObjectSubObjValidity, I_REMeasurement) and exposes 22 fields with key fields InternalRealEstateNumberLvl3, REMeasurementType, ValidityEndDateendasValidityEndDate.

2 data source(s) 22 fields

Data Sources (2)

SourceAliasJoin Type
I_REIntegObjectSubObjValidity _REIntegObjectSubObjValidity from
I_REMeasurement _REMeasurement inner

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IREINTOBMSSUBOBJ view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Real Estate Integ Measurement Subobject view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
VDM.viewType #COMPOSITE view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.preserveKey true view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY InternalRealEstateNumberLvl3 I_REIntegObjectSubObjValidity InternalRealEstateNumberLvl3
KEY REMeasurementType I_REMeasurement REMeasurementType
KEY ValidityEndDateendasValidityEndDate
ValidityStartDateendasValidityStartDate
InternalRealEstateNumberLvl2 I_REIntegObjectSubObjValidity InternalRealEstateNumberLvl2
InternalRealEstateNumberLvl1 I_REIntegObjectSubObjValidity InternalRealEstateNumberLvl1
InternalRealEstateNumberLvl0 I_REIntegObjectSubObjValidity InternalRealEstateNumberLvl0
ValidityStartDateLvl0 I_REIntegObjectSubObjValidity ValidityStartDateLvl0
ValidityEndDateLvl0 I_REIntegObjectSubObjValidity ValidityEndDateLvl0
ValidityStartDateLvl1 I_REIntegObjectSubObjValidity ValidityStartDateLvl1
ValidityEndDateLvl1 I_REIntegObjectSubObjValidity ValidityEndDateLvl1
ValidityStartDateLvl2 I_REIntegObjectSubObjValidity ValidityStartDateLvl2
ValidityEndDateLvl2 I_REIntegObjectSubObjValidity ValidityEndDateLvl2
ValidityStartDateLvl3 I_REIntegObjectSubObjValidity ValidityStartDateLvl3
ValidityEndDateLvl3 I_REIntegObjectSubObjValidity ValidityEndDateLvl3
REMeasurementQuantity I_REMeasurement REMeasurementQuantity
REMaximumMeasurementQuantity REMaximumMeasurementQuantity
REMeasurementUnit REMeasurementUnit
REMeasurementIsManuallySet REMeasurementIsManuallySet
REMsmtHasSubordinateObject REMsmtHasSubordinateObject
_REMeasurementType _REMeasurementType
_UnitOfMeasure _UnitOfMeasure 
@AbapCatalog.sqlViewName: 'IREINTOBMSSUBOBJ'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Real Estate Integ Measurement Subobject'
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ObjectModel.usageType.serviceQuality: #D
@ObjectModel.usageType.sizeCategory: #L
//@ObjectModel.dataCategory: #VALUE_HELP


@VDM.viewType: #COMPOSITE
//@Search.searchable: true

@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true

define view I_REIntegObjectMsmtSubObj
  as select from I_REIntegObjectSubObjValidity as _REIntegObjectSubObjValidity
    inner join   I_REMeasurement             as _REMeasurement on _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl3 = _REMeasurement.InternalRealEstateNumber
                                                                 and (
                                                                 _REMeasurement.ValidityStartDate                           <= _REIntegObjectSubObjValidity.ValidityEndDateLvl3
                                                                 and _REMeasurement.ValidityEndDate                         >= _REIntegObjectSubObjValidity.ValidityStartDateLvl3
                                                                and 
                                                                 _REMeasurement.ValidityStartDate                           <= _REIntegObjectSubObjValidity.ValidityEndDateLvl2
                                                                 and _REMeasurement.ValidityEndDate                         >= _REIntegObjectSubObjValidity.ValidityStartDateLvl2                                                                 
                                                                and 
                                                                 _REMeasurement.ValidityStartDate                           <= _REIntegObjectSubObjValidity.ValidityEndDateLvl1
                                                                 and _REMeasurement.ValidityEndDate                         >= _REIntegObjectSubObjValidity.ValidityStartDateLvl1 
                                                                and 
                                                                 _REMeasurement.ValidityStartDate                           <= _REIntegObjectSubObjValidity.ValidityEndDateLvl0
                                                                 and _REMeasurement.ValidityEndDate                         >= _REIntegObjectSubObjValidity.ValidityStartDateLvl0
                                                                 )
{
  key    _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl3,
  key    _REMeasurement.REMeasurementType,
         @Semantics.businessDate.to: true
  key    case
           when _REMeasurement.ValidityEndDate > _REIntegObjectSubObjValidity.ValidityEndDateLvl3  then _REIntegObjectSubObjValidity.ValidityEndDateLvl3 
           when _REMeasurement.ValidityEndDate > _REIntegObjectSubObjValidity.ValidityEndDateLvl2  then _REIntegObjectSubObjValidity.ValidityEndDateLvl2
           when _REMeasurement.ValidityEndDate > _REIntegObjectSubObjValidity.ValidityEndDateLvl1  then _REIntegObjectSubObjValidity.ValidityEndDateLvl1
           when _REMeasurement.ValidityEndDate > _REIntegObjectSubObjValidity.ValidityEndDateLvl0  then _REIntegObjectSubObjValidity.ValidityEndDateLvl0
           else _REMeasurement.ValidityEndDate
         end                                            as ValidityEndDate,
         @Semantics.businessDate.from: true
         case
           when _REMeasurement.ValidityStartDate < _REIntegObjectSubObjValidity.ValidityStartDateLvl3 then _REIntegObjectSubObjValidity.ValidityStartDateLvl3
           when _REMeasurement.ValidityStartDate < _REIntegObjectSubObjValidity.ValidityStartDateLvl2 then _REIntegObjectSubObjValidity.ValidityStartDateLvl2
           when _REMeasurement.ValidityStartDate < _REIntegObjectSubObjValidity.ValidityStartDateLvl1 then _REIntegObjectSubObjValidity.ValidityStartDateLvl1
           when _REMeasurement.ValidityStartDate < _REIntegObjectSubObjValidity.ValidityStartDateLvl0 then _REIntegObjectSubObjValidity.ValidityStartDateLvl0
          else _REMeasurement.ValidityStartDate
         end                                            as ValidityStartDate,         
         _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl2,
         _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl1,
         _REIntegObjectSubObjValidity.InternalRealEstateNumberLvl0,
         _REIntegObjectSubObjValidity.ValidityStartDateLvl0,
         _REIntegObjectSubObjValidity.ValidityEndDateLvl0,
         _REIntegObjectSubObjValidity.ValidityStartDateLvl1,
         _REIntegObjectSubObjValidity.ValidityEndDateLvl1,
         _REIntegObjectSubObjValidity.ValidityStartDateLvl2,
         _REIntegObjectSubObjValidity.ValidityEndDateLvl2,
         _REIntegObjectSubObjValidity.ValidityStartDateLvl3,
         _REIntegObjectSubObjValidity.ValidityEndDateLvl3,


         @Semantics.quantity.unitOfMeasure: 'REMeasurementUnit'
         _REMeasurement.REMeasurementQuantity,
         @Semantics.quantity.unitOfMeasure: 'REMeasurementUnit'
         REMaximumMeasurementQuantity,
         @ObjectModel.foreignKey.association: '_UnitOfMeasure'
         @Semantics.unitOfMeasure
         REMeasurementUnit,
         REMeasurementIsManuallySet,
         REMsmtHasSubordinateObject,

         _REMeasurementType,
         _UnitOfMeasure
}

Learn More