C_FMEAMngFunction

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 C_FMEAMngFunction.
-- 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 C_FMEAMngFunction AS
SELECT
  FMEANodeUUID,
  FMEANode,
  FMEAHeaderUUID,
  FMEANodeType,
  FMEANodeListType,
  FMEAItemType,
  FMEAParentNodeUUID,
  FMEANodeReferenceUUID,
  _FMEAReferenceAssignment.FMEANode AS FMEANodeReference,
  _FMEANodeText.FMEANodeDescription : localized AS FMEANodeDescriptionlocalized,
  FMEANodeLongTextDescription,
  cast( CreatedByUser as plmt_created_by preserving type ) AS CreatedByUser,
  _FMEANodeAssignment.CreationDate AS CreationDate,
  cast( LastChangedByUser as plmt_changed_by preserving type ) AS LastChangedByUser,
  _FMEANodeAssignment.LastChangedDate AS LastChangedDate,
  ChangedDateTime
FROM I_FMEAFunctionNodeTP
;