C_DefectTaskRecord

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_DefectTaskRecord.
-- 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: CDEFTSKREC

CREATE VIEW C_DefectTaskRecord AS
SELECT
  QualityTaskInternalId,
  QualityTask,
  QualityTaskOrigin,
  QualityTaskText,
  QualityTaskLifecycleStatus,
  QualityTaskArchivingStatus,
  QualityTaskProcessor,
  QltyTaskFollowUpAction,
  QltyTaskFllwUpActionSts,
  MasterLanguage,
  NotifTaskPlannedEndDateTime,
  NotifTaskPlannedEndDate,
  NotifTaskPlannedEndTime,
  NotifTaskCompletionDateTime,
  NotifTaskCompletionDate,
  NotifTaskCompletionTime,
  NotifTaskCompletedByUser,
  NotifTaskTimeZone,
  DefectInternalID,
  ChangedDateTime,
  IsDeleted,
  QltyTskProcgIsCtrldByTskOrigin,
  QltyTaskTimeBasedEffort,
  QltyTaskTimeBasedEffortUoM
FROM I_QualityTaskTP
LEFT OUTER JOIN C_DefectRecord AS _DefectRecord ON DefectInternalID = _DefectRecord.DefectInternalID  -- association [1..1]
LEFT OUTER JOIN C_DefectQltyTskProcsrNotes AS _DefectQltyTskProcsrNotes ON QualityTaskInternalId = _DefectQltyTskProcsrNotes.QualityTaskInternalId AND MasterLanguage = _DefectQltyTskProcsrNotes.Language AND _DefectQltyTskProcsrNotes.ItemCounter = 1  -- association [0..1]
;