I_InsuranceClaim

@AbapCatalog.sqlViewName: 'INSURANCECLAIM'
@AbapCatalog.compiler.compareFilter: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Schaden-/Leistungsfall'
@VDM.viewType: #BASIC
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
@AbapCatalog.preserveKey:true

define view I_InsuranceClaim
  as select from iclclaim

  association [0..1] to I_InsurClaimPolicyProduct    as _PolicyProduct   on  $projection.InsurClmPolicyProduct        = _PolicyProduct.InsurClmPolicyProduct
                                                                         and $projection.InsurClmPolicyProdGeneration = _PolicyProduct.InsurClmPolicyProdGeneration
                                                                         and $projection.InsurClmPolicyProductVersion = _PolicyProduct.InsurClmPolicyProductVersion

  association [0..1] to I_InsurClmPolicySnapshot     as _PolicySnapshot  on  $projection.InsuranceClaim              = _PolicySnapshot.InsuranceClaim
                                                                         and _PolicySnapshot.InsurClmContractVersion = '00'

  association [0..*] to I_InsurIntClmTypeAllwdSubclm as _AllwdSubclmType on  $projection.InsurClmType           = _AllwdSubclmType.InsurClmType
                                                                         and $projection.InsurClmTypeGeneration = _AllwdSubclmType.InsurClmTypeGeneration
                                                                         and $projection.InsurClmTypeVers       = _AllwdSubclmType.InsurClmTypeVers
  //association [1..1] to E_InsuranceClaim             as _Extension       on  I_InsurClm1stNotif.insuranceclaim = _Extension.InsuranceClaim

  //and _Extension.InsurClmActive         = 'A'

{
  key claim                                                       as InsuranceClaim,
      policy                                                      as InsuranceContract,
      polprod                                                     as InsurClmPolicyProduct,
      cast( changetime as icl_achangetime_fiori preserving type ) as ChangedOnDateTime,
      changedby                                                   as LastChangedByUser,
      cast( createtime as icl_createutc_fiori   preserving type ) as CreationDateTime,
      createdby                                                   as CreatedByUser,
      status                                                      as InsurClmLifeCycSts,
      statreason                                                  as InsurClmStatReason,
      claimtype                                                   as InsurClmType,
      authclm                                                     as InsurClmAuthznGrp,
      generat                                                     as InsurClmPolicyProdGeneration,
      version                                                     as InsurClmPolicyProductVersion,
      losstype                                                    as InsurClmIncdntType,
      dateloss                                                    as InsurClmDateOfLoss,
      losscause                                                   as InsurClmCauseOfLoss,
      lossaddress                                                 as InsurClmLossLocAddressID,
      cltypeg                                                     as InsurClmTypeGeneration,
      cltypev                                                     as InsurClmTypeVers,
      timeloss                                                    as InsurClmTimeOfLoss,
      ltimezone                                                   as InsurClmTimeZoneOfLoss,
      cast( lrenewal   as icl_lrenewal_fiori   preserving type )  as InsurClmContractLastRenewal,
      cast( verchngutc as icl_verchngutc_fiori preserving type )  as InsurClmVersionChangeTime,
      assign_guid                                                 as InsurClmAssignUUID,
      complex                                                     as InsurClmComplexity,
      juriscountry                                                as InsurClmJurisdictionCountry,
      jurisregion                                                 as InsurClmJurisdictionRegion,
      covered                                                     as InsurClmCovered,
      // Added BENTREE,BENTREEG,BENTREEV field for Claim item, Payment App - start - 20.10.2021

      bentree                                                     as InsurClmBenefitTypeTree,
      bentreeg                                                    as InsurClmBnftTypeTreeGeneration,
      bentreev                                                    as InsurClmBnftTypeTreeVersion,
      // Added BENTREE,BENTREEG,BENTREEV field for Claim item, Payment App - end - 20.10.2021

      xwithout_product                                            as InsurClmIsWithoutProduct,
      xdummyclaim                                                 as InsurClmIsDummyClaim,
      lossrepcompa                                                as InsurClmReportedDate,
      lossrepagent                                                as InsurClmAgentReportedDate,
      xsensitive                                                  as InsurClmSensitiveClaim,
      //      exclaimno                                                    as InsuranceClaimExternalNumber,

      //      Added for FNOL Claim Nr. to appear in FNOL RAP based Fiori app

      fnol_claimnr                                                as InsuranceClaimDraftIdentifier,
      _PolicyProduct,
      _PolicySnapshot,
      _AllwdSubclmType
}

where
      active  =  #icl_active.'A'
  and deleted <> #boole.'X'