I_FMEACauseNodeTP

DDL: I_FMEACAUSENODETP Type: view_entity TRANSACTIONAL
26 Fields 1 Data Sources 5 Associations

FMEA Node - TP

I_FMEACauseNodeTP is a Transactional CDS View that provides data about "FMEA Node - TP" in SAP S/4HANA. It reads from 1 data source (I_FMEANode) and exposes 26 fields with key field FMEANodeUUID. It has 5 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FMEANode I_FMEANode from

Associations (5)

CardinalityTargetAliasCondition
[0..1] I_FMEARating _FMEARating $projection.fmearatingprofile = _FMEARating.FMEARatingProfile and $projection.FMEARating = _FMEARating.FMEARating
[0..1] I_FMEAValuationProcedure _FMEAValuationProcedure $projection.fmeavaluationprocedure = _FMEAValuationProcedure.FMEAValuationProcedure
[0..1] I_FMEANode _FMEAReferenceNode $projection.FMEANodeReferenceUUID = _FMEAReferenceNode.FMEANodeUUID
[0..1] I_FMEANodeUsage _FMEANodeUsage $projection.FMEANodeUUID = _FMEANodeUsage.FMEANodeUUID
[0..1] I_QltyMgmtSystAndUsrTmeZn _QltyMgmtSystAndUsrTmeZn 1 = 1

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label FMEA Node - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view

Fields (26)

KeyFieldSource TableSource FieldDescription
KEY FMEANodeUUID I_FMEANode FMEANodeUUID
FMEANode
FMEAHeaderUUID I_FMEANode FMEAHeaderUUID
FMEANodeType I_FMEANode FMEANodeType Type
FMEANodeListType I_FMEANode FMEANodeListType List Type
FMEAItemType I_FMEANode FMEAItemType Item Type
FMEANodeReferenceUUID I_FMEANode FMEANodeReferenceUUID
FMEANodeReferenceObjectType I_FMEANode FMEANodeReferenceObjectType Object Type
FMEAParentNodeUUID
FMEARating I_FMEANode FMEARating Rating
FMEARatingProfile _FailureModeEffectAnalysisTP FMEARatingProfile
FMEAValuationProcedure _FailureModeEffectAnalysisTP FMEAValuationProcedure Procedure
FMEARatingCriticality 1
FMEAValuationResultValue I_FMEANode FMEAValuationResultValue Target Result
ChangedDateTime I_FMEANode ChangedDateTime Time Stamp
_FailureModeEffectAnalysisTP _FailureModeEffectAnalysisTP
_FailureModeEffectAnalysis I_FMEANode _FailureModeEffectAnalysis
_FMEANodeParent I_FMEANode _FMEANodeParent
_FMEANodeChild I_FMEANode _FMEANodeChild
_FMEATask I_FMEANode _FMEATask
_FMEANodeText I_FMEANode _FMEANodeText
_FMEARating _FMEARating
_FMEAValuationProcedure _FMEAValuationProcedure
_FMEAReferenceNode _FMEAReferenceNode
_FMEAHeader I_FMEANode _FMEAHeader
_FMEARatingProfile _FailureModeEffectAnalysisTP _FMEARatingProfile

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_FMEACauseNodeTP.
-- 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_FMEACauseNodeTP AS
SELECT
  I_FMEANode.FMEANodeUUID AS FMEANodeUUID,
  I_FMEANode._FMEANodeAssignment.FMEANode AS FMEANode,
  I_FMEANode.FMEAHeaderUUID AS FMEAHeaderUUID,
  I_FMEANode.FMEANodeType AS FMEANodeType,
  I_FMEANode.FMEANodeListType AS FMEANodeListType,
  I_FMEANode.FMEAItemType AS FMEAItemType,
  I_FMEANode.FMEANodeReferenceUUID AS FMEANodeReferenceUUID,
  I_FMEANode.FMEANodeReferenceObjectType AS FMEANodeReferenceObjectType,
  I_FMEANode._FMEANodeParent.FMEAParentNodeUUID AS FMEAParentNodeUUID,
  I_FMEANode.FMEARating AS FMEARating,
  _FailureModeEffectAnalysisTP.FMEARatingProfile AS FMEARatingProfile,
  _FailureModeEffectAnalysisTP.FMEAValuationProcedure AS FMEAValuationProcedure,
  1 AS FMEARatingCriticality,
  I_FMEANode.FMEAValuationResultValue AS FMEAValuationResultValue,
  I_FMEANode.ChangedDateTime AS ChangedDateTime,
  I_FMEANode._FailureModeEffectAnalysis AS _FailureModeEffectAnalysis,
  I_FMEANode._FMEANodeParent AS _FMEANodeParent,
  I_FMEANode._FMEANodeChild AS _FMEANodeChild,
  I_FMEANode._FMEATask AS _FMEATask,
  I_FMEANode._FMEANodeText AS _FMEANodeText,
  I_FMEANode._FMEAHeader AS _FMEAHeader,
  _FailureModeEffectAnalysisTP._FMEARatingProfile AS _FMEARatingProfile
FROM I_FMEANode
LEFT OUTER JOIN I_FMEARating AS _FMEARating ON fmearatingprofile = _FMEARating.FMEARatingProfile AND FMEARating = _FMEARating.FMEARating  -- association [0..1]
LEFT OUTER JOIN I_FMEAValuationProcedure AS _FMEAValuationProcedure ON fmeavaluationprocedure = _FMEAValuationProcedure.FMEAValuationProcedure  -- association [0..1]
LEFT OUTER JOIN I_FMEANode AS _FMEAReferenceNode ON FMEANodeReferenceUUID = _FMEAReferenceNode.FMEANodeUUID  -- association [0..1]
LEFT OUTER JOIN I_FMEANodeUsage AS _FMEANodeUsage ON FMEANodeUUID = _FMEANodeUsage.FMEANodeUUID  -- association [0..1]
LEFT OUTER JOIN I_QltyMgmtSystAndUsrTmeZn AS _QltyMgmtSystAndUsrTmeZn ON 1 = 1  -- association [0..1]
;

Learn More