I_RERentableObject

DDL: I_RERENTABLEOBJECT Type: view_entity COMPOSITE

Real Estate Rentable Object

I_RERentableObject is a Composite CDS View (Dimension) that provides data about "Real Estate Rentable Object" in SAP S/4HANA. It reads from 1 data source (I_REGenericRentalObject) and exposes 32 fields with key field RealEstateRentableObjectUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_REGenericRentalObject I_REGenericRentalObject from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_RERntblObjToUsblObjAssgmt _RERntblObjToUsblObjAssgmt $projection.RealEstateRentableObjectUUID = _RERntblObjToUsblObjAssgmt.RealEstateRentableObjectUUID

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Real Estate Rentable Object view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view
Metadata.allowExtensions true view
VDM.viewType #COMPOSITE view
Analytics.internalName #LOCAL view
Analytics.dataCategory #DIMENSION view
Analytics.dataExtraction.enabled true view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY RealEstateRentableObjectUUID REGenericRentalObjectUUID
REGenericRentalObjectType REGenericRentalObjectType
InternalRealEstateNumber InternalRealEstateNumber
REStatusObject REStatusObject
RealEstateRentableObjectOID REGenericRentalObjectOID
REGnrcRntlObjectAlternativeID REGnrcRntlObjectAlternativeID
REGnrcRentalObjPortfolioID
RealEstateRentableObjectNumber
RERentableObjectName
REIdentificationKey REIdentificationKey
CompanyCode CompanyCode
ValidityStartDate ValidityStartDate
ValidityEndDate ValidityEndDate
REAuthorizationGroup REAuthorizationGroup
REGnrcRentalObjUsageCategory REGnrcRentalObjUsageCategory
REGenericRentalObjectUsageType
REGenericRentalObjParentUUID REGenericRentalObjParentUUID
RERentableObjectCategory RERentableObjectCategory
CreationDateTime CreationDateTime
LastChangeDateTime LastChangeDateTime
LocalLastChangeDateTime LocalLastChangeDateTime
_REKeyAssgmt _REKeyAssgmt
_CompanyCode _CompanyCode
_REAuthorizationGroup _REAuthorizationGroup
_REGnrcRentalObjUsageCategory _REGnrcRentalObjUsageCategory
_REGnrcRentalObjUsageType _REGnrcRentalObjUsageType
_REParentGenericRentalObject _REParentGenericRentalObject
_RERentableObjectCategory _RERentableObjectCategory
_REArchitectureObject _REArchitectureObject
_StatusObject _StatusObject
_StatusObjectStatus _StatusObjectStatus
_RERntblObjToUsblObjAssgmt _RERntblObjToUsblObjAssgmt
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'Real Estate Rentable Object'

//@ObjectModel.representativeKey: 'RealEstateRentableObjectNumber'

@ObjectModel.semanticKey: ['RealEstateRentableObjectNumber']
@ObjectModel.usageType.dataClass: #MASTER
@ObjectModel.usageType.serviceQuality: #C
@ObjectModel.usageType.sizeCategory: #L

@Metadata.allowExtensions: true
@VDM.viewType: #COMPOSITE

@Analytics.internalName:#LOCAL
@Analytics:{
    dataCategory: #DIMENSION,
    dataExtraction: {
        enabled: true
//        delta.changeDataCapture: {

//        automatic: true

//        }

    }
}

define view entity I_RERentableObject
  as select from I_REGenericRentalObject

  association [1..*] to I_RERntblObjToUsblObjAssgmt as _RERntblObjToUsblObjAssgmt on $projection.RealEstateRentableObjectUUID = _RERntblObjToUsblObjAssgmt.RealEstateRentableObjectUUID
{
  key REGenericRentalObjectUUID                                                             as RealEstateRentableObjectUUID,
      REGenericRentalObjectType,
      InternalRealEstateNumber,
      REStatusObject,
      REGenericRentalObjectOID                                                              as RealEstateRentableObjectOID,
      REGnrcRntlObjectAlternativeID,
      //REGnrcRentalObjPortfolioID,

      _RERntblObjToUsblObjAssgmt._REUsableObject.REGnrcRentalObjPortfolioID,
      cast( REGenericRentalObjectNumber as regogonrrentable preserving type )               as RealEstateRentableObjectNumber,
      cast( REGenericRentalObjectName   as regovdmxrentableobject preserving type )         as RERentableObjectName,
      REIdentificationKey,
      CompanyCode,
      ValidityStartDate,
      ValidityEndDate,
      REAuthorizationGroup,
      REGnrcRentalObjUsageCategory,
      cast( REGenericRentalObjectUsageType as regovdmrentableobjusagetype preserving type ) as REGenericRentalObjectUsageType,
      REGenericRentalObjParentUUID,
      RERentableObjectCategory,

      @Semantics.systemDateTime.createdAt: true
      CreationDateTime,
      @Semantics.systemDateTime.lastChangedAt: true
      LastChangeDateTime,
      @Semantics.systemDateTime.localInstanceLastChangedAt: true
      LocalLastChangeDateTime,

      /* Associations */
      _REKeyAssgmt,
      _CompanyCode,
      _REAuthorizationGroup,
      //_REGnrcRentalObjPortfolio,

      _REGnrcRentalObjUsageCategory,
      _REGnrcRentalObjUsageType,
      _REParentGenericRentalObject,
      _RERentableObjectCategory,
      _REArchitectureObject,
      _StatusObject,
      _StatusObjectStatus,
      _RERntblObjToUsblObjAssgmt
}
where
     REGenericRentalObjectType = 'R' //Rentable Object