C_FMEACauseTaskFDP

DDL: C_FMEACAUSETASKFDP Type: view_entity CONSUMPTION Package: ODATA_QM_FMEA

FDP for FMEA Causes and Tasks

C_FMEACauseTaskFDP is a Consumption CDS View that provides data about "FDP for FMEA Causes and Tasks" in SAP S/4HANA. It reads from 1 data source (I_FMEACauseNode) and exposes 28 fields with key field FMEACauseUUID. It has 8 associations to related views. Part of development package ODATA_QM_FMEA.

1 data source(s) 28 fields

Data Sources (1)

SourceAliasJoin Type
I_FMEACauseNode _FMEACauseNode from

Associations (8)

CardinalityTargetAliasCondition
[0..*] C_FMEATaskFDP _FMEATaskFDP ( $projection.FMEANodeReferenceObjectType is initial and $projection.FMEACauseUUID = _FMEATaskFDP.FMEAParentNodeUUID ) or ( $projection.FMEANodeReferenceObjectType is not initial and _FMEACauseNode.FMEANodeReferenceUUID = _FMEATaskFDP.FMEAParentNodeUUID )
[0..*] I_FMEALongText _FMEACauseLongText $projection.FMEACauseOriginUUID = _FMEACauseLongText.FMEANodeUUID and _FMEACauseLongText.LongTextInternalNumber = 1
[0..*] I_FMEANodeText _FMEACauseText $projection.FMEACauseOriginUUID = _FMEACauseText.FMEANodeUUID
[0..*] I_FMEALongText _FMEAFunctionLongText $projection.FMEAFunctionOriginUUID = _FMEAFunctionLongText.FMEANodeUUID and _FMEAFunctionLongText.LongTextInternalNumber = 1
[0..*] I_FMEANodeText _FMEAFunctionText $projection.FMEAFunctionOriginUUID = _FMEAFunctionText.FMEANodeUUID
[0..*] I_FMEALongText _FMEAElementLongText $projection.FMEAElementOriginUUID = _FMEAElementLongText.FMEANodeUUID and _FMEAElementLongText.LongTextInternalNumber = 1
[0..*] I_FMEANodeText _FMEAElementText $projection.FMEAElementOriginUUID = _FMEAElementText.FMEANodeUUID
[0..*] I_FMEAText _FMEAElementFMEAText $projection.FMEAElementOriginUUID = _FMEAElementFMEAText.FMEAHeaderUUID

Annotations (10)

NameValueLevelField
EndUserText.label FDP for FMEA Causes and Tasks view
AccessControl.authorizationCheck #MANDATORY view
AccessControl.personalData.blocking #BLOCKED_DATA_EXCLUDED view
ObjectModel.representativeKey FMEACauseUUID view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
VDM.viewType #CONSUMPTION view
Metadata.allowExtensions true view
ObjectModel.modelingPattern #OUTPUT_FORM_DATA_PROVIDER view

Fields (28)

KeyFieldSource TableSource FieldDescription
KEY FMEACauseUUID I_FMEACauseNode FMEANodeUUID
FMEAHeaderUUID I_FMEACauseNode FMEAHeaderUUID
FMEACauseOriginUUID I_FMEACauseNode FMEACauseOriginUUID
FailureModeEffectAnalysisCause
FMEACauseDescription
FMEACauseLongText
FMEANodeReferenceObjectType I_FMEACauseNode FMEANodeReferenceObjectType
FMEANodeReferenceUUID I_FMEACauseNode FMEANodeReferenceUUID
FMEARating I_FMEACauseNode FMEARating
FMEAValuationResultValue I_FMEACauseNode FMEAValuationResultValue
FMEAValuationScoreValue I_FMEACauseNode FMEAValuationScoreValue
FMEAFunctionOriginUUID I_FMEACauseNode FMEAFunctionOriginUUID
FMEANodeendasFMEACauseFunction
FMEAFunctionDescription
FMEAFunctionLongText
FMEAElementOriginUUID I_FMEACauseNode FMEAElementOriginUUID
FMEANodeendasFMEACauseElement
FMEAElementLongText
FMEAFailureModeUUID I_FMEACauseNode FMEAFailureModeUUID
FMEACauseRiskPrioNumberValue
FMEACauseActionPriorityValue
FMEACauseProbltyOfDtctnVal
FMEACauseProbltyOfOccrenVal
CreationDate _FMEANodeAssignment CreationDate
_FailureModeEffectAnalysis I_FMEACauseNode _FailureModeEffectAnalysis
_FMEATaskFDP _FMEATaskFDP
_FMEAFunctionText _FMEAFunctionText
_FMEAFunctionLongText _FMEAFunctionLongText 
@EndUserText.label: 'FDP for FMEA Causes and Tasks'
@AccessControl: { authorizationCheck: #MANDATORY, personalData.blocking: #BLOCKED_DATA_EXCLUDED }
@ObjectModel.representativeKey: 'FMEACauseUUID'
@ObjectModel.usageType: { serviceQuality: #D, sizeCategory: #S, dataClass: #TRANSACTIONAL }
@VDM: { viewType: #CONSUMPTION }
@Metadata.allowExtensions: true
@ObjectModel.modelingPattern:           #OUTPUT_FORM_DATA_PROVIDER
@ObjectModel.supportedCapabilities:  [  #OUTPUT_FORM_DATA_PROVIDER   ]

define view entity C_FMEACauseTaskFDP
  as select from I_FMEACauseNode as _FMEACauseNode

  association [0..*] to C_FMEATaskFDP  as _FMEATaskFDP          on  ( $projection.FMEANodeReferenceObjectType is initial
                                                                and $projection.FMEACauseUUID                 = _FMEATaskFDP.FMEAParentNodeUUID )
                                                                or  ( $projection.FMEANodeReferenceObjectType  is not initial
                                                                and _FMEACauseNode.FMEANodeReferenceUUID       = _FMEATaskFDP.FMEAParentNodeUUID )
  association [0..*] to I_FMEALongText as _FMEACauseLongText    on  $projection.FMEACauseOriginUUID           = _FMEACauseLongText.FMEANodeUUID
                                                                and _FMEACauseLongText.LongTextInternalNumber = 1
  association [0..*] to I_FMEANodeText as _FMEACauseText        on  $projection.FMEACauseOriginUUID = _FMEACauseText.FMEANodeUUID
  association [0..*] to I_FMEALongText as _FMEAFunctionLongText on  $projection.FMEAFunctionOriginUUID           = _FMEAFunctionLongText.FMEANodeUUID
                                                                and _FMEAFunctionLongText.LongTextInternalNumber = 1
  association [0..*] to I_FMEANodeText as _FMEAFunctionText     on  $projection.FMEAFunctionOriginUUID = _FMEAFunctionText.FMEANodeUUID
  association [0..*] to I_FMEALongText as _FMEAElementLongText  on  $projection.FMEAElementOriginUUID           = _FMEAElementLongText.FMEANodeUUID
                                                                and _FMEAElementLongText.LongTextInternalNumber = 1
  association [0..*] to I_FMEANodeText as _FMEAElementText      on  $projection.FMEAElementOriginUUID = _FMEAElementText.FMEANodeUUID
  association [0..*] to I_FMEAText     as _FMEAElementFMEAText  on  $projection.FMEAElementOriginUUID = _FMEAElementFMEAText.FMEAHeaderUUID

{
  key _FMEACauseNode.FMEANodeUUID                                                            as FMEACauseUUID,
      _FMEACauseNode.FMEAHeaderUUID,

      //Cause

      _FMEACauseNode.FMEACauseOriginUUID,
      _FMEACauseNode._FMEANodeAssignment.FMEANode                                            as FailureModeEffectAnalysisCause,
      _FMEACauseText[ 1:Language = $session.system_language ].FMEANodeDescription            as FMEACauseDescription,
      _FMEACauseLongText[ 1:Language = $session.system_language ].FMEALongText               as FMEACauseLongText,
      _FMEACauseNode.FMEANodeReferenceObjectType,
      _FMEACauseNode.FMEANodeReferenceUUID,
      _FMEACauseNode.FMEARating,
      _FMEACauseNode.FMEAValuationResultValue,
      _FMEACauseNode.FMEAValuationScoreValue,
      
      //Element function of cause

      _FMEACauseNode.FMEAFunctionOriginUUID,
      case when _FMEACauseNode.FMEANodeReferenceObjectType is initial then cast('' as  cgpl_extid )
      else
          _FMEACauseNode._FMEAReferenceNode._FMEANodeHierarchy._FMEAParentNodeAssignment.FMEANode
      end                                                                                    as FMEACauseFunction,
      _FMEAFunctionText[ 1:Language = $session.system_language ].FMEANodeDescription         as FMEAFunctionDescription,
      _FMEAFunctionLongText[ 1:Language = $session.system_language ].FMEALongText            as FMEAFunctionLongText,
  
      //Element of Cause

      _FMEACauseNode.FMEAElementOriginUUID,
      case when _FMEACauseNode.FMEANodeReferenceObjectType is initial then cast('' as  cgpl_extid )
       else _FMEACauseNode._FMEAReferenceNode._FMEANodeHierarchy._FMEAParentNode._FMEANodeHierarchy._FMEAParentNodeAssignment.FMEANode
       end                                                                                   as FMEACauseElement,
      case when _FMEAElementFMEAText[ 1:Language = $session.system_language ].FMEADescription is null
        then _FMEAElementText[ 1:Language = $session.system_language ].FMEANodeDescription
        else _FMEAElementFMEAText[ 1:Language = $session.system_language ].FMEADescription
      end                                                                                    as FMEAElementDescription,

      _FMEAElementLongText[ 1:Language = $session.system_language ].FMEALongText             as FMEAElementLongText,

      case when _FMEACauseNode.FMEANodeReferenceObjectType is initial then ''
       else
         case when _FMEACauseNode._FMEAReferenceNode._FMEANodeHierarchy._FMEAParentNode._FMEANodeHierarchy._FMEAParentNode.FMEANodeReferenceObjectType is initial then
           _FMEACauseNode._FMEAReferenceNode._FMEANodeHierarchy._FMEAParentNode._FMEANodeHierarchy._FMEAParentNode._FMEANodeText[ 1:Language = $session.system_language ].FMEANodeDescription
         else
           _FMEACauseNode._FMEAReferenceNode._FMEANodeHierarchy._FMEAParentNode._FMEANodeHierarchy._FMEAParentNode._FMEAReference._FMEAText[ 1:Language = $session.system_language ].FMEADescription
         end
       end                                                                                   as FMEACauseElementDescription,

      //Failure mode

      _FMEACauseNode.FMEAFailureModeUUID,

      // to be filled in ABAP

      @ObjectModel: { readOnly: true, virtualElement: true, virtualElementCalculatedBy: 'ABAP:CL_QM_CAUSE_FDP_EXIT_HELPER' }
      cast( '' as abap.char(6)) as FMEACauseRiskPrioNumberValue,
      @ObjectModel: { readOnly: true, virtualElement: true, virtualElementCalculatedBy: 'ABAP:CL_QM_CAUSE_FDP_EXIT_HELPER' }
      cast( '' as abap.char(2)) as FMEACauseActionPriorityValue,
      @ObjectModel: { readOnly: true, virtualElement: true, virtualElementCalculatedBy: 'ABAP:CL_QM_CAUSE_FDP_EXIT_HELPER' }
      cast( '' as abap.char(2) ) as FMEACauseProbltyOfDtctnVal,      
      @ObjectModel: { readOnly: true, virtualElement: true, virtualElementCalculatedBy: 'ABAP:CL_QM_CAUSE_FDP_EXIT_HELPER' }
      cast( '' as abap.char(2) ) as FMEACauseProbltyOfOccrenVal,   
      
      _FMEANodeAssignment.CreationDate,   

      //  /* Associations */

      _FMEACauseNode._FailureModeEffectAnalysis,
      _FMEATaskFDP,
      _FMEAFunctionText,
      _FMEAFunctionLongText

}

Learn More