I_FMEAElementNodeTP

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_FMEAElementNodeTP.
-- 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_FMEAElementNodeTP AS
SELECT
  FMEANodeUUID,
  _FMEANodeAssignment.FMEANode AS FMEANode,
  FMEAHeaderUUID,
  FMEANodeType,
  FMEANodeListType,
  FMEAItemType,
  _FMEANodeParent.FMEAParentNodeUUID AS FMEAParentNodeUUID,
  FMEANodeReferenceUUID,
  FMEANodeReferenceObjectType,
  ChangedDateTime,
  _FMEAElmntLngDpdntDscrptn.FMEALongText AS FMEAElementLongText,
  _FMEALngDpdntDscrptn.FMEALongText AS FMEALongText
FROM I_FMEANode
LEFT OUTER JOIN I_FMEANodeText AS _FMEANodeText ON FMEANodeUUID = _FMEANodeText.FMEANodeUUID  -- association [0..*]
LEFT OUTER JOIN I_FMEAHeader AS _FMEAReferenceHeader ON FMEANodeReferenceUUID = _FMEAReferenceHeader.FMEAHeaderUUID  -- association [0..1]
LEFT OUTER JOIN I_FailureModeEffectAnalysis AS _FMEAReference ON FMEANodeReferenceUUID = _FMEAReference.FMEAHeaderUUID  -- association [0..1]
LEFT OUTER JOIN I_FMEALongText AS _FMEAElmntLngDpdntDscrptn ON FMEANodeUUID = _FMEAElmntLngDpdntDscrptn.FMEANodeUUID AND _FMEAElmntLngDpdntDscrptn.Language = $session.system_language AND _FMEAElmntLngDpdntDscrptn.LongTextInternalNumber = 1  -- association [0..1]
LEFT OUTER JOIN I_FMEALongText AS _FMEALngDpdntDscrptn ON FMEANodeReferenceUUID = _FMEALngDpdntDscrptn.FMEANodeUUID AND _FMEALngDpdntDscrptn.Language = $session.system_language AND _FMEALngDpdntDscrptn.LongTextInternalNumber = 1  -- association [0..1]
;