I_ProductionOrderPRTLongText

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_ProductionOrderPRTLongText.
-- 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_ProductionOrderPRTLongText AS
SELECT
  text.OrderInternalID AS ProductionOrderInternalID,
  text.OrderProdnRsceToolInternalID AS OrderProdnRsceToolInternalID,
  text.LongTextLanguage AS LongTextLanguage,
  text.OrderProdnRsceToolText AS OrderProdnRsceToolText,
  text.OrderProdnRsceToolLongText AS OrderProdnRsceToolLongText,
  cast(text.OrderID as vdm_manufacturingorder preserving type) AS ProductionOrder
FROM I_OrderOperationPRTLongText AS text
LEFT OUTER JOIN I_ProductionOrderInternalID AS _ProductionOrderInternal ON ProductionOrderInternalID = _ProductionOrderInternal.ProductionOrderInternalID  -- association [1..1]
LEFT OUTER JOIN I_Language AS _LongTextLanguage ON LongTextLanguage = _LongTextLanguage.Language  -- association [1..1]
LEFT OUTER JOIN I_ProductionOrder AS _ProductionOrderHeader ON ProductionOrder = _ProductionOrderHeader.ProductionOrder  -- association [1..1]
;