I_FailureModeEffectAnalysisTP

DDL: I_FAILUREMODEEFFECTANALYSISTP Type: view_entity TRANSACTIONAL
55 Fields 1 Data Sources 25 Associations

FMEA - TP

I_FailureModeEffectAnalysisTP is a Transactional CDS View that provides data about "FMEA - TP" in SAP S/4HANA. It reads from 1 data source (I_FailureModeEffectAnalysis) and exposes 55 fields with key field FMEAHeaderUUID. It has 25 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_FailureModeEffectAnalysis I_FailureModeEffectAnalysis from

Associations (25)

CardinalityTargetAliasCondition
[0..*] I_FMEAInternalFunctionNet _FMEAInternalFunctionNet $projection.FMEAHeaderUUID = _FMEAInternalFunctionNet.FMEAHeaderUUID
[0..*] I_FMEAFunctionNet _FMEAFunctionNet $projection.FMEAHeaderUUID = _FMEAFunctionNet.FMEAHeaderUUID
[0..*] I_FMEAFailureNet _FailureNet $projection.FMEAHeaderUUID = _FailureNet.FMEAHeaderUUID
[0..*] I_FMEATypeText _FMEATypeText $projection.FMEAType = _FMEATypeText.FMEAType
[0..*] I_FMEAConfidentialityLevelText _FMEAConfidentialityLevelText $projection.FMEAConfidentialityLevel = _FMEAConfidentialityLevelText.FMEAConfidentialityLevel
[0..*] I_FMEAAuthorizationGroupT _FMEAAuthorizationGroupT $projection.FMEAAuthorizationGroup = _FMEAAuthorizationGroupT.FMEAAuthorizationGroup
[0..*] I_FMEAStatusText _FMEAStatusText $projection.FMEAStatus = _FMEAStatusText.FMEAStatus
[0..1] I_FMEAObjectAggregate _FMEAObjectAggregate $projection.FMEAHeaderUUID = _FMEAObjectAggregate.FMEAHeaderUUID
[0..1] I_FMEATaskAggregate _FMEATaskAggregate $projection.FMEAHeaderUUID = _FMEATaskAggregate.FMEAHeaderUUID
[0..1] I_FMEATextTP _FMEATextTP1 $projection.FMEAHeaderUUID = _FMEATextTP1.FMEAHeaderUUID and _FMEATextTP1.Language = $session.system_language
[0..1] I_FMEATextTP _FMEATextTP2 $projection.FMEAHeaderUUID = _FMEATextTP2.FMEAHeaderUUID and $projection.OriginalLanguage = _FMEATextTP2.Language
[0..1] I_FMEADescriptionTP _FMEADescriptionTP1 $projection.FMEAHeaderUUID = _FMEADescriptionTP1.FMEANodeUUID and _FMEADescriptionTP1.Language = $session.system_language
[0..1] I_QltyMgmtSystAndUsrTmeZn _QltyMgmtSystAndUsrTmeZn 1 = 1
[0..*] I_FMEANodeTP _FMEANode
[0..*] I_FMEANodeHierarchyTP _FMEANodeHierarchyTP
[0..*] I_FMEAPartnerTP _FMEAPartnerTP
[0..*] I_FMEAObjectTP _FMEAObjectTP
[0..*] I_FMEATextTP _FMEATextTP
[0..*] I_FMEADescriptionTP _FMEADescriptionTP
[0..*] I_FMEAElementNodeTP _ElementNode
[0..*] I_FMEAFunctionNodeTP _FunctionNode
[0..*] I_FMEAFailureNodeTP _FailureNode
[0..*] I_FMEACauseNodeTP _CauseNode
[0..*] I_FMEACauseTaskTP _CauseTaskNode
[0..*] I_FMEAEffectNodeTP _EffectNode

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
EndUserText.label FMEA - TP view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.sapObjectNodeType.name FailureModeEffectAnalysis view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #C view

Fields (55)

KeyFieldSource TableSource FieldDescription
KEY FMEAHeaderUUID FMEAHeaderUUID
OutputControlApplicationObject
OriginalLanguage OriginalLanguage Original Language
FMEAHeader _FMEAHeader FMEAHeader
FMEAType FMEAType
FMEAAuthorizationGroup FMEAAuthorizationGroup AuthorizGroup
FMEAStatus FMEAStatus
FMEACalculationStatus FMEACalculationStatus Charge Calc. Sts
CreatedByUser _FMEAHeader CreatedByUser User Name
CreationDate _FMEAHeader CreationDate Time Stamp
LastChangedByUser _FMEAHeader LastChangedByUser User Name
LastChangedDate _FMEAHeader LastChangedDate Created On
FMEAActualStartDateTime _FMEAHeader FMEAActualStartDateTime
ChangedDateTime ChangedDateTime Time Stamp
FMEALongTextDesc _FMEADescriptionTP1 FMEALongText
FMEAValuationResultValue FMEAValuationResultValue Target Result
FMEAValuationProcedure FMEAValuationProcedure Procedure
FMEARatingProfile FMEARatingProfile Step Classification
FMEARating FMEARating Rating
FMEARatingCriticality 1
FMEAGroup FMEAGroup Worklist Group
FMEASearchTermValue FMEASearchTermValue Search Field
FMEAIsHeaderFMEA FMEAIsHeaderFMEA Is Header FMEA
FMEAConfidentialityLevel FMEAConfidentialityLevel
_FMEANode _FMEANode
_FMEANodeHierarchyTP _FMEANodeHierarchyTP
_FMEAPartnerTP _FMEAPartnerTP
_FMEAObjectTP _FMEAObjectTP
_FMEATextTP _FMEATextTP
_FMEADescriptionTP _FMEADescriptionTP
_FMEAHeaderLongText _FMEAHeaderLongText
_FMEAText _FMEAText
_CreatedByUserContactCard _FMEAHeader _CreatedByUserContactCard
_LastChangedByUserContactCard _FMEAHeader _LastChangedByUserContactCard
_ElementNode _ElementNode
_FunctionNode _FunctionNode
_FMEAFunctionNet _FMEAFunctionNet
_FMEAInternalFunctionNet _FMEAInternalFunctionNet
_FailureNode _FailureNode
_FailureNet _FailureNet
_CauseNode _CauseNode
_CauseTaskNode _CauseTaskNode
_EffectNode _EffectNode
_FMEAAuthorizationGroup _FMEAAuthorizationGroup
_FMEAStatus _FMEAStatus
_FMEATypeText _FMEATypeText
_FMEAConfidentialityLevelText _FMEAConfidentialityLevelText
_FMEAAuthorizationGroupT _FMEAAuthorizationGroupT
_FMEAStatusText _FMEAStatusText
_FMEAObjectAggregate _FMEAObjectAggregate
_FMEATaskAggregate _FMEATaskAggregate
_FMEAValuationProcedure _FMEAValuationProcedure
_FMEARatingProfile _FMEARatingProfile
_FMEARating _FMEARating
_FMEAConfidentialityLevel _FMEAConfidentialityLevel

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 I_FailureModeEffectAnalysisTP.
-- 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 I_FailureModeEffectAnalysisTP AS
SELECT
  FMEAHeaderUUID,
  cast( bintohex( FMEAHeaderUUID ) as apoc_appl_object_id ) AS OutputControlApplicationObject,
  OriginalLanguage,
  _FMEAHeader.FMEAHeader AS FMEAHeader,
  FMEAType,
  FMEAAuthorizationGroup,
  FMEAStatus,
  FMEACalculationStatus,
  _FMEAHeader.CreatedByUser AS CreatedByUser,
  _FMEAHeader.CreationDate AS CreationDate,
  _FMEAHeader.LastChangedByUser AS LastChangedByUser,
  _FMEAHeader.LastChangedDate AS LastChangedDate,
  _FMEAHeader.FMEAActualStartDateTime AS FMEAActualStartDateTime,
  ChangedDateTime,
  _FMEADescriptionTP1.FMEALongText AS FMEALongTextDesc,
  FMEAValuationResultValue,
  FMEAValuationProcedure,
  FMEARatingProfile,
  FMEARating,
  1 AS FMEARatingCriticality,
  FMEAGroup,
  FMEASearchTermValue,
  FMEAIsHeaderFMEA,
  FMEAConfidentialityLevel,
  _FMEAHeader._CreatedByUserContactCard AS _CreatedByUserContactCard,
  _FMEAHeader._LastChangedByUserContactCard AS _LastChangedByUserContactCard
FROM I_FailureModeEffectAnalysis
LEFT OUTER JOIN I_FMEAInternalFunctionNet AS _FMEAInternalFunctionNet ON FMEAHeaderUUID = _FMEAInternalFunctionNet.FMEAHeaderUUID  -- association [0..*]
LEFT OUTER JOIN I_FMEAFunctionNet AS _FMEAFunctionNet ON FMEAHeaderUUID = _FMEAFunctionNet.FMEAHeaderUUID  -- association [0..*]
LEFT OUTER JOIN I_FMEAFailureNet AS _FailureNet ON FMEAHeaderUUID = _FailureNet.FMEAHeaderUUID  -- association [0..*]
LEFT OUTER JOIN I_FMEATypeText AS _FMEATypeText ON FMEAType = _FMEATypeText.FMEAType  -- association [0..*]
LEFT OUTER JOIN I_FMEAConfidentialityLevelText AS _FMEAConfidentialityLevelText ON FMEAConfidentialityLevel = _FMEAConfidentialityLevelText.FMEAConfidentialityLevel  -- association [0..*]
LEFT OUTER JOIN I_FMEAAuthorizationGroupT AS _FMEAAuthorizationGroupT ON FMEAAuthorizationGroup = _FMEAAuthorizationGroupT.FMEAAuthorizationGroup  -- association [0..*]
LEFT OUTER JOIN I_FMEAStatusText AS _FMEAStatusText ON FMEAStatus = _FMEAStatusText.FMEAStatus  -- association [0..*]
LEFT OUTER JOIN I_FMEAObjectAggregate AS _FMEAObjectAggregate ON FMEAHeaderUUID = _FMEAObjectAggregate.FMEAHeaderUUID  -- association [0..1]
LEFT OUTER JOIN I_FMEATaskAggregate AS _FMEATaskAggregate ON FMEAHeaderUUID = _FMEATaskAggregate.FMEAHeaderUUID  -- association [0..1]
LEFT OUTER JOIN I_FMEATextTP AS _FMEATextTP1 ON FMEAHeaderUUID = _FMEATextTP1.FMEAHeaderUUID AND _FMEATextTP1.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FMEATextTP AS _FMEATextTP2 ON FMEAHeaderUUID = _FMEATextTP2.FMEAHeaderUUID AND OriginalLanguage = _FMEATextTP2.Language  -- association [0..1]
LEFT OUTER JOIN I_FMEADescriptionTP AS _FMEADescriptionTP1 ON FMEAHeaderUUID = _FMEADescriptionTP1.FMEANodeUUID AND _FMEADescriptionTP1.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_QltyMgmtSystAndUsrTmeZn AS _QltyMgmtSystAndUsrTmeZn ON 1 = 1  -- association [0..1]
LEFT OUTER JOIN I_FMEANodeTP AS _FMEANode ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_FMEANodeHierarchyTP AS _FMEANodeHierarchyTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_FMEAPartnerTP AS _FMEAPartnerTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_FMEAObjectTP AS _FMEAObjectTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_FMEATextTP AS _FMEATextTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_FMEADescriptionTP AS _FMEADescriptionTP ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_FMEAElementNodeTP AS _ElementNode ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_FMEAFunctionNodeTP AS _FunctionNode ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_FMEAFailureNodeTP AS _FailureNode ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_FMEACauseNodeTP AS _CauseNode ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_FMEACauseTaskTP AS _CauseTaskNode ON /* condition not available in parsed metadata */  -- association [0..*]
LEFT OUTER JOIN I_FMEAEffectNodeTP AS _EffectNode ON /* condition not available in parsed metadata */  -- association [0..*]
;

Learn More