I_DefectUnion

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 I_DefectUnion.
-- 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: IDEFECTUNI

CREATE VIEW I_DefectUnion AS
SELECT
  DefectInternalID,
  cast( ' ' as qmnum preserving type ) AS Notification,
  cast( '0000' as felfd preserving type ) AS NotificationItem,
  cast( '0000' as qnotifitemexternal preserving type ) AS NotificationItemExternalID,
  Defect,
  DefectCategory,
  CreatedByUser,
  CreationDate,
  CreationTime,
  LastChangedByUser,
  LastChangeDate,
  LastChangeTime,
  DefectText,
  DefectCodeCatalog,
  DefectCodeGroup,
  DefectCode,
  DefectCodeVersion,
  DefectObjectCodeCatalog AS DefectLocationCatalog,
  DefectObjectCodeGroup AS DefectLocationCodeGroup,
  DefectObjectCode AS DefectLocationCode,
  DefectClass,
  NumberOfDefects,
  DefectLifecycleStatus,
  cast( ' ' as qdefrefnum preserving type ) AS ReferencedDefect,
  Plant,
  Material,
  Batch,
  InspectionLot,
  InspPlanOperationInternalID,
  InspectionCharacteristic,
  InspectionSubsetInternalID,
  MaterialSample,
  cast( ' ' as elifn preserving type ) AS Supplier,
  cast( ' ' as qkunwe preserving type ) AS Customer,
  cast( ' ' as qmart preserving type ) AS NotificationType,
  ProductionOrder,
  ProductionOrderOperation,
  ProductionOrderSequence,
  WorkCenterTypeCode,
  MainWorkCenterInternalID,
  MainWorkCenterPlant,
  MainWorkCenter,
  StorageLocation,
  ProductionSupplyArea,
  Warehouse,
  StorageType,
  SourceStorageBin,
  WarehouseLogicalSystem,
  IsDeleted,
  DefectOrigin,
  DefectCausedBy,
  DefectUUID,
  _Notification._Plant AS _Plant,
  _Notification._Product AS _Product
FROM I_Defect_TP
LEFT OUTER JOIN I_Notification AS _Notification ON Notification = _Notification.Notification  -- association [0..1]
LEFT OUTER JOIN I_NotificationType AS _NotificationType ON NotificationType = _NotificationType.NotificationType  -- association [0..1]
LEFT OUTER JOIN I_DefectLocationCatalog AS _DefectLocationCatalog ON DefectLocationCatalog = _DefectLocationCatalog.DefectLocationCatalog  -- association [0..1]
LEFT OUTER JOIN I_DefectLocationCodeGroup AS _DefectLocationCodeGroup ON DefectLocationCatalog = _DefectLocationCodeGroup.DefectLocationCatalog AND DefectLocationCodeGroup = _DefectLocationCodeGroup.DefectLocationCodeGroup  -- association [0..1]
LEFT OUTER JOIN I_DefectLocationCode AS _DefectLocationCode ON DefectLocationCatalog = _DefectLocationCode.DefectLocationCatalog AND DefectLocationCodeGroup = _DefectLocationCode.DefectLocationCodeGroup AND DefectLocationCode = _DefectLocationCode.DefectLocationCode  -- association [0..1]
LEFT OUTER JOIN I_DefectCodeGroup AS _DefectCodeGroup ON DefectCodeGroup = _DefectCodeGroup.DefectCodeGroup  -- association [0..1]
LEFT OUTER JOIN I_DefectCode AS _DefectCode ON DefectCodeGroup = _DefectCode.DefectCodeGroup AND DefectCode = _DefectCode.DefectCode  -- association [0..1]
LEFT OUTER JOIN I_InspectionLot AS _InspectionLot ON inspectionlot = _InspectionLot.InspectionLot  -- association [0..1]
LEFT OUTER JOIN I_DefectStatus AS _DefectStatus ON DefectLifecycleStatus = _DefectStatus.DefectLifecycleStatus  -- association [0..1]
LEFT OUTER JOIN I_DefectCausedBy AS _DefectCausedBy ON DefectCausedBy = _DefectCausedBy.DefectCausedBy  -- association [0..1]
LEFT OUTER JOIN I_EWM_WarehouseNumber_2 AS _EWM_WarehouseNumber_2 ON Warehouse = _EWM_WarehouseNumber_2.EWMWarehouse  -- association [0..1]
LEFT OUTER JOIN I_EWM_WarehouseNumber AS _EWM_WarehouseNumber ON Warehouse = _EWM_WarehouseNumber.Warehouse  -- association [0..1]
LEFT OUTER JOIN I_UserContactCard AS _CreatedByUserContactCard ON CreatedByUser = _CreatedByUserContactCard.ContactCardID  -- association [0..1]
-- UNION with additional select branch(es): I_Defect_TP, I_NotificationItem
;