I_INSURCLAIMTASK

CDS View

Aufgaben bei Fall

I_INSURCLAIMTASK is a CDS View in S/4HANA. Aufgaben bei Fall. 3 CDS views read from this table.

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_InsurClaimTaskInqry view from COMPOSITE Offene Aufgaben bei Fall
I_InsurClmTasksPending view from COMPOSITE Pending Tasks on Claim
R_InsurClaimTaskTP view_entity from TRANSACTIONAL Insurance Claim Tasks - TP
@AbapCatalog.sqlViewName: 'IICLCLMTASK'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK

@VDM.viewType: #BASIC
  
@ObjectModel.usageType: {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #L,
    serviceQuality: #C
}
@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Aufgaben bei Fall'
define view I_InsurClaimTask
  as select from iclactivity
{

  key claim                         as InsuranceClaim,
  key subclaim                      as InsurClmSubclm,
  key actnumber                     as InsurClmActivitySequenceNumber,
      cast(createtime as timestamp) as CreationDateTime,
      cast(changetime as timestamp) as ChangedOnDateTime,
      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,
      _dataaging                    as InsuranceDataAgingObjectDate

}
where
  active = #icl_active.'A'