C_RERentableObjectDEX

DDL: C_RERENTABLEOBJECTDEX Type: view_entity CONSUMPTION
21 Fields 1 Data Sources 1 Associations

Extraction RE Rentable Object

C_RERentableObjectDEX (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Cross Applications

C_RERentableObjectDEX is a Consumption CDS View that provides data about "Extraction RE Rentable Object" in SAP S/4HANA. It reads from 1 data source (I_RERentableObject) and exposes 21 fields with key field RealEstateRentableObjectUUID. It has 1 association to related views.

SAP API Hub

StateC1
Line of BusinessCross Applications
Application ComponentRE-FX-BD
CapabilitiesData Source for Data Extraction, Association Target for Defining CDS Entities
PackageCross Applications for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_RERentableObject I_RERentableObject from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_RERentableObject _Extension $projection.RealEstateRentableObjectUUID = _Extension.RealEstateRentableObjectUUID

Annotations (12)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Extraction RE Rentable Object view
VDM.viewType #CONSUMPTION view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
Analytics.dataExtraction.delta.byElement.name LastChangeDateTime view
Analytics.dataExtraction.delta.byElement.maxDelayInSeconds 1800 view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.representativeKey RealEstateRentableObjectUUID view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (21)

KeyFieldSource TableSource FieldDescription
KEY RealEstateRentableObjectUUID RealEstateRentableObjectUUID UUID for Generic Rental Object
REGenericRentalObjectType REGenericRentalObjectType Generic Rental Object Type
InternalRealEstateNumber InternalRealEstateNumber Internal Key of Real Estate Object
REStatusObject REStatusObject Val. Obj. No.
RealEstateRentableObjectOID RealEstateRentableObjectOID One Domain Model ID for Real Estate Generic Object
REGnrcRntlObjectAlternativeID REGnrcRntlObjectAlternativeID Generic Rental Object Alternative ID
REGnrcRentalObjPortfolioID REGnrcRentalObjPortfolioID Generic Rental Object Portfolio ID
RealEstateRentableObjectNumber RealEstateRentableObjectNumber Real Estate Generic Rental Object Number
RERentableObjectName RERentableObjectName Rentable Object Name
REIdentificationKey REIdentificationKey ID Part Key, for example "1000/123"
CompanyCode CompanyCode Receiver Company Code
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate Validity End Date
REAuthorizationGroup REAuthorizationGroup Authorization Group
REGnrcRentalObjUsageCategory REGnrcRentalObjUsageCategory Generic Rental Object Usage Category
REGenericRentalObjectUsageType REGenericRentalObjectUsageType Rentable Object Usage Type
REGenericRentalObjParentUUID REGenericRentalObjParentUUID UUID for Parent Generic Rental Object
RERentableObjectCategory RERentableObjectCategory RE Rentable Object Category
CreationDateTime CreationDateTime Creation Date Time
LastChangeDateTime LastChangeDateTime Last Change Date Time
LocalLastChangeDateTime LocalLastChangeDateTime Local Instance Last Change Date Time

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 C_RERentableObjectDEX.
-- 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 C_RERentableObjectDEX AS
SELECT
  RealEstateRentableObjectUUID,
  REGenericRentalObjectType,
  InternalRealEstateNumber,
  REStatusObject,
  RealEstateRentableObjectOID,
  REGnrcRntlObjectAlternativeID,
  REGnrcRentalObjPortfolioID,
  RealEstateRentableObjectNumber,
  RERentableObjectName,
  REIdentificationKey,
  CompanyCode,
  ValidityStartDate,
  ValidityEndDate,
  REAuthorizationGroup,
  REGnrcRentalObjUsageCategory,
  REGenericRentalObjectUsageType,
  REGenericRentalObjParentUUID,
  RERentableObjectCategory,
  CreationDateTime,
  LastChangeDateTime,
  LocalLastChangeDateTime
FROM I_RERentableObject
LEFT OUTER JOIN E_RERentableObject AS _Extension ON RealEstateRentableObjectUUID = _Extension.RealEstateRentableObjectUUID  -- association [1..1]
;

Learn More