I_FMEAFunctionNodeTP

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_FMEAFunctionNodeTP.
-- 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_FMEAFunctionNodeTP AS
SELECT
  FMEANodeUUID,
  _FMEANodeAssignment.FMEANode AS FMEANode,
  FMEAHeaderUUID,
  FMEANodeType,
  FMEANodeListType,
  FMEAItemType,
  FMEANodeReferenceUUID,
  FMEANodeReferenceObjectType,
  _FMEANodeHierarchy.FMEAParentNodeUUID AS FMEAParentNodeUUID,
  cast( _FMEANodeAssignment.CreatedByUser as plmt_created_by preserving type ) AS CreatedByUser,
  cast( _FMEANodeAssignment.LastChangedByUser as plmt_changed_by preserving type ) AS LastChangedByUser,
  ChangedDateTime,
  _FMEANodeLangDepdntDescription.FMEALongText AS FMEANodeLongTextDescription,
  OriginalLanguage,
  _FMEANodeAssignment._CreatedByUserContactCard AS _CreatedByUserContactCard,
  _FMEANodeAssignment._LastChangedByUserContactCard AS _LastChangedByUserContactCard
FROM I_FMEANode
LEFT OUTER JOIN I_FMEANodeText AS _FMEANodeText ON FMEANodeUUID = _FMEANodeText.FMEANodeUUID  -- association [0..*]
LEFT OUTER JOIN I_FMEANodeText AS _FMEAParentNodeText ON fmeaparentnodeuuid = _FMEAParentNodeText.FMEANodeUUID  -- association [0..*]
LEFT OUTER JOIN I_FMEANodeTextTP AS _FMEANodeTextCurrentLangu ON FMEANodeUUID = _FMEANodeTextCurrentLangu.FMEANodeUUID AND _FMEANodeTextCurrentLangu.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FMEANodeTextTP AS _FMEANodeTextOriginal ON FMEANodeUUID = _FMEANodeTextOriginal.FMEANodeUUID AND OriginalLanguage = _FMEANodeTextOriginal.Language  -- association [0..1]
LEFT OUTER JOIN I_FMEALongText AS _FMEANodeLangDepdntDescription ON FMEANodeUUID = _FMEANodeLangDepdntDescription.FMEANodeUUID AND _FMEANodeLangDepdntDescription.LongTextInternalNumber = 1 AND _FMEANodeLangDepdntDescription.Language = $session.system_language  -- association [0..1]
;