I_FMEATaskTP

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_FMEATaskTP.
-- 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.

CREATE VIEW I_FMEATaskTP AS
SELECT
  FMEATaskUUID,
  _FMEATaskAssignment.FMEATask AS FMEATask,
  _ParentNodeAssignment.FMEAHeaderUUID AS FMEAHeaderUUID,
  _ParentNodeAssignment.FMEANode AS FMEANode,
  FMEAAuthorizationGroup,
  FMEATaskStatus,
  _FMEATaskActionStatus.FMEATaskActionStatus AS FMEATaskActionStatus,
  FMEATaskType,
  FMEAParentNodeUUID,
  FMEATaskCompletionRate,
  FMEAValuationProfile,
  FMEAHasTargetValuation,
  FMEAValnPrflTargetValuation,
  FMEATargetValuationScoreValue,
  FMEATargetValnResultValue,
  FMEAValnProfileValuation,
  FMEAValuationScoreValue,
  FMEAValuationResultValue,
  FMEATaskGroup,
  FMEATaskConfirmationDateTime,
  QualityTaskCodeCatalog,
  QualityTaskCodeGroup,
  QualityTaskCode,
  FMEATaskIsCancelled,
  FMEATaskIsStartAction,
  ChangedDateTime,
  _FMEATaskText.FMEATaskDescription AS FMEATaskDescription,
  _FMEATaskAssignment.FMEATaskPlannedStartDateTime AS FMEATaskPlannedStartDateTime,
  _FMEATaskAssignment.FMEATaskPlannedFinishDateTime AS FMEATaskPlannedFinishDateTime,
  _FMEATaskAssignment.FMEATaskActualFinishDateTime AS FMEATaskActualFinishDateTime,
  cast( _FMEATaskAssignment.CreatedByUser as cgpl_created_by preserving type ) AS CreatedByUser,
  _FMEATaskAssignment.CreationDate AS CreationDate,
  cast( _FMEATaskAssignment.LastChangedByUser as cgpl_changed_by preserving type ) AS LastChangedByUser,
  _FMEATaskAssignment.LastChangedDate AS LastChangedDate,
  _FMEATaskLangDepdntDescription.FMEALongText AS FMEATaskLongText
FROM I_FMEATask
LEFT OUTER JOIN I_FMEACauseTaskTP AS _FMEACauseTaskTP ON FMEAParentNodeUUID = _FMEACauseTaskTP.FMEANodeUUID AND FMEATaskUUID = _FMEACauseTaskTP.FMEATaskUUID  -- association [0..1]
LEFT OUTER JOIN I_FMEATaskText AS _FMEATaskText ON FMEATaskUUID = _FMEATaskText.FMEATaskUUID AND _FMEATaskText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FMEALongText AS _FMEATaskLangDepdntDescription ON FMEATaskUUID = _FMEATaskLangDepdntDescription.FMEANodeUUID AND _FMEATaskLangDepdntDescription.Language = $session.system_language AND _FMEATaskLangDepdntDescription.LongTextInternalNumber = 1  -- association [0..1]
LEFT OUTER JOIN I_FMEATaskResponsible AS _Responsible ON FMEATaskUUID = _Responsible.FMEATaskUUID  -- association [0..1]
LEFT OUTER JOIN I_FMEATaskPartnerTP AS _FMEATaskPartnerTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_FMEATaskTextTP AS _FMEATaskTextTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_FMEATaskDescriptionTextTP AS _FMEATaskDescription ON /* condition not available in parsed metadata */  -- association [0..*]
;