C_RERntblObjectStatusObjectTP

DDL: C_RERNTBLOBJECTSTATUSOBJECTTP Type: view_entity CONSUMPTION Package: ODATA_RE_GO_RENTABLE_OBJ_APP

Real Estate Usable Object Status Object

C_RERntblObjectStatusObjectTP is a Consumption CDS View that provides data about "Real Estate Usable Object Status Object" in SAP S/4HANA. It reads from 1 data source (R_RERntblObjectStatusObjectTP) and exposes 10 fields with key fields RealEstateRentableObjectUUID, StatusProfile, StatusCode. It is exposed through 2 OData services (ASQL_F7694, UI_RERENTABLEOBJECT). Part of development package ODATA_RE_GO_RENTABLE_OBJ_APP.

Data Sources (1)

SourceAliasJoin Type
R_RERntblObjectStatusObjectTP R_RERntblObjectStatusObjectTP projection

Annotations (7)

NameValueLevelField
EndUserText.label Real Estate Usable Object Status 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_F7694 ASQL_F7694 C2 NOT_RELEASED
UI_RERENTABLEOBJECT UI_RERENTABLEOBJECT V4 C1 NOT_RELEASED

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY RealEstateRentableObjectUUID RealEstateRentableObjectUUID UUID GO
KEY StatusProfile StatusProfile Status Profile
KEY StatusCode StatusCode Statuscode
StatusCodeForEdit StatusCodeForEdit Statuscode
REStatusObject REStatusObject Val. Obj. No.
IsUserStatus IsUserStatus
StatusIsInactive StatusIsInactive
StatusNameasStatusNamelocalized
_StatusCode _StatusCode
_StatusProfile _StatusProfile

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_RERntblObjectStatusObjectTP.
-- 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_RERntblObjectStatusObjectTP AS
SELECT
  RealEstateRentableObjectUUID,
  StatusProfile,
  StatusCode,
  StatusCodeForEdit,
  REStatusObject,
  IsUserStatus,
  StatusIsInactive,
  _StatusCode._StatusCodeText.StatusName as StatusName : localized AS StatusNameasStatusNamelocalized
FROM R_RERntblObjectStatusObjectTP
;