I_RERentableObjectForContrVH

DDL: I_RERENTABLEOBJECTFORCONTRVH Type: view_entity COMPOSITE Package: VDM_RE_GO
27 Fields 1 Data Sources 1 Associations

Real Estate Rentable Object

I_RERentableObjectForContrVH 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_RERentableObject) and exposes 27 fields with key field RealEstateRentableObjectNumber. It has 1 association to related views. Part of development package VDM_RE_GO.

Data Sources (1)

SourceAliasJoin Type
I_RERentableObject I_RERentableObject from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_REObjectTypeDetails _REObjectTypeDetails $projection.InternalRealEstateNumber = _REObjectTypeDetails.InternalRealEstateNumber

Annotations (15)

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

Fields (27)

KeyFieldSource TableSource FieldDescription
KEY RealEstateRentableObjectNumber RealEstateRentableObjectNumber Rentable Object
InternalRealEstateNumber InternalRealEstateNumber RE Key
REIdentification _REObjectTypeDetails REIdentification Object
REGenericRentalObjectType REGenericRentalObjectType RO Obj Type
REGnrcRntlObjectAlternativeID REGnrcRntlObjectAlternativeID Alternative ID
RERentableObjectName RERentableObjectName Rentable Object Name
CompanyCode CompanyCode Receiver Company Code
REGnrcRentalObjUsageCategory REGnrcRentalObjUsageCategory Usage Category
REGenericRentalObjectUsageType REGenericRentalObjectUsageType RO Usage Type
RERentableObjectCategory RERentableObjectCategory Rentable Object Category
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
REAuthorizationGroup REAuthorizationGroup Authoriz. Group
REStatusObject REStatusObject Val. Obj. No.
REArchtrObjectNumberBldngLand
REGnrcRntlObjUsgeCatHasPrtflo _REGnrcRentalObjUsageCategory REGnrcRntlObjUsgeCatHasPrtflo
CompanyCodeName _CompanyCode CompanyCodeName Company Name
REGnrcRentalObjUsageCatText
REGnrcRentalObjUsageTypeText
RERentableObjectCategoryName
REAuthorizationGroupName
_CompanyCode _CompanyCode
_REGnrcRentalObjUsageCategory _REGnrcRentalObjUsageCategory
_REGnrcRentalObjUsageType _REGnrcRentalObjUsageType
_RERentableObjectCategory _RERentableObjectCategory
_REAuthorizationGroup _REAuthorizationGroup
_StatusObject _StatusObject

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view I_RERentableObjectForContrVH.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW I_RERentableObjectForContrVH AS
SELECT
  RealEstateRentableObjectNumber,
  InternalRealEstateNumber,
  _REObjectTypeDetails.REIdentification AS REIdentification,
  REGenericRentalObjectType,
  REGnrcRntlObjectAlternativeID,
  RERentableObjectName,
  CompanyCode,
  REGnrcRentalObjUsageCategory,
  REGenericRentalObjectUsageType,
  RERentableObjectCategory,
  ValidityStartDate,
  ValidityEndDate,
  REAuthorizationGroup,
  REStatusObject,
  cast (_REArchitectureObject.REArchitectureObjectNumber as reobvdmobnrbuildingland preserving type ) AS REArchtrObjectNumberBldngLand,
  _REGnrcRentalObjUsageCategory.REGnrcRntlObjUsgeCatHasPrtflo AS REGnrcRntlObjUsgeCatHasPrtflo,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _REGnrcRentalObjUsageCategory._Text[1: Language = $session.system_language ].REGnrcRentalObjUsageCatText AS REGnrcRentalObjUsageCatText,
  _REGnrcRentalObjUsageType._Text[1: Language = $session.system_language ].REGnrcRentalObjUsageTypeText AS REGnrcRentalObjUsageTypeText,
  _RERentableObjectCategory._Text[1: Language = $session.system_language ].RERentableObjectCategoryName AS RERentableObjectCategoryName,
  _REAuthorizationGroup._Text[1: Language = $session.system_language ].REAuthorizationGroupName AS REAuthorizationGroupName
FROM I_RERentableObject
LEFT OUTER JOIN I_REObjectTypeDetails AS _REObjectTypeDetails ON InternalRealEstateNumber = _REObjectTypeDetails.InternalRealEstateNumber  -- association [1..1]
;

Learn More