I_FMEAElementNodeTP

DDL: I_FMEAELEMENTNODETP Type: view_entity TRANSACTIONAL

Transactional Processing for FMEA Node

I_FMEAElementNodeTP 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 20 fields with key field FMEANodeUUID. It has 5 associations to related views.

1 data source(s) 20 fields

Data Sources (1)

SourceAliasJoin Type
I_FMEANode I_FMEANode from

Associations (5)

CardinalityTargetAliasCondition
[0..*] I_FMEANodeText _FMEANodeText $projection.FMEANodeUUID = _FMEANodeText.FMEANodeUUID
[0..1] I_FMEAHeader _FMEAReferenceHeader $projection.FMEANodeReferenceUUID = _FMEAReferenceHeader.FMEAHeaderUUID
[0..1] I_FailureModeEffectAnalysis _FMEAReference $projection.FMEANodeReferenceUUID = _FMEAReference.FMEAHeaderUUID
[0..1] I_FMEALongText _FMEAElmntLngDpdntDscrptn $projection.FMEANodeUUID = _FMEAElmntLngDpdntDscrptn.FMEANodeUUID and _FMEAElmntLngDpdntDscrptn.Language = $session.system_language and _FMEAElmntLngDpdntDscrptn.LongTextInternalNumber = 1
[0..1] I_FMEALongText _FMEALngDpdntDscrptn $projection.FMEANodeReferenceUUID = _FMEALngDpdntDscrptn.FMEANodeUUID and _FMEALngDpdntDscrptn.Language = $session.system_language and _FMEALngDpdntDscrptn.LongTextInternalNumber = 1

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 #B view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY FMEANodeUUID FMEANodeUUID
FMEANode _FMEANodeAssignment FMEANode
FMEAHeaderUUID FMEAHeaderUUID
FMEANodeType FMEANodeType
FMEANodeListType FMEANodeListType
FMEAItemType FMEAItemType
FMEAParentNodeUUID _FMEANodeParent FMEAParentNodeUUID
FMEANodeReferenceUUID FMEANodeReferenceUUID
FMEANodeReferenceObjectType FMEANodeReferenceObjectType
ChangedDateTime ChangedDateTime
FMEAElementLongText _FMEAElmntLngDpdntDscrptn FMEALongText
FMEALongText _FMEALngDpdntDscrptn FMEALongText
_FailureModeEffectAnalysisTP _FailureModeEffectAnalysisTP
_FailureModeEffectAnalysis _FailureModeEffectAnalysis
_FMEANodeParent _FMEANodeParent
_FMEANodeChild _FMEANodeChild
_FMEATask _FMEATask
_FMEANodeText _FMEANodeText
_FMEAReferenceHeader _FMEAReferenceHeader
_FMEAReference _FMEAReference 
@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: #B
}
define view entity I_FMEAElementNodeTP
  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_FMEAHeader                         as _FMEAReferenceHeader         on  $projection.FMEANodeReferenceUUID = _FMEAReferenceHeader.FMEAHeaderUUID
  association [0..1] to I_FailureModeEffectAnalysis          as _FMEAReference               on  $projection.FMEANodeReferenceUUID = _FMEAReference.FMEAHeaderUUID
  association [0..1] to I_FMEALongText                       as _FMEAElmntLngDpdntDscrptn    on  $projection.FMEANodeUUID                         = _FMEAElmntLngDpdntDscrptn.FMEANodeUUID
                                                                                             and _FMEAElmntLngDpdntDscrptn.Language               = $session.system_language
                                                                                             and _FMEAElmntLngDpdntDscrptn.LongTextInternalNumber = 1
  association [0..1] to I_FMEALongText                       as _FMEALngDpdntDscrptn         on  $projection.FMEANodeReferenceUUID           = _FMEALngDpdntDscrptn.FMEANodeUUID
                                                                                             and _FMEALngDpdntDscrptn.Language               = $session.system_language
                                                                                             and _FMEALngDpdntDscrptn.LongTextInternalNumber = 1
{
  key FMEANodeUUID,
      _FMEANodeAssignment.FMEANode,
      FMEAHeaderUUID,
      FMEANodeType,
      FMEANodeListType,
      FMEAItemType,
      _FMEANodeParent.FMEAParentNodeUUID,
      FMEANodeReferenceUUID,
      FMEANodeReferenceObjectType,
      ChangedDateTime,
      _FMEAElmntLngDpdntDscrptn.FMEALongText as FMEAElementLongText,
      _FMEALngDpdntDscrptn.FMEALongText as FMEALongText,
      //Associations

      _FailureModeEffectAnalysisTP,
      _FailureModeEffectAnalysis,
      _FMEANodeParent,
      _FMEANodeChild,
      _FMEATask,
      _FMEANodeText,
      _FMEAReferenceHeader,
      _FMEAReference
}
where
  FMEAItemType = '811'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FMEALONGTEXT",
"I_FMEANODE",
"I_FMEANODEASSIGNMENT",
"I_FMEANODEHIERARCHY"
],
"ASSOCIATED":
[
"I_FAILUREMODEEFFECTANALYSIS",
"I_FAILUREMODEEFFECTANALYSISTP",
"I_FMEAHEADER",
"I_FMEANODEHIERARCHY",
"I_FMEANODETEXT",
"I_FMEATASK"
],
"BASE":
[
"I_FMEANODE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More