I_FMEAFailureNodeTP

DDL: I_FMEAFAILURENODETP Type: view_entity TRANSACTIONAL

Transactional Processing for FMEA Node

I_FMEAFailureNodeTP is a Transactional CDS View that provides data about "Transactional Processing for FMEA Node" in SAP S/4HANA. It reads from 1 data source (I_FMEANode) and exposes 24 fields with key field FMEANodeUUID. It has 3 associations to related views.

1 data source(s) 24 fields

Data Sources (1)

SourceAliasJoin Type
I_FMEANode I_FMEANode from

Associations (3)

CardinalityTargetAliasCondition
[0..*] I_FMEANodeText _FMEANodeText $projection.FMEANodeUUID = _FMEANodeText.FMEANodeUUID
[0..1] I_FMEARating _FMEARating $projection.fmearatingprofile = _FMEARating.FMEARatingProfile and $projection.FMEARating = _FMEARating.FMEARating
[0..1] I_FMEANodeDescriptionTextTP _FMEANodeLangDepdntDescription $projection.FMEANodeUUID = _FMEANodeLangDepdntDescription.FMEANodeUUID and _FMEANodeLangDepdntDescription.Language = $session.system_language

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label Transactional Processing for FMEA Node 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 (24)

KeyFieldSource TableSource FieldDescription
KEY FMEANodeUUID FMEANodeUUID
FMEANode _FMEANodeAssignment FMEANode
FMEAHeaderUUID FMEAHeaderUUID
FMEANodeType FMEANodeType
FMEANodeListType FMEANodeListType
FMEAItemType FMEAItemType
FMEANodeReferenceUUID FMEANodeReferenceUUID
FMEANodeReferenceObjectType FMEANodeReferenceObjectType
FMEAParentNodeUUID _FMEANodeParent FMEAParentNodeUUID
ChangedDateTime ChangedDateTime
FMEAValuationResultValue FMEAValuationResultValue
FMEAValuationProcedure FMEAValuationProcedure
FMEARating FMEARating
FMEARatingProfile _FailureModeEffectAnalysisTP FMEARatingProfile
FMEARatingCriticality 1
FMEANodeLongTextDescription _FMEANodeLangDepdntDescription FMEALongText
_FailureModeEffectAnalysisTP _FailureModeEffectAnalysisTP
_FailureModeEffectAnalysis _FailureModeEffectAnalysis
_FMEANodeParent _FMEANodeParent
_FMEANodeChild _FMEANodeChild
_FMEATask _FMEATask
_FMEANodeText _FMEANodeText
_FMEAValuationProcedure _FMEAValuationProcedure
_FMEARating _FMEARating 
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Transactional Processing for FMEA Node'
@VDM.viewType: #TRANSACTIONAL
@VDM.lifecycle.contract.type: #SAP_INTERNAL_API
@Metadata.ignorePropagatedAnnotations: true
@ObjectModel.usageType: {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #M,
    serviceQuality: #C
}
define view entity I_FMEAFailureNodeTP
  as select from I_FMEANode
  association        to parent I_FailureModeEffectAnalysisTP as _FailureModeEffectAnalysisTP on $projection.FMEAHeaderUUID = _FailureModeEffectAnalysisTP.FMEAHeaderUUID
  association [0..*] to I_FMEANodeText                       as _FMEANodeText                on $projection.FMEANodeUUID = _FMEANodeText.FMEANodeUUID
  association [0..1] to I_FMEARating                as _FMEARating             on  $projection.fmearatingprofile = _FMEARating.FMEARatingProfile
                                                                               and $projection.FMEARating        = _FMEARating.FMEARating
 association [0..1] to I_FMEANodeDescriptionTextTP as _FMEANodeLangDepdntDescription on $projection.FMEANodeUUID = _FMEANodeLangDepdntDescription.FMEANodeUUID
                                                                                     and _FMEANodeLangDepdntDescription.Language = $session.system_language
{
  key FMEANodeUUID,
      _FMEANodeAssignment.FMEANode,
      FMEAHeaderUUID,
      FMEANodeType,
      FMEANodeListType,
      FMEAItemType,
      FMEANodeReferenceUUID,
      FMEANodeReferenceObjectType,
      _FMEANodeParent.FMEAParentNodeUUID,
      ChangedDateTime,
      FMEAValuationResultValue,
      FMEAValuationProcedure,
      FMEARating,
      _FailureModeEffectAnalysisTP.FMEARatingProfile,
      1 as FMEARatingCriticality,
      _FMEANodeLangDepdntDescription.FMEALongText as FMEANodeLongTextDescription,
      
      //Associations

      _FailureModeEffectAnalysisTP,
      _FailureModeEffectAnalysis,
      _FMEANodeParent,
      _FMEANodeChild,
      _FMEATask,
      _FMEANodeText,
      _FMEAValuationProcedure,
      _FMEARating
      
}
where
  FMEAItemType = '803'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FAILUREMODEEFFECTANALYSISTP",
"I_FMEANODE",
"I_FMEANODEASSIGNMENT",
"I_FMEANODEDESCRIPTIONTEXTTP",
"I_FMEANODEHIERARCHY"
],
"ASSOCIATED":
[
"I_FAILUREMODEEFFECTANALYSIS",
"I_FAILUREMODEEFFECTANALYSISTP",
"I_FMEANODEHIERARCHY",
"I_FMEANODETEXT",
"I_FMEARATING",
"I_FMEATASK",
"I_FMEAVALUATIONPROCEDURE"
],
"BASE":
[
"I_FMEANODE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More