I_MaintOrderOperationLongText

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_MaintOrderOperationLongText.
-- 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: IMAINTORDOPLTXT

CREATE VIEW I_MaintOrderOperationLongText AS
SELECT
  I_MaintOrderOperAndSubOper.MaintenanceOrder AS MaintenanceOrder,
  afvc_text.aufpl AS MaintOrderRoutingNumber,
  afvc_text.aplzl AS MaintenanceOrderRoutingNode,
  I_TextObjectPlainLongText.TextObjectType AS TextObjectType,
  I_TextObjectPlainLongText.Language AS Language,
  afvc_text.tdname AS TextObjectKey,
  I_TextObjectPlainLongText.PlainLongText AS OrderOperationLongText,
  I_TextObjectPlainLongText.TextObjectCategory AS TextObjectCategory
FROM I_TextObjectPlainLongText
INNER JOIN afvc_text ON /* join condition not captured in parsed metadata */
INNER JOIN I_MaintOrderOperAndSubOper ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN I_MaintenanceOrder AS _MaintenanceOrder ON _MaintenanceOrder.MaintenanceOrder = MaintenanceOrder  -- association [0..1]
LEFT OUTER JOIN I_Language AS _Language ON _Language.Language = Language  -- association [0..1]
LEFT OUTER JOIN I_MaintOrderOperAndSubOper AS _MaintenanceOrderSubOperation ON _MaintenanceOrderSubOperation.MaintenanceOrder = MaintenanceOrder AND _MaintenanceOrderSubOperation.MaintOrderRoutingNumber = MaintOrderRoutingNumber AND _MaintenanceOrderSubOperation.MaintOrderOperationCounter = MaintenanceOrderRoutingNode  -- association [0..1]
LEFT OUTER JOIN I_TextObjectPlainLongText AS _TextObjectPlainLongText ON _TextObjectPlainLongText.TextObjectKey = TextObjectKey AND _TextObjectPlainLongText.TextObjectCategory = 'AUFK' AND ( _TextObjectPlainLongText.TextObjectType = 'AVOT' OR _TextObjectPlainLongText.TextObjectType = 'AVON' OR _TextObjectPlainLongText.TextObjectType = 'AVOC' OR _TextObjectPlainLongText.TextObjectType = 'AVOD' )  -- association [0..*]
;