C_REUsblObjToContractAssgmtDEX

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

Extractor for RE Usbl Obj Contr Assgmt

C_REUsblObjToContractAssgmtDEX (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_REUsblObjToContractAssgmtDEX is a Consumption CDS View that provides data about "Extractor for RE Usbl Obj Contr Assgmt" in SAP S/4HANA. It reads from 1 data source (I_REUsblObjectToContractAssgmt) and exposes 17 fields with key fields RealEstateUsableObjectUUID, REObjectAssignmentType, CompanyCode, RealEstateContract, ValidityStartEndDateValue. It has 1 association to related views.

SAP API Hub

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

Documentation

Data Sources (1)

SourceAliasJoin Type
I_REUsblObjectToContractAssgmt _REContractAssgmt from

Associations (1)

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

Annotations (10)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Extractor for RE Usbl Obj Contr Assgmt view
VDM.viewType #CONSUMPTION view
Analytics.dataExtraction.enabled true view
Analytics.technicalName CREUSBLOBJTOCONTRASSGMTDEX 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 RealEstateUsableObjectUUID RealEstateUsableObjectUUID 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
_REUsableObject _REUsableObject
_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_REUsblObjToContractAssgmtDEX.
-- 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_REUsblObjToContractAssgmtDEX AS
SELECT
  RealEstateUsableObjectUUID,
  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_REUsblObjectToContractAssgmt AS _REContractAssgmt
LEFT OUTER JOIN I_REContract AS _REContract ON CompanyCode = _REContract.CompanyCode AND RealEstateContract = _REContract.RealEstateContract  -- association [1..1]
;

Learn More