C_LglCntntMRelatedTask

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_LglCntntMRelatedTask.
-- 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: CLCMRELTASK

CREATE VIEW C_LglCntntMRelatedTask AS
SELECT
  LegalTransactionTask,
  LegalTransactionUUID,
  LegalTransactionWrkflwSqnc,
  LglTransWrkFlwModInstce,
  LegalTransactionTaskName,
  LegalTransactionTaskCurUsr,
  LglTransTskCrtnUTCDteTme,
  LglCntntMTaskCompltnUTCDteTme,
  LegalTransactionTaskStatus,
  LegalTransactionTaskType,
  cast ( '' as sww_statxt ) AS LegalTransactionTaskTypeName,
  cast ( '' as sww_statxt ) AS LegalTransactionTaskStatusName,
  WorkflowTaskResult,
  cast ( '' as swd_text_d ) AS WorkflowStepResultText,
  0 AS LegalTransactionTaskStsCritlty,
  cast('' as rsm_de_agent_rule_id_s4) AS RespyMgmtContextAgentDetnRule,
  WorkflowTaskProcessorRole,
  cast('' as rsm_de_agent_rule_descr) AS RespyMCntxtAgentDetnRuleDesc
FROM I_LglCntntMTask
LEFT OUTER JOIN I_LCMUserContactCard AS _ProcessorContactCard ON _ProcessorContactCard.ContactCardType = 'User' AND _ProcessorContactCard.ContactCardID = LegalTransactionTaskCurUsr AND _ProcessorContactCard.ContactCardRole = 'Creator'  -- association [0..1]
;