I_CommissionObjectRelationship

DDL: I_COMMISSIONOBJECTRELATIONSHIP Type: view_entity BASIC Package: CACSVDM_COMMON
22 Fields 1 Data Sources

Object Relationship

I_CommissionObjectRelationship is a Basic CDS View that provides data about "Object Relationship" in SAP S/4HANA. It reads from 1 data source (hrp1001) and exposes 22 fields with key fields HCMObjectType, HCMObjectID, HCMPlanVersion, HCMObjectRelshpSpecification, HCMObjectRelationship. Part of development package CACSVDM_COMMON.

Data Sources (1)

SourceAliasJoin Type
hrp1001 hrp1001 from

Annotations (7)

NameValueLevelField
EndUserText.label Object Relationship view
AccessControl.authorizationCheck #NOT_REQUIRED view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.serviceQuality #A view
VDM.viewType #BASIC view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY HCMObjectType otype Type of Val.
KEY HCMObjectID objid Work Center
KEY HCMPlanVersion plvar Plan version
KEY HCMObjectRelshpSpecification rsign Relationship
KEY HCMObjectRelationship relat Relnship
KEY HCMPlanningStatus istat System status
KEY HCMObjectRelationshipPriority priox Priority
KEY StartDate begda Valid From
KEY EndDate endda Valid To
KEY HCMVariationField varyf Variation field
KEY HCMSequentialNumber seqnr Tank ID
HCMInfoType infty Infotype
HCMSubtype subty Subtype
LastChangedDate aedtm Changed On
LastChangedByUser uname User Name
HCMInfoTypeRecordReason reasn Reason for inclusion
HCMInfoTypeRecordIsHistorical histo Historical rec.
HCMInfoTypeTextModule itxnr Text Module
HCMRelatedObjectType sclas Rel.obj.type
HCMRelatedObjectID sobid ID rel.object
HCMObjRelshpWgtngPct prozt Share
HCMAdditionalDataNumber adatanr ADATA number

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_CommissionObjectRelationship.
-- 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 I_CommissionObjectRelationship AS
SELECT
  otype AS HCMObjectType,
  objid AS HCMObjectID,
  plvar AS HCMPlanVersion,
  rsign AS HCMObjectRelshpSpecification,
  relat AS HCMObjectRelationship,
  istat AS HCMPlanningStatus,
  priox AS HCMObjectRelationshipPriority,
  begda AS StartDate,
  endda AS EndDate,
  varyf AS HCMVariationField,
  seqnr AS HCMSequentialNumber,
  infty AS HCMInfoType,
  subty AS HCMSubtype,
  aedtm AS LastChangedDate,
  uname AS LastChangedByUser,
  reasn AS HCMInfoTypeRecordReason,
  histo AS HCMInfoTypeRecordIsHistorical,
  itxnr AS HCMInfoTypeTextModule,
  sclas AS HCMRelatedObjectType,
  sobid AS HCMRelatedObjectID,
  prozt AS HCMObjRelshpWgtngPct,
  adatanr AS HCMAdditionalDataNumber
FROM hrp1001
;

Learn More