I_ProductionHoldBasic

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_ProductionHoldBasic.
-- 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: IMPEPRODNHLDBSC

CREATE VIEW I_ProductionHoldBasic AS
SELECT
  hold_nmbr AS ProductionHold,
  hold_object_type AS ProductionHoldObjectType,
  werks AS ProductionPlant,
  matnr AS Material,
  arbid AS WorkCenterInternalID,
  cast('A ' as cr_objty preserving type) AS WorkCenterTypeCode,
  aufnr AS ManufacturingOrder,
  aufpl AS OrderInternalID,
  aplzl AS OrderOperationInternalID,
  sfi_id AS ShopFloorItem,
  sfi_at_oai_group_id AS OperationActivitySFIGroup,
  oan_instance_id AS OpActyNtwkInstance,
  oan_element_number AS OpActyNtwkElement,
  started_at AS ProductionHoldStartDateTime,
  ended_at AS ProductionHoldEndDateTime,
  gross_duration AS HoldDurationInSeconds,
  net_calendar_duration AS CalendarBasedNetDurnInSeconds,
  net_work_center_duration AS WorkCenterBsdNetDurnInSeconds,
  qmnum AS DefectInternalID,
  Notification,
  notification_item AS NotificationItem,
  is_applied_for_order_chg AS ProdnHoldIsAppldForOrderChg
FROM mpe_exec_hold AS hold
LEFT OUTER JOIN I_ProductionHoldObjectType AS _ProductionHoldObjectType ON ProductionHoldObjectType = _ProductionHoldObjectType.ProductionHoldObjectType  -- association [1..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_WorkCenter AS _WorkCenter ON WorkCenterTypeCode = _WorkCenter.WorkCenterTypeCode AND WorkCenterInternalID = _WorkCenter.WorkCenterInternalID  -- association [0..1]
LEFT OUTER JOIN I_MfgOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN I_OrdInternalBillOfOperations AS _OrderInternalID ON OrderInternalID = _OrderInternalID.OrderInternalBillOfOperations  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderOperation AS _MfgOrderOperation ON OrderInternalID = _MfgOrderOperation.OrderInternalBillOfOperations AND OrderOperationInternalID = _MfgOrderOperation.OrderIntBillOfOperationsItem  -- association [0..1]
LEFT OUTER JOIN I_ShopFloorItem AS _ShopFloorItem ON ShopFloorItem = _ShopFloorItem.ShopFloorItem  -- association [0..1]
LEFT OUTER JOIN I_ProductionHoldStatus AS _ProductionHoldStatus ON ProductionHoldStatus = _ProductionHoldStatus.ProductionHoldStatus  -- association [1..1]
LEFT OUTER JOIN I_OpActyNtwkInstance AS _OpActyNtwkInstance ON OpActyNtwkInstance = _OpActyNtwkInstance.OpActyNtwkInstance  -- association [0..1]
LEFT OUTER JOIN I_OperationActivityInstance AS _OperationActivityInstance ON OpActyNtwkInstance = _OperationActivityInstance.OpActyNtwkInstance AND OpActyNtwkElement = _OperationActivityInstance.OpActyNtwkElement  -- association [0..1]
LEFT OUTER JOIN I_Defect AS _Defect ON DefectInternalID = _Defect.DefectInternalID  -- association [0..1]
LEFT OUTER JOIN I_Notification AS _Notification ON Notification = _Notification.Notification  -- association [0..1]
LEFT OUTER JOIN I_NotificationItem AS _NotificationItem ON Notification = _NotificationItem.Notification AND NotificationItem = _NotificationItem.NotificationItem  -- association [0..1]
LEFT OUTER JOIN I_OperationActivitySFIGroup AS _OperationActivitySFIGroup ON OperationActivitySFIGroup = _OperationActivitySFIGroup.OperationActivitySFIGroup  -- association [0..1]
;