C_DFS_PositionToTaskTP

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_PositionToTaskTP.
-- 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: CDFSPOSTOTASKTP

CREATE VIEW C_DFS_PositionToTaskTP AS
SELECT
  PositionToTaskTP.DfsPositionID AS DfsPositionID,
  PositionToTaskTP.DfsPositionRelatedObjectID AS DfsPositionRelatedObjectID,
  PositionToTaskTP.DfsPositionPlngStatus AS DfsPositionPlngStatus,
  PositionToTaskTP.DfsPositionValdtyStartDate AS DfsPositionValdtyStartDate,
  PositionToTaskTP.DfsPositionValdtyEndDate AS DfsPositionValdtyEndDate,
  PositionToTaskTP.DfsPositionObjectType AS DfsPositionObjectType,
  PositionToTaskTP.DfsPositionPlanVersion AS DfsPositionPlanVersion,
  PositionToTaskTP.DfsPositionRelshpSpec AS DfsPositionRelshpSpec,
  PositionToTaskTP.DfsPositionRelshpBtwnObj AS DfsPositionRelshpBtwnObj,
  PositionToTaskTP.DfsPositionRelshpPriority AS DfsPositionRelshpPriority,
  PositionToTaskTP.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  PositionToTaskTP.DfsPositionInfoType AS DfsPositionInfoType,
  PositionToTaskTP.DfsPositionSubType AS DfsPositionSubType,
  PositionToTaskTP.DfsPositionRelatedObjectType AS DfsPositionRelatedObjectType,
  PositionToTaskTP.DfsPositionIDFoEd AS DfsPositionIDFoEd,
  PositionToTaskTP.DfsPositionRelatedObjectIDFoEd AS DfsPositionRelatedObjectIDFoEd,
  PositionToTaskTP.DfsPositionPlngStatusFoEd AS DfsPositionPlngStatusFoEd,
  PositionToTaskTP.DfsPositionValdtyStartDateFoEd AS DfsPositionValdtyStartDateFoEd,
  PositionToTaskTP.DfsPositionValdtyEndDateFoEd AS DfsPositionValdtyEndDateFoEd,
  _PositionPlngStatusVH.DfsObjectPlngStatusName AS DfsObjectPlngStatusName,
  _PositionTaskName.DfsObjectName AS DfsTaskName,
  FrcElmntOrgPlanDelimitDate,
  FrcElmntOrgPlngStatusName,
  DfsAssgmtPlanOpStsCriticality
FROM I_DFS_PositionToTaskTP AS PositionToTaskTP
LEFT OUTER JOIN C_DFS_PositionHeaderTP AS _PositionHeaderTP ON DfsPositionID = _PositionHeaderTP.DfsPositionID  -- association [1..1]
LEFT OUTER JOIN C_DFS_PositionPlngStatusVH AS _PositionPlngStatusVH ON _PositionPlngStatusVH.DfsObjectPlngStatus = DfsPositionPlngStatus  -- association [1..1]
LEFT OUTER JOIN C_DFS_PositionTaskVH AS _PositionTaskVH ON DfsPositionRelatedObjectID = _PositionTaskVH.DfsTaskID AND DfsPositionRelatedObjectType = _PositionTaskVH.DfsTaskType AND _PositionTaskVH.LanguageCode = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_DFS_ObjectName AS _PositionTaskName ON DfsPositionRelatedObjectID = _PositionTaskName.DfsObjectID AND DfsPositionRelatedObjectType = _PositionTaskName.DfsObjectType AND _PositionTaskName.LanguageCode = $session.system_language AND _PositionTaskName.DfsObjectType = 'T' AND ( _PositionTaskName.DfsObjectValdtyStartDate <= $session.system_date AND _PositionTaskName.DfsObjectValdtyEndDate >= $session.system_date )  -- association [1..1]
;