I_REIntegObjectRelationAddl

DDL: I_REINTEGOBJECTRELATIONADDL SQL: IREINTOBJRELADD Type: view COMPOSITE
7 Fields 1 Data Sources 1 Associations

Integration Object Relation Additional

I_REIntegObjectRelationAddl is a Composite CDS View that provides data about "Integration Object Relation Additional" in SAP S/4HANA. It reads from 1 data source (I_REIntegrationObjectRelation) and exposes 7 fields with key field REIntegObjectRelationUUID. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_REIntegrationObjectRelation I_REIntegrationObjectRelation from

Associations (1)

CardinalityTargetAliasCondition
[1..1] I_REEntryValidity _REEntryValidity $projection.REEntryValidity = _REEntryValidity.REEntryValidity

Annotations (13)

NameValueLevelField
AbapCatalog.sqlViewName IREINTOBJRELADD view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
Metadata.ignorePropagatedAnnotations true view
AccessControl.personalData.blocking #NOT_REQUIRED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.dataClass #MIXED view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
EndUserText.label Integration Object Relation Additional view

Fields (7)

KeyFieldSource TableSource FieldDescription
KEY REIntegObjectRelationUUID REIntegObjectRelationUUID Object Relation GUID
InternalRealEstateNumber InternalRealEstateNumber RE Key
InternalRealEstateNumberRltn InternalRealEstateNumberRltn Int. Num Relation
ValidityEndDate ValidityEndDate ValidTo
REMeasurementType REMeasurementType MeasType
ValidityStartDate ValidityStartDate Validity Start Date
_REEntryValidity _REEntryValidity

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 I_REIntegObjectRelationAddl.
-- 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.
-- SQL view name: IREINTOBJRELADD

CREATE VIEW I_REIntegObjectRelationAddl AS
SELECT
  REIntegObjectRelationUUID,
  InternalRealEstateNumber,
  InternalRealEstateNumberRltn,
  ValidityEndDate,
  REMeasurementType,
  ValidityStartDate
FROM I_REIntegrationObjectRelation
LEFT OUTER JOIN I_REEntryValidity AS _REEntryValidity ON REEntryValidity = _REEntryValidity.REEntryValidity  -- association [1..1]
;

Learn More