I_MfgOrderDefectForSituations

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_MfgOrderDefectForSituations.
-- 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: IMFGDEFECTSIT

CREATE VIEW I_MfgOrderDefectForSituations AS
SELECT
  DefectInternalID,
  _Equip.SerialNumber AS SerialNumber,
  Defect.Defect AS Defect,
  DefectCategory,
  CreatedByUser,
  CreationDate,
  LastChangedByUser,
  LastChangeDate,
  DefectText,
  DefectCodeCatalog,
  DefectCodeGroup,
  DefectCode,
  DefectCodeVersion,
  DefectObjectCodeCatalog,
  DefectObjectCodeGroup,
  DefectObjectCode,
  DefectObjectCodeVersion,
  DefectCauseCodeCatalog,
  DefectCauseCodeGroup,
  DefectCauseCode,
  DefectCauseCodeVersion,
  DefectiveQuantityUnit,
  ProductionOrderOperationActy,
  _OpActyInstceNtwkElmntBasic.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  _OpActyInstceNtwkElmntBasic.OpActyNtwkInstance AS OpActyNtwkInstance,
  _OpActyInstceNtwkElmntBasic.OpActyNtwkElement AS OpActyNtwkElement,
  _MfgOrderOperationBasic.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  _MfgOrderOperationBasic.MfgOrderOperationText AS MfgOrderOperationText,
  _MfgOrderOperationBasic.ManufacturingOrder AS ManufacturingOrder,
  _MfgOrderOperationBasic._MfgOrder.ManufacturingOrderText AS ManufacturingOrderText,
  ProductionOrderOpActyVers,
  Batch,
  DefectiveSingleUnit,
  ProductionOrder,
  OrderInternalID,
  CreationTime,
  LastChangeTime,
  DefectClass,
  NumberOfDefects,
  InspPlanOperationInternalID,
  InspectionCharacteristic,
  InspectionSubsetInternalID,
  MaterialSample,
  WorkCenterTypeCode,
  MainWorkCenterInternalID,
  MainWorkCenterPlant,
  MainWorkCenter,
  Equipment,
  FunctionalLocation,
  DefectOrigin,
  Material,
  Plant,
  InspectionLot,
  CatalogProfile,
  ChangedDateTime,
  DefectLifecycleStatus,
  cast(LOWER(_DefectStatus._DefectStatusText[1:Language = $session.system_language].DefectLifecycleStatusText) as char40) AS DefectLifecycleStatusText,
  ProblemAnalysisStatus,
  QualityIssueReference,
  MasterLanguage
FROM I_Defect AS Defect
LEFT OUTER JOIN I_SitnInstceIndicator AS _SitnInstceIndicator ON _SitnInstceIndicator.SitnInstceAnchorObjectKey = Defect AND _SitnInstceIndicator.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_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..*]
;