I_MfgOrderSplitChildOrder

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_MfgOrderSplitChildOrder.
-- 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: IMFGORDERSPLIT

CREATE VIEW I_MfgOrderSplitChildOrder AS
SELECT
  afsprel.c_aufnr AS MfgOrderSplitChildOrder,
  afsprel.byproduct AS MfgOrderSplitByProduct,
  afsprel.order_split_uuid AS MfgOrderSplitUUID,
  afsprel.splcnt AS MfgOrderSplitChildOrderIntID,
  afsprel.p_aufnr AS MfgOrderSplitParentOrder,
  afsprel.l_aufnr AS MfgOrderSplitLeadingOrder,
  afsprel.byprod_mat_doc AS ByProductMaterialDocument,
  afsprel.byprod_mat_item AS ByProductMaterialDocumentItem,
  afsprel.byprod_mat_year AS ByProductMaterialDocumentYear,
  cast(afsprel.sdate as erdat preserving type) AS CreationDate,
  afsprel.stime AS CreationTime,
  afsprel.suser AS CreatedByUser,
  cast(afsprel.qunit as operationunit preserving type) AS OperationUnit,
  afsprel.splq AS MfgOrderSplitQuantity
FROM afsprel
INNER JOIN I_LogisticsOrderBasic AS afko ON /* join condition not captured in parsed metadata */
INNER JOIN above ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_ManufacturingOrder AS _ChildOrder ON MfgOrderSplitChildOrder = _ChildOrder.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_User AS _CreatedByUser ON CreatedByUser = _CreatedByUser.UserID  -- association [1..1]
LEFT OUTER JOIN I_CalendarDate AS _CreationDate ON CreationDate = _CreationDate.CalendarDate  -- association [1..1]
LEFT OUTER JOIN I_Product AS _ByProduct ON MfgOrderSplitByProduct = _ByProduct.Product  -- association [0..1]
LEFT OUTER JOIN I_Batch AS _ByProductBatch ON MfgOrderSplitByProduct = _ByProductBatch.Material AND MfgOrderSplitByProductBatch = _ByProductBatch.Batch  -- association [0..*]
LEFT OUTER JOIN I_MaterialDocumentYear AS _MaterialDocumentYear ON ByProductMaterialDocumentYear = _MaterialDocumentYear.MaterialDocumentYear  -- association [0..1]
LEFT OUTER JOIN I_MaterialDocumentHeader_2 AS _MaterialDocumentHeader ON ByProductMaterialDocumentYear = _MaterialDocumentHeader.MaterialDocumentYear AND ByProductMaterialDocument = _MaterialDocumentHeader.MaterialDocument  -- association [0..1]
LEFT OUTER JOIN I_MaterialDocumentItem_2 AS _MaterialDocumentItem ON ByProductMaterialDocumentYear = _MaterialDocumentItem.MaterialDocumentYear AND ByProductMaterialDocument = _MaterialDocumentItem.MaterialDocument AND ByProductMaterialDocumentItem = _MaterialDocumentItem.MaterialDocumentItem  -- association [0..1]
LEFT OUTER JOIN I_UnitOfMeasure AS _OperationUnit ON OperationUnit = _OperationUnit.UnitOfMeasure  -- association [1..1]
;