I_InsurClmLossExpnRcvryInqry

DDL: I_INSURCLMLOSSEXPNRCVRYINQRY SQL: IICLLSEXPRECINQY Type: view COMPOSITE Package: ICL_VDM_CLAIMINQUIRY

Finanzübersicht für Auskunft

I_InsurClmLossExpnRcvryInqry is a Composite CDS View that provides data about "Finanzübersicht für Auskunft" in SAP S/4HANA. It reads from 1 data source (I_InsurClmLossExpenseRecovery) and exposes 12 fields with key field InsuranceClaim. Part of development package ICL_VDM_CLAIMINQUIRY.

1 data source(s) 12 fields

Data Sources (1)

SourceAliasJoin Type
I_InsurClmLossExpenseRecovery I_InsurClmLossExpenseRecovery from

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IICLLSEXPRECINQY view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Finanzübersicht für Auskunft view

Fields (12)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim
InsurClmSalvagePaytAmt
InsurClmSubrogtnRcvryPaytAmt
InsurClmRecoveryPaytAmt
InsurClmTotalRecoveryPaytAmt
InsurClmLossPaytAmt
InsurClmExpensePaytAmt
InsurClmLossReserveAmt
InsurClmExpenseReserveAmount
InsurClmLossExpenditureAmount
InsurClmExpnExpenditureAmount
InsurClmPaymentCurrency InsurClmPaymentCurrency 
@AbapCatalog.sqlViewName: 'IICLLSEXPRECINQY'
@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 Auskunft'
define view I_InsurClmLossExpnRcvryInqry
  as select from I_InsurClmLossExpenseRecovery
{
  key InsuranceClaim,
      sum(InsurClmSalvagePaytAmt)        as InsurClmSalvagePaytAmt,
      sum(InsurClmSubrogtnRcvryPaytAmt)  as InsurClmSubrogtnRcvryPaytAmt,
      sum(InsurClmRecoveryPaytAmt)       as InsurClmRecoveryPaytAmt,
      sum(InsurClmTotalRecoveryPaytAmt)  as InsurClmTotalRecoveryPaytAmt,
      sum(InsurClmLossPaytAmt)           as InsurClmLossPaytAmt,
      sum(InsurClmExpensePaytAmt)        as InsurClmExpensePaytAmt,
      sum(InsurClmLossReserveAmt)        as InsurClmLossReserveAmt,
      sum(InsurClmExpenseReserveAmount)  as InsurClmExpenseReserveAmount,
      sum(InsurClmLossExpenditureAmount) as InsurClmLossExpenditureAmount,
      sum(InsurClmExpnExpenditureAmount) as InsurClmExpnExpenditureAmount,

      InsurClmPaymentCurrency

      //_Claim

}
group by
  InsuranceClaim,
  InsurClmPaymentCurrency

Learn More