I_MfgOrderLogicalComponent

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_MfgOrderLogicalComponent.
-- 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.

CREATE VIEW I_MfgOrderLogicalComponent AS
SELECT
  aufnr AS ManufacturingOrder,
  lcp_guid AS LogicalComponentUUID,
  lcp_reference AS LgclCompReferenceOriginCode,
  cast(stlty as pph_stlty preserving type) AS BillOfMaterialCategory,
  cast(stlnr as pph_stnum preserving type) AS BillOfMaterialInternalID,
  stlal AS BillOfMaterialVariant,
  bom_versn AS BillOfMaterialVersion,
  stvkn AS InheritedNodeNumberForBOMItem,
  rsnum AS Reservation,
  rspos AS ReservationItem,
  rsart AS RecordType
FROM mpe_sfo_lcp
LEFT OUTER JOIN I_ManufacturingOrder AS _ManufacturingOrder ON ManufacturingOrder = _ManufacturingOrder.ManufacturingOrder  -- association [0..1]
LEFT OUTER JOIN I_LogisticsOrder AS _LogisticsOrder ON ManufacturingOrder = _LogisticsOrder.OrderID  -- association [1..1]
LEFT OUTER JOIN I_ReservationDocumentHeader AS _ReservationDocumentHeader ON Reservation = _ReservationDocumentHeader.Reservation  -- association [0..1]
LEFT OUTER JOIN I_ReservationDocumentItem AS _ReservationDocumentItem ON Reservation = _ReservationDocumentItem.Reservation AND ReservationItem = _ReservationDocumentItem.ReservationItem AND RecordType = _ReservationDocumentItem.RecordType  -- association [0..1]
LEFT OUTER JOIN I_ReservationItem AS _ReservationItem ON Reservation = _ReservationItem.Reservation AND ReservationItem = _ReservationItem.ReservationItem AND RecordType = _ReservationItem.RecordType  -- association [0..1]
LEFT OUTER JOIN I_ReservationDocRecordType AS _ReservationDocRecordType ON RecordType = _ReservationDocRecordType.RecordType  -- association [0..1]
LEFT OUTER JOIN I_OrderComponentBasic AS _OrderComponentBasic ON Reservation = _OrderComponentBasic.Reservation AND ReservationItem = _OrderComponentBasic.ReservationItem AND RecordType = _OrderComponentBasic.RecordType  -- association [0..1]
;