I_FMEATask

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_FMEATask.
-- 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.
-- SQL view name: IFMEATSK

CREATE VIEW I_FMEATask AS
SELECT
  cast( plmm_audit_act.guid as plmt_fmea_node_guid preserving type ) AS FMEATaskUUID,
  cast( cgpl_hierarchy.up as plmt_fmea_node_guid preserving type ) AS FMEAParentNodeUUID,
  plmm_audit_act.auth_group AS FMEAAuthorizationGroup,
  plmm_audit_act.proc_status AS FMEATaskStatus,
  cast( plmm_audit_act.acttyp as plmt_fmea_task_type preserving type ) AS FMEATaskType,
  plmm_audit_act.complete_percent AS FMEATaskCompletionRate,
  plmm_audit_act.assessm_profil AS FMEAValuationProfile,
  plmm_audit_act.assessment_rec AS FMEAHasTargetValuation,
  plmm_audit_act.assessm_res AS FMEAValnPrflTargetValuation,
  plmm_audit_act.score_rec AS FMEATargetValuationScoreValue,
  plmm_audit_act.score_res AS FMEATargetValnResultValue,
  plmm_audit_act.assessm_res_old AS FMEAValnProfileValuation,
  plmm_audit_act.score_rec_old AS FMEAValuationScoreValue,
  plmm_audit_act.score_res_old AS FMEAValuationResultValue,
  plmm_audit_act.confirmation AS FMEATaskConfirmationDateTime,
  plmm_audit_act.makat AS QualityTaskCodeCatalog,
  plmm_audit_act.gruppe AS QualityTaskCodeGroup,
  plmm_audit_act.code AS QualityTaskCode,
  plmm_audit_act.act_cancel AS FMEATaskIsCancelled,
  plmm_audit_act.start_action AS FMEATaskIsStartAction,
  plmm_audit_act.changeddatetime AS ChangedDateTime,
  plmm_audit_act.grouping AS FMEATaskGroup
FROM plmm_audit_act
LEFT OUTER JOIN I_FMEATaskPartner AS _FMEATaskPartner ON FMEATaskUUID = _FMEATaskPartner.FMEATaskUUID  -- association [0..*]
LEFT OUTER JOIN I_FMEAAuthorizationGroup AS _FMEAAuthorizationGroup ON FMEAAuthorizationGroup = _FMEAAuthorizationGroup.FMEAAuthorizationGroup  -- association [0..1]
LEFT OUTER JOIN I_FMEAValuationProfile AS _FMEAValuationProfile ON FMEAValuationProfile = _FMEAValuationProfile.FMEAValuationProfile  -- association [0..1]
LEFT OUTER JOIN I_FMEAValnProfileValuation AS _FMEAValnProfileValuation ON FMEAValuationProfile = _FMEAValnProfileValuation.FMEAValuationProfile AND FMEAValnProfileValuation = _FMEAValnProfileValuation.FMEAValnProfileValuation  -- association [0..1]
LEFT OUTER JOIN I_FMEAValnProfileValuation AS _FMEAValnProfileTargetValn ON FMEAValuationProfile = _FMEAValnProfileTargetValn.FMEAValuationProfile AND FMEAValnPrflTargetValuation = _FMEAValnProfileTargetValn.FMEAValnProfileValuation  -- association [0..1]
LEFT OUTER JOIN I_ConfigurableCodesCodeGroup AS _ConfigurableCodesCodeGroup ON QualityTaskCodeGroup = _ConfigurableCodesCodeGroup.ConfigurableCodesCodeGroup AND QualityTaskCodeCatalog = _ConfigurableCodesCodeGroup.ConfigurableCodesCatalog  -- association [0..1]
LEFT OUTER JOIN I_ConfigurableCodesCode AS _ConfigurableCodesCode ON QualityTaskCode = _ConfigurableCodesCode.ConfigurableCodesCode AND QualityTaskCodeGroup = _ConfigurableCodesCode.ConfigurableCodesCodeGroup AND QualityTaskCodeCatalog = _ConfigurableCodesCode.ConfigurableCodesCatalog  -- association [0..1]
LEFT OUTER JOIN I_FMEATaskHierarchy AS _FMEATaskHierarchy ON FMEATaskUUID = _FMEATaskHierarchy.FMEATaskUUID  -- association [0..1]
LEFT OUTER JOIN I_FMEATaskAssignment AS _FMEATaskAssignment ON FMEATaskUUID = _FMEATaskAssignment.FMEATaskUUID  -- association [1..1]
LEFT OUTER JOIN I_FMEANodeAssignment AS _ParentNodeAssignment ON FMEAParentNodeUUID = _ParentNodeAssignment.FMEANodeUUID  -- association [0..1]
LEFT OUTER JOIN I_FMEAStatus AS _FMEATaskStatus ON FMEATaskStatus = _FMEATaskStatus.FMEAStatus  -- association [0..1]
LEFT OUTER JOIN I_FMEATaskType AS _FMEATaskType ON FMEATaskType = _FMEATaskType.FMEATaskType  -- association [0..1]
LEFT OUTER JOIN I_FMEATaskText AS _FMEATaskText ON FMEATaskUUID = _FMEATaskText.FMEATaskUUID  -- association [0..*]
LEFT OUTER JOIN I_FMEALongText AS _FMEATaskLongText ON FMEATaskUUID = _FMEATaskLongText.FMEANodeUUID  -- association [0..*]
LEFT OUTER JOIN I_FMEATaskAssignedActionStatus AS _FMEATaskActionStatus ON FMEATaskUUID = _FMEATaskActionStatus.FMEATaskUUID  -- association [0..1]
LEFT OUTER JOIN E_FMEATask AS _Extension ON FMEATaskUUID = _Extension.FMEATaskUUID  -- association [1..1]
;