I_InsurClmClaimOverview

@AbapCatalog.sqlViewName: 'IICLCLAIMOVW'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Schaden-/Leistungsfall cübersicht'
@AccessControl.personalData.blocking: #REQUIRED
@VDM.viewType: #COMPOSITE
@ObjectModel.usageType.serviceQuality: #X
@ObjectModel.usageType.sizeCategory: #L
@ObjectModel.usageType.dataClass: #TRANSACTIONAL
@ClientHandling.algorithm: #SESSION_VARIABLE
define view I_InsurClmClaimOverview
  as select from I_InsuranceClaim
  association [1..1] to I_InsurClmInsuredVehInquiry   as _InsuredVehicle   on  $projection.InsuranceClaim = _InsuredVehicle.InsuranceContract
  // and $projection.InsurClmVehicle   = _InsuredVehicle.InsurClmVehicle

  association [1..1] to I_InsurClmLossCause           as _LossCause        on  $projection.InsurClmType           = _LossCause.InsurClmType
                                                                           and $projection.InsurClmTypeGeneration = _LossCause.InsurClmTypeGeneration
                                                                           and $projection.InsurClmTypeVers       = _LossCause.InsurClmTypeVers
                                                                           and $projection.InsurClmCauseOfLoss    = _LossCause.InsurClmCauseOfLoss
  association [1..1] to I_Address                     as _address          on  $projection.InsurClmLossLocAddressID = _address.AddressID
                                                                           and $projection.InsurClmLossLocAddressID is not initial
  association [0..1] to I_InsurClmLossDesc            as _LossDescription  on  $projection.InsuranceClaim = _LossDescription.InsuranceClaim

  association [0..1] to I_InsurClmHandler             as _ClaimHandler     on  $projection.InsuranceClaim = _ClaimHandler.InsuranceClaim

  association [0..*] to I_InsurClmIncdntTypeText      as _IncidentTypeText on  $projection.InsurClmIncdntType = _IncidentTypeText.InsurClmIncdntType

  association [0..1] to I_InsurClmPolicyHolderInquiry as _PolicyHolder     on  $projection.InsuranceClaim = _PolicyHolder.InsuranceClaim

  association [0..1] to I_InsurClmStatus              as _ClaimStatus      on  $projection.InsurClmLifeCycSts = _ClaimStatus.InsurClmLifeCycSts

  association [0..*] to I_InsurClmComplexityText      as _ComplexityText   on  $projection.InsurClmComplexity = _ComplexityText.InsurClmComplexity

  association [1..1] to I_InsurClmLossExpnRcvryInqry  as _LossExpRecovery  on  $projection.InsuranceClaim = _LossExpRecovery.InsuranceClaim

  association [1..1] to I_InsurClmObjectAssignment    as _ObjectAssign     on  $projection.InsuranceClaim              = _ObjectAssign.InsuranceClaim
                                                                           and _ObjectAssign.InsurClmSubobjectCategory = 'C'
                                                                           and _ObjectAssign.InsurClmObjectCategory    = 'E'
                                                                           and _ObjectAssign.IsDeleted                 = 'O'

  association [1..1] to I_InsurClmLossLocDesc         as _LossLocDesc      on  $projection.InsuranceClaim = _LossLocDesc.InsuranceClaim

  association [1..1] to I_InsurClmIncidentDetails     as _LossDesc         on  $projection.InsuranceClaim = _LossDesc.InsuranceClaim

  // association [1..1] to I_InsurClmStatusText          as _StatusDrop       on  $projection.InsurClmLifeCycSts = _StatusDrop.InsurClmLifeCycSts // _StatusDrop.Language = $session.system_language

  association [0..1] to E_InsuranceClaim              as _Extension        on  $projection.InsuranceClaim = _Extension.InsuranceClaim
  association [1..1] to I_InsurClmStatsReasonText     as _StatusReasonText on  $projection.InsurClmStatReason = _StatusReasonText.InsurClmStatReason
                                                                           and _StatusReasonText.Language     = $session.system_language
{
  key InsuranceClaim,
      InsuranceContract,
      InsurClmPolicyProduct,
      //   @Consumption.valueHelp: '_StatusDrop'

      InsurClmLifeCycSts,


      _ClaimStatus._ClaimStatusText[ Language = $session.system_language ].InsurClmLifeCycStsName    as InsurClmLifeCycStsName,

      InsurClmType,
      InsurClmTypeGeneration,
      InsurClmTypeVers,
      InsurClmAuthznGrp,
      InsurClmPolicyProdGeneration,
      InsurClmPolicyProductVersion,

      InsurClmIncdntType,
      _IncidentTypeText[ Language = $session.system_language ].InsurClmIncdntTypeName                as InsurClmIncdntTypeName,

      _PolicySnapshot.InsurLineOfBus,
      InsurClmDateOfLoss,
      InsurClmCauseOfLoss,
      InsurClmLossLocAddressID,
      _LossLocDesc.InsurClmDescriptionOfLossLoc                                                      as InsurClmDescriptionOfLossLoc,
      _LossDesc.InsurClmIncidentDetailsText,

      _ObjectAssign.InsuranceClaimObject                                                             as InsurClaimBundle,

      InsurClmTimeOfLoss,
      InsurClmComplexity,
      _ComplexityText[ Language = $session.system_language ].InsurClmComplexityName                  as InsurClmComplexityName,

      InsurClmCovered,

      _PolicySnapshot.InsurancePolicy                                                                as InsurancePolicy,

      cast( _PolicySnapshot.InsurClmContractStartDateTime as icl_achangetime_fiori preserving type ) as InsurClmContractStartDateTime,

      cast( _PolicySnapshot.InsurClmContractEndDateTime as icl_achangetime_fiori preserving type )   as InsurClmContractEndDateTime,


      //      _InsuredVehicle.InsurClmVehiclePlateNumber                                                     as InsurClmVehiclePlateNumber,


      //      concat_with_space(_InsuredVehicle.InsurClmVehicleMfrTxt,_InsuredVehicle.InsurClmVehicleModelTxt,1) as InsurClmInsrdVehMakeModelText,

      //      _InsuredVehicle.InsurClmInsrdVehMakeModelText,


      ////      _address.StreetName                        as InsurClmLossLocStreet,

      ////      _address.HouseNumber                       as InsurClmLossLocHouseNumber,

      ////      _address.CityName                          as InsurClmLossLocCity,

      ////      _address.Region                            as InsurClmLossLocRegion,

      ////      _address.PostalCode                        as InsurClmLossLocPostalCode,

      ////      _address.Country                           as InsurClmLossLocCountry,

      concat_with_space( _address.HouseNumber,
       concat_with_space(_address.StreetName,
        concat_with_space(_address.CityName,
         concat_with_space(_address.Region,
          concat_with_space(_address.PostalCode,_address.Country, 1), 1), 1), 1), 1 )                as InsurClmLocationText,

      _LossDescription.InsurClmDescriptionOfLoss                                                     as InsurClmDescriptionOfLoss,

      _LossCause._LossCauseText[ Language = $session.system_language ].InsurClmCauseOfLossName       as InsurClmCauseOfLossName,

      _ClaimHandler.FullName                                                                         as FullName,

      _PolicyHolder.InsurClmPolicyHolderName                                                         as InsurClmPolicyHolderName,
      _PolicyHolder.BusinessPartner                                                                  as InsurancePolicyholder,

      _LossExpRecovery.InsurClmExpnExpenditureAmount                                                 as InsurClmExpnExpenditureAmount,
      _LossExpRecovery.InsurClmLossExpenditureAmount                                                 as InsurClmLossExpenditureAmount,
      _LossExpRecovery.InsurClmTotalRecoveryPaytAmt                                                  as InsurClmTotalRecoveryPaytAmt,

      _LossExpRecovery.InsurClmLossPaytAmt                                                           as InsurClmLossPaytAmt,
      _LossExpRecovery.InsurClmExpensePaytAmt                                                        as InsurClmExpensePaytAmt,
      _LossExpRecovery.InsurClmLossReserveAmt                                                        as InsurClmLossReserveAmt,
      //Commented for incident:2180197645

      //      _LossExpRecovery.InsurClmExpenseReserveAmount                                                  as InsurClmExpenseReserveAmount,

      //End of commented for incident:2180197645


      //Added for incident:2180197645

      _LossExpRecovery.InsurClmExpnExpenditureAmount - _LossExpRecovery.InsurClmExpensePaytAmt       as InsurClmExpenseReserveAmount,
      //End of addition for incident:2180197645

      _LossExpRecovery.InsurClmSalvagePaytAmt                                                        as InsurClmSalvagePaytAmt,
      _LossExpRecovery.InsurClmSubrogtnRcvryPaytAmt                                                  as InsurClmSubrogtnRcvryPaytAmt,
      _LossExpRecovery.InsurClmRecoveryPaytAmt                                                       as InsurClmRecoveryPaytAmt,
      cast(_LossExpRecovery.InsurClmPaymentCurrency as char0008)                                     as InsurClmPaymentCurrency,
      InsurClmStatReason,
      InsurClmAgentReportedDate,
      _LossExpRecovery,
      _StatusReasonText
      // _StatusDrop







      ////      _LossCause

      ////      _PolicyProduct,

      ////      _PolicySnapshot,

      ////      _AllwdSubclmType

}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_ADDRESS",
"I_INSURANCECLAIM",
"I_INSURCLMCOMPLEXITYTEXT",
"I_INSURCLMHANDLER",
"I_INSURCLMINCDNTTYPETEXT",
"I_INSURCLMINCIDENTDETAILS",
"I_INSURCLMLOSSCAUSE",
"I_INSURCLMLOSSCAUSETEXT",
"I_INSURCLMLOSSDESC",
"I_INSURCLMLOSSEXPNRCVRYINQRY",
"I_INSURCLMLOSSLOCDESC",
"I_INSURCLMOBJECTASSIGNMENT",
"I_INSURCLMPOLICYHOLDERINQUIRY",
"I_INSURCLMPOLICYSNAPSHOT",
"I_INSURCLMSTATUS",
"I_INSURCLMSTATUSTEXT"
],
"ASSOCIATED":
[
"E_INSURANCECLAIM",
"I_ADDRESS",
"I_INSURCLMCOMPLEXITYTEXT",
"I_INSURCLMHANDLER",
"I_INSURCLMINCDNTTYPETEXT",
"I_INSURCLMINCIDENTDETAILS",
"I_INSURCLMINSUREDVEHINQUIRY",
"I_INSURCLMLOSSCAUSE",
"I_INSURCLMLOSSDESC",
"I_INSURCLMLOSSEXPNRCVRYINQRY",
"I_INSURCLMLOSSLOCDESC",
"I_INSURCLMOBJECTASSIGNMENT",
"I_INSURCLMPOLICYHOLDERINQUIRY",
"I_INSURCLMSTATSREASONTEXT",
"I_INSURCLMSTATUS"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/