I_InsurClaimTaskInqry

@AbapCatalog.sqlViewName: 'IICLCLMTASKINQRY'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK

@VDM.viewType: #COMPOSITE
@AccessControl.personalData.blocking: #REQUIRED
   
@ObjectModel.usageType: {
    dataClass: #MIXED,
    sizeCategory: #L,
    serviceQuality: #C
}
@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Offene Aufgaben bei Fall'
define view I_InsurClaimTaskInqry
  as select from I_InsurClaimTask
  association [0..1] to I_User as _User on $projection.InsurClmProposedHandler = _User.UserID
{
  key InsuranceClaim,
  key InsurClmSubclm,
  key InsurClmActivitySequenceNumber,

      cast( CreationDateTime as icl_achangetime_fiori preserving type )    as CreationDateTime,
      tstmp_to_dats( CreationDateTime,
                     abap_system_timezone( $session.client,'NULL' ),
                     $session.client,
                     'NULL' )                                              as CreationDate,

      InsurClmActivity,
      InsurClmTaskManualFlag,
      InsurClmTaskName,

      cast( InsurClmDueDateTime as icl_achangetime_fiori preserving type ) as InsurClmDueDateTime,

      tstmp_to_dats( InsurClmDueDateTime,
                     abap_system_timezone( $session.client,'NULL' ),
                     $session.client,
                     'NULL' )                                              as InsurClmDueDate,

      case
        when InsurClmDueDateTime is not initial then
           tstmp_seconds_between(
           tstmp_current_utctimestamp(),
           cast( InsurClmDueDateTime as abap.dec(15,0)),'FAIL')
         else
           0
         end                                                               as InsurClmTaskTimeDifference,

      //            case InsurClmTimediff

      //              when  0

      //              then 'X'

      //              else ''

      //              end as pendingtask,



      InsurClmTaskCompleted,
      InsurClmActivityStatus,
      //      InsurClmSubobjCat,

      //      InsurClmSubobject,

      InsurClmProposedHandler,

      _User.UserDescription
}
where
//      InsurClmActivityStatus <> '5'

//  and InsurClmActivityStatus <> '7'

//  and 

      InsurClmActivityStatus <> '8'
  and InsurClmActivityStatus <> '9'
  and InsurClmActivityStatus <> 'V'
  and InsurClmTaskCompleted  <> 'X'