I_InsurClmSrvcTaskHistoryDEX

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_InsurClmSrvcTaskHistoryDEX.
-- 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.

CREATE VIEW I_InsurClmSrvcTaskHistoryDEX AS
SELECT
  claim AS InsuranceClaim,
  subclaim AS InsurClmSubclm,
  actnumber AS InsurClmActivitySequenceNumber,
  active AS InsurClmActive,
  cast(changetime as timestamp preserving type) AS ChangedOnDateTime,
  cast(createtime as timestamp) AS CreationDateTime,
  changedby AS InsurClmChangedBy,
  deleted AS InsurClmDatabaseLineStatus,
  createdby AS CreatedByUser,
  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,
  act_assign_state AS InsurClmActyAssgmtSts,
  act_handlertype AS InsurClmActyHdlrType,
  act_handler AS InsurClmActyHdlr,
  act_hndlrtp_grp AS InsurClmActyHdlrTypeGrp,
  act_handler_grp AS InsurClmActyHdlrGrp,
  man_actorid AS InsurClmProposedHandler,
  subactivityused AS InsurClmSubActivityUsed,
  cast( resubm_time as timestamp ) 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,
  man_otype AS InsurClmProposeHandlerCategory,
  priority_wf AS InsurClmActyWrkflwPrio,
  authgrp AS InsurClmActyAuthznGrp,
  xsystem_activity AS InsurClmActyIsSystActy,
  wf_status AS InsurClmWorkflowStatus,
  wi_id AS InsurClmActyIdOfWrkItm,
  manual_task_only AS InsurClmActyIsMnlTsk,
  navigate AS InsurClmNavigate,
  cctype AS InsurClaimBundleType,
  task_ccevent AS InsurClaimBundleTaskLogEntry,
  manual_character AS InsurClaimIsManualCharacter,
  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,
  text_langu AS InsuranceClaimTextLanguage,
  xforwarded AS InsuranceClaimIsForwarded
FROM icsactivity
LEFT OUTER JOIN I_InsuranceClaim AS _Claim ON InsuranceClaim = _Claim.InsuranceClaim  -- association [1]
;