C_DFS_PosToPersonOpRelshp

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_DFS_PosToPersonOpRelshp.
-- 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: CDFSPOSOPPERS

CREATE VIEW C_DFS_PosToPersonOpRelshp AS
SELECT
  PosToPersonOpRelshp.PersonnelNumber AS PersonnelNumber,
  PosToPersonOpRelshp.DfsObjectSubType AS DfsObjectSubType,
  PosToPersonOpRelshp.DfsObjectValdtyStartDate AS DfsPositionValdtyStartDate,
  PosToPersonOpRelshp.DfsObjectValdtyEndDate AS DfsPositionValdtyEndDate,
  PosToPersonOpRelshp.DfsPositionSequenceNumber AS DfsPositionSequenceNumber,
  PosToPersonOpRelshp.DfsPositionRelatedObjectID AS DfsPositionRelatedObjectID,
  PosToPersonOpRelshp.DfsPositionRelatedObjectType AS DfsPositionRelatedObjectType,
  PosToPersonOpRelshp.DfsPositionOpExerciseID AS DfsPositionOpExerciseID,
  PosToPersonOpRelshp.DfsPositionRotationKey AS DfsPositionRotationKey,
  PosToPersonOpRelshp.EmployeeName AS EmployeeName,
  PosToPersonOpRelshp.DfsObjectShortName AS DfsObjectShortName,
  PosToPersonOpRelshp.PersonnelNumberFoEd AS PersonnelNumberFoEd,
  _PositionToOperationVH.FrcElmntOrgName AS FrcElmntOrgName,
  _FrcElmntOrgOpExerRotationVH.FrcElmntOrgRotationName AS FrcElmntOrgRotationName,
  _PosOpToPersTypeVH.FrcElmntOrgRelshpDesc AS DfsPositionRelshpDesc
LEFT OUTER JOIN C_DFS_PositionHeaderTP AS _PositionHeaderTP ON DfsPositionRelatedObjectID = _PositionHeaderTP.DfsPositionID  -- association [1..1]
LEFT OUTER JOIN C_DFS_PositionToOperationVH AS _PositionToOperationVH ON _PositionToOperationVH.ForceElementOrgID = DfsPositionOpExerciseID  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgOpExerRotationVH AS _FrcElmntOrgOpExerRotationVH ON DfsPositionOpExerciseID = _FrcElmntOrgOpExerRotationVH.ForceElementOrgID AND DfsPositionRotationKey = _FrcElmntOrgOpExerRotationVH.FrcElmntOrgRotationKey  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgOpToPersTypeVH AS _PosOpToPersTypeVH ON _PosOpToPersTypeVH.FrcElmntOrgType = DfsPositionRelatedObjectType  -- association [1..*]
;