I_FMEAELEMENTNODETP

CDS View

Transactional Processing for FMEA Node

I_FMEAELEMENTNODETP is a CDS View in S/4HANA. Transactional Processing for FMEA Node. 2 CDS views read from this table.

CDS Views using this table (2)

ViewTypeJoinVDMDescription
C_FMEAElementNode view from CONSUMPTION System elements of FMEA
C_FMEAMngElement view_entity projection CONSUMPTION FMEA Element Projection
@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'