C_MfgOrderSplitOrderDetail

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_MfgOrderSplitOrderDetail.
-- 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: CMFGORDEROFSPLIT

CREATE VIEW C_MfgOrderSplitOrderDetail AS
SELECT
  MfgOrderSplitOrder.ManufacturingOrder AS ManufacturingOrder,
  MfgOrderSplitOrder.MfgOrderSplitParentOrder AS MfgOrderSplitParentOrder,
  MfgOrderSplitOrder.MfgOrderSplitLeadingOrder AS MfgOrderSplitLeadingOrder,
  ManufacturingOrder.ProductionPlant AS ProductionPlant,
  ManufacturingOrder.ManufacturingOrderType AS ManufacturingOrderType,
  ManufacturingOrder.ManufacturingOrderCategory AS ManufacturingOrderCategory,
  ManufacturingOrder.ProductionUnit AS ProductionUnit,
  ManufacturingOrder.MfgOrderPlannedTotalQty AS MfgOrderPlannedTotalQty,
  ManufacturingOrder.Material AS Material,
  ManufacturingOrder._Material._Text[1: Language=$session.system_language].MaterialName AS MaterialName,
  cast(ManufacturingOrder.WBSElementInternalID as ps_s4_pspnr preserving type ) AS WBSElementInternalID,
  _WBSElement.WBSElementExternalID AS WBSElementExternalID,
  ManufacturingOrder._ProductionPlant AS _ProductionPlant,
  ManufacturingOrder._MfgOrderType AS _MfgOrderType,
  ManufacturingOrder._MfgOrderCategory AS _MfgOrderCategory,
  ManufacturingOrder._Material AS _Material
FROM P_MfgOrderSplitOrder AS MfgOrderSplitOrder
INNER JOIN I_ManufacturingOrder AS ManufacturingOrder ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ManufacturingOrder AS _ManufacturingOrder ON ManufacturingOrder = _ManufacturingOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _ParentOrder ON MfgOrderSplitParentOrder = _ParentOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_ManufacturingOrder AS _LeadingOrder ON MfgOrderSplitLeadingOrder = _LeadingOrder.ManufacturingOrder  -- association [1..1]
LEFT OUTER JOIN I_WBSElementBasicData AS _WBSElement ON WBSElementInternalID = _WBSElement.WBSElementInternalID  -- association [0..1]
;