I_FMEATASKHIERARCHY

CDS View

Hierarchy of FMEA Action

I_FMEATASKHIERARCHY is a CDS View in S/4HANA. Hierarchy of FMEA Action. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_FMEATaskAggregate view left_outer COMPOSITE Aggregation on FMEA Task Level 
@VDM.viewType: #BASIC
@AccessControl.authorizationCheck: #NOT_REQUIRED
@EndUserText.label: 'Hierarchy of FMEA Action'
@ObjectModel.representativeKey: 'FMEATaskUUID'
@ObjectModel.usageType: { serviceQuality: #A, sizeCategory: #M, dataClass: #TRANSACTIONAL } 
define view entity I_FMEATaskHierarchy as select from cgpl_hierarchy as TaskHierarchy
   inner join cgpl_hierarchy as NodeHierarchy on
       TaskHierarchy.up = NodeHierarchy.guid
   association [0..1] to I_FailureModeEffectAnalysis as _FailureModeEffectAnalysis
     on $projection.FMEAHeaderUUID = _FailureModeEffectAnalysis.FMEAHeaderUUID  
   association [0..1] to I_FMEATask as _FMEATask on $projection.FMEATaskUUID = _FMEATask.FMEATaskUUID  
   association [0..1] to I_FMEANode as _FMEAParentNode on $projection.FMEAParentNodeUUID = _FMEAParentNode.FMEANodeUUID  
   association [0..1] to I_FMEANodeAssignment as _FMEAParentNodeAssignment on $projection.FMEAParentNodeUUID = _FMEAParentNodeAssignment.FMEANodeUUID
{
  key cast( TaskHierarchy.guid as plmt_fmea_node_guid preserving type ) as FMEATaskUUID,
  cast( NodeHierarchy.project_guid as plmt_fmea_node_guid preserving type ) as FMEAHeaderUUID,
  cast( TaskHierarchy.up as plmt_fmea_node_guid preserving type ) as FMEAParentNodeUUID,
  //Association

  _FailureModeEffectAnalysis,
  _FMEATask,
  _FMEAParentNode,
  _FMEAParentNodeAssignment
}
where TaskHierarchy.task_level = 0 and TaskHierarchy.project_guid = hextobin( '00000000000000000000000000000000' )
  and NodeHierarchy.project_guid <> hextobin( '00000000000000000000000000000000' )
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"CGPL_HIERARCHY"
],
"ASSOCIATED":
[
"I_FAILUREMODEEFFECTANALYSIS",
"I_FMEANODE",
"I_FMEANODEASSIGNMENT",
"I_FMEATASK"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More