I_INSURCLMLOSSEXPENSERECOVERY

CDS View

Finanzübersicht für Entschädigung oder Kosten

I_INSURCLMLOSSEXPENSERECOVERY is a CDS View in S/4HANA. Finanzübersicht für Entschädigung oder Kosten. 1 CDS views read from this table.

Used by 1 CDS view(s)

CDS Views using this table (1)

ViewTypeJoinVDMDescription
I_InsurClmLossExpnRcvryInqry view from COMPOSITE Finanzübersicht für Auskunft 
@AbapCatalog.sqlViewName: 'IICLLOSSEXPREC'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@VDM.viewType: #COMPOSITE
  
@ObjectModel.usageType: {
    dataClass: #MIXED,
    sizeCategory: #L,
    serviceQuality: #D
}

@ClientHandling.algorithm: #SESSION_VARIABLE

@EndUserText.label: 'Finanzübersicht für Entschädigung oder Kosten'
define view I_InsurClmLossExpenseRecovery
  as select from I_InsurClmFinOvwDetails
{
  key InsuranceClaim,
  key InsurClmLossExpnType,

      sum(InsurClmSalvagePaytAmt)       as InsurClmSalvagePaytAmt,
      sum(InsurClmSubrogtnRcvryPaytAmt) as InsurClmSubrogtnRcvryPaytAmt,
      sum(InsurClmRecoveryPaytAmt)      as InsurClmRecoveryPaytAmt,

      case  InsurClmLossExpnType
            when '0' then //loss

            sum(InsurClmPaytAmt)
            else
              0
            end                         as InsurClmLossPaytAmt,
      case  InsurClmLossExpnType
            when '1' then //loss

            sum(InsurClmPaytAmt)
            else
            0
            end                         as InsurClmExpensePaytAmt,
      case  InsurClmLossExpnType
            when '0' then //loss

            sum(InsurClmReserveAmount)
            else
              0
            end                         as InsurClmLossReserveAmt,
      case  InsurClmLossExpnType
            when '1' then //loss

            sum(InsurClmReserveAmount)
            else
            0
            end                         as InsurClmExpenseReserveAmount,
      case  InsurClmLossExpnType
            when '0' then //loss

            sum(InsurClmTotalExpenditure)
            else
              0
            end                         as InsurClmLossExpenditureAmount,
      case  InsurClmLossExpnType
            when '1' then //loss

      //Commented for incident:2180197645

      //            sum(InsurClmTotalExpenditure)

      //End of commented for incident:2180197645


      //Added for incident:2180197645

      sum(InsurClmReserveAmount)
      //End of addition for incident:2180197645

            else
            0
            end                         as InsurClmExpnExpenditureAmount,

      sum(InsurClmTotalRecoveryPaytAmt) as InsurClmTotalRecoveryPaytAmt,
      sum(InsurClmPaytAmt)              as InsurClmPaytAmt,
      sum(InsurClmReserveAmount)        as InsurClmReserveAmount,
      sum(InsurClmTotalExpenditure)     as InsurClmTotalExpenditure,
      InsurClmPaymentCurrency

      // _Claim

}
group by
  InsuranceClaim,
  InsurClmLossExpnType,
  InsurClmPaymentCurrency
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURCLMFINOVWDETAILS"
],
"ASSOCIATED":
[],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More