I_InsuranceClaimShadowTask

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_InsuranceClaimShadowTask.
-- 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: IICLCLMSHDWTASK

CREATE VIEW I_InsuranceClaimShadowTask AS
SELECT
  claim AS InsuranceClaim,
  subclaim AS InsurClmSubclm,
  actnumber AS InsurClmActivitySequenceNumber,
  tstmp_to_dats( changetime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as InsurClmChangeDate AS clientNULLasInsurClmChangeDate,
  tstmp_to_tims( changetime, abap_system_timezone( $session.client,'NULL' ), $session.client, 'NULL' ) as InsurClmChangedTime AS clientNULLasInsurClmChangedTime,
  cast(changetime as timestamp) AS ChangedOnDateTime,
  cast(createtime as timestamp) AS CreationDateTime,
  activity AS InsurClmActivity,
  xmanual AS InsurClmTaskManualFlag,
  text AS InsurClmTaskName,
  cast(duetime as timestamp) AS InsurClmDueDateTime,
  xdone AS InsurClmTaskCompleted,
  act_status AS InsurClmActivityStatus,
  subobjcat AS InsurClmSubobjectCategory,
  subobject AS InsurClmSubobject,
  man_actorid AS InsurClmProposedHandler,
  subactivityused AS InsurClmSubActivityUsed,
  man_otype AS InsurClmProposeHandlerCategory,
  navigate AS InsurClmNavigate,
  changedby AS InsurClmChangedBy,
  deleted AS InsurClmDatabaseLineStatus,
  createdby AS CreatedByUser,
  act_assign_state AS InsurClmActyAssgmtSts,
  act_handlertype AS InsurClmActyHdlrType,
  act_handler AS InsurClmActyHdlr,
  act_hndlrtp_grp AS InsurClmActyHdlrTypeGrp,
  act_handler_grp AS InsurClmActyHdlrGrp,
  cast ( resubm_time as icl_achangetime_fiori preserving type) AS InsurClmActyResubmsnDteTme,
  act_grp_cat AS InsurClmActyTaskType,
  expression_orig AS InsurClmActyExprOrign,
  cast ( duedate_time1 as icl_achangetime_fiori preserving type) AS InsurClmActy1stSubmsnDuDteTme,
  cast ( duedate_time2 as icl_achangetime_fiori preserving type) AS InsurClmActyLtstStrtDteTme,
  cast ( duedate_time3 as icl_achangetime_fiori preserving type) AS InsurClmActyLtstEndDteTme,
  priority_wf AS InsurClmActyWrkflwPrio,
  authgrp AS InsurClmActyAuthznGrp,
  cctype AS InsurClaimBundleType,
  task_ccevent AS InsurClaimBundleTaskLogEntry,
  xsystem_activity AS InsurClmActyIsSystActy,
  manual_task_only AS InsurClmActyIsMnlTsk,
  manual_character AS InsurClaimIsManualCharacter,
  wf_relevant AS InsurClmWrkflwRlvt,
  wf_status AS InsurClmWorkflowStatus,
  ref_objcat AS InsurClmObjectCategory,
  ref_object AS InsuranceClaimObject,
  reftask_subclaim AS InsurClmSubclaimReferenceTask,
  reftask_actno AS InsurClmRefNmbrActySqncNmbr,
  reftask_category AS InsuranceClaimReferenceTaskCat,
  parent_subclaim AS InsuranceClaimParentSubclaim,
  parent_subobjcat AS InsurClmParSubobjCat,
  parent_subobject AS InsuranceClaimParentSubobject,
  wi_id AS InsurClmActyIdOfWrkItm,
  text_langu AS InsuranceClaimTextLanguage,
  xforwarded AS InsuranceClaimIsForwarded,
  priority AS InsurClmActyPrio
FROM icsactivity
;