C_REUsblObjToRntblObjAssgmtTP

DDL: C_REUSBLOBJTORNTBLOBJASSGMTTP Type: view_entity CONSUMPTION Package: ODATA_RE_GO_USABLE_OBJ_APP
17 Fields 1 Data Sources 2 OData Services

Real Estate Usable to Rentable Object

C_REUsblObjToRntblObjAssgmtTP is a Consumption CDS View that provides data about "Real Estate Usable to Rentable Object" in SAP S/4HANA. It reads from 1 data source (R_REUsblObjToRntblObjAssgmtTP) and exposes 17 fields with key field REUsblObjToRntblAssgmtUUID. It is exposed through 2 OData services (ASQL_F7693, UI_REUSABLEOBJECT). Part of development package ODATA_RE_GO_USABLE_OBJ_APP.

Data Sources (1)

SourceAliasJoin Type
R_REUsblObjToRntblObjAssgmtTP R_REUsblObjToRntblObjAssgmtTP projection

Annotations (7)

NameValueLevelField
EndUserText.label Real Estate Usable to Rentable Object view
AccessControl.authorizationCheck #MANDATORY view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view

OData Services (2)

ServiceBindingVersionContractRelease
ASQL_F7693 ASQL_F7693 C2 NOT_RELEASED
UI_REUSABLEOBJECT UI_REUSABLEOBJECT V4 C1 NOT_RELEASED

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY REUsblObjToRntblAssgmtUUID REUsblObjToRntblAssgmtUUID
RealEstateRentableObjectUUID RealEstateRentableObjectUUID UUID GO
RealEstateUsableObjectUUID RealEstateUsableObjectUUID
RealEstateRentableObjectNumber RealEstateRentableObjectNumber Rentable Object
RealEstateRentableObjectOID _RERentableObject RealEstateRentableObjectOID Generic Rental Object OID
ValidityEndDate ValidityEndDate ValidTo
ValidityStartDate ValidityStartDate Validity Start Date
RERentableObjectName _RERentableObject RERentableObjectName Rentable Object Name
CompanyCode _REUsableObject CompanyCode Receiver Company Code
RERentableObjectCompanyCode _RERentableObject CompanyCode Receiver Company Code
REArchitectureObjectNumber
REGenericRentalObjectUsageType _RERentableObject REGenericRentalObjectUsageType RO Usage Type
REGnrcRntlObjUsgeCatHasPrtflo
RealEstateUsableObjectNumber
REEntryValidity REEntryValidity Entry Validity
REEntryValidityCriticality REEntryValidityCriticality
REGnrcRentalObjUsageTypeTextlocalized

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_REUsblObjToRntblObjAssgmtTP.
-- 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_REUsblObjToRntblObjAssgmtTP AS
SELECT
  REUsblObjToRntblAssgmtUUID,
  RealEstateRentableObjectUUID,
  RealEstateUsableObjectUUID,
  RealEstateRentableObjectNumber,
  _RERentableObject.RealEstateRentableObjectOID AS RealEstateRentableObjectOID,
  ValidityEndDate,
  ValidityStartDate,
  _RERentableObject.RERentableObjectName AS RERentableObjectName,
  _REUsableObject.CompanyCode AS CompanyCode,
  _RERentableObject.CompanyCode AS RERentableObjectCompanyCode,
  _REUsableObject._REArchitectureObject.REArchitectureObjectNumber AS REArchitectureObjectNumber,
  _RERentableObject.REGenericRentalObjectUsageType AS REGenericRentalObjectUsageType,
  _REUsableObject._REGnrcRentalObjUsageCategory.REGnrcRntlObjUsgeCatHasPrtflo AS REGnrcRntlObjUsgeCatHasPrtflo,
  _RERentableObject._RERntblObjToUsblObjAssgmt[1:ValidityStartDate <= $session.system_date and ValidityEndDate >= $session.system_date ]._REUsableObject.RealEstateUsableObjectNumber AS RealEstateUsableObjectNumber,
  REEntryValidity,
  REEntryValidityCriticality,
  _RERentableObject._REGnrcRentalObjUsageType._Text.REGnrcRentalObjUsageTypeText : localized AS REGnrcRentalObjUsageTypeTextlocalized
FROM R_REUsblObjToRntblObjAssgmtTP
;

Learn More