C_RERntblObjToContrAssgmtDEX

DDL: C_RERNTBLOBJTOCONTRASSGMTDEX Type: view_entity CONSUMPTION
17 Fields 1 Data Sources 1 Associations

Extractor for RE Rntbl Obj Contr Assgmt

C_RERntblObjToContrAssgmtDEX (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_RERntblObjToContrAssgmtDEX is a Consumption CDS View that provides data about "Extractor for RE Rntbl Obj Contr Assgmt" in SAP S/4HANA. It reads from 1 data source (I_RERntblObjToContractAssgmt) and exposes 17 fields with key fields RealEstateRentableObjectUUID, REObjectAssignmentType, CompanyCode, RealEstateContract, ValidityStartEndDateValue. 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_RERntblObjToContractAssgmt _REContractAssgmt from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_REContract _REContract $projection.CompanyCode = _REContract.CompanyCode and $projection.RealEstateContract = _REContract.RealEstateContract

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Extractor for RE Rntbl Obj Contr Assgmt view
VDM.viewType #CONSUMPTION view
Analytics.dataExtraction.enabled true view
Analytics.internalName #LOCAL view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #L view

Fields (17)

KeyFieldSource TableSource FieldDescription
KEY RealEstateRentableObjectUUID RealEstateRentableObjectUUID UUID for Generic Rental Object
KEY REObjectAssignmentType REObjectAssignmentType Type of Object Assignment
KEY CompanyCode CompanyCode Receiver Company Code
KEY RealEstateContract RealEstateContract Real Estate Contract
KEY ValidityStartEndDateValue ValidityStartEndDateValue Date from to (RAP Key)
REStatusObjectSource REStatusObjectSource Object Number
REStatusObjectTarget REStatusObjectTarget Object Number
ValidityStartDate Validity Start Date
ValidityEndDate Validity End Date
REOnlyInfoAssgmt REOnlyInfoAssgmt Informational Assignment
REStatusObjectSourceIsArchived REStatusObjectSourceIsArchived Source Object Was Archived
REObjectPossessionStartDate REObjectPossessionStartDate Date From Which the Object Is Made Available for Use
REObjectPossessionEndDate REObjectPossessionEndDate Date Up to Which the Object Is Used
_REObjectAssignmentType _REObjectAssignmentType
_RERentableObject _RERentableObject
_REContract _REContract
_CompanyCode _CompanyCode

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_RERntblObjToContrAssgmtDEX.
-- 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_RERntblObjToContrAssgmtDEX AS
SELECT
  RealEstateRentableObjectUUID,
  REObjectAssignmentType,
  CompanyCode,
  RealEstateContract,
  ValidityStartEndDateValue,
  REStatusObjectSource,
  REStatusObjectTarget,
  cast( coalesce(ValidityStartDate, '00000000') as rebdvdmvalidfrom ) AS ValidityStartDate,
  cast( coalesce(ValidityEndDate, '99991231') as rebdvdmvalidto ) AS ValidityEndDate,
  REOnlyInfoAssgmt,
  REStatusObjectSourceIsArchived,
  REObjectPossessionStartDate,
  REObjectPossessionEndDate
FROM I_RERntblObjToContractAssgmt AS _REContractAssgmt
LEFT OUTER JOIN I_REContract AS _REContract ON CompanyCode = _REContract.CompanyCode AND RealEstateContract = _REContract.RealEstateContract  -- association [1..1]
;

Learn More