I_FMEAFunctionNodeTP

DDL: I_FMEAFUNCTIONNODETP Type: view_entity TRANSACTIONAL

Transactional Processing for FMEA Node

I_FMEAFunctionNodeTP 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. It is exposed through 1 OData service (QM_FMEA_MNG_SRV_DEF).

1 data source(s) Exposed by 1 service(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..*] I_FMEANodeText _FMEAParentNodeText $projection.fmeaparentnodeuuid = _FMEAParentNodeText.FMEANodeUUID
[0..1] I_FMEALongText _FMEANodeLangDepdntDescription $projection.FMEANodeUUID = _FMEANodeLangDepdntDescription.FMEANodeUUID and _FMEANodeLangDepdntDescription.LongTextInternalNumber = 1 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 #B view

OData Services (1)

ServiceBindingVersionContractRelease
QM_FMEA_MNG_SRV_DEF QM_FMEA_MNG_SRV V2 C1 NOT_RELEASED

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
CreatedByUser
LastChangedByUser
ChangedDateTime ChangedDateTime
FMEANodeLongTextDescription _FMEANodeLangDepdntDescription FMEALongText
_FailureModeEffectAnalysisTP _FailureModeEffectAnalysisTP
_FailureModeEffectAnalysis _FailureModeEffectAnalysis
_FMEANodeAssignment _FMEANodeAssignment
_FMEANodeParent _FMEANodeParent
_FMEANodeChild _FMEANodeChild
_FMEATask _FMEATask
_FMEANodeText _FMEANodeText
_FMEAParentNodeText _FMEAParentNodeText
_FMEAReferenceAssignment _FMEAReferenceAssignment
_CreatedByUserContactCard _FMEANodeAssignment _CreatedByUserContactCard
_LastChangedByUserContactCard _FMEANodeAssignment _LastChangedByUserContactCard 
@AccessControl.authorizationCheck: #CHECK
@AccessControl.privilegedAssociations: ['_LastChangedByUserContactCard', '_CreatedByUserContactCard']
@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_FMEAFunctionNodeTP
  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..*] to I_FMEANodeText                       as _FMEAParentNodeText           on $projection.fmeaparentnodeuuid = _FMEAParentNodeText.FMEANodeUUID
  association [0..1] to I_FMEALongText                       as _FMEANodeLangDepdntDescription on $projection.FMEANodeUUID = _FMEANodeLangDepdntDescription.FMEANodeUUID
                                                                                               and _FMEANodeLangDepdntDescription.LongTextInternalNumber = 1
                                                                                               and _FMEANodeLangDepdntDescription.Language = $session.system_language
{
  key FMEANodeUUID,
      _FMEANodeAssignment.FMEANode,
      FMEAHeaderUUID,
      FMEANodeType,
      FMEANodeListType,
      FMEAItemType,
      FMEANodeReferenceUUID,
      FMEANodeReferenceObjectType,
      _FMEANodeParent.FMEAParentNodeUUID,
      cast( _FMEANodeAssignment.CreatedByUser as plmt_created_by preserving type )     as CreatedByUser,
      cast( _FMEANodeAssignment.LastChangedByUser as plmt_changed_by preserving type ) as LastChangedByUser,
      ChangedDateTime,
      _FMEANodeLangDepdntDescription.FMEALongText as FMEANodeLongTextDescription,
      
      //Associations

      _FailureModeEffectAnalysisTP,
      _FailureModeEffectAnalysis,
      _FMEANodeAssignment,
      _FMEANodeParent,
      _FMEANodeChild,
      _FMEATask,
      _FMEANodeText,
      _FMEAParentNodeText,
      _FMEAReferenceAssignment,
      _FMEANodeAssignment._CreatedByUserContactCard,
      _FMEANodeAssignment._LastChangedByUserContactCard

}
where
        FMEAItemType                = '801'
  or    FMEAItemType                = '812'
  or    FMEAItemType                = '814'
  or(
        FMEAItemType                = '802'
    and FMEANodeReferenceObjectType = ''
  )

Learn More