I_HCMEvalPathObjRelationship

DDL: I_HCMEVALPATHOBJRELATIONSHIP Type: view COMPOSITE
23 Fields 2 Data Sources 1 Associations

Object Relationships in Evaluation Path

I_HCMEvalPathObjRelationship is a Composite CDS View that provides data about "Object Relationships in Evaluation Path" in SAP S/4HANA. It reads from 2 data sources (I_HCMEvaluationPathDefinition, I_HCMObjectRelationship) and exposes 23 fields with key fields HCMObjectType, HCMObjectID, HCMPlanVersion, HCMObjectRelshpSpecification, HCMObjectRelationship. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_HCMEvaluationPathDefinition EvalPathDef inner
I_HCMObjectRelationship ObjectRelationship from

Parameters (3)

NameTypeDefault
P_StartDate begdatum
P_EndDate enddatum
P_HCMEvalPath wegid

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_HCMEvalPathObjRelationship _ObjectRelationship $projection.HCMObjectType = _ObjectRelationship.HCMRelatedObjectType and $projection.HCMObjectID = _ObjectRelationship.HCMRelatedObjectID

Annotations (11)

NameValueLevelField
EndUserText.label Object Relationships in Evaluation Path view
AbapCatalog.sqlViewName IEVALPATHOBJREL view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #C view
VDM.viewType #COMPOSITE view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY HCMObjectType I_HCMObjectRelationship HCMObjectType Type of Val.
KEY HCMObjectID I_HCMObjectRelationship HCMObjectID Work Center
KEY HCMPlanVersion I_HCMObjectRelationship HCMPlanVersion Plan version
KEY HCMObjectRelshpSpecification I_HCMObjectRelationship HCMObjectRelshpSpecification Relationship
KEY HCMObjectRelationship I_HCMObjectRelationship HCMObjectRelationship Relnship
KEY HCMPlanningStatus I_HCMObjectRelationship HCMPlanningStatus System status
KEY HCMObjectRelationshipPriority I_HCMObjectRelationship HCMObjectRelationshipPriority Priority
KEY StartDate I_HCMObjectRelationship StartDate Valid From
KEY EndDate I_HCMObjectRelationship EndDate Term to
KEY HCMVariationField I_HCMObjectRelationship HCMVariationField Variation field
KEY HCMSequentialNumber I_HCMObjectRelationship HCMSequentialNumber IT record no.
HCMInfoType I_HCMObjectRelationship HCMInfoType Prefix
HCMSubtype I_HCMObjectRelationship HCMSubtype Subtype
LastChangedDate I_HCMObjectRelationship LastChangedDate Created On
LastChangedByUser I_HCMObjectRelationship LastChangedByUser User Name
HCMInfoTypeRecordReason I_HCMObjectRelationship HCMInfoTypeRecordReason Reason for inclusion
HCMInfoTypeRecordIsHistorical I_HCMObjectRelationship HCMInfoTypeRecordIsHistorical Historical rec.
HCMInfoTypeTextModule I_HCMObjectRelationship HCMInfoTypeTextModule Text Module
HCMRelatedObjectType I_HCMObjectRelationship HCMRelatedObjectType Rel.obj.type
HCMRelatedObjectID I_HCMObjectRelationship HCMRelatedObjectID ID rel.object
HCMObjRelshpWgtngPct I_HCMObjectRelationship HCMObjRelshpWgtngPct Share
HCMAdditionalDataNumber I_HCMObjectRelationship HCMAdditionalDataNumber ADATA number
_ObjectRelationship _ObjectRelationship

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_HCMEvalPathObjRelationship.
-- 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.
-- Parameters: P_StartDate : begdatum, P_EndDate : enddatum, P_HCMEvalPath : wegid

CREATE VIEW I_HCMEvalPathObjRelationship AS
SELECT
  ObjectRelationship.HCMObjectType AS HCMObjectType,
  ObjectRelationship.HCMObjectID AS HCMObjectID,
  ObjectRelationship.HCMPlanVersion AS HCMPlanVersion,
  ObjectRelationship.HCMObjectRelshpSpecification AS HCMObjectRelshpSpecification,
  ObjectRelationship.HCMObjectRelationship AS HCMObjectRelationship,
  ObjectRelationship.HCMPlanningStatus AS HCMPlanningStatus,
  ObjectRelationship.HCMObjectRelationshipPriority AS HCMObjectRelationshipPriority,
  ObjectRelationship.StartDate AS StartDate,
  ObjectRelationship.EndDate AS EndDate,
  ObjectRelationship.HCMVariationField AS HCMVariationField,
  ObjectRelationship.HCMSequentialNumber AS HCMSequentialNumber,
  ObjectRelationship.HCMInfoType AS HCMInfoType,
  ObjectRelationship.HCMSubtype AS HCMSubtype,
  ObjectRelationship.LastChangedDate AS LastChangedDate,
  ObjectRelationship.LastChangedByUser AS LastChangedByUser,
  ObjectRelationship.HCMInfoTypeRecordReason AS HCMInfoTypeRecordReason,
  ObjectRelationship.HCMInfoTypeRecordIsHistorical AS HCMInfoTypeRecordIsHistorical,
  ObjectRelationship.HCMInfoTypeTextModule AS HCMInfoTypeTextModule,
  ObjectRelationship.HCMRelatedObjectType AS HCMRelatedObjectType,
  ObjectRelationship.HCMRelatedObjectID AS HCMRelatedObjectID,
  ObjectRelationship.HCMObjRelshpWgtngPct AS HCMObjRelshpWgtngPct,
  ObjectRelationship.HCMAdditionalDataNumber AS HCMAdditionalDataNumber
FROM I_HCMObjectRelationship AS ObjectRelationship
INNER JOIN I_HCMEvaluationPathDefinition AS EvalPathDef ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_HCMEvalPathObjRelationship AS _ObjectRelationship ON HCMObjectType = _ObjectRelationship.HCMRelatedObjectType AND HCMObjectID = _ObjectRelationship.HCMRelatedObjectID  -- association [0..*]
;

Learn More