C_ProbSolvingProcStepQltyTask

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_ProbSolvingProcStepQltyTask.
-- 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 C_ProbSolvingProcStepQltyTask AS
SELECT
  QualityTaskInternalId,
  QualityTask,
  QualityTaskOrigin,
  MasterLanguage,
  QualityTaskText,
  QualityTaskCode,
  QualityTaskCodeGroup,
  QualityTaskLifecycleStatus,
  QualityTaskProcessor,
  NotifTaskTimeZone,
  NotifTaskPlannedEndDate,
  NotifTaskPlannedEndTime,
  NotifTaskCompletionDate,
  NotifTaskCompletionTime,
  ProbSolvingProc,
  ProbSolvingProcStp,
  ProbSolvingProcCause,
  PredecessorQltyTaskIntNumber,
  cast( I_QualityTaskTP._PredecessorQualityTask.QualityTask as vdm_predecessorqltytask preserving type ) AS PredecessorQltyTask,
  cast( I_QualityTaskTP._PredecessorQualityTask.QualityTaskText as vdm_predecessorqltytaskdesc preserving type ) AS PredecessorQltyTaskText,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime
FROM I_QualityTaskTP
LEFT OUTER JOIN I_QualityTaskLongText AS _QualityTaskDetailedDesc ON QualityTaskInternalId = _QualityTaskDetailedDesc.QualityTaskInternalId AND MasterLanguage = _QualityTaskDetailedDesc.Language AND _QualityTaskDetailedDesc.LongTextInternalNumber = 2 AND _QualityTaskDetailedDesc.LongTextID = 'LTXT'  -- association [0..1]
LEFT OUTER JOIN C_ProbSolvingProcExect AS _ProbSolvingProc ON ProbSolvingProc = _ProbSolvingProc.ProbSolvingProc  -- association [0..1]
LEFT OUTER JOIN C_ProbSolvingProcStepExect AS _ProbSolvingProcStep ON ProbSolvingProc = _ProbSolvingProcStep.ProbSolvingProc AND ProbSolvingProcStp = _ProbSolvingProcStep.ProbSolvingProcStp  -- association [0..1]
LEFT OUTER JOIN C_ProbSolvingProcCause AS _ProbSolvingProcCause ON ProbSolvingProc = _ProbSolvingProcCause.ProbSolvingProc AND ProbSolvingProcCause = _ProbSolvingProcCause.ProbSolvingProcCause  -- association [0..1]
;