C_DFS_PositionEmployeeGroupTP

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_PositionEmployeeGroupTP.
-- 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: CDFSEMPLGRPTP

CREATE VIEW C_DFS_PositionEmployeeGroupTP AS
SELECT
  PositionEmployeeGroupTP.DfsPositionPlanVersion AS DfsPositionPlanVersion,
  PositionEmployeeGroupTP.DfsPositionObjectType AS DfsPositionObjectType,
  PositionEmployeeGroupTP.DfsPositionID AS DfsPositionID,
  PositionEmployeeGroupTP.DfsPositionPlngStatus AS DfsPositionPlngStatus,
  PositionEmployeeGroupTP.DfsPositionValdtyStartDate AS DfsPositionValdtyStartDate,
  PositionEmployeeGroupTP.DfsPositionValdtyEndDate AS DfsPositionValdtyEndDate,
  _PositionPlngStatusVH.DfsObjectPlngStatusName AS DfsObjectPlngStatusName,
  PositionEmployeeGroupTP.DfsPositionInfoType AS DfsPositionInfoType,
  PositionEmployeeGroupTP.DfsPositionEmployeeGroup AS DfsPositionEmployeeGroup,
  PositionEmployeeGroupTP.DfsPositionPlngStsCritlty AS DfsPositionPlngStsCritlty,
  _PositionEmployeeGroupVH.DfsPositionEmployeeGroupDesc AS DfsPositionEmployeeGroupDesc,
  PositionEmployeeGroupTP.DfsPositionEmployeeSubGroup AS DfsPositionEmployeeSubGroup,
  _PositionEmployeeSubGrpVH.DfsPositionEmployeeSubGrpDesc AS DfsPositionEmployeeSubGrpDesc,
  PositionEmployeeGroupTP.DfsPositionValdtyStartDateFoEd AS DfsPositionValdtyStartDateFoEd,
  PositionEmployeeGroupTP.DfsPositionValdtyEndDateFoEd AS DfsPositionValdtyEndDateFoEd
FROM I_DFS_PositionEmployeeGroupTP AS PositionEmployeeGroupTP
LEFT OUTER JOIN C_DFS_PositionHeaderTP AS _PositionHeaderTP ON DfsPositionID = _PositionHeaderTP.DfsPositionID  -- association [1..1]
LEFT OUTER JOIN C_DFS_PositionEmployeeGroupVH AS _PositionEmployeeGroupVH ON DfsPositionEmployeeGroup = _PositionEmployeeGroupVH.DfsPositionEmployeeGroup  -- association [1..1]
LEFT OUTER JOIN C_DFS_PositionEmployeeSubGrpVH AS _PositionEmployeeSubGrpVH ON DfsPositionEmployeeGroup = _PositionEmployeeSubGrpVH.DfsPositionEmployeeGroup AND DfsPositionEmployeeSubGroup = _PositionEmployeeSubGrpVH.DfsPositionEmployeeSubGroup  -- association [1..1]
LEFT OUTER JOIN C_DFS_PositionPlngStatusVH AS _PositionPlngStatusVH ON _PositionPlngStatusVH.DfsObjectPlngStatus = DfsPositionPlngStatus  -- association [1..1]
;