C_Defect

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_Defect.
-- 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: CDEFECT

CREATE VIEW C_Defect AS
SELECT
  I_QualityDefectUnion.Notification AS DefectInternalID,
  I_QualityDefectUnion.NotificationItem AS NotificationItem,
  cast( substring(I_QualityDefectUnion.Notification,2,11) as qdefectid preserving type ) AS Defect,
  I_QualityDefectUnion.DefectCodeGroup AS DefectCodeGroup,
  I_QualityDefectUnion.DefectCode AS DefectCode,
  I_QualityDefectUnion.NumberOfDefects AS NumberOfDefects,
  I_QualityDefectUnion.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  I_QualityDefectUnion.InspectionCharacteristic AS InspectionCharacteristic,
  I_QualityDefectUnion.InspectionLot AS InspectionLot,
  I_QualityDefectUnion.Plant AS Plant,
  cast (1 as abap.int8) AS InspectionLotSum,
  I_QualityDefectUnion.DefectCategory AS DefectCategory,
  I_QualityDefectUnion.WorkCenterTypeCode AS WorkCenterTypeCode,
  I_QualityDefectUnion.MainWorkCenterInternalID AS MainWorkCenterInternalID,
  I_QualityDefectUnion.MainWorkCenter AS MainWorkCenter,
  I_QualityDefectUnion.MainWorkCenterPlant AS MainWorkCenterPlant,
  I_QualityDefectUnion.DefectCodeCatalog AS DefectCodeCatalog,
  I_QualityDefectUnion._InspectionLot AS _InspectionLot
FROM I_QualityDefectUnion
;