C_FMEANodeFDP

DDL: C_FMEANODEFDP Type: view_entity CONSUMPTION

Form Data Provider for FMEA Node

C_FMEANodeFDP is a Consumption CDS View that provides data about "Form Data Provider for FMEA Node" in SAP S/4HANA. It reads from 2 data sources (I_FailureModeEffectAnalysis, I_FMEANode) and exposes 34 fields with key field FMEANodeUUID. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_FailureModeEffectAnalysis Header inner
I_FMEANode Node from

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_FMEARating _FMEANodeRating $projection.FMEARatingProfile = _FMEANodeRating.FMEARatingProfile and $projection.FMEARating = _FMEANodeRating.FMEARating

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
VDM.viewType #CONSUMPTION view
ObjectModel.representativeKey FMEANodeUUID view
ObjectModel.usageType.serviceQuality #B view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
EndUserText.label Form Data Provider for FMEA Node view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY FMEANodeUUID I_FMEANode FMEANodeUUID
FMEAHeaderUUID I_FMEANode FMEAHeaderUUID
FMEAHierarchyProfile I_FMEANode FMEAHierarchyProfile
FMEAHierarchyProfileLevel I_FMEANode FMEAHierarchyProfileLevel
FMEANodeType I_FMEANode FMEANodeType
FMEANodeListType I_FMEANode FMEANodeListType
FMEAItemType I_FMEANode FMEAItemType
FMEANodeReferenceUUID I_FMEANode FMEANodeReferenceUUID
FMEANodeReferenceObjectType I_FMEANode FMEANodeReferenceObjectType
FMEAValuationProfile I_FMEANode FMEAValuationProfile
FMEAHasValuation I_FMEANode FMEAHasValuation
FMEAValnProfileValuation I_FMEANode FMEAValnProfileValuation
FMEAValuationScoreValue I_FMEANode FMEAValuationScoreValue
FMEAValuationResultValue I_FMEANode FMEAValuationResultValue
InspectionCatalog I_FMEANode InspectionCatalog
InspectionCodeGroup I_FMEANode InspectionCodeGroup
InspectionCode I_FMEANode InspectionCode
DefectCodeCatalog I_FMEANode DefectCodeCatalog
DefectCauseCodeCatalog I_FMEANode DefectCauseCodeCatalog
FMEAFunctionCodeCatalog I_FMEANode FMEAFunctionCodeCatalog
FMEAEffectCodeCatalog I_FMEANode FMEAEffectCodeCatalog
QualityTaskCodeCatalog I_FMEANode QualityTaskCodeCatalog
InspectionSpecification I_FMEANode InspectionSpecification
InspectionSpecificationPlant I_FMEANode InspectionSpecificationPlant
InspSpecImportanceCode I_FMEANode InspSpecImportanceCode
FMEACharacteristicType I_FMEANode FMEACharacteristicType
ChangedDateTime I_FMEANode ChangedDateTime
FMEAValuationProcedure I_FMEANode FMEAValuationProcedure
FMEARating I_FMEANode FMEARating
FMEARatingProfile I_FailureModeEffectAnalysis FMEARatingProfile
_FailureModeEffectAnalysis I_FMEANode _FailureModeEffectAnalysis
_FMEAReferenceNode I_FMEANode _FMEAReferenceNode
_FMEARatingProfile I_FailureModeEffectAnalysis _FMEARatingProfile
_FMEANodeRating _FMEANodeRating
@AccessControl.authorizationCheck: #MANDATORY
//@AccessControl.privilegedAssociations:  [ '_FMEANodeLongText' ]

@VDM.viewType: #CONSUMPTION
@ObjectModel.representativeKey: 'FMEANodeUUID'
@ObjectModel.usageType: { serviceQuality: #B, sizeCategory: #M, dataClass: #TRANSACTIONAL }
@EndUserText.label: 'Form Data Provider for FMEA Node'
define view entity C_FMEANodeFDP as select from I_FMEANode as Node
  inner join I_FailureModeEffectAnalysis as Header on Node.FMEAHeaderUUID = Header.FMEAHeaderUUID
  association [0..1] to I_FMEARating   as _FMEANodeRating   on  $projection.FMEARatingProfile = _FMEANodeRating.FMEARatingProfile
                                                            and $projection.FMEARating        = _FMEANodeRating.FMEARating
{
  key Node.FMEANodeUUID as FMEANodeUUID,
  Node.FMEAHeaderUUID,
  Node.FMEAHierarchyProfile,
  Node.FMEAHierarchyProfileLevel,
  Node.FMEANodeType,
  Node.FMEANodeListType,
  Node.FMEAItemType,
  Node.FMEANodeReferenceUUID,
  Node.FMEANodeReferenceObjectType,
  Node.FMEAValuationProfile,
  Node.FMEAHasValuation,
  Node.FMEAValnProfileValuation,
  Node.FMEAValuationScoreValue,
  Node.FMEAValuationResultValue,
  Node.InspectionCatalog,
  Node.InspectionCodeGroup,
  Node.InspectionCode,
  Node.DefectCodeCatalog,
  Node.DefectCauseCodeCatalog,
  Node.FMEAFunctionCodeCatalog,
  Node.FMEAEffectCodeCatalog,
  Node.QualityTaskCodeCatalog,
  Node.InspectionSpecification,
  Node.InspectionSpecificationPlant,
  Node.InspSpecImportanceCode,
  Node.FMEACharacteristicType,
  Node.ChangedDateTime,
  Node.FMEAValuationProcedure,
  Node.FMEARating,
  Header.FMEARatingProfile,
  
  /* Associations */
  Node._FailureModeEffectAnalysis,
  Node._FMEAReferenceNode,
  Header._FMEARatingProfile,
  _FMEANodeRating
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_FAILUREMODEEFFECTANALYSIS",
"I_FMEANODE"
],
"ASSOCIATED":
[
"I_FAILUREMODEEFFECTANALYSIS",
"I_FMEANODE",
"I_FMEARATING",
"I_FMEARATINGPROFILE"
],
"BASE":
[
"I_FAILUREMODEEFFECTANALYSIS",
"I_FMEANODE"
],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/