C_REUsblObjLdngAcctAssgmtDEX

DDL: C_REUSBLOBJLDNGACCTASSGMTDEX Type: view_entity CONSUMPTION
25 Fields 2 Data Sources 1 Associations

Extractor RE Usbl Obj Ldng Acct Assign

C_REUsblObjLdngAcctAssgmtDEX (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_REUsblObjLdngAcctAssgmtDEX is a Consumption CDS View that provides data about "Extractor RE Usbl Obj Ldng Acct Assign" in SAP S/4HANA. It reads from 2 data sources (I_REObjectAssgmt, I_REUsableObject) and exposes 25 fields with key fields RealEstateUsableObjectUUID, REStatusObjectSource, REObjectAssignmentType, REStatusObjectTarget, ValidityStartDate. 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 (2)

SourceAliasJoin Type
I_REObjectAssgmt _REObjectAssgmt from
I_REUsableObject _REUsableObjectData inner

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_REObjectType _REObjectTypeTarget $projection.REStatusObjectTarget = _REObjectTypeTarget.RealEstateObjectType

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Extractor RE Usbl Obj Ldng Acct Assign 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 (25)

KeyFieldSource TableSource FieldDescription
KEY RealEstateUsableObjectUUID I_REUsableObject RealEstateUsableObjectUUID UUID for Generic Rental Object
KEY REStatusObjectSource I_REObjectAssgmt REStatusObjectSource Object Number
KEY REObjectAssignmentType I_REObjectAssgmt REObjectAssignmentType Type of Object Assignment
KEY REStatusObjectTarget I_REObjectAssgmt REStatusObjectTarget Object Number
KEY ValidityStartDate I_REObjectAssgmt ValidityStartDate Validity Start Date
ValidityEndDate I_REObjectAssgmt ValidityEndDate Validity End Date
REOnlyInfoAssgmt I_REObjectAssgmt REOnlyInfoAssgmt Informational Assignment
REStatusObjectSourceIsArchived I_REObjectAssgmt REStatusObjectSourceIsArchived Source Object Was Archived
REGenerationType I_REObjectAssgmt REGenerationType Generation Type Functional Location
REIsMainAsset I_REObjectAssgmt REIsMainAsset Asset Is Leading Asset
REAssignmentHasMultiple I_REObjectAssgmt REAssignmentHasMultiple Generated Entry for Multiple Assignment
REObjectPossessionStartDate I_REObjectAssgmt REObjectPossessionStartDate Date From Which the Object Is Made Available for Use
REObjectPossessionEndDate I_REObjectAssgmt REObjectPossessionEndDate Date Up to Which the Object Is Used
REIsLeadingObject I_REObjectAssgmt REIsLeadingObject Leading object Indicator
_CostCenter I_REObjectAssgmt _CostCenter
_FixedAsset I_REObjectAssgmt _FixedAsset
_InternalOrder I_REObjectAssgmt _InternalOrder
_REContractSubject I_REObjectAssgmt _REContractSubject
_REGenerationType I_REObjectAssgmt _REGenerationType
_REObjectGroup I_REObjectAssgmt _REObjectGroup
_REObjectTypeDetails I_REObjectAssgmt _REObjectTypeDetails
_TechnicalObject I_REObjectAssgmt _TechnicalObject
_WBSElement I_REObjectAssgmt _WBSElement
_REUsableObject _REUsableObject
_REObjectTypeTarget _REObjectTypeTarget

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_REUsblObjLdngAcctAssgmtDEX.
-- 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_REUsblObjLdngAcctAssgmtDEX AS
SELECT
  _REUsableObjectData.RealEstateUsableObjectUUID AS RealEstateUsableObjectUUID,
  _REObjectAssgmt.REStatusObjectSource AS REStatusObjectSource,
  _REObjectAssgmt.REObjectAssignmentType AS REObjectAssignmentType,
  _REObjectAssgmt.REStatusObjectTarget AS REStatusObjectTarget,
  _REObjectAssgmt.ValidityStartDate AS ValidityStartDate,
  _REObjectAssgmt.ValidityEndDate AS ValidityEndDate,
  _REObjectAssgmt.REOnlyInfoAssgmt AS REOnlyInfoAssgmt,
  _REObjectAssgmt.REStatusObjectSourceIsArchived AS REStatusObjectSourceIsArchived,
  _REObjectAssgmt.REGenerationType AS REGenerationType,
  _REObjectAssgmt.REIsMainAsset AS REIsMainAsset,
  _REObjectAssgmt.REAssignmentHasMultiple AS REAssignmentHasMultiple,
  _REObjectAssgmt.REObjectPossessionStartDate AS REObjectPossessionStartDate,
  _REObjectAssgmt.REObjectPossessionEndDate AS REObjectPossessionEndDate,
  _REObjectAssgmt.REIsLeadingObject AS REIsLeadingObject,
  _REObjectAssgmt._CostCenter AS _CostCenter,
  _REObjectAssgmt._FixedAsset AS _FixedAsset,
  _REObjectAssgmt._InternalOrder AS _InternalOrder,
  _REObjectAssgmt._REContractSubject AS _REContractSubject,
  _REObjectAssgmt._REGenerationType AS _REGenerationType,
  _REObjectAssgmt._REObjectGroup AS _REObjectGroup,
  _REObjectAssgmt._REObjectTypeDetails AS _REObjectTypeDetails,
  _REObjectAssgmt._TechnicalObject AS _TechnicalObject,
  _REObjectAssgmt._WBSElement AS _WBSElement
FROM I_REObjectAssgmt AS _REObjectAssgmt
INNER JOIN I_REUsableObject AS _REUsableObjectData ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_REObjectType AS _REObjectTypeTarget ON REStatusObjectTarget = _REObjectTypeTarget.RealEstateObjectType  -- association [1..1]
;

Learn More