C_MfgOrderDefect

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_MfgOrderDefect.
-- 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: CMFGORDDEF

CREATE VIEW C_MfgOrderDefect AS
SELECT
  Defect.DefectInternalID AS DefectInternalID,
  Defect.NotificationItem AS NotificationItem,
  Defect.Notification AS Notification,
  Defect.Defect AS Defect,
  ShopFloorItem.SerialNumber AS SerialNumber,
  Defect.DefectCategory AS DefectCategory,
  Defect._DefectCategory._Text[1: Language=$session.system_language].DefectCategoryText AS DefectCategoryText,
  Defect.NotificationType AS NotificationType,
  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._DefectCodeGroup._Text[1: Language=$session.system_language].InspSpecAddlCodeGroupText AS DefectCodeGroupText,
  Defect.DefectCode AS DefectCode,
  Defect._DefectCode._Text[1: Language=$session.system_language].InspectionCodeText AS DefectCodeText,
  Defect.DefectiveQuantity AS DefectiveQuantity,
  Defect.DefectiveQuantityUnit AS DefectiveQuantityUnit,
  Defect.DefectIsCreatedAutomatically AS DefectIsCreatedAutomatically,
  Defect.ProductionOrderOperationActy AS ProductionOrderOperationActy,
  Defect.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  _OperationActivityText.OperationActivityName AS OperationActivityName,
  Defect.OpActyNtwkInstance AS OpActyNtwkInstance,
  Defect.OpActyNtwkElement AS OpActyNtwkElement,
  cast(_MfgOrderOperationBasic.ManufacturingOrderOperation as vdm_vornr preserving type) AS ManufacturingOrderOperation,
  _MfgOrderOperationBasic.MfgOrderOperationText AS MfgOrderOperationText,
  Defect.ProductionOrderOpActyVers AS ProductionOrderOpActyVers,
  Defect.ProductionOrder AS ProductionOrder,
  Defect.OrderInternalID AS OrderInternalID,
  Defect.CreationTime AS CreationTime,
  Defect.LastChangeTime AS LastChangeTime,
  Defect.InspPlanOperationInternalID AS InspPlanOperationInternalID,
  Defect.InspectionCharacteristic AS InspectionCharacteristic,
  Defect.InspectionSubsetInternalID AS InspectionSubsetInternalID,
  Defect.DefectiveSingleUnit AS DefectiveSingleUnit,
  Defect.ProducedMaterial AS ProducedMaterial,
  _ProductText.MaterialName AS ProducedMaterialName,
  Defect.ProducedSerialNumber AS ProducedSerialNumber,
  Defect.Batch AS Batch,
  Defect.ShopFloorItem AS ShopFloorItem,
  ShopFloorStatus.OperationActivitySFIGroup AS OperationActivitySFIGroup,
  Defect.Equipment AS Equipment,
  Defect.IsDeleted AS IsDeleted,
  Defect.Material AS Material,
  _MaterialText.MaterialName AS MaterialName,
  Defect.Plant AS Plant,
  Defect.InspectionLot AS InspectionLot,
  Defect.ChangedDateTime AS ChangedDateTime,
  Defect.DefectLifecycleStatus AS DefectLifecycleStatus,
  Defect.NotifProcessingPhase AS NotifProcessingPhase,
  Defect._DefectStatus._DefectStatusText[1: Language=$session.system_language].DefectLifecycleStatusText AS DefectLifecycleStatusText,
  Defect._NotifProcessingPhase._Text[1: Language=$session.system_language].NotifProcessingPhaseDesc AS NotifProcessingPhaseDesc,
  Defect.NotificationText AS NotificationText,
  Defect.MfgDefectDecision AS MfgDefectDecision,
  Defect.MfgDefectDecisionName AS MfgDefectDecisionName,
  _Sitn.SitnNumberOfInstances AS SitnNumberOfInstances,
  Defect.WorkCenterTypeCode AS WorkCenterTypeCode,
  Defect.WorkCenterInternalID AS MainWorkCenterInternalID,
  Defect.MainWorkCenter AS MainWorkCenter,
  Defect.MainWorkCenterPlant AS MainWorkCenterPlant,
  Defect.BillOfMaterialCategory AS BillOfMaterialCategory,
  Defect.BillOfMaterialInternalID AS BillOfMaterialInternalID,
  Defect.BillOfMaterialVariant AS BillOfMaterialVariant,
  Defect.BillOfMaterialItemNodeNumber AS BillOfMaterialItemNodeNumber,
  Defect.BOMItemInternalChangeCount AS BOMItemInternalChangeCount,
  BillOfMaterialItem.InheritedNodeNumberForBOMItem AS InheritedNodeNumberForBOMItem,
  BillOfMaterialItem.BillOfMaterialVersion AS BillOfMaterialVersion,
  cast(DigitalMockUpCharcs.DgtlMockUpCharcsValue as dmu_tmxguid_char32) AS OriglDgtlMockUpCharcsCharUUID,
  Defect.BOMItemInstanceUUID AS BOMItemInstanceUUID,
  cast('' as vmp_ref_des) AS ReferenceDesignatorName,
  Defect.BatchBySupplier AS BatchBySupplier,
  Defect.ManufacturerSerialNumber AS ManufacturerSerialNumber,
  _MfgExecDocumentNote.MfgExecutionDocumentNote AS MfgExecutionDocumentNote,
  _MfgOrderOperationBasic.ManufacturingOrder AS ManufacturingOrder,
  LogisticsOrder.OrderDescription AS ManufacturingOrderText,
  LogisticsOrder.ProdnProcgIsFlexible AS ProdnProcgIsFlexible,
  cast(' ' as qcode preserving type) AS ManufacturingActionReasonCode,
  cast('' as mpe_hold_object_type) AS ProductionHoldObjectType,
  cast('' as rsnum) AS Reservation,
  cast('' as rspos) AS ReservationItem,
  cast('' as rsart preserving type) AS RecordType,
  cast(' ' as werks_d preserving type) AS OrderHeaderProductionPlant,
  cast(' ' as mpe_rtg_assigned_to_oa preserving type) AS OpActyAssignmentExists,
  cast('' as objky) AS LinkedSAPObjectKey,
  cast('' as mpe_mrs_designator_name) AS MfgRefStrucItmRefDsgntrName,
  cast( '' as stvkn ) AS OriglBOMItemInheritedNodeNmbr,
  Defect._Notification AS _Notification,
  Defect._DefectStatus AS _DefectStatus,
  Defect._InspectionLot AS _InspectionLot,
  Defect._CreatedByUserContactCard AS _CreatedByUserContactCard,
  Defect._DefectCode AS _DefectCode,
  Defect._DefectCodeCatalog AS _DefectCodeCatalog,
  Defect._DefectCodeGroup AS _DefectCodeGroup,
  Defect._ProducedMaterial AS _ProducedMaterial,
  Defect._LastChangedByUserContactCard AS _LastChangedByUserContactCard,
  Defect._NotifProcessingPhase AS _NotifProcessingPhase,
  Defect._DefectCategory AS _DefectCategory,
  Defect._DefectDecisionVH AS _DefectDecisionVH,
  _MfgOrderOperationBasic._MfgOrder AS _MfgOrder,
  Defect._DefectCodeText AS _DefectCodeText
FROM I_MfgOrderDefectRecord AS Defect
LEFT OUTER JOIN I_SitnInstceIndicator AS _Sitn ON _Sitn.SitnInstceAnchorObjectKey = Defect AND _Sitn.SitnDefAnchorObject = 'Defect'  -- 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 C_ReworkBOOVersionDefectCode AS _ReworkBOOVersionDefectCode ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_MaterialText AS _MaterialText ON Material = _MaterialText.Material AND _MaterialText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MaterialText AS _ProductText ON ProducedMaterial = _ProductText.Material AND _ProductText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_MfgExecDocumentNote AS _MfgExecDocumentNote ON /* condition not available in parsed metadata */  -- association [0..1]
;