C_MfgOrderDefectRecord

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_MfgOrderDefectRecord.
-- 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: CMFGORDDEFREC

CREATE VIEW C_MfgOrderDefectRecord AS
SELECT
  Defect.DefectInternalID AS DefectInternalID,
  _Equip.SerialNumber AS SerialNumber,
  Defect,
  Defect.DefectCategory AS DefectCategory,
  Defect.CreatedByUser AS CreatedByUser,
  Defect.CreationDate AS CreationDate,
  Defect.LastChangedByUser AS LastChangedByUser,
  Defect.LastChangeDate AS LastChangeDate,
  DefectText,
  Defect.DefectCodeCatalog AS DefectCodeCatalog,
  Defect.DefectCodeGroup AS DefectCodeGroup,
  Defect.DefectCode AS DefectCode,
  Defect.DefectCodeVersion AS DefectCodeVersion,
  DefectObjectCodeCatalog,
  DefectObjectCodeGroup,
  DefectObjectCode,
  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,
  _OpActyInstceNtwkElmntBasic.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  _OpActyInstceNtwkElmntBasic.OpActyNtwkInstance AS OpActyNtwkInstance,
  _OpActyInstceNtwkElmntBasic.OpActyNtwkElement AS OpActyNtwkElement,
  cast(_MfgOrderOperationBasic.ManufacturingOrderOperation as manufacturingorderoperation preserving type) AS ManufacturingOrderOperation,
  _MfgOrderOperationBasic.MfgOrderOperationText AS MfgOrderOperationText,
  _MfgOrderOperationBasic.ManufacturingOrder AS ManufacturingOrder,
  _MfgOrderOperationBasic._MfgOrder.ManufacturingOrderText AS ManufacturingOrderText,
  Defect.ProductionOrderOpActyVers AS ProductionOrderOpActyVers,
  Defect.Batch AS Batch,
  Defect.DefectiveSingleUnit AS DefectiveSingleUnit,
  Defect.ProductionOrder AS ProductionOrder,
  Defect.OrderInternalID AS OrderInternalID,
  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.InspectionLot AS InspectionLot,
  Defect.CatalogProfile AS CatalogProfile,
  Defect.ChangedDateTime AS ChangedDateTime,
  Defect.DefectLifecycleStatus AS DefectLifecycleStatus,
  _DefectStatus._DefectStatusText[1: Language=$session.system_language].DefectLifecycleStatusText AS DefectLifecycleStatusText,
  Defect.ProblemAnalysisStatus AS ProblemAnalysisStatus,
  Defect.QualityIssueReference AS QualityIssueReference,
  Defect.MasterLanguage AS MasterLanguage,
  _NotificationItem.Notification AS Notification,
  _NotificationItem._Notification.NotificationText AS NotificationText,
  _NotificationItem.NotificationItem AS NotificationItem,
  _DefectDecision.MfgDefectDecision AS MfgDefectDecision,
  _DefectDecision._DefectDecisionVH._Text[1: Language=$session.system_language].MfgDefectDecisionName AS MfgDefectDecisionName,
  _Sitn.SitnNumberOfInstances AS SitnNumberOfInstances,
  Defect.BOMItemInstanceUUID AS BOMItemInstanceUUID,
  Defect.ProducedMaterial AS ProducedMaterial,
  Defect.ProducedSerialNumber AS ProducedSerialNumber
FROM I_Defect_TP AS Defect
LEFT OUTER JOIN I_NotificationItem AS _NotificationItem ON _NotificationItem.ReferencedDefect = Defect.DefectInternalID AND _NotificationItem.IsDeleted = ''  -- association [0..1]
LEFT OUTER JOIN I_SitnInstceIndicator AS _Sitn ON _Sitn.SitnInstceAnchorObjectKey = Defect AND _Sitn.SitnDefAnchorObject = 'Defect'  -- association [0..1]
LEFT OUTER JOIN I_Equipment AS _Equip ON Defect.Equipment = _Equip.Equipment  -- association [0..1]
LEFT OUTER JOIN I_InspectionSubset AS _InspectionSubset ON _InspectionSubset.InspectionLot = InspectionLot AND _InspectionSubset.InspPlanOperationInternalID = InspPlanOperationInternalID AND _InspectionSubset.InspectionSubsetInternalID = InspectionSubsetInternalID  -- association [0..1]
LEFT OUTER JOIN I_ShopFloorItem AS _ShopFloorItem ON Defect.Material = _ShopFloorItem.Material AND serialnumber = _ShopFloorItem.SerialNumber  -- association [0..1]
LEFT OUTER JOIN I_MfgOrdDefectDecision AS _DefectDecision ON _DefectDecision.Notification = DefectInternalID AND _DefectDecision.NotificationItem = '0000'  -- association [0..1]
LEFT OUTER JOIN I_DefectLongTextTP AS _DefectLongTextTP ON DefectInternalID = _DefectLongTextTP.DefectInternalID  -- association [0..*]
LEFT OUTER JOIN I_MfgOrderOperation AS _MfgOrderOperation ON _MfgOrderOperation.OrderInternalBillOfOperations = OrderInternalID AND _MfgOrderOperation.OrderIntBillOfOperationsItem = InspPlanOperationInternalID  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderOperationBasic AS _MfgOrderOperationBasic ON _MfgOrderOperationBasic.OrderInternalBillOfOperations = OrderInternalID AND _MfgOrderOperationBasic.OrderIntBillOfOperationsItem = InspPlanOperationInternalID  -- association [1..1]
LEFT OUTER JOIN I_OperationActivityText AS _OperationActivityText ON ProductionOrderOperationActy = _OperationActivityText.OperationActivity AND ProductionOrderOpActyVers = _OperationActivityText.OperationActyVersionCounter AND _OperationActivityText.Language = $session.system_language  -- association [1..1]
LEFT OUTER JOIN I_OpActyInstceOpActyNtwkElmnt AS _OpActyInstceOpActyNtwkElmnt ON _OpActyInstceOpActyNtwkElmnt.ManufacturingOrder = ProductionOrder AND _OpActyInstceOpActyNtwkElmnt.OrderOperationInternalID = InspPlanOperationInternalID AND _OpActyInstceOpActyNtwkElmnt.OperationActivity = ProductionOrderOperationActy AND _OpActyInstceOpActyNtwkElmnt.OperationActyVersionCounter = ProductionOrderOpActyVers  -- association [1..1]
LEFT OUTER JOIN I_OpActyInstceNtwkElmntBasic AS _OpActyInstceNtwkElmntBasic ON _OpActyInstceNtwkElmntBasic.ManufacturingOrder = ProductionOrder AND _OpActyInstceNtwkElmntBasic.OrderOperationInternalID = InspPlanOperationInternalID AND _OpActyInstceNtwkElmntBasic.OperationActivity = ProductionOrderOperationActy AND _OpActyInstceNtwkElmntBasic.OperationActyVersionCounter = ProductionOrderOpActyVers  -- association [1..1]
LEFT OUTER JOIN I_MfgActionReasonCode AS _MfgActionReasonCode ON _MfgActionReasonCode.MfgActionReasonCodeGroupCtlg = DefectCodeCatalog AND _MfgActionReasonCode.MfgActionReasonCodeGroup = DefectCodeGroup AND _MfgActionReasonCode.ManufacturingActionReasonCode = DefectCode AND _MfgActionReasonCode.Version = DefectCodeVersion  -- association [0..1]
LEFT OUTER JOIN I_DefectCodeText AS _DefectCodeText ON DefectCodeGroup = _DefectCodeText.DefectCodeGroup AND DefectCode = _DefectCodeText.DefectCode AND _DefectCodeText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN C_ReworkBOOVersionDefectCode AS _ReworkBOOVersionDefectCode ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.MaterialName  -- association [0..*]
;