C_REUsableObjectTP

DDL: C_REUSABLEOBJECTTP Type: view_entity CONSUMPTION
35 Fields 1 Data Sources 1 Associations

Real Estate Usable Object

C_REUsableObjectTP is a Consumption CDS View that provides data about "Real Estate Usable Object" in SAP S/4HANA. It reads from 1 data source (R_REUsableObjectTP) and exposes 35 fields with key field RealEstateUsableObjectUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
R_REUsableObjectTP R_REUsableObjectTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..*] C_REGnrcRntlObjMeasurement _REUsableObjectTotalMsmt $projection.InternalRealEstateNumber = _REUsableObjectTotalMsmt.InternalRealEstateNumber and $projection.ValidityStartDate = _REUsableObjectTotalMsmt.ValidityEndDate and $projection.ValidityEndDate = _REUsableObjectTotalMsmt.ValidityStartDate

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Real Estate Usable Object view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey RealEstateUsableObjectUUID view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.modelingPattern #TRANSACTIONAL_QUERY view
Metadata.allowExtensions true view
Search.searchable true view

Fields (35)

KeyFieldSource TableSource FieldDescription
KEY RealEstateUsableObjectUUID RealEstateUsableObjectUUID
REGenericRentalObjectType REGenericRentalObjectType RO Obj Type
InternalRealEstateNumber InternalRealEstateNumber RE Key
REStatusObject REStatusObject Val. Obj. No.
RealEstateUsableObjectOID RealEstateUsableObjectOID
REGnrcRntlObjectAlternativeID REGnrcRntlObjectAlternativeID Alternative ID
RealEstateUsableObjectNumber RealEstateUsableObjectNumber
REUsableObjectNumberForEdit REUsableObjectNumberForEdit
REUsableObjectName REUsableObjectName
CompanyCode CompanyCode Receiver Company Code
ValidityStartDate ValidityStartDate Validity Start Date
ValidityEndDate ValidityEndDate ValidTo
REAuthorizationGroup REAuthorizationGroup Authoriz. Group
REGnrcRentalObjUsageCategory REGnrcRentalObjUsageCategory Usage Category
REGenericRentalObjectUsageType REGenericRentalObjectUsageType RO Usage Type
REGnrcRentalObjPortfolioID REGnrcRentalObjPortfolioID Portfolio ID
REGnrcRentalObjOwnershipID REGnrcRentalObjOwnershipID
REArchtrObjectNumberBldngLand REArchtrObjectNumberBldngLand Building/Land Object Number
REArchitectureObjectNumberSite
REArchitectureObjectOID _REArchitectureObject REArchitectureObjectOID Architecture Object OID
StatusProfile StatusProfile Status Profile
CreationDateTime CreationDateTime Timestamp
LastChangeDateTime LastChangeDateTime Timestamp
LocalLastChangeDateTime LocalLastChangeDateTime Time Stamp
CompanyCodeName _CompanyCode CompanyCodeName Company Name
REArchtrObjectBldngLandName _REArchitectureObject REArchitectureObjectName Architecture Object Name
SemanticObject
REArchtrObjectSiteName
virtualREOwnershipIDIsHiddenrecabool
virtualSystemStatusTextregovdmgostatus
virtualIsDraftEntityrecabool
virtualRECreateContractIsHiddenrecabool
virtualREValidityIsHiddenrecabool
ChangeDocObject ChangeDocObject Object Value
_REUsableObjectTotalMsmt _REUsableObjectTotalMsmt

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_REUsableObjectTP.
-- 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_REUsableObjectTP AS
SELECT
  RealEstateUsableObjectUUID,
  REGenericRentalObjectType,
  InternalRealEstateNumber,
  REStatusObject,
  RealEstateUsableObjectOID,
  REGnrcRntlObjectAlternativeID,
  RealEstateUsableObjectNumber,
  REUsableObjectNumberForEdit,
  REUsableObjectName,
  CompanyCode,
  ValidityStartDate,
  ValidityEndDate,
  REAuthorizationGroup,
  REGnrcRentalObjUsageCategory,
  REGenericRentalObjectUsageType,
  REGnrcRentalObjPortfolioID,
  REGnrcRentalObjOwnershipID,
  REArchtrObjectNumberBldngLand,
  cast (_REArchitectureObject._REArchitectureObjSite.REArchitectureObjectNumber as reobvdmobnrsite preserving type ) AS REArchitectureObjectNumberSite,
  _REArchitectureObject.REArchitectureObjectOID AS REArchitectureObjectOID,
  StatusProfile,
  CreationDateTime,
  LastChangeDateTime,
  LocalLastChangeDateTime,
  _CompanyCode.CompanyCodeName AS CompanyCodeName,
  _REArchitectureObject.REArchitectureObjectName AS REArchtrObjectBldngLandName,
  _REArchitectureObject._REArchitectureObjectType.SemanticObject AS SemanticObject,
  _REArchitectureObject._REArchitectureObjSite.REArchitectureObjectName AS REArchtrObjectSiteName,
  virtual REOwnershipIDIsHidden : recabool AS virtualREOwnershipIDIsHiddenrecabool,
  virtual SystemStatusText : regovdmgostatus AS virtualSystemStatusTextregovdmgostatus,
  virtual IsDraftEntity : recabool AS virtualIsDraftEntityrecabool,
  virtual RECreateContractIsHidden : recabool AS virtualRECreateContractIsHiddenrecabool,
  virtual REValidityIsHidden : recabool AS virtualREValidityIsHiddenrecabool,
  ChangeDocObject
FROM R_REUsableObjectTP
LEFT OUTER JOIN C_REGnrcRntlObjMeasurement AS _REUsableObjectTotalMsmt ON InternalRealEstateNumber = _REUsableObjectTotalMsmt.InternalRealEstateNumber AND ValidityStartDate = _REUsableObjectTotalMsmt.ValidityEndDate AND ValidityEndDate = _REUsableObjectTotalMsmt.ValidityStartDate  -- association [0..*]
;

Learn More