I_CommsnEvalPathObjRelshp

DDL: I_COMMSNEVALPATHOBJRELSHP Type: view_entity COMPOSITE Package: CACSVDM_COMMON
23 Fields 2 Data Sources 1 Associations

Object Relationships in Evaluation Path

I_CommsnEvalPathObjRelshp 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_CommsnEvalPathDefinition, I_CommissionObjectRelationship) and exposes 23 fields with key fields HCMObjectType, HCMObjectID, HCMPlanVersion, HCMObjectRelshpSpecification, HCMObjectRelationship. It has 1 association to related views. Part of development package CACSVDM_COMMON.

Data Sources (2)

SourceAliasJoin Type
I_CommsnEvalPathDefinition EvalPathDef inner
I_CommissionObjectRelationship ObjectRelationship from

Parameters (3)

NameTypeDefault
P_StartDate begdatum
P_EndDate enddatum
P_HCMEvalPath wegid

Associations (1)

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

Annotations (7)

NameValueLevelField
EndUserText.label Object Relationships in Evaluation Path view
AccessControl.authorizationCheck #NOT_REQUIRED 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_CommissionObjectRelationship HCMObjectType Type of Val.
KEY HCMObjectID I_CommissionObjectRelationship HCMObjectID Work Center
KEY HCMPlanVersion I_CommissionObjectRelationship HCMPlanVersion Plan version
KEY HCMObjectRelshpSpecification I_CommissionObjectRelationship HCMObjectRelshpSpecification Relationship
KEY HCMObjectRelationship I_CommissionObjectRelationship HCMObjectRelationship Relnship
KEY HCMPlanningStatus I_CommissionObjectRelationship HCMPlanningStatus System status
KEY HCMObjectRelationshipPriority I_CommissionObjectRelationship HCMObjectRelationshipPriority Priority
KEY StartDate I_CommissionObjectRelationship StartDate Valid From
KEY EndDate I_CommissionObjectRelationship EndDate Term to
KEY HCMVariationField I_CommissionObjectRelationship HCMVariationField Variation field
KEY HCMSequentialNumber I_CommissionObjectRelationship HCMSequentialNumber IT record no.
HCMInfoType I_CommissionObjectRelationship HCMInfoType Prefix
HCMSubtype I_CommissionObjectRelationship HCMSubtype Subtype
LastChangedDate I_CommissionObjectRelationship LastChangedDate Created On
LastChangedByUser I_CommissionObjectRelationship LastChangedByUser User Name
HCMInfoTypeRecordReason I_CommissionObjectRelationship HCMInfoTypeRecordReason Reason for inclusion
HCMInfoTypeRecordIsHistorical I_CommissionObjectRelationship HCMInfoTypeRecordIsHistorical Historical rec.
HCMInfoTypeTextModule I_CommissionObjectRelationship HCMInfoTypeTextModule Text Module
HCMRelatedObjectType I_CommissionObjectRelationship HCMRelatedObjectType Rel.obj.type
HCMRelatedObjectID I_CommissionObjectRelationship HCMRelatedObjectID ID rel.object
HCMObjRelshpWgtngPct I_CommissionObjectRelationship HCMObjRelshpWgtngPct Share
HCMAdditionalDataNumber I_CommissionObjectRelationship 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_CommsnEvalPathObjRelshp.
-- 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_CommsnEvalPathObjRelshp 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_CommissionObjectRelationship AS ObjectRelationship
INNER JOIN I_CommsnEvalPathDefinition AS EvalPathDef ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_CommsnEvalPathObjRelshp AS _ObjectRelationship ON HCMObjectType = _ObjectRelationship.HCMRelatedObjectType AND HCMObjectID = _ObjectRelationship.HCMRelatedObjectID  -- association [0..*]
;

Learn More