C_QualityTaskProcess

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_QualityTaskProcess.
-- 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: CQLTYTSKPROC

CREATE VIEW C_QualityTaskProcess AS
SELECT
  QualityTaskInternalId,
  QualityTask,
  QualityTaskOrigin,
  _QualityTaskOrigin._Text[1: Language = $session.system_language].QualityTaskOriginText AS QualityTaskOriginText,
  QualityTaskType,
  QualityTaskText,
  QualityTaskProcessor,
  QualityTaskLifecycleStatus,
  QualityTaskArchivingStatus,
  MasterLanguage,
  NotifTaskPlannedEndDateTime,
  NotifTaskPlannedEndDate,
  NotifTaskPlannedEndTime,
  NotifTaskCompletionDateTime,
  NotifTaskCompletionDate,
  NotifTaskCompletionTime,
  NotifTaskCompletedByUser,
  cast( I_QualityTaskTP._CompletedByUserContactCard.FullName as vdm_userdescription preserving type ) AS TaskCompletedByUserName,
  NotifTaskTimeZone,
  QualityTaskCodeCatalog,
  QualityTaskCodeGroup,
  QualityTaskCode,
  QltyTaskFollowUpAction,
  QltyTaskFllwUpActionSts,
  QltyTskFllwUpActnConfignVal,
  ChangedDateTime,
  CreationDate,
  CreationTime,
  cast( 0 as timestamp ) AS CreationDateTime,
  CreatedByUser,
  cast( I_QualityTaskTP._CreatedByUserContactCard.FullName as vdm_createdbyuserdescription preserving type ) AS CreatedByUserFullName,
  LastChangeDate,
  LastChangeTime,
  cast( 0 as timestamp ) AS LastChangeDateTime,
  LastChangedByUser,
  cast( I_QualityTaskTP._LastChangedByUserContactCard.FullName as vdm_lastchangedbyuserdescripti preserving type ) AS LastChangedByUserFullName,
  QltyTskProcgIsCtrldByTskOrigin,
  DefectInternalID,
  cast( ' ' as qdefectid preserving type ) AS Defect,
  cast( ' ' as vdm_qfetxt preserving type ) AS DefectText,
  ProbSolvingProc,
  ProbSolvingProcStp,
  ProbSolvingProcCause,
  cast( 'Bla ' as qprbslvprctxt preserving type ) AS ProbSolvingProcDesc,
  QltyTaskTimeBasedEffort,
  QltyTaskTimeBasedEffortUoM
FROM I_QualityTaskTP
LEFT OUTER JOIN C_QltyTskProcProcsrNotes AS _QltyTskProcProcsrNotes ON QualityTaskInternalId = _QltyTskProcProcsrNotes.QualityTaskInternalId AND MasterLanguage = _QltyTskProcProcsrNotes.Language AND _QltyTskProcProcsrNotes.ItemCounter = 1  -- association [0..1]
LEFT OUTER JOIN C_QltyTaskDetailedDescription AS _QltyTaskDetailedDescription ON QualityTaskInternalId = _QltyTaskDetailedDescription.QualityTaskInternalId AND MasterLanguage = _QltyTaskDetailedDescription.Language AND _QltyTaskDetailedDescription.ItemCounter = 2  -- association [0..1]
LEFT OUTER JOIN C_QltyTskProcFllwActnSglParam AS _QltyTskProcFllwActnSglParam ON QualityTaskInternalId = _QltyTskProcFllwActnSglParam.QualityTaskInternalId AND _QltyTskProcFllwActnSglParam.ItemCounter = 1  -- association [0..1]
LEFT OUTER JOIN C_QltyTskProcFllwActnTblParam AS _QltyTskProcFllwActnTblParam ON QualityTaskInternalId = _QltyTskProcFllwActnTblParam.QualityTaskInternalId  -- association [0..*]
LEFT OUTER JOIN C_QualityTaskProcessCalc AS _QualityTaskProcessCalc ON QualityTaskInternalId = _QualityTaskProcessCalc.QualityTaskInternalId  -- association [1..1]
LEFT OUTER JOIN C_QltyTaskProcessDefectInfo AS _QltyTaskProcessDefectInfo ON DefectInternalID = _QltyTaskProcessDefectInfo.DefectInternalID  -- association [0..1]
LEFT OUTER JOIN C_QltyTaskProbSolvingProcInfo AS _QltyTaskProbSolvingProcInfo ON ProbSolvingProc = _QltyTaskProbSolvingProcInfo.ProbSolvingProc AND ProbSolvingProcStp = _QltyTaskProbSolvingProcInfo.ProbSolvingProcStp  -- association [0..1]
;