C_ProductionOrderHold

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_ProductionOrderHold.
-- 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: CMPEPRODORDHOLD

CREATE VIEW C_ProductionOrderHold AS
SELECT
  Hold.ProductionHold AS ProductionHold,
  Hold.ManufacturingOrder AS ManufacturingOrder,
  Hold.ManufacturingOrderType AS ManufacturingOrderType,
  Hold.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  Hold.Material AS Material,
  Hold.ProductionPlant AS ProductionPlant,
  Hold.ProductionHoldObjectType AS ProductionHoldObjectType,
  ProductionHoldAction.MfgActionReasonCodeGroupCtlg AS MfgActionReasonCodeGroupCtlg,
  ProductionHoldAction.MfgActionReasonCodeGroup AS MfgActionReasonCodeGroup,
  ProductionHoldAction.ManufacturingActionReasonCode AS ManufacturingActionReasonCode,
  ProductionHoldAction._MfgActionReasonCode._Text[1: Language=$session.system_language].MfgActionReasonCodeName AS MfgActionReasonCodeName
FROM P_MfgOrderHeaderHoldUnionBasic AS Hold
INNER JOIN I_ProductionHoldAction AS ProductionHoldAction ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_Material AS _Material ON Material = _Material.Material  -- association [0..1]
LEFT OUTER JOIN I_Plant AS _ProductionPlant ON ProductionPlant = _ProductionPlant.Plant  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderCategory AS _MfgOrderCategory ON ManufacturingOrderCategory = _MfgOrderCategory.ManufacturingOrderCategory  -- association [1..1]
LEFT OUTER JOIN I_MfgOrderType AS _MfgOrderType ON ManufacturingOrderType = _MfgOrderType.ManufacturingOrderType  -- association [1..1]
LEFT OUTER JOIN I_ProductionHoldObjectType AS _ProductionHoldObjectType ON ProductionHoldObjectType = _ProductionHoldObjectType.ProductionHoldObjectType  -- association [1..1]
;