I_InsurClmBundleTasks

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_InsurClmBundleTasks.
-- 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: IICLEACTIVITY

CREATE VIEW I_InsurClmBundleTasks AS
SELECT
  active AS InsurClmActive,
  ccevent AS InsurClaimBundle,
  actnumber AS InsurClmBndlActySqncNmbr,
  cast( changetime as icl_achangetime_fiori preserving type ) AS ChangedOnDateTime,
  changedby AS LastChangedByUser,
  deleted AS InsurClmDatabaseLineStatus,
  cast( createtime as icl_createutc_fiori preserving type ) AS CreationDateTime,
  createdby AS CreatedByUser,
  activity AS InsuranceClaimBundleActivity,
  xmanual AS InsurClmTaskManualFlag,
  text AS InsurClmTaskName,
  cast( duetime as icl_achangetime_fiori preserving type ) AS InsurClmDueDateTime,
  xdone AS InsurClmTaskCompleted,
  act_status AS InsurClmActivityStatus,
  navigate AS InsurClmBndlTskNavgnTgt,
  subobjcat AS InsurClmSubobjectCategory,
  subobject AS InsurClmActySubobj,
  act_assign_state AS InsurClmActyAssgmtSts,
  act_handlertype AS InsurClmActyHdlrType,
  act_handler AS InsurClmActyHdlr,
  act_hndlrtp_grp AS InsurClmActyHdlrTypeGrp,
  act_handler_grp AS InsurClmActyHdlrGrp,
  subactivityused AS InsurClmActyActyUsdProcTsk,
  cast( resubm_time as icl_achangetime_fiori preserving type ) AS InsurClmActyResubmsnDteTme,
  subactivityn AS InsurClmSubActivityUsedName,
  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,
  man_actorid AS InsurClmProposedHandler,
  priority_wf AS InsurClmActyWrkflwPrio,
  authgrp AS InsurClmActyAuthznGrp,
  xsystem_activity AS InsurClmActyIsSystActy,
  wf_status AS InsurClmWorkflowStatus,
  not_wf_relevant AS InsurClmBndlIsWrkflwRlvt,
  wi_id AS InsurClmActyIdOfWrkItm,
  manual_task_only AS InsurClmActyIsMnlTsk
FROM icleactivity
;