I_INSURCLMSUBROGATION

CDS View

Regress (Kopf)

I_INSURCLMSUBROGATION is a CDS View in S/4HANA. Regress (Kopf). It contains 22 fields. 3 CDS views read from this table.

Used by 3 CDS view(s) 22 fields

CDS Views using this table (3)

ViewTypeJoinVDMDescription
I_InsurClmFinOvwSubrogation view from COMPOSITE Finanzübersicht Regress
R_InsurClmSrvcsSubrogationTP view_entity from TRANSACTIONAL Claim Services Subrogation Header TP
R_InsurClmSubrogationTP view_entity from TRANSACTIONAL Insurance Claim Subrogation Header

Fields (22)

KeyField CDS FieldsUsed in Views
KEY InsuranceClaim InsuranceClaim 3
KEY InsurClmActive InsurClmActive 1
KEY InsurClmSubrogationUUID InsurClmSubrogationUUID 3
_Claim _Claim 1
ChangedOnDateTime ChangedOnDateTime 2
InsurClaimSubrogationCurrency InsurClaimSubrogationCurrency 2
InsurClaimSubrogationType InsurClaimSubrogationType 2
InsurClmDatabaseLineStatus InsurClmDatabaseLineStatus 2
InsurClmLtgtnUUID InsurClmLtgtnUUID 2
InsurClmSubrogationCompId InsurClmSubrogationCompId 2
InsurClmSubrogationEstAmount InsurClmSubrogationEstAmount 2
InsurClmSubrogationIsFinished InsurClmSubrogationIsFinished 2
InsurClmSubrogationLbltyRate InsurClmSubrogationLbltyRate 2
InsurClmSubrogationNumber InsurClmSubrogationNumber 2
InsurClmSubrogationPartyLiable InsurClmSubrogationPartyLiable 2
InsurClmSubrogationReason InsurClmSubrogationReason 2
InsurClmSubrogationSentDate InsurClmSubrogationSentDate 2
InsurClmSubrogationStatus InsurClmSubrogationStatus 2
InsurClmSubrogationStatusText InsurClmSubrogationStatusText 2
InsurClmSubrogtnClsRsnTxt InsurClmSubrogtnClsRsnTxt 2
InsurClmSubrogtnProbltyRate InsurClmSubrogtnProbltyRate 2
LastChangedByUser LastChangedByUser 2 
  --Label of view
-- e.g. display as filter name in the consumption
@EndUserText.label: 'Regress (Kopf)'

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

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

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

define view I_InsurClmSubrogation
  as select from icl_subrog

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

  association [1..*] to I_InsurClmSubrogationItem as _SubrogationItem on  $projection.InsuranceClaim          = _SubrogationItem.InsuranceClaim
                                                                      and $projection.InsurClmSubrogationUUID = _SubrogationItem.InsurClmSubrogationUUID
  //  association [0..1] to I_InsurClmSubrogationStatusTxt as _Status          on  $projection.InsurClmSubrogationStatus = _Status.InsurClmSubrogationStatus

  //                                                                           and _Status.Language                      = $session.system_language

{
  key active                                                       as InsurClmActive,
  key claim                                                        as InsuranceClaim,
  key cast ( subrog_guid as sysuuid_c preserving type)             as InsurClmSubrogationUUID,
  cast( changetime    as icl_achangetime_fiori preserving type )   as ChangedOnDateTime,
      changedby                                                    as LastChangedByUser,
      deleted                                                      as InsurClmDatabaseLineStatus,
      type                                                         as InsurClaimSubrogationType,
      reason                                                       as InsurClmSubrogationReason,
      estimamount                                                  as InsurClmSubrogationEstAmount,
      currency                                                     as InsurClaimSubrogationCurrency,
      liabrate                                                     as InsurClmSubrogationLbltyRate,
      probability                                                  as InsurClmSubrogtnProbltyRate,
      bp_sbrg_main                                                 as InsurClmSubrogationPartyLiable,
      lithguid                                                     as InsurClmLtgtnUUID,
      // Added SR_STATUS field as part of Claims Inquiry app creation - 24/04/2020

      sr_status   as InsurClmSubrogationStatus,
      // Added Case statement for status text as part of Claims Inquiry app creation - 24/04/2020

      case sr_status
            when '' then 'Created'
            when '1' then 'Initiate'
            when '2' then 'Demand Made'
            when '3' then 'Partially Paid'
            when '4' then 'Fully Paid'
            when '5' then 'Closed'
            else 'Data Not Found'
      end                                                          as InsurClmSubrogationStatusText,
      //      _Status.InsurClmSubrogationStatusText as InsurClmSubrogationStatusText,


      sentdate                                                     as InsurClmSubrogationSentDate,
      finished                                                     as InsurClmSubrogationIsFinished,
      closereason                                                  as InsurClmSubrogtnClsRsnTxt,
      subrog_id                                                    as InsurClmSubrogationNumber,
      subrog_cguid                                                 as InsurClmSubrogationCompId,
      _Claim,
      _SubrogationItem
}

/*+[internal] {
"BASEINFO":
{
"FROM":
[
"ICL_SUBROG"
],
"ASSOCIATED":
[
"I_INSURANCECLAIM",
"I_INSURCLMSUBROGATIONITEM"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/

Learn More