C_FMEAFailureModeFDP

DDL: C_FMEAFAILUREMODEFDP Type: view_entity CONSUMPTION Package: ODATA_QM_FMEA
23 Fields 1 Data Sources 3 Associations

Failure Modes of FMEA

C_FMEAFailureModeFDP is a Consumption CDS View that provides data about "Failure Modes of FMEA" in SAP S/4HANA. It reads from 1 data source (I_FMEANode) and exposes 23 fields with key field FMEAFailureModeUUID. It has 3 associations to related views. Part of development package ODATA_QM_FMEA.

Data Sources (1)

SourceAliasJoin Type
I_FMEANode I_FMEANode from

Associations (3)

CardinalityTargetAliasCondition
[0..1] C_FailureModeEffectAnalysisFDP _FailureModeEffectAnalysisFDP $projection.FMEAHeaderUUID = _FailureModeEffectAnalysisFDP.FMEAHeaderUUID
[0..*] C_FMEACauseTaskFDP _FMEACauseTaskFDP $projection.FMEAHeaderUUID = _FMEACauseTaskFDP.FMEAHeaderUUID and $projection.FMEAFailureModeUUID = _FMEACauseTaskFDP.FMEAFailureModeUUID
[0..*] C_FMEAEffectFDP _FMEAEffectFDP $projection.FMEAHeaderUUID = _FMEAEffectFDP.FMEAHeaderUUID and $projection.FMEAFailureModeUUID = _FMEAEffectFDP.FMEAFailureModeUUID

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Failure Modes of FMEA view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
ObjectModel.modelingPattern #OUTPUT_FORM_DATA_PROVIDER view

Fields (23)

KeyFieldSource TableSource FieldDescription
KEY FMEAFailureModeUUID FMEANodeUUID
FMEAFailureMode _FMEANodeAssignment FMEANode
FMEAHeaderUUID FMEAHeaderUUID
InspectionCatalog InspectionCatalog Catalog Type
InspectionCodeGroup InspectionCodeGroup Code Group
InspectionCode InspectionCode Water Hazard Cl.
DefectCodeCatalog DefectCodeCatalog Defect types
ChangedDateTime ChangedDateTime Time Stamp
OriginalLanguage OriginalLanguage Original Language
FMEAFailureModeDescription
FMEAFunction
FMEAFunctionDescription
FMEAFunctionLongText
FMEAHeader _FMEAHeader FMEAHeader
CreationDate _FMEANodeAssignment CreationDate Time Stamp
FMEALongText _FailureModeEffectAnalysisFDP FMEALongText
_FMEACauseTaskFDP _FMEACauseTaskFDP
_FMEAEffectFDP _FMEAEffectFDP
_FailureModeEffectAnalysisFDP _FailureModeEffectAnalysisFDP
_FailureModeEffectAnalysis _FailureModeEffectAnalysis
_FMEANodeAssignment _FMEANodeAssignment
_FMEANodeChild _FMEANodeChild
_FMEANodeHierarchy _FMEANodeHierarchy

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view C_FMEAFailureModeFDP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW C_FMEAFailureModeFDP AS
SELECT
  FMEANodeUUID AS FMEAFailureModeUUID,
  _FMEANodeAssignment.FMEANode AS FMEAFailureMode,
  FMEAHeaderUUID,
  InspectionCatalog,
  InspectionCodeGroup,
  InspectionCode,
  DefectCodeCatalog,
  ChangedDateTime,
  OriginalLanguage,
  _FMEANodeLongText[ 1:Language = $session.system_language ].FMEALongText AS FMEAFailureModeDescription,
  _FMEANodeHierarchy._FMEAParentNodeAssignment.FMEANode AS FMEAFunction,
  _FMEANodeHierarchy._FMEAParentNode._FMEANodeText[ 1:Language = $session.system_language ].FMEANodeDescription AS FMEAFunctionDescription,
  _FMEANodeHierarchy._FMEAParentNode._FMEANodeLongText[ 1:Language = $session.system_language ].FMEALongText AS FMEAFunctionLongText,
  _FMEAHeader.FMEAHeader AS FMEAHeader,
  _FMEANodeAssignment.CreationDate AS CreationDate,
  _FailureModeEffectAnalysisFDP.FMEALongText AS FMEALongText
FROM I_FMEANode
LEFT OUTER JOIN C_FailureModeEffectAnalysisFDP AS _FailureModeEffectAnalysisFDP ON FMEAHeaderUUID = _FailureModeEffectAnalysisFDP.FMEAHeaderUUID  -- association [0..1]
LEFT OUTER JOIN C_FMEACauseTaskFDP AS _FMEACauseTaskFDP ON FMEAHeaderUUID = _FMEACauseTaskFDP.FMEAHeaderUUID AND FMEAFailureModeUUID = _FMEACauseTaskFDP.FMEAFailureModeUUID  -- association [0..*]
LEFT OUTER JOIN C_FMEAEffectFDP AS _FMEAEffectFDP ON FMEAHeaderUUID = _FMEAEffectFDP.FMEAHeaderUUID AND FMEAFailureModeUUID = _FMEAEffectFDP.FMEAFailureModeUUID  -- association [0..*]
;

Learn More