C_DefectMng

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_DefectMng.
-- 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: CDEFECTMNG

CREATE VIEW C_DefectMng AS
SELECT
  _DefectUnion._NotificationType._NotificationTypeName[1: Language = $session.system_language].NotificationTypeName AS NotificationTypeName,
  _DefectUnion._DefectCode._Text[1:Language=$session.system_language].DefectCodeText AS DefectCodeText,
  _DefectUnion._DefectCodeGroup._Text[1:Language=$session.system_language].DefectCodeGroupText AS DefectCodeGroupText,
  cast( concat_with_space(_DefectUnion.DefectCodeGroup, _DefectUnion.DefectCode, 1) as qdefect_code_group_and_code preserving type ) AS DefectCodeGroupAndCode,
  _Product._Text[1:Language=$session.system_language].ProductName AS MaterialName,
  _DefectUnion._InspectionLot.InspectionLotOrigin AS InspectionLotOrigin,
  _DefectUnion._InspectionLot._Supplier.SupplierName AS SupplierName,
  _DefectUnion._InspectionLot.Supplier AS Supplier,
  _DefectUnion._InspectionLot._Customer.CustomerName AS CustomerName,
  _DefectUnion._InspectionLot.Customer AS Customer,
  _DefectClass._Text[1:Language=$session.system_language].DefectClassText AS DefectClassText,
  cast ( _DefectUnion._InspectionLot.InspectionLotHasUsageDecision as xfeld preserving type ) AS InspectionLotHasUsageDecision,
  _DefectUnion._InspectionLot._InspectionLotType._Text[1:Language=$session.system_language].InspectionLotTypeText AS InspectionLotTypeText,
  _DefectUnion._InspectionLot.InspectionLotType AS InspectionLotType,
  _DefectUnion._InspectionLot.BatchStorageLocation AS BatchStorageLocation,
  _WorkCenterBySemanticKey._WorkCenterTextBySemanticKey[1:Language=$session.system_language].WorkCenterText AS WorkCenterText,
  _ProductionSupplyArea._Text[1: Language = $session.system_language].ProductionSupplyAreaName AS ProductionSupplyAreaName,
  _EWM_WarehouseNumber_2._Text[1: Language = $session.system_language].EWMWarehouseDescription AS EWMWarehouseDescription,
  _EWM_SourceStorageType._Text[1: Language = $session.system_language].EWMStorageTypeName AS EWMStorageTypeName,
  cast( _DefectUnion._InspectionLot._Manufacturer.SupplierName as vdm_qm_manufacturer_name preserving type ) AS ManufacturerName,
  _DefectUnion._InspectionLot.Manufacturer AS Manufacturer,
  _DefectUnion._InspectionLot._PurchasingOrganization.PurchasingOrganizationName AS PurchasingOrganizationName,
  _DefectUnion._InspectionLot.PurchasingOrganization AS PurchasingOrganization,
  _DefectUnion._InspectionLot.PurchasingDocument AS PurchasingDocument,
  _DefectUnion._InspectionLot.PurchasingDocumentItem AS PurchasingDocumentItem,
  _DefectUnion._InspectionLot.ManufacturerPartNmbr AS ManufacturerPartNmbr,
  _DefectUnion._InspectionLot.SalesOrder AS SalesOrder,
  _DefectUnion._InspectionLot.SalesOrderItem AS SalesOrderItem,
  _DefectUnion._InspectionLot.DeliveryDocument AS DeliveryDocument,
  _DefectUnion._InspectionLot.SalesOrganization AS SalesOrganization,
  _DefectUnion._InspectionLot.MaterialByCustomer AS MaterialByCustomer,
  cast(_DefectUnion._InspectionLot.MaterialIsBatchManaged as xfeld preserving type ) AS MaterialIsBatchManaged,
  cast (_DefectUnion._InspectionLot.InspLotHasSubsets as xfeld preserving type ) AS InspLotHasSubsets,
  _DefectUnion._InspectionLot.InspectionLotQuantity AS InspectionLotQuantity,
  _DefectUnion._InspectionLot.InspectionLotQuantityUnit AS InspectionLotQuantityUnit,
  _DefectUnion._InspectionLot.MaterialDocument AS MaterialDocument,
  _DefectUnion._InspectionLot.MaterialDocumentItem AS MaterialDocumentItem,
  _DefectUnion._InspectionLot.MaterialDocumentYear AS MaterialDocumentYear,
  _DefectUnion._InspectionLot._InspLotUsageDecision.InspLotUsageDecisionCodeGroup AS InspLotUsageDecisionCodeGroup,
  _DefectUnion._InspectionLot._InspLotUsageDecision.InspectionLotUsageDecisionCode AS InspectionLotUsageDecisionCode,
  _DefectUnion._InspectionLot._InspLotUsageDecision._UsageDecisionCode.UsageDecisionCodeText AS UsageDecisionCodeText,
  _DefectUnion._InspectionLot._InspLotUsageDecision.InspectionLotQualityScore AS InspectionLotQualityScore,
  _DefectUnion._InspectionLot.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _DefectLocationCodeGroup._Text[1:Language=$session.system_language].DefectLocationCodeGroupText AS DefectLocationCodeGroupText,
  _DefectLocationCode._DefectLocationCodeText[1:Language=$session.system_language].DefectLocationCodeText AS DefectLocationCodeText,
  _InspectionLot._InspLotUsageDecision._UsageDecisionCodeGroup AS _UsageDecisionCodeGroup,
  _InspectionLot._InspLotUsageDecision._UsageDecisionCode AS _UsageDecisionCode,
  _DefectUnion.DefectInternalID AS DefectInternalID,
  _DefectUnion.Notification AS Notification,
  _DefectUnion.NotificationType AS NotificationType,
  _DefectUnion.NotificationItem AS NotificationItem,
  _DefectUnion.Defect AS Defect,
  _DefectUnion.NotificationItemExternalID AS NotificationItemExternalID,
  _DefectUnion.InspectionLot AS InspectionLot,
  _DefectUnion.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  _DefectUnion.InspectionCharacteristic AS InspectionCharacteristic,
  _DefectUnion.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  _DefectUnion.MaterialSample AS MaterialSample,
  _DefectUnion.DefectText AS DefectText,
  _DefectUnion.DefectLifecycleStatus AS DefectLifecycleStatus,
  _DefectUnion.DefectCode AS DefectCode,
  _DefectUnion.DefectCodeGroup AS DefectCodeGroup,
  _DefectUnion.DefectCategory AS DefectCategory,
  _DefectUnion.Material AS Material,
  _DefectUnion.Plant AS Plant,
  _DefectUnion.NumberOfDefects AS NumberOfDefects,
  _DefectUnion.CreationDate AS CreationDate,
  _DefectUnion.DefectClass AS DefectClass,
  _DefectUnion.Batch AS Batch,
  _DefectUnion.MainWorkCenterInternalID AS MainWorkCenterInternalID,
  _DefectUnion.WorkCenterTypeCode AS WorkCenterTypeCode,
  _DefectUnion.MainWorkCenterPlant AS MainWorkCenterPlant,
  _DefectUnion.StorageLocation AS StorageLocation,
  _DefectUnion.ProductionSupplyArea AS ProductionSupplyArea,
  _DefectUnion.Warehouse AS Warehouse,
  _DefectUnion.StorageType AS StorageType,
  _DefectUnion.SourceStorageBin AS SourceStorageBin,
  _DefectUnion.CreatedByUser AS CreatedByUser,
  _DefectUnion.CreationTime AS CreationTime,
  _DefectUnion.LastChangedByUser AS LastChangedByUser,
  _DefectUnion.LastChangeDate AS LastChangeDate,
  _DefectUnion.LastChangeTime AS LastChangeTime,
  _DefectUnion.IsDeleted AS IsDeleted,
  _DefectUnion.MainWorkCenter AS MainWorkCenter,
  _DefectUnion.DefectCausedBy AS DefectCausedBy,
  _DefectUnion.DefectLocationCatalog AS DefectLocationCatalog,
  _DefectUnion.DefectLocationCodeGroup AS DefectLocationCodeGroup,
  _DefectUnion.DefectLocationCode AS DefectLocationCode,
  _DefectCalc.NumberOfDefectsCriticality AS NumberOfDefectsCriticality,
  _DefectsWeek.CalendarWeek AS CalendarWeek,
  _DefectsWeek.CalendarYear AS CalendarYear,
  _DefectsWeek._CalendarYear AS _CalendarYear,
  _InspectionLot._InspectionLotType AS _InspectionLotType,
  _InspectionLot._PurchasingOrganization AS _PurchasingOrganization,
  _InspectionLot._Manufacturer AS _Manufacturer,
  _InspectionLot._InspectionLotOrigin AS _InspectionLotOrigin,
  _InspectionLot._ManufacturerPartNmbr AS _ManufacturerPartNmbr,
  _InspectionLot._Supplier AS _Supplier,
  _InspectionLot._Customer AS _Customer,
  _InspectionLot._SalesOrganization AS _SalesOrganization,
  _InspectionLot._InspectionLotQuantityUnit AS _InspectionLotQuantityUnit,
  _Plant.PlantName AS PlantName,
  _WorkCenterBySemanticKey.WorkCenter AS WorkCenter
FROM I_DefectUnion AS _DefectUnion
LEFT OUTER JOIN I_CalendarDate AS _DefectsWeek ON CreationDate = _DefectsWeek.CalendarDate  -- association [1..1]
LEFT OUTER JOIN C_Plantvaluehelp AS _Plant ON Plant = _Plant.Plant  -- association [1..1]
LEFT OUTER JOIN C_InspLotSuplrValHelp AS _SupplierVH ON supplier = _SupplierVH.Supplier  -- association [0..1]
LEFT OUTER JOIN C_InspLotCustValHelp AS _CustomerVH ON customer = _CustomerVH.Customer  -- association [1..1]
LEFT OUTER JOIN C_InsLotHasUsgeDcsnT AS _InspLotHasUsgeDcsn ON InspectionLotHasUsageDecision = _InspLotHasUsgeDcsn.InspectionLotHasUsageDecision  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenterBySemanticKey ON MainWorkCenterInternalID = _WorkCenterBySemanticKey.WorkCenterInternalID AND MainWorkCenterPlant = _WorkCenterBySemanticKey.Plant  -- association [0..1]
LEFT OUTER JOIN C_DefectCalc AS _DefectCalc ON DefectInternalID = _DefectCalc.DefectInternalID  -- association [1..1]
LEFT OUTER JOIN I_InspectionOperation AS _InspectionOperation ON InspectionLot = _InspectionOperation.InspectionLot AND InspPlanOperationInternalID = _InspectionOperation.InspPlanOperationInternalID  -- association [0..1]
LEFT OUTER JOIN C_DefectMngCharcs AS _DefectMngCharcs ON InspectionLot = _DefectMngCharcs.InspectionLot AND InspPlanOperationInternalID = _DefectMngCharcs.InspPlanOperationInternalID AND InspectionCharacteristic = _DefectMngCharcs.InspectionCharacteristic  -- association [0..1]
LEFT OUTER JOIN C_DefectMngCharacteristicsSbst AS _DefectMngCharacteristicsSbst ON InspectionLot = _DefectMngCharacteristicsSbst .InspectionLot AND InspPlanOperationInternalID = _DefectMngCharacteristicsSbst .InspPlanOperationInternalID AND InspectionSubsetInternalID = _DefectMngCharacteristicsSbst .InspectionSubsetInternalID AND MaterialSample = _DefectMngCharacteristicsSbst .MaterialSample AND InspectionCharacteristic = _DefectMngCharacteristicsSbst .InspectionCharacteristic  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderVH AS _MfgOrderVH ON ManufacturingOrder = _MfgOrderVH.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN I_StorageLocation AS _StorageLocation ON Plant = _StorageLocation.Plant AND StorageLocation = _StorageLocation.StorageLocation  -- association [0..1]
LEFT OUTER JOIN I_ProductionSupplyArea AS _ProductionSupplyArea ON ProductionSupplyArea = _ProductionSupplyArea.ProductionSupplyArea AND Plant = _ProductionSupplyArea.Plant  -- 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_StorageType_2 AS _EWM_SourceStorageType ON Warehouse = _EWM_SourceStorageType.EWMWarehouse AND StorageType = _EWM_SourceStorageType.EWMStorageType  -- association [0..1]
LEFT OUTER JOIN I_EWM_StorageBin_2 AS _EWM_SourceStorageBin ON Warehouse = _EWM_SourceStorageBin.EWMWarehouse AND SourceStorageBin = _EWM_SourceStorageBin.EWMStorageBin  -- association [0..1]
LEFT OUTER JOIN C_DefectMngInspectionSubset AS _DefectMngInspectionSubset ON InspectionLot = _DefectMngInspectionSubset .InspectionLot AND InspPlanOperationInternalID = _DefectMngInspectionSubset .InspPlanOperationInternalID AND InspectionSubsetInternalID = _DefectMngInspectionSubset .InspectionSubsetInternalID  -- association [0..1]
LEFT OUTER JOIN I_DefectStatusText AS _DefectStatusText ON DefectLifecycleStatus = _DefectStatusText.DefectLifecycleStatus  -- association [0..*]
LEFT OUTER JOIN I_DefectCategoryText AS _DefectCategoryText ON DefectCategory = _DefectCategoryText.DefectCategory  -- association [0..*]
LEFT OUTER JOIN I_DefectCausedBy AS _DefectCausedBy ON DefectCausedBy = _DefectCausedBy.DefectCausedBy  -- association [0..1]
LEFT OUTER JOIN I_DefectCausedByText AS _DefectCausedByText ON DefectCausedBy = _DefectCausedByText.DefectCausedBy  -- association [1..*]
;