I_FMEANode

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_FMEANode.
-- 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: IFMEANODE

CREATE VIEW I_FMEANode AS
SELECT
  cast( plmm_quest_res.guid as plmt_fmea_node_guid preserving type ) AS FMEANodeUUID,
  cast( plmm_quest_res.project_guid as plmt_fmea_node_guid preserving type ) AS FMEAHeaderUUID,
  plmm_quest_res.hierarchy_profil AS FMEAHierarchyProfile,
  plmm_quest_res.hierarchy_level AS FMEAHierarchyProfileLevel,
  plmm_quest_res.node_type AS FMEANodeType,
  plmm_quest_res.listtyp AS FMEANodeListType,
  plmm_quest_res.listityp AS FMEAItemType,
  cast( reference as plmt_fmea_node_guid preserving type ) AS FMEANodeReferenceUUID,
  reference_obtyp AS FMEANodeReferenceObjectType,
  plmm_quest_res.assessm_profil AS FMEAValuationProfile,
  plmm_quest_res.assessment_rec AS FMEAHasValuation,
  plmm_quest_res.assessment_res AS FMEAValnProfileValuation,
  plmm_quest_res.score_rec AS FMEAValuationScoreValue,
  plmm_quest_res.score_res AS FMEAValuationResultValue,
  plmm_quest_res.katalgart AS InspectionCatalog,
  plmm_quest_res.gruppe AS InspectionCodeGroup,
  plmm_quest_res.code AS InspectionCode,
  plmm_quest_res.fekat AS DefectCodeCatalog,
  plmm_quest_res.urkat AS DefectCauseCodeCatalog,
  plmm_quest_res.functioncat AS FMEAFunctionCodeCatalog,
  plmm_quest_res.effectcat AS FMEAEffectCodeCatalog,
  plmm_quest_res.makat AS QualityTaskCodeCatalog,
  plmm_quest_res.verwmerkm AS InspectionSpecification,
  plmm_quest_res.qpmk_werks AS InspectionSpecificationPlant,
  plmm_quest_res.merkgew AS InspSpecImportanceCode,
  plmm_quest_res.char_type AS FMEACharacteristicType,
  plmm_quest_res.changeddatetime AS ChangedDateTime,
  plmm_quest_res.audit_calculate AS FMEAValuationProcedure,
  plmm_quest_res.classification_code AS FMEARating,
  plmm_quest_res.original_langu AS OriginalLanguage
FROM plmm_quest_res
LEFT OUTER JOIN I_FMEANodeAssignment AS _FMEANodeAssignment ON FMEANodeUUID = _FMEANodeAssignment.FMEANodeUUID  -- association [1..1]
LEFT OUTER JOIN I_FailureModeEffectAnalysis AS _FailureModeEffectAnalysis ON FMEAHeaderUUID = _FailureModeEffectAnalysis.FMEAHeaderUUID  -- association [0..1]
LEFT OUTER JOIN I_FMEAHeader AS _FMEAHeader ON FMEAHeaderUUID = _FMEAHeader.FMEAHeaderUUID  -- association [1..1]
LEFT OUTER JOIN I_FMEANodeHierarchy AS _FMEANodeHierarchy ON FMEANodeUUID = _FMEANodeHierarchy.FMEANodeUUID  -- association [0..1]
LEFT OUTER JOIN I_FMEANodeHierarchy AS _FMEANodeChild ON FMEANodeUUID = _FMEANodeChild.FMEAParentNodeUUID  -- association [0..*]
LEFT OUTER JOIN I_FMEAValuationProfile AS _FMEAValuationProfile ON FMEAValuationProfile = _FMEAValuationProfile.FMEAValuationProfile  -- association [0..1]
LEFT OUTER JOIN I_InspectionCodeGroup AS _InspectionCodeGroup ON InspectionCatalog = _InspectionCodeGroup.InspectionCatalog AND InspectionCodeGroup = _InspectionCodeGroup.InspectionCodeGroup  -- association [0..1]
LEFT OUTER JOIN I_InspectionCode AS _InspectionCode ON InspectionCatalog = _InspectionCode.InspectionCatalog AND InspectionCodeGroup = _InspectionCode.InspectionCodeGroup AND InspectionCode = _InspectionCode.InspectionCode  -- association [0..1]
LEFT OUTER JOIN I_FMEATask AS _FMEATask ON FMEANodeUUID = _FMEATask.FMEAParentNodeUUID  -- association [0..*]
LEFT OUTER JOIN I_FMEANodeText AS _FMEANodeText ON FMEANodeUUID = _FMEANodeText.FMEANodeUUID  -- association [0..*]
LEFT OUTER JOIN I_FMEANodeAssignment AS _FMEAReferenceAssignment ON FMEANodeReferenceUUID = _FMEAReferenceAssignment.FMEANodeUUID  -- association [1..1]
LEFT OUTER JOIN I_FMEANode AS _FMEAReferenceNode ON FMEANodeReferenceUUID = _FMEAReferenceNode.FMEANodeUUID  -- association [0..1]
LEFT OUTER JOIN I_FMEAHeader AS _FMEAReference ON FMEANodeReferenceUUID = _FMEAReference.FMEAHeaderUUID  -- association [1..1]
LEFT OUTER JOIN I_FMEAValuationProcedure AS _FMEAValuationProcedure ON FMEAValuationProcedure = _FMEAValuationProcedure.FMEAValuationProcedure  -- association [0..1]
LEFT OUTER JOIN I_FMEALongText AS _FMEANodeLongText ON FMEANodeUUID = _FMEANodeLongText.FMEANodeUUID AND _FMEANodeLongText.LongTextInternalNumber = 1  -- association [0..*]
LEFT OUTER JOIN I_FMEAText AS _FMEAHeaderText ON FMEAHeaderUUID = _FMEAHeaderText.FMEAHeaderUUID AND _FMEAHeaderText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN E_FMEANode AS _Extension ON FMEANodeUUID = _Extension.FMEANodeUUID  -- association [1..1]
;