I_INSURCLMRESERVE

CDS View

Einzelfallreserve

I_INSURCLMRESERVE is a CDS View in S/4HANA. Einzelfallreserve. It contains 16 fields. 11 CDS views read from this table.

Used by 11 CDS view(s) 16 fields

CDS Views using this table (11)

ViewTypeJoinVDMDescription
I_InsurClmFinOvwReserveDetails view from COMPOSITE Finanzübersicht - Reserve Details
I_InsurClmFinOvwRsrvPaytItmEst view left_outer COMPOSITE Reservebezogene Zahlungpostenberechnungen
I_InsurClmReserveApp view from COMPOSITE Reserve Change App - Base View
I_InsurClmReserveUnion view union_all COMPOSITE Finanzübersicht für Reservenhistorie
I_InsurClmTotExpndtrReserve view from COMPOSITE Reserve-Sicht f. GesaAufwaAbfrage
P_InsurClmGrossReserve view from COMPOSITE
R_InsuranceClaimReserveTP view_entity from TRANSACTIONAL Insurance Claim Reserve - TP
R_InsurClmSrvcsReserveTP view_entity from TRANSACTIONAL Claim Services Reserves TP
R_InsurClmSrvcsSubclmReserveTP view_entity from TRANSACTIONAL Clm Srvcs Subclaim Reserve TP
R_InsurClmSubclaimReserveTP view_entity from TRANSACTIONAL Insurance Subclaim Reserve - TP
R_InsurClmSubclmLossReserveTP view from TRANSACTIONAL Teilfall - Entschädigungsreserve

Fields (16)

KeyField CDS FieldsUsed in Views
KEY InsuranceClaim InsuranceClaim 2
KEY InsurClmReserveCurrency InsurClmReserveCurrency 3
KEY InsurClmRsrvType InsurClmRsrvType 2
KEY InsurClmSubclm InsurClmSubclm 2
_Claim _Claim 1
_ReserveType _ReserveType 1
GrossReserveAmount GrossReserveAmount 2
InsurClmAssignUUID InsurClmAssignUUID 1
InsurClmChangeDate InsurClmChangeDate 1
InsurClmReserveChangeRsn InsurClmReserveChangeRsn 1
InsurClmRsrvChangeTime InsurClmRsrvChangeTime 1
InsurClmRsrvMethodName InsurClmRsrvMethodName 1
InsurClmRsrvMethodText InsurClmRsrvMethodText 1
InsurClmRsrvPendingAmount InsurClmRsrvPendingAmount 1
InsurClmSubclaimAssignUUID InsurClmSubclaimAssignUUID 1
PostingDate PostingDate 1 
@EndUserText.label: 'Einzelfallreserve'

@AbapCatalog: {
  sqlViewName: 'IICLRESERVE',
  compiler.compareFilter: true
}

@AccessControl.authorizationCheck: #CHECK
@AbapCatalog.preserveKey: true
@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #BASIC

@ObjectModel.usageType: {
    dataClass: #TRANSACTIONAL,
    sizeCategory: #L,
    serviceQuality: #B
}

define view I_InsurClmReserve
  as select from iclreserve

  association [1]    to I_InsurClmReserveType as _ReserveType on  $projection.InsurClmRsrvType = _ReserveType.InsurClmRsrvType

  association [0..1] to I_InsurClmSubclaim    as _Subclaim    on  $projection.InsuranceClaim = _Subclaim.InsuranceClaim
                                                              and $projection.InsurClmSubclm = _Subclaim.InsurClmSubclm

  association [1]    to I_InsuranceClaim      as _Claim       on  $projection.InsuranceClaim = _Claim.InsuranceClaim

{

  key claim                                                                                                 as InsuranceClaim,
  key subcl                                                                                                 as InsurClmSubclm,
  key restype                                                                                               as InsurClmRsrvType,
  key curr                                                                                                  as InsurClmReserveCurrency,
      //changetime                                                                                            as InsurClmRsrvChangeTime,

      cast(changetime as timestamp)                                                                         as InsurClmRsrvChangeTime,
      tstmp_to_dats(changetime,  abap_system_timezone( $session.client,'NULL' ), $session.client,'INITIAL') as InsurClmChangeDate,
      grossres                                                                                              as GrossReserveAmount,
      postdate                                                                                              as PostingDate,
      // Added field METHOD, Method text and RSPENDING as part of Claims Inquiry app creation - 28/04/2020

      method                                                                                                as InsurClmRsrvMethodName,
      case method
      when '2' then 'Statistical'
      when '4' then 'For compensation calculation'
      when '6' then 'Manually'
      when '8' then 'Re-distributed'
      else 'No data found'
      end                                                                                                   as InsurClmRsrvMethodText,
      rspending                                                                                             as InsurClmRsrvPendingAmount,
      // Added field change Reason for Reserve change app creation - 30/12/2020

      changereason                                                                                          as InsurClmReserveChangeRsn,

      _Subclaim.InsurClmSubclaimAssignUUID,
      _Claim.InsurClmAssignUUID,

      _Subclaim,
      _ReserveType,
      _Claim
}
where
      iclreserve.active  =  #icl_active.'A'
  and iclreserve.deleted <> #icl_recstatus.'X'
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURANCECLAIM",
"I_INSURCLMSUBCLAIM",
"ICLRESERVE"
],
"ASSOCIATED":
[
"I_INSURANCECLAIM",
"I_INSURCLMRESERVETYPE",
"I_INSURCLMSUBCLAIM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More