C_QltyTskMng

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_QltyTskMng.
-- 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: CQLTYTSKMNG

CREATE VIEW C_QltyTskMng AS
SELECT
  QualityTaskInternalId,
  QualityTask,
  QualityTaskText,
  QualityTaskLifecycleStatus,
  _QualityTaskStatus._QualityTaskStatusText[1:Language=$session.system_language].QualityTaskLifecycleStatusText AS QualityTaskLifecycleStatusText,
  0 AS CriticalityCode,
  NotifTaskPlannedEndDate,
  QualityTaskProcessor,
  _QualityTaskProcessor.FullName AS FullName,
  _QualityTaskProcessor.UserID AS UserID,
  cast( _Defect_TP.Defect as vdm_qdefectid preserving type ) AS Defect,
  _Defect_TP.DefectText AS DefectText,
  _Defect_TP._DefectCategory.DefectCategory AS DefectCategory,
  _Defect_TP._DefectCategory._Text[1:Language = $session.system_language].DefectCategoryText AS DefectCategoryText,
  QualityTaskOrigin,
  cast( IsDeleted as vdm_qm_qualitytaskdeleted preserving type ) AS IsDeleted,
  NotifTaskCompletedByUser,
  NotifTaskCompletionDate,
  DefectInternalID,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  cast ( 1 as vdm_qm_plannedendcnt ) AS NumberOfTasks,
  CalendarWeek AS EndDateWeek
FROM I_QualityTaskTP
LEFT OUTER JOIN I_CalendarDate ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN C_QltyTskAssgdVislFltr AS _QltyTskAssgdVislFltr ON QualityTaskInternalId = _QltyTskAssgdVislFltr.QualityTaskInternalId  -- association [1..1]
LEFT OUTER JOIN C_QltyTskStsVislFltr AS _QltyTskStsVislFltr ON QualityTaskInternalId = _QltyTskStsVislFltr.QualityTaskInternalId  -- association [1..1]
LEFT OUTER JOIN C_QltyTskDefectCatVislFltr AS _QltyTskDefectCatVislFltr ON QualityTaskInternalId = _QltyTskDefectCatVislFltr.QualityTaskInternalId  -- association [1..1]
LEFT OUTER JOIN I_UserContactCard AS _UserContactCard ON userid = _UserContactCard.ContactCardID  -- association [0..1]
LEFT OUTER JOIN I_QltyTskNoPlndEndDte AS _QltyTskNoPlndEndDte ON EndDateWeek = _QltyTskNoPlndEndDte.CalendarWeek  -- association [1..1]
;