I_LegalTransactionWrkFlwTasks

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_LegalTransactionWrkFlwTasks.
-- 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: ILTWFTASKS

CREATE VIEW I_LegalTransactionWrkFlwTasks AS
SELECT
  LegalTransactionUUID,
  LegalTransactionTask,
  LegalTransactionWrkflwSqnc,
  LglTransWrkFlwModInstce,
  LglCntntMTaskGroupName,
  _LegalTransaction.LegalTransactionHealth AS LegalTransactionHealth,
  _LegalTransactionEntityMain.LegalTransactionEntityUUID AS LegalTransactionEntityUUID,
  _LglTransWorkflowTaskTitle.WorkflowTaskName AS LegalTransactionTaskName,
  LegalTransactionTaskType,
  LegalTransactionTaskTypeName,
  LegalTransactionTaskStatus,
  LegalTransactionTaskStatusName,
  LegalTransactionTaskCrtedByUsr,
  LglTransTskCrtnUTCDteTme,
  LegalTransactionTaskCurUsr,
  LglCntntMTaskDefinition AS WorkflowTaskDefinition,
  cast( '' as sww_recipient ) AS WorkflowTaskRecipient
FROM I_LegalTransactionStartedTasks
LEFT OUTER JOIN I_WorkflowTask AS _WorkflowTask ON LegalTransactionTask = _WorkflowTask.WorkflowTaskInternalID  -- association [0..1]
LEFT OUTER JOIN I_LCMUserContactCard AS _AgentContactCard ON _AgentContactCard.ContactCardType = 'User' AND _AgentContactCard.ContactCardID = WorkflowTaskRecipient AND _AgentContactCard.ContactCardRole = 'Creator'  -- association [0..1]
LEFT OUTER JOIN I_LegalTransaction AS _LegalTransaction ON LegalTransactionUUID = _LegalTransaction.LegalTransactionUUID  -- association [1..1]
LEFT OUTER JOIN I_LegalTransactionEntityMain AS _LegalTransactionEntityMain ON LegalTransactionUUID = _LegalTransactionEntityMain.LegalTransactionUUID  -- association [0..1]
;