C_QltyTaskProcessDefectInfo

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_QltyTaskProcessDefectInfo.
-- 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: CQLTYTSKPRCDINFO

CREATE VIEW C_QltyTaskProcessDefectInfo AS
SELECT
  DefectInternalID,
  Defect,
  DefectCategory,
  _DefectCategory._Text[1: Language = $session.system_language].DefectCategoryText AS DefectCategoryText,
  DefectText,
  DefectLifecycleStatus,
  _DefectStatus._DefectStatusText[1: Language = $session.system_language].DefectLifecycleStatusText AS DefectLifecycleStatusText,
  DefectCodeGroup,
  _DefectCodeGroup._Text[1: Language = $session.system_language].DefectCodeGroupText AS DefectCodeGroupText,
  DefectCode,
  _DefectCode._Text[1: Language = $session.system_language].DefectCodeText AS DefectCodeText,
  QualityIssueReference,
  Plant,
  MasterLanguage,
  _QltyTaskProcDefectInfoLongT.DefectLongText AS DefectLongText,
  WorkCenterTypeCode,
  MainWorkCenterInternalID,
  MainWorkCenter,
  MainWorkCenterPlant,
  InspectionLot
FROM I_Defect_TP
LEFT OUTER JOIN C_QltyTaskProcDefectInfoLongT AS _QltyTaskProcDefectInfoLongT ON DefectInternalID = _QltyTaskProcDefectInfoLongT.DefectInternalID AND MasterLanguage = _QltyTaskProcDefectInfoLongT.Language  -- association [0..1]
;