P_ProductionHoldTP

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 P_ProductionHoldTP.
-- 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: PMPEPRODHOLDTP

CREATE VIEW P_ProductionHoldTP AS
SELECT
  ProductionHold.ProductionHold AS ProductionHold,
  cast(ProductionHold.ProductionHoldObjectType as mpe_manage_hold_object_type preserving type ) AS ProductionHoldObjectType,
  ProductionHold.ProductionPlant AS ProductionPlant,
  ProductionHold.Material AS Material,
  ProductionHold.WorkCenterInternalID AS WorkCenterInternalID,
  ProductionHold.WorkCenterTypeCode AS WorkCenterTypeCode,
  cast(coalesce(ProductionHold._WorkCenter.WorkCenter, '') as arbpl preserving type ) AS WorkCenter,
  ProductionHold._WorkCenter._Text[1: Language=$session.system_language].WorkCenterText AS WorkCenterText,
  ProductionHold.ManufacturingOrder AS ManufacturingOrder,
  ProductionHold.OrderInternalID AS OrderInternalID,
  ProductionHold.OrderOperationInternalID AS OrderOperationInternalID,
  ProductionHold.ManufacturingOrderSequence AS ManufacturingOrderSequence,
  ProductionHold.ManufacturingOrderOperation AS ManufacturingOrderOperation,
  ProductionHold.OperationText AS OperationText,
  ProductionHold.ShopFloorItem AS ShopFloorItem,
  ShopFloorItem.SerialNumber AS SerialNumber,
  ProductionHold.OpActyNtwkInstance AS OpActyNtwkInstance,
  ProductionHold.OpActyNtwkElement AS OpActyNtwkElement,
  ProductionHold.OperationActivitySFIGroup AS OperationActivitySFIGroup,
  ProductionHold._OperationActivitySFIGroup.OpActySFIGroupName AS OpActySFIGroupName,
  ProductionHold.OperationActivityName AS OperationActivityName,
  ProductionHold.OpActyNtwkElementExternalID AS OpActyNtwkElementExternalID,
  ProductionHold.ProductionHoldStartDateTime AS ProductionHoldStartDateTime,
  ProductionHold.ProductionHoldEndDateTime AS ProductionHoldEndDateTime,
  ProductionHold.ProductionHoldStatus AS ProductionHoldStatus,
  _ProductionHoldStatus._Text[1: Language=$session.system_language].ProductionHoldStatusName AS ProductionHoldStatusName,
  ProductionHold.HoldDurationInSeconds AS HoldDurationInSeconds,
  ProductionHold.CalendarBasedNetDurnInSeconds AS CalendarBasedNetDurnInSeconds,
  ProductionHold.WorkCenterBsdNetDurnInSeconds AS WorkCenterBsdNetDurnInSeconds,
  cast(ProductionHoldApply.MfgActionReasonCodeGroupCtlg as mpe_hold_apply_catalog preserving type ) AS ProdnHoldApplyRsnCodeGrpCtlg,
  cast(ProductionHoldApply.MfgActionReasonCodeGroup as mpe_hold_apply_codegrp preserving type ) AS ProdnHoldApplyRsnCodeGroup,
  cast(ProductionHoldApply.ManufacturingActionReasonCode as mpe_hold_apply_code preserving type ) AS ProductionHoldApplyReasonCode,
  ProductionHoldApply._MfgActionReasonCode._Text[1: Language=$session.system_language].MfgActionReasonCodeName AS ProdnHoldApplyReasonCodeName,
  cast(ProductionHoldApply.LastChangedByUser as mpe_hold_apply_lchg_user preserving type ) AS ProdnHoldApplyLastChgdByUsr,
  cast(ProductionHoldApply.LastChangeDateTime as mpe_hold_apply_lchg_tstmpl preserving type ) AS ProdnHoldApplyLastChgdDteTme,
  ProductionHoldApplyNote.MfgExecutionDocumentNote AS ProductionHoldApplyNote,
  cast(ProductionHoldRelease.MfgActionReasonCodeGroupCtlg as mpe_hold_release_catalog preserving type ) AS ProdnHoldRelRsnCodeGrpCtlg,
  cast(ProductionHoldRelease.MfgActionReasonCodeGroup as mpe_hold_release_codegrp preserving type ) AS ProdnHoldRelRsnCodeGroup,
  cast(ProductionHoldRelease.ManufacturingActionReasonCode as mpe_hold_release_code preserving type ) AS ProductionHoldRelReasonCode,
  cast(ProductionHoldRelease.LastChangedByUser as mpe_hold_release_lchg_user preserving type ) AS ProdnHoldReleaseLastChgdByUsr,
  cast(ProductionHoldRelease.LastChangeDateTime as mpe_hold_release_lchg_tstmpl preserving type ) AS ProdnHoldReleaseLastChgdDteTme,
  ProductionHoldReleaseNote.MfgExecutionDocumentNote AS ProductionHoldReleaseNote,
  ProductionHold.ProdnHoldIsAppldForOrderChg AS ProdnHoldIsAppldForOrderChg,
  ProductionHold._ProductionHoldObjectType AS _ProductionHoldObjectType,
  ProductionHold._ProductionPlant AS _ProductionPlant,
  ProductionHold._WorkCenter AS _WorkCenter,
  ProductionHold._ShopFloorItem AS _ShopFloorItem,
  ProductionHold._OpActyNtwkInstance AS _OpActyNtwkInstance,
  ProductionHold._OperationActivityInstance AS _OperationActivityInstance,
  ProductionHold._OperationActivitySFIGroup AS _OperationActivitySFIGroup
FROM P_ProductionHoldEnhcd AS ProductionHold
INNER JOIN I_ProductionHoldAction AS ProductionHoldApply ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ProductionHoldStatus AS _ProductionHoldStatus ON ProductionHoldStatus = _ProductionHoldStatus.ProductionHoldStatus  -- association [1..1]
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_MfgOrder AS _MfgOrder ON ManufacturingOrder = _MfgOrder.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN I_MfgOrderOperation AS _MfgOrderOperation ON OrderInternalID = _MfgOrderOperation.OrderInternalBillOfOperations AND OrderOperationInternalID = _MfgOrderOperation.OrderIntBillOfOperationsItem  -- association [0..1]
LEFT OUTER JOIN I_OrderOperationBasic AS _OrderOperationBasic ON OrderInternalID = _OrderOperationBasic.OrderInternalID AND OrderOperationInternalID = _OrderOperationBasic.OrderOperationInternalID  -- association [0..1]
LEFT OUTER JOIN I_WorkCenterBySemanticKey AS _WorkCenterBySemanticKey ON ProductionPlant = _WorkCenterBySemanticKey.Plant AND WorkCenter = _WorkCenterBySemanticKey.WorkCenter  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingActionSetting AS _ReleaseActionSetting ON ProductionPlant = _ReleaseActionSetting.Plant AND MfgObjectType = _ReleaseActionSetting.MfgObjectType AND ( ( ProductionHoldObjectType = '1' AND _ReleaseActionSetting.MfgProcgExecAction = 'SAP_RELEASE_MATERIAL_HOLD' ) OR( ProductionHoldObjectType = '2' AND _ReleaseActionSetting.MfgProcgExecAction = 'SAP_RELEASE_WC_HOLD' ) OR( ProductionHoldObjectType = '3' AND _ReleaseActionSetting.MfgProcgExecAction = 'SAP_RELEASE_ORDER_HOLD' ) OR( ProductionHoldObjectType = '4' AND _ReleaseActionSetting.MfgProcgExecAction = 'SAP_RELEASE_OPERATION_HOLD' ) OR( ProductionHoldObjectType = '5' AND _ReleaseActionSetting.MfgProcgExecAction = 'SAP_RELEASE_SFI_HOLD' ) OR( ProductionHoldObjectType = '6' AND _ReleaseActionSetting.MfgProcgExecAction = 'SAP_RELEASE_OA_HOLD' ) )  -- association [0..1]
LEFT OUTER JOIN I_ManufacturingActionSetting AS _ApplyActionSetting ON ProductionPlant = _ApplyActionSetting.Plant AND MfgObjectType = _ApplyActionSetting.MfgObjectType AND ( ( ProductionHoldObjectType = '1' AND _ApplyActionSetting.MfgProcgExecAction = 'SAP_APPLY_MATERIAL_HOLD' ) OR( ProductionHoldObjectType = '2' AND _ApplyActionSetting.MfgProcgExecAction = 'SAP_APPLY_WC_HOLD' ) OR( ProductionHoldObjectType = '3' AND _ApplyActionSetting.MfgProcgExecAction = 'SAP_APPLY_ORDER_HOLD' ) OR( ProductionHoldObjectType = '4' AND _ApplyActionSetting.MfgProcgExecAction = 'SAP_APPLY_OPERATION_HOLD' ) OR( ProductionHoldObjectType = '5' AND _ApplyActionSetting.MfgProcgExecAction = 'SAP_APPLY_SFI_HOLD' ) OR( ProductionHoldObjectType = '6' AND _ApplyActionSetting.MfgProcgExecAction = 'SAP_APPLY_OA_HOLD' ) )  -- 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_NotificationItem AS _ReferenceNotificationItem ON ProductionHold.DefectInternalID = _ReferenceNotificationItem.ReferencedDefect AND ProductionHold.DefectInternalID <> '' AND _ReferenceNotificationItem.IsDeleted = ''  -- association [0..1]
LEFT OUTER JOIN I_NotificationItem AS _NotificationItemRefDefect ON ProductionHold.Notification = _NotificationItemRefDefect.Notification AND ProductionHold.NotificationItem = _NotificationItemRefDefect.NotificationItem  -- association [0..1]
;