I_FMEACauseTaskTP

DDL: I_FMEACAUSETASKTP Type: view_entity TRANSACTIONAL Package: PLM_FMEA
65 Fields 1 Data Sources 7 Associations

FMEA Cause Task Node - TP

I_FMEACauseTaskTP is a Transactional CDS View that provides data about "FMEA Cause Task Node - TP" in SAP S/4HANA. It reads from 1 data source (I_FMEANode) and exposes 65 fields with key fields FMEANodeUUID, FMEATaskUUID. It has 7 associations to related views. Part of development package PLM_FMEA.

Data Sources (1)

SourceAliasJoin Type
I_FMEANode I_FMEANode from

Associations (7)

CardinalityTargetAliasCondition
[1..1] I_FMEATaskAssignment _FMEATaskAssignment FMEATask.FMEATaskUUID = _FMEATaskAssignment.FMEATaskUUID
[0..1] I_FMEARating _FMEARating $projection.fmearatingprofile = _FMEARating.FMEARatingProfile and $projection.FMEARating = _FMEARating.FMEARating
[0..1] I_FMEAValuationProcedure _FMEAValuationProcedure $projection.fmeavaluationprocedure = _FMEAValuationProcedure.FMEAValuationProcedure
[0..1] I_FMEANode _FMEAReferenceNode $projection.FMEANodeReferenceUUID = _FMEAReferenceNode.FMEANodeUUID
[0..1] I_FMEATaskTP _FMEARelatedTask $projection.FMEATaskUUID = _FMEARelatedTask.FMEATaskUUID
[0..1] I_FMEANodeUsage _FMEANodeUsage $projection.FMEANodeUUID = _FMEANodeUsage.FMEANodeUUID
[0..1] I_QltyMgmtSystAndUsrTmeZn _QltyMgmtSystAndUsrTmeZn 1 = 1

Annotations (8)

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

Fields (65)

KeyFieldSource TableSource FieldDescription
KEY FMEANodeUUID I_FMEANode FMEANodeUUID
KEY FMEATaskUUID FMEATask FMEATaskUUID
FMEANode
FMEAHeaderUUID I_FMEANode FMEAHeaderUUID
FMEANodeType I_FMEANode FMEANodeType Type
FMEANodeListType I_FMEANode FMEANodeListType List Type
FMEAItemType I_FMEANode FMEAItemType Item Type
FMEANodeReferenceUUID I_FMEANode FMEANodeReferenceUUID
FMEANodeReferenceObjectType I_FMEANode FMEANodeReferenceObjectType Object Type
FMEAParentNodeUUID
FMEAValuationResultValue I_FMEANode FMEAValuationResultValue Target Result
FMEARating I_FMEANode FMEARating Rating
InspectionCatalog I_FMEANode InspectionCatalog Catalog Type
InspectionCodeGroup I_FMEANode InspectionCodeGroup Code Group
InspectionCode I_FMEANode InspectionCode Water Hazard Cl.
FMEARatingProfile _FailureModeEffectAnalysisTP FMEARatingProfile
FMEAValuationProcedure _FailureModeEffectAnalysisTP FMEAValuationProcedure Procedure
FMEARatingCriticality 1
ChangedDateTime I_FMEANode ChangedDateTime Time Stamp
FMEATask
FMEAAuthorizationGroup FMEATask FMEAAuthorizationGroup
FMEATaskStatus FMEATask FMEATaskStatus
FMEATaskActionStatus
FMEATaskType FMEATask FMEATaskType
FMEATaskCompletionRate FMEATask FMEATaskCompletionRate
FMEAValuationProfile FMEATask FMEAValuationProfile Valuatn Profile
FMEAHasTargetValuation FMEATask FMEAHasTargetValuation
FMEAValnPrflTargetValuation FMEATask FMEAValnPrflTargetValuation
FMEATargetValuationScoreValue FMEATask FMEATargetValuationScoreValue
FMEATargetValnResultValue FMEATask FMEATargetValnResultValue
FMEAValnProfileValuation FMEATask FMEAValnProfileValuation Valuation
FMEAValuationScoreValue FMEATask FMEAValuationScoreValue Tgt No.Points
FMEATaskGroup FMEATask FMEATaskGroup
FMEATaskConfirmationDateTime FMEATask FMEATaskConfirmationDateTime
QualityTaskCodeCatalog FMEATask QualityTaskCodeCatalog Catalog type
QualityTaskCodeGroup FMEATask QualityTaskCodeGroup
QualityTaskCode FMEATask QualityTaskCode
FMEATaskIsCancelled FMEATask FMEATaskIsCancelled
FMEATaskIsStartAction FMEATask FMEATaskIsStartAction
FMEATaskChangedDateTime FMEATask ChangedDateTime Time Stamp
FMEATaskLongText _FMEARelatedTask FMEATaskLongText
FMEATaskDescription _FMEARelatedTask FMEATaskDescription
FMEATaskProcessor
PersonFullName
BusinessPartnerFullName
BusinessPartnerUUID
FMEAPartnerUUID
FMEAPartnerRole
_FailureModeEffectAnalysisTP _FailureModeEffectAnalysisTP
_FailureModeEffectAnalysis I_FMEANode _FailureModeEffectAnalysis
_FMEANodeHierarchy I_FMEANode _FMEANodeHierarchy
_FMEANodeChild I_FMEANode _FMEANodeChild
_FMEATask I_FMEANode _FMEATask
_FMEANodeText I_FMEANode _FMEANodeText
_FMEANodeLongText I_FMEANode _FMEANodeLongText
_InspectionCodeGroup I_FMEANode _InspectionCodeGroup
_InspectionCode I_FMEANode _InspectionCode
_FMEATaskPartner FMEATask _FMEATaskPartner
_FMEATaskAssignment _FMEATaskAssignment
_FMEARating _FMEARating
_FMEAValuationProcedure _FMEAValuationProcedure
_FMEAReferenceNode _FMEAReferenceNode
_FMEARelatedTask _FMEARelatedTask
_FMEAHeader I_FMEANode _FMEAHeader
_FMEARatingProfile _FailureModeEffectAnalysisTP _FMEARatingProfile

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_FMEACauseTaskTP.
-- 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_FMEACauseTaskTP AS
SELECT
  I_FMEANode.FMEANodeUUID AS FMEANodeUUID,
  FMEATask.FMEATaskUUID AS FMEATaskUUID,
  cast ( I_FMEANode._FMEANodeAssignment.FMEANode as plmt_fmea_cause preserving type ) AS FMEANode,
  I_FMEANode.FMEAHeaderUUID AS FMEAHeaderUUID,
  I_FMEANode.FMEANodeType AS FMEANodeType,
  I_FMEANode.FMEANodeListType AS FMEANodeListType,
  I_FMEANode.FMEAItemType AS FMEAItemType,
  I_FMEANode.FMEANodeReferenceUUID AS FMEANodeReferenceUUID,
  I_FMEANode.FMEANodeReferenceObjectType AS FMEANodeReferenceObjectType,
  I_FMEANode._FMEANodeHierarchy.FMEAParentNodeUUID AS FMEAParentNodeUUID,
  I_FMEANode.FMEAValuationResultValue AS FMEAValuationResultValue,
  I_FMEANode.FMEARating AS FMEARating,
  I_FMEANode.InspectionCatalog AS InspectionCatalog,
  I_FMEANode.InspectionCodeGroup AS InspectionCodeGroup,
  I_FMEANode.InspectionCode AS InspectionCode,
  _FailureModeEffectAnalysisTP.FMEARatingProfile AS FMEARatingProfile,
  _FailureModeEffectAnalysisTP.FMEAValuationProcedure AS FMEAValuationProcedure,
  1 AS FMEARatingCriticality,
  I_FMEANode.ChangedDateTime AS ChangedDateTime,
  FMEATask._FMEATaskAssignment.FMEATask AS FMEATask,
  FMEATask.FMEAAuthorizationGroup AS FMEAAuthorizationGroup,
  FMEATask.FMEATaskStatus AS FMEATaskStatus,
  FMEATask._FMEATaskActionStatus.FMEATaskActionStatus AS FMEATaskActionStatus,
  FMEATask.FMEATaskType AS FMEATaskType,
  FMEATask.FMEATaskCompletionRate AS FMEATaskCompletionRate,
  FMEATask.FMEAValuationProfile AS FMEAValuationProfile,
  FMEATask.FMEAHasTargetValuation AS FMEAHasTargetValuation,
  FMEATask.FMEAValnPrflTargetValuation AS FMEAValnPrflTargetValuation,
  FMEATask.FMEATargetValuationScoreValue AS FMEATargetValuationScoreValue,
  FMEATask.FMEATargetValnResultValue AS FMEATargetValnResultValue,
  FMEATask.FMEAValnProfileValuation AS FMEAValnProfileValuation,
  FMEATask.FMEAValuationScoreValue AS FMEAValuationScoreValue,
  FMEATask.FMEATaskGroup AS FMEATaskGroup,
  FMEATask.FMEATaskConfirmationDateTime AS FMEATaskConfirmationDateTime,
  FMEATask.QualityTaskCodeCatalog AS QualityTaskCodeCatalog,
  FMEATask.QualityTaskCodeGroup AS QualityTaskCodeGroup,
  FMEATask.QualityTaskCode AS QualityTaskCode,
  FMEATask.FMEATaskIsCancelled AS FMEATaskIsCancelled,
  FMEATask.FMEATaskIsStartAction AS FMEATaskIsStartAction,
  FMEATask.ChangedDateTime AS FMEATaskChangedDateTime,
  _FMEARelatedTask.FMEATaskLongText AS FMEATaskLongText,
  _FMEARelatedTask.FMEATaskDescription AS FMEATaskDescription,
  _FMEARelatedTask._Responsible._BusinessPartner.BusinessPartner AS FMEATaskProcessor,
  _FMEARelatedTask._Responsible._BusinessPartner.PersonFullName AS PersonFullName,
  _FMEARelatedTask._Responsible._BusinessPartner.BusinessPartnerFullName AS BusinessPartnerFullName,
  _FMEARelatedTask._Responsible.BusinessPartnerUUID AS BusinessPartnerUUID,
  _FMEARelatedTask._Responsible.FMEAPartnerUUID AS FMEAPartnerUUID,
  cast( '60' as plmt_role ) AS FMEAPartnerRole,
  I_FMEANode._FailureModeEffectAnalysis AS _FailureModeEffectAnalysis,
  I_FMEANode._FMEANodeHierarchy AS _FMEANodeHierarchy,
  I_FMEANode._FMEANodeChild AS _FMEANodeChild,
  I_FMEANode._FMEATask AS _FMEATask,
  I_FMEANode._FMEANodeText AS _FMEANodeText,
  I_FMEANode._FMEANodeLongText AS _FMEANodeLongText,
  I_FMEANode._InspectionCodeGroup AS _InspectionCodeGroup,
  I_FMEANode._InspectionCode AS _InspectionCode,
  FMEATask._FMEATaskPartner AS _FMEATaskPartner,
  I_FMEANode._FMEAHeader AS _FMEAHeader,
  _FailureModeEffectAnalysisTP._FMEARatingProfile AS _FMEARatingProfile
FROM I_FMEANode
LEFT OUTER JOIN I_FMEATaskAssignment AS _FMEATaskAssignment ON FMEATask.FMEATaskUUID = _FMEATaskAssignment.FMEATaskUUID  -- association [1..1]
LEFT OUTER JOIN I_FMEARating AS _FMEARating ON fmearatingprofile = _FMEARating.FMEARatingProfile AND FMEARating = _FMEARating.FMEARating  -- association [0..1]
LEFT OUTER JOIN I_FMEAValuationProcedure AS _FMEAValuationProcedure ON fmeavaluationprocedure = _FMEAValuationProcedure.FMEAValuationProcedure  -- association [0..1]
LEFT OUTER JOIN I_FMEANode AS _FMEAReferenceNode ON FMEANodeReferenceUUID = _FMEAReferenceNode.FMEANodeUUID  -- association [0..1]
LEFT OUTER JOIN I_FMEATaskTP AS _FMEARelatedTask ON FMEATaskUUID = _FMEARelatedTask.FMEATaskUUID  -- association [0..1]
LEFT OUTER JOIN I_FMEANodeUsage AS _FMEANodeUsage ON FMEANodeUUID = _FMEANodeUsage.FMEANodeUUID  -- association [0..1]
LEFT OUTER JOIN I_QltyMgmtSystAndUsrTmeZn AS _QltyMgmtSystAndUsrTmeZn ON 1 = 1  -- association [0..1]
;

Learn More