C_LglCntntMManageTask

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_LglCntntMManageTask.
-- 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: CLCMMANTASK

CREATE VIEW C_LglCntntMManageTask AS
SELECT
  LegalTransactionTask,
  LegalTransactionUUID,
  LegalTransactionWrkflwSqnc,
  LglTransWrkFlwModInstce,
  cast(0 as int2) AS LegalTransactionTaskActySqnc,
  LegalTransactionTaskName,
  LegalTransaction,
  LegalTransactionTaskType,
  cast ( '' as sww_statxt ) AS LegalTransactionTaskTypeName,
  cast('' as xubname ) AS LegalTransactionTaskNewUsr,
  LegalTransactionTitle,
  LegalTransactionTaskCurUsr,
  LegalTransactionTaskStatus,
  cast ( '' as sww_statxt ) AS LegalTransactionTaskStatusName,
  LglCntntMContext AS LegalContext,
  LglCntntMContextVersion,
  LglCntntMContextTitle,
  LglTransTskCrtnUTCDteTme AS LglCntntMCreatedUTCDateTime,
  _LCMTaskNotif[1:LglCntntMTaskTopNotif = 'X'].LglCntntMCreatedUTCDateTime AS LglCntntMTskLastNotifiedDteTme,
  LglCntntMTaskCompltnUTCDteTme,
  0 AS LegalTransactionTaskStsCritlty,
  cast('' as rsm_de_agent_rule_id_s4) AS RespyMgmtContextAgentDetnRule,
  WorkflowTaskProcessorRole,
  cast('' as rsm_de_agent_rule_descr) AS RespyMCntxtAgentDetnRuleDesc,
  WorkflowTaskResult,
  cast ( '' as boole_d ) AS LglCntntMIsMyLegalTransaction,
  cast( '20210126154003' as swfleutcdatetime ) AS LglCntntMTaskDueDateTime,
  _LegalTransactionMainEntity.LglCntntMEntityType AS LglCntntMEntityType,
  _LegalTransactionMainEntity._LCMEntityTypeText[1: Language = $session.system_language].LglCntntMEntityTypeName AS LglCntntMEntityTypeName,
  _LegalTransactionMainEntity.LglCntntMEntity AS LglCntntMEntity,
  cast ('' as char80) AS LglCntntMEntityName,
  cast( '' as boole_d ) AS LglCntntMTaskIsOverdue,
  cast( '20210126154003' as swfleutcdatetime ) AS LglCntntMTaskFirstDueDateTime,
  cast ( '' as swd_text_d ) AS WorkflowStepResultText,
  cast ( '' as sww_recipient ) AS WorkflowTaskRecipient,
  LglCntntMTaskDefinition,
  LegalTransactionTaskCrtedByUsr,
  _LegalTransactionMainEntity._EntityTypeText AS _EntityTypeText
LEFT OUTER JOIN I_LCMUserContactCard AS _ProcessorByContactCard ON _ProcessorByContactCard.ContactCardType = 'User' AND _ProcessorByContactCard.ContactCardID = LegalTransactionTaskCurUsr AND _ProcessorByContactCard.ContactCardRole = 'Creator'  -- association [0..1]
LEFT OUTER JOIN I_LCMUserContactCard AS _CreatedByContactCard ON _CreatedByContactCard.ContactCardType = 'User' AND _CreatedByContactCard.ContactCardID = LegalTransactionTaskCrtedByUsr AND _CreatedByContactCard.ContactCardRole = 'Creator'  -- association [0..1]
LEFT OUTER JOIN C_LglCntntMTskActlAgents AS _LglCntntMTskActlAgents ON LegalTransactionTask = _LglCntntMTskActlAgents.WorkflowTaskInternalID  -- association [0..*]
LEFT OUTER JOIN C_LglCntntMRelatedTask AS _LCMRelatedTasks ON LegalTransactionUUID = _LCMRelatedTasks.LegalTransactionUUID AND LglTransWrkFlwModInstce = _LCMRelatedTasks.LglTransWrkFlwModInstce AND LegalTransactionTask <> _LCMRelatedTasks.LegalTransactionTask  -- association [0..*]
LEFT OUTER JOIN C_LglCntntMTaskNotif AS _LCMTaskNotif ON LegalTransactionTask = _LCMTaskNotif.LegalTransactionTask  -- association [0..*]
LEFT OUTER JOIN C_LglCntntMTaskComments AS _LglCntntMTaskComments ON LegalTransactionTask = _LglCntntMTaskComments.LegalTransactionTask  -- association [0..*]
LEFT OUTER JOIN C_LglCntntMContextQuickView AS _LglCntntMContextQuickView ON LglCntntMContextVersion = _LglCntntMContextQuickView.LglCntntMContextVersion AND LegalContext = _LglCntntMContextQuickView.LegalContext  -- association [0..1]
LEFT OUTER JOIN I_WorkflowTaskDueDate AS _LglCntntMTaskDueDateTimeVH ON LegalTransactionTask = _LglCntntMTaskDueDateTimeVH.WorkflowTaskInternalID  -- association [0..1]
LEFT OUTER JOIN I_LegalTransactionEntityMain AS _LegalTransactionMainEntity ON LegalTransactionUUID = _LegalTransactionMainEntity.LegalTransactionUUID  -- association [0..1]
;