C_DefectFDP

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_DefectFDP.
-- 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.

CREATE VIEW C_DefectFDP AS
SELECT
  _Defect.DefectInternalID AS DefectInternalID,
  _Defect.Defect AS Defect,
  _Defect.DefectCategory AS DefectCategory,
  _Defect._DefectCategory._Text[ 1: Language = $session.system_language ].DefectCategoryText AS DefectCategoryText,
  _Defect.CreatedByUser AS CreatedByUser,
  cast( _Defect._CreatedByUserContactCard.FullName as vdm_createdbyuserdescription preserving type ) AS CreatedByUserDescription,
  _Defect.CreationDate AS CreationDate,
  _Defect.CreationTime AS CreationTime,
  _Defect.LastChangedByUser AS LastChangedByUser,
  cast( _Defect._LastChangedByUserContactCard.FullName as vdm_lastchangedbyuserdescripti preserving type ) AS LastChangedByUserDescription,
  _Defect.LastChangeDate AS LastChangeDate,
  _Defect.LastChangeTime AS LastChangeTime,
  _Defect.DefectText AS DefectText,
  _Defect.DefectCodeCatalog AS DefectCodeCatalog,
  _Defect.DefectCodeGroup AS DefectCodeGroup,
  _Defect._DefectCodeGroup._Text[ 1: Language = $session.system_language ].DefectCodeGroupText AS DefectCodeGroupText,
  _Defect.DefectCode AS DefectCode,
  _Defect._DefectCode._Text[ 1: Language = $session.system_language ].DefectCodeText AS DefectCodeText,
  _Defect.DefectiveQuantity AS DefectiveQuantity,
  _Defect.DefectiveQuantityUnit AS DefectiveQuantityUnit,
  _Defect.Material AS Product,
  _Defect._Product._Text[ 1: Language = $session.system_language ].ProductName AS ProductName,
  _Defect.Plant AS Plant,
  _Defect._Plant.PlantName AS PlantName,
  _Defect.Batch AS Batch,
  _Defect.ProductionOrder AS ManufacturingOrder,
  _Defect._ManufacturingOrder.ManufacturingOrderText AS ManufacturingOrderText,
  _Defect._ManufacturingOrderOperation.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  cast(' ' as mfgordersequencetext preserving type) AS MfgOrderSequenceText,
  cast( _Defect._ManufacturingOrderOperation.ManufacturingOrderOperation as vdm_vornr preserving type ) AS ManufacturingOrderOperation,
  _Defect._ManufacturingOrderOperation.MfgOrderOperationText AS MfgOrderOperationText,
  _Defect.OrderInternalID AS OrderInternalID,
  _Defect.DefectClass AS DefectClass,
  _Defect._DefectClass._Text[ 1: Language = $session.system_language ].DefectClassText AS DefectClassText,
  _Defect.NumberOfDefects AS NumberOfDefects,
  _Defect.InspectionLot AS InspectionLot,
  _Defect.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  cast( _InspectionOperation.InspectionOperation as vdm_vornr preserving type ) AS InspectionOperation,
  _InspectionOperation.OperationText AS OperationText,
  _Defect.InspectionCharacteristic AS InspectionCharacteristic,
  _InspectionCharacteristic.InspectionCharacteristicText AS InspectionCharacteristicText,
  _Defect.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  _Defect.MaterialSample AS MaterialSample,
  _Defect.WorkCenterTypeCode AS WorkCenterTypeCode,
  _Defect.MainWorkCenterInternalID AS MainWorkCenterInternalID,
  _Defect.MainWorkCenterPlant AS MainWorkCenterPlant,
  _MainWorkCenterPlant.PlantName AS MainWorkCenterPlantName,
  _Defect.MainWorkCenter AS MainWorkCenter,
  _MainWorkCenterText[ 1: Language = $session.system_language ].WorkCenterText AS MainWorkCenterText,
  _Defect.IsDeleted AS IsDeleted,
  _Defect.DefectOrigin AS DefectOrigin,
  _Defect.ChangedDateTime AS ChangedDateTime,
  _Defect.DefectLifecycleStatus AS DefectLifecycleStatus,
  _Defect._DefectStatus._DefectStatusText[ 1: Language = $session.system_language ].DefectLifecycleStatusText AS DefectLifecycleStatusText,
  _Defect.ProblemAnalysisStatus AS ProblemAnalysisStatus,
  _Defect._ProblemAnalysisStatus._ProblemAnalysisStatusT[ 1: Language = $session.system_language ].ProblemAnalysisStatusText AS ProblemAnalysisStatusText,
  _Defect.QualityIssueReference AS QualityIssueReference,
  cast( _Defect.MasterLanguage as vdm_j_masterlanguage ) AS MasterLanguage,
  _Defect._DefectLongText[ 1: Language = masterlanguage and LongTextID = 'LTXT' ].DefectLongText AS DefectDetailedDescription
FROM I_Defect AS _Defect
LEFT OUTER JOIN C_DefectTaskFDP AS _DefectTask ON DefectInternalID = _DefectTask.DefectInternalID  -- association [0..*]
LEFT OUTER JOIN C_DefectAffectedObjectFDP AS _DefectAffectedObject ON DefectInternalID = _DefectAffectedObject.DefectInternalID  -- association [0..*]
LEFT OUTER JOIN C_DefectSerialNumberFDP AS _DefectSerialNumber ON DefectInternalID = _DefectSerialNumber.DefectInternalID  -- association [0..*]
LEFT OUTER JOIN I_InspectionOperation AS _InspectionOperation ON InspectionLot = _InspectionOperation.InspectionLot AND InspPlanOperationInternalID = _InspectionOperation.InspPlanOperationInternalID  -- association [0..1]
LEFT OUTER JOIN I_InspectionCharacteristic AS _InspectionCharacteristic ON InspectionLot = _InspectionCharacteristic.InspectionLot AND InspPlanOperationInternalID = _InspectionCharacteristic.InspPlanOperationInternalID AND InspectionCharacteristic = _InspectionCharacteristic.InspectionCharacteristic  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _MainWorkCenterPlant ON MainWorkCenterPlant = _MainWorkCenterPlant.Plant  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasureText AS _DefectiveQuantityUnitText ON DefectiveQuantityUnit = _DefectiveQuantityUnitText.UnitOfMeasure  -- association [0..*]
LEFT OUTER JOIN I_WorkCenterText AS _MainWorkCenterText ON WorkCenterTypeCode = _MainWorkCenterText.WorkCenterTypeCode AND MainWorkCenterInternalID = _MainWorkCenterText.WorkCenterInternalID  -- association [0..*]
LEFT OUTER JOIN E_NotificationItem AS _Extension ON DefectInternalID = _Extension.Notification AND _Extension.NotificationItem = '0000'  -- association [1..1]
;