I_Defect_TP

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_Defect_TP.
-- 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: IDEFECTTP

CREATE VIEW I_Defect_TP AS
SELECT
  _Defect.DefectInternalID AS DefectInternalID,
  _Defect.Defect AS Defect,
  _Defect.DefectCategory AS DefectCategory,
  _Defect.CreatedByUser AS CreatedByUser,
  _Defect.CreationDate AS CreationDate,
  _Defect.LastChangedByUser AS LastChangedByUser,
  _Defect.LastChangeDate AS LastChangeDate,
  _Defect.DefectText AS DefectText,
  _Defect.DefectCodeCatalog AS DefectCodeCatalog,
  _Defect.DefectCodeGroup AS DefectCodeGroup,
  _Defect.DefectCode AS DefectCode,
  _Defect.DefectCodeVersion AS DefectCodeVersion,
  _Defect.DefectObjectCodeCatalog AS DefectObjectCodeCatalog,
  _Defect.DefectObjectCodeGroup AS DefectObjectCodeGroup,
  _Defect.DefectObjectCode AS DefectObjectCode,
  _Defect.DefectObjectCodeVersion AS DefectObjectCodeVersion,
  _Defect.DefectCauseCodeCatalog AS DefectCauseCodeCatalog,
  _Defect.DefectCauseCodeGroup AS DefectCauseCodeGroup,
  _Defect.DefectCauseCode AS DefectCauseCode,
  _Defect.DefectCauseCodeVersion AS DefectCauseCodeVersion,
  _Defect.DefectiveQuantity AS DefectiveQuantity,
  _Defect.DefectiveQuantityUnit AS DefectiveQuantityUnit,
  _Defect.DefectIsCreatedAutomatically AS DefectIsCreatedAutomatically,
  _Defect.ProductionOrderOperationActy AS ProductionOrderOperationActy,
  _Defect.ProductionOrderOpActyVers AS ProductionOrderOpActyVers,
  _Defect.Batch AS Batch,
  _Defect.DefectiveSingleUnit AS DefectiveSingleUnit,
  _Defect.ProductionOrder AS ProductionOrder,
  _Defect.OrderInternalID AS OrderInternalID,
  _ProductionOrderOperation.Operation AS ProductionOrderOperation,
  _ProductionOrderOperation.Sequence AS ProductionOrderSequence,
  _Defect.CreationTime AS CreationTime,
  _Defect.LastChangeTime AS LastChangeTime,
  _Defect.DefectClass AS DefectClass,
  _Defect.NumberOfDefects AS NumberOfDefects,
  _Defect.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _Defect.InspectionCharacteristic AS InspectionCharacteristic,
  _Defect.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  _Defect.MaterialSample AS MaterialSample,
  _Defect.WorkCenterTypeCode AS WorkCenterTypeCode,
  _Defect.MainWorkCenterInternalID AS MainWorkCenterInternalID,
  _Defect.MainWorkCenterPlant AS MainWorkCenterPlant,
  _Defect.MainWorkCenter AS MainWorkCenter,
  _Defect.Equipment AS Equipment,
  _Defect.FunctionalLocation AS FunctionalLocation,
  _Defect.IsDeleted AS IsDeleted,
  _Defect.DefectOrigin AS DefectOrigin,
  _Defect.Material AS Material,
  _Defect.Plant AS Plant,
  _Defect.StorageLocation AS StorageLocation,
  _Defect.InspectionLot AS InspectionLot,
  _Defect.CatalogProfile AS CatalogProfile,
  _Defect.ChangedDateTime AS ChangedDateTime,
  DefectLifecycleStatus,
  DefectArchivingStatus,
  ProblemAnalysisStatus,
  QualityIssueReference,
  MasterLanguage,
  DefectUUID,
  _Defect.ProductionSupplyArea AS ProductionSupplyArea,
  _Defect.EWMWarehouse AS Warehouse,
  _Defect.SourceStorageType AS StorageType,
  _Defect.SourceStorageBin AS SourceStorageBin,
  _Defect.WarehouseLogicalSystem AS WarehouseLogicalSystem,
  _DefectConfiguration.defectconfigurationvalue AS DefectConfigurationValue,
  _Defect.DefectCausedBy AS DefectCausedBy,
  _Defect.CostCenter AS CostCenter,
  _Defect.BOMItemInstanceUUID AS BOMItemInstanceUUID,
  _Defect.OpActyNtwkInstance AS OpActyNtwkInstance,
  _Defect.OpActyNtwkElement AS OpActyNtwkElement,
  _Defect.ProducedMaterial AS ProducedMaterial,
  _Defect.ProducedSerialNumber AS ProducedSerialNumber,
  _Defect.BillOfMaterialCategory AS BillOfMaterialCategory,
  _Defect.BillOfMaterial AS BillOfMaterial,
  _Defect.BillOfMaterialVariant AS BillOfMaterialVariant,
  _Defect.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  _Defect.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  _Defect._CatalogProfile AS _CatalogProfile,
  _Defect._DefectCategory AS _DefectCategory,
  _Defect._DefectCodeCatalog AS _DefectCodeCatalog,
  _Defect._InspectionLot AS _InspectionLot,
  _Defect._DefectiveQuantityUnit AS _DefectiveQuantityUnit,
  _Defect._DefectArchivingStatus AS _DefectArchivingStatus
FROM I_Defect AS _Defect
LEFT OUTER JOIN tqdefectconfig AS _DefectConfiguration ON _Defect.DefectInternalID = _DefectConfiguration.defectinternalid  -- 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_Inspectioncatalog AS _DefectCauseCodeCatalog ON DefectCauseCodeCatalog = _DefectCauseCodeCatalog.InspectionCatalog  -- association [0..1]
LEFT OUTER JOIN I_DefectCauseCodeGroup AS _DefectCauseCodeGroup ON DefectCauseCodeGroup = _DefectCauseCodeGroup.DefectCauseCodeGroup  -- association [0..1]
LEFT OUTER JOIN I_DefectCauseCode AS _DefectCauseCode ON DefectCauseCodeGroup = _DefectCauseCode.DefectCauseCodeGroup AND DefectCauseCode = _DefectCauseCode.DefectCauseCode  -- association [0..1]
LEFT OUTER JOIN I_Inspectioncatalog AS _DefectObjectCodeCatalog ON DefectObjectCodeCatalog = _DefectObjectCodeCatalog.InspectionCatalog  -- association [0..1]
LEFT OUTER JOIN I_InspectionCodeGroup AS _DefectObjectPartCodeGroup ON DefectObjectCodeCatalog = _DefectObjectPartCodeGroup.InspectionCatalog AND DefectObjectCodeGroup = _DefectObjectPartCodeGroup.InspectionCodeGroup  -- association [0..1]
LEFT OUTER JOIN I_InspectionCode AS _DefectObjectCode ON DefectObjectCodeCatalog = _DefectObjectCode.InspectionCatalog AND DefectObjectCodeGroup = _DefectObjectCode.InspectionCodeGroup AND DefectObjectCode = _DefectObjectCode.InspectionCode  -- association [0..1]
LEFT OUTER JOIN I_DefectStatus AS _DefectStatus ON DefectLifecycleStatus = _DefectStatus.DefectLifecycleStatus  -- association [0..1]
LEFT OUTER JOIN I_ProblemAnalysisStatus AS _ProblemAnalysisStatus ON ProblemAnalysisStatus = _ProblemAnalysisStatus.ProblemAnalysisStatus  -- association [0..1]
LEFT OUTER JOIN I_EWM_WarehouseNumber AS _EWM_WarehouseNumber ON Warehouse = _EWM_WarehouseNumber.Warehouse  -- association [0..1]
LEFT OUTER JOIN I_EWM_StorageType AS _EWM_StorageType ON Warehouse = _EWM_StorageType.Warehouse AND StorageType = _EWM_StorageType.StorageType  -- association [0..1]
LEFT OUTER JOIN I_EWM_StorageBin AS _EWM_StorageBin ON Warehouse = _EWM_StorageBin.Warehouse AND SourceStorageBin = _EWM_StorageBin.StorageBin  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _DefectiveQtyUnitOfMeasure ON DefectiveQuantityUnit = _DefectiveQtyUnitOfMeasure.UnitOfMeasure  -- association [0..1]
LEFT OUTER JOIN I_OrderOperationBasic AS _ProductionOrderOperation ON OrderInternalID = _ProductionOrderOperation.OrderInternalID AND InspPlanOperationInternalID = _ProductionOrderOperation.OrderOperationInternalID  -- association [0..1]
LEFT OUTER JOIN I_DefectLongTextTP AS _DefectLongTextTP ON DefectInternalID = _DefectLongTextTP.DefectInternalID  -- association [0..*]
LEFT OUTER JOIN I_DefectAffectedObjectTP AS _DefectAffectedObjectTP ON DefectInternalID = _DefectAffectedObjectTP.DefectInternalID  -- association [0..*]
LEFT OUTER JOIN I_DefectLongTextTP AS _DefectDetailedDescription ON DefectInternalID = _DefectDetailedDescription.DefectInternalID AND _DefectDetailedDescription.LongTextID = 'LTXT'  -- association [0..*]
LEFT OUTER JOIN E_NotificationItem AS _Extension ON DefectInternalID = _Extension.Notification AND _Extension.NotificationItem = '0000'  -- association [1..1]
;