C_DFS_PosToPersonExerRelshp

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_PosToPersonExerRelshp.
-- 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: CDFSPOSEXPERS

CREATE VIEW C_DFS_PosToPersonExerRelshp AS
SELECT
  PosToPersonExerRelshp.PersonnelNumber AS PersonnelNumber,
  PosToPersonExerRelshp.DfsObjectSubType AS DfsObjectSubType,
  PosToPersonExerRelshp.DfsObjectValdtyStartDate AS DfsPositionValdtyStartDate,
  PosToPersonExerRelshp.DfsObjectValdtyEndDate AS DfsPositionValdtyEndDate,
  PosToPersonExerRelshp.DfsPositionSequenceNumber AS DfsPositionSequenceNumber,
  PosToPersonExerRelshp.DfsPositionRelatedObjectID AS DfsPositionRelatedObjectID,
  PosToPersonExerRelshp.DfsPositionRelatedObjectType AS DfsPositionRelatedObjectType,
  PosToPersonExerRelshp.DfsPositionOpExerciseID AS DfsPositionOpExerciseID,
  PosToPersonExerRelshp.DfsPositionRotationKey AS DfsPositionRotationKey,
  PosToPersonExerRelshp.EmployeeName AS EmployeeName,
  PosToPersonExerRelshp.DfsObjectShortName AS DfsObjectShortName,
  PosToPersonExerRelshp.PersonnelNumberFoEd AS PersonnelNumberFoEd,
  _PosExerToPersTypeVH.FrcElmntOrgRelshpDesc AS DfsPositionRelshpDesc,
  _FrcElmntOrgOpExerRotationVH.FrcElmntOrgRotationName AS FrcElmntOrgRotationName,
  _PositionToExerciseVH.FrcElmntOrgName AS FrcElmntOrgName,
  _PositionToExerciseVH.ForceElementOrgID AS ForceElementOrgID
LEFT OUTER JOIN C_DFS_PositionHeaderTP AS _PositionHeaderTP ON DfsPositionRelatedObjectID = _PositionHeaderTP.DfsPositionID  -- association [1..1]
LEFT OUTER JOIN C_DFS_PositionToExerciseVH AS _PositionToExerciseVH ON DfsPositionOpExerciseID = _PositionToExerciseVH.ForceElementOrgID  -- association [1..1]
LEFT OUTER JOIN C_FrcElmntOrgOpExerRotationVH AS _FrcElmntOrgOpExerRotationVH ON DfsPositionOpExerciseID = _FrcElmntOrgOpExerRotationVH.ForceElementOrgID AND DfsPositionRotationKey = _FrcElmntOrgOpExerRotationVH.FrcElmntOrgRotationKey  -- association [1..*]
LEFT OUTER JOIN C_FrcElmntOrgExerToPersTypeVH AS _PosExerToPersTypeVH ON _PosExerToPersTypeVH.FrcElmntOrgType = DfsPositionRelatedObjectType  -- association [1..*]
;