I_DFS_PositionToStdWrkflwTskTP

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_DFS_PositionToStdWrkflwTskTP.
-- 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: IDFSPOSTOSWTSKTP

CREATE VIEW I_DFS_PositionToStdWrkflwTskTP AS
SELECT
  PositionToStdWrkflwTskTP.DfsObjectID AS DfsPositionID,
  PositionToStdWrkflwTskTP.DfsPositionRelatedObjectID AS DfsPositionRelatedObjectID,
  PositionToStdWrkflwTskTP.DfsObjectPlngStatus AS DfsPositionPlngStatus,
  PositionToStdWrkflwTskTP.DfsObjectValdtyStartDate AS DfsPositionValdtyStartDate,
  PositionToStdWrkflwTskTP.DfsObjectValdtyEndDate AS DfsPositionValdtyEndDate,
  PositionToStdWrkflwTskTP.DfsObjectType AS DfsPositionObjectType,
  PositionToStdWrkflwTskTP.DfsObjectPlanVersion AS DfsPositionPlanVersion,
  PositionToStdWrkflwTskTP.DfsObjectRelshpSpec AS DfsPositionRelshpSpec,
  PositionToStdWrkflwTskTP.DfsObjectRelshpBtwnObj AS DfsPositionRelshpBtwnObj,
  PositionToStdWrkflwTskTP.DfsObjectRelshpPriority AS DfsPositionRelshpPriority,
  PositionToStdWrkflwTskTP.DfsPositionDescRefSqncNmbr AS DfsPositionDescRefSqncNmbr,
  PositionToStdWrkflwTskTP.DfsObjectInfoType AS DfsPositionInfoType,
  PositionToStdWrkflwTskTP.DfsObjectSubType AS DfsPositionSubType,
  PositionToStdWrkflwTskTP.DfsPositionRelatedObjectType AS DfsPositionRelatedObjectType,
  PositionToStdWrkflwTskTP.DfsObjRelshpLastChgdByUserName AS DfsPosRelshpLastChgdByUserName,
  PositionToStdWrkflwTskTP.DfsObjRelshpLastChgdByUser AS DfsPositionRelshpLastChgdByUsr,
  PositionToStdWrkflwTskTP.DfsObjRelshpLastChgdDate AS DfsPositionRelshpLastChgdDate,
  PositionToStdWrkflwTskTP.FrcElmntOrgPlngStsCritlty AS FrcElmntOrgPlngStsCritlty,
  PositionToStdWrkflwTskTP.DfsObjectID AS DfsPositionIDFoEd,
  PositionToStdWrkflwTskTP.DfsPositionRelatedObjectID AS DfsPositionRelatedObjectIDFoEd,
  PositionToStdWrkflwTskTP.DfsObjectPlngStatus AS DfsPositionPlngStatusFoEd,
  DfsObjectValdtyStartDate AS DfsPositionValdtyStartDateFoEd,
  DfsObjectValdtyEndDate AS DfsPositionValdtyEndDateFoEd,
  _PosPlndOpTP.FrcElmntOrgPlngStatus AS FrcElmntOrgPlngStatus,
  _PosPlndOpTP.FrcElmntOrgPlanDelimitDate AS FrcElmntOrgPlanDelimitDate,
  _PosPlndOpTP.FrcElmntOrgPlngStatusName AS FrcElmntOrgPlngStatusName,
  _PosPlndOpTP.FrcElmntOrgPlngStsCritlty AS DfsAssgmtPlanOpStsCriticality
FROM I_DFS_ObjStructureRelationship AS PositionToStdWrkflwTskTP
LEFT OUTER JOIN I_DFS_PositionHeaderTP AS _PositionHeaderTP ON DfsPositionID = _PositionHeaderTP.DfsPositionID  -- association [1..1]
LEFT OUTER JOIN I_DFS_PosPlndOpTP AS _PosPlndOpTP ON DfsPositionID = _PosPlndOpTP.ForceElementOrgID AND DfsPositionRelatedObjectID = _PosPlndOpTP.FrcElmntOrgRelatedOrgID AND DfsPositionValdtyStartDate = _PosPlndOpTP.FrcElmntOrgValdtyRefStartDate AND DfsPositionValdtyEndDate = _PosPlndOpTP.FrcElmntOrgValdtyRefEndDate AND DfsPositionSubType = _PosPlndOpTP.FrcElmntOrgRefSubtype AND _PosPlndOpTP.FrcElmntOrgRefInfoType = '1001'  -- association [1..1]
;