I_InsurClmDmgdObjChange

@AbapCatalog.sqlViewName: 'ICLDMGOBJ'
@AbapCatalog.compiler.compareFilter: true
@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: 'Damaged Object Details'
@VDM.viewType: #COMPOSITE

@ObjectModel.usageType: {
    dataClass: #MIXED,
    sizeCategory: #S,
    serviceQuality: #D
}
@AccessControl.personalData.blocking: #REQUIRED
@ClientHandling.algorithm: #SESSION_VARIABLE

define view I_InsurClmDmgdObjChange
  as select from I_InsurClmDamagedObject
  association [1..*] to I_InsurClmDamagedVeh           as _DamVehDets        on  $projection.InsuranceClaim        = _DamVehDets.InsuranceClaim
                                                                             and $projection.InsurClmDamagedObject = _DamVehDets.InsurClmDamagedObject
  association [1..1] to I_InsurClmInjuredPersnRltnDets as _DmgdBodilyInjured on  $projection.InsuranceClaim        = _DmgdBodilyInjured.InsuranceClaim
                                                                             and $projection.InsurClmDamagedObject = _DmgdBodilyInjured.InsurClmInjuredPersonNumber
  association [1..1] to I_InsurClmDamagedPropertyTP    as _DmgdProperty      on  $projection.InsuranceClaim        = _DmgdProperty.InsuranceClaim
                                                                             and $projection.InsurClmDamagedObject = _DmgdProperty.InsurClmDamagedObject
  association [1..1] to I_InsurClmDamageSeverityText   as _DmgdSvrtyTxt      on  $projection.InsurClmDamageSeverity = _DmgdSvrtyTxt.InsurClmDamageSeverity
                                                                             and $projection.InsurClmDamageCategory = _DmgdSvrtyTxt.InsurClmDamageCategory
                                                                             and _DmgdSvrtyTxt.Language             = $session.system_language

  association [1..*] to I_InsurClmDamageAssignment     as _Subclaim          on  $projection.InsuranceClaim        = _Subclaim.InsuranceClaim
                                                                             and $projection.InsurClmDamagedObject = _Subclaim.InsurClmDamagedObject
  //                                                                             and _Subclaim.InsurClmSubobjectCategory   = 'S'

  //                                                                             and $projection.InsurClmSubobjectCategory = _Subclaim.InsurClmSubobjectCategory


  association [1]    to I_InsurClmPartcipnType         as _PartTxt           on  $projection.insurclmparticipanttype = _PartTxt.InsurClmParticipantType
  // and _PartTxt.Language                   = $session.system_language


  association [1..1] to I_InsurClmVehicleMfrTxt        as _MakeTxt           on  $projection.InsurClmInsuredObjectMake = _MakeTxt.InsurClmVehicleMfr
                                                                             and $projection.InsurClmDamageCategory    = _MakeTxt.InsurClmVehicleCat
  association [1]    to I_InsurClmDmgdPrptyType        as _PropertyType      on  $projection.InsurClmDamageCategory    = _PropertyType.InsurClmInsuredObjectCategory
                                                                             and $projection.InsurClmInsuredObjectType = _PropertyType.InsurClmInsuredObjectType
{
  key InsuranceClaim,

  key InsurClmDamagedObject,
  key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) as InsurClmDmgdObjUUID,
  key cast( case  when _Subclaim.InsurClmDmgdSubObject is null
          then '000' else _Subclaim.InsurClmDmgdSubObject end as abap.char(3) )            as InsurClmDmgdSubObject,
      //  key _Subclaim.InsurClmDmgdSubObject as InsurClmDmgdSubObject,

  key cast( case when _Subclaim.InsurClmSubobjectCategory  is null
            then 'C'     else  _Subclaim.InsurClmSubobjectCategory end as abap.char(2) )   as InsurClmSubobjectCategory,
      //     _Subclaim.InsurClmSubobjectCategory                                                 as InsurClmSubobjectCategory,

      InsurClmDamageCategory,
      CreationDateTime,
      CreatedByUser,
      ChangedOnDateTime,
      InsurClmInsuredObject,
      InsurClmDamageSeverity,
      InsurClmProbableLossAmount,
      InsurClmInsuredObjectCategory,
      InsurClmInsuredObjectType,
      @Semantics.currencyCode: true
      InsurClmProbableLossAmountCrcy,
      InsurClmDmgdObjHasLblty,
      _DamVehDets.InsurClmInspectionDate                                                   as InsurClmInspectionDate,
      _DamVehDets.InsurClmDamagedObjectLocation                                            as InsurClmDamagedObjectLocation,
      _DamVehDets.InsurClmVehicleIdentification                                            as InsurClmVehicleIdentification,

      _DamVehDets.InsurClmConstructionYear                                                 as InsurClmConstructionYear,
      @Semantics.quantity.unitOfMeasure: 'InsurClmVehicleMileageUnit'
      _DamVehDets.InsurClmVehicleMileage                                                   as InsurClmVehicleMileage,
      _DamVehDets.InsurClmVehicleMileageUnit                                               as InsurClmVehicleMileageUnit,
      @Semantics.amount.currencyCode: 'InsurClmVehObjectValCurrency'
      _DamVehDets.InsurClmVehicleValueAmount                                               as InsurClmVehicleValueAmount,
      @Semantics.currencyCode: true
      _DamVehDets.InsurClmVehObjectValCurrency                                             as InsurClmVehObjectValCurrency,

      //@ObjectModel.text.association: 'I_InsurClmVehicleMfrTxt'

      _DamVehDets.InsurClmInsuredObjectMake                                                as InsurClmInsuredObjectMake,


      _DamVehDets.InsurClmVehiclePlateNumber                                               as InsurClmVehiclePlateNumber,
      _DamVehDets.InsurClmInsuredObjectModel                                               as InsurClmInsuredObjectModel,

      //New fields for FNOL API 03/07/23 - Start

      _DamVehDets.InsurClmInsuredVehicleCategory                                           as InsurClmInsuredVehicleCategory,
      _DamVehDets.InsurClmVehicleEngineCapacity                                            as InsurClmVehicleEngineCapacity,
      _DamVehDets.InsurClmVehicleEngineCapUnit                                             as InsurClmVehicleEngineCapUnit,
      _DamVehDets.InsurClmSeasnlLicPlateValdFrm                                            as InsurClmSeasnlLicPlateValdFrm,
      _DamVehDets.InsurClmSeasnlLicPlateValidTo                                            as InsurClmSeasnlLicPlateValidTo,
      _DamVehDets.InsurClmVehiclePlateCountry                                              as InsurClmVehiclePlateCountry,
      _DamVehDets.InsurClmVehiclePlateRegion                                               as InsurClmVehiclePlateRegion,
      //New fields for FNOL API 03/07/23 - End


      _DmgdBodilyInjured.InsurClmRelationship                                              as InsurClmRelationship,
      _DmgdBodilyInjured.BusinessPartner,
      _DmgdBodilyInjured.InsurClmFatalInjury,
      _DmgdBodilyInjured.InsurClmImpairmentPercent,
      _DmgdBodilyInjured.InsurClmIntraCompany,
      _DmgdBodilyInjured.InsurClmParticipantType,
      _DmgdBodilyInjured.InsurClmNoInsurance,
      _DmgdBodilyInjured.BirthDate                                                         as BirthDate,
      _DmgdBodilyInjured.BusinessPartnerName                                               as BusinessPartnerName,

      _DmgdBodilyInjured.HouseNumber                                                       as InsurClmInjuredPersnHouseNmbr,
      _DmgdBodilyInjured.StreetName                                                        as InsurClmInjuredPersnStreetName,
      _DmgdBodilyInjured.CityName                                                          as InsurClmInjuredPersnCityName,
      _DmgdBodilyInjured.Country                                                           as InsurClmInjuredPersnCountry,
      _DmgdBodilyInjured._RelshpTypeTxt.InsurClmRelationshipText                           as InsurClmRelationshipText,
      _DmgdBodilyInjured.InsurClmInjuredPersnAddrTxt                                       as InsurClmInjuredPersnAddrTxt,
      _DmgdBodilyInjured.InsurClmInjuryInsurCompanyName                                    as InsurClmInjuryInsurCompanyName,
      _DmgdProperty.InsurClmBuildingAddress                                                as InsurClmBuildingAddress,
      _DmgdProperty.InsurClmBuildingTypeDesc                                               as InsurClmBuildingTypeDesc,
      _DmgdProperty.InsurClmTotalLoss                                                      as InsurClmTotalLoss,
      _DmgdProperty.InsurClmPreferredSupplier                                              as InsurClmPreferredSupplier,
      _DmgdProperty.InsurClmScopeOfLoss                                                    as InsurClmScopeOfLoss,
      _DmgdProperty.InsurClmPrimaryMaterial                                                as InsurClmPrimaryMaterial,
      _DmgdProperty.InsurClmConstructionYear                                               as InsurClmPrptyConstructionYear,
      _DmgdProperty.InsurClmClaimantID                                                     as InsurClmClaimantID,
      _DmgdProperty.InsurClmClaimantName                                                   as InsurClmClaimantName,
      _DmgdProperty.InsurClmRECityName                                                     as InsurClmRECityName,
      _DmgdProperty.InsurClmRECountry                                                      as InsurClmRECountry,
      _DmgdProperty.InsurClmREHouseNmbr                                                    as InsurClmREHouseNmbr,
      _DmgdProperty.InsurClmRERegion                                                       as InsurClmRERegion,
      _DmgdProperty.InsurClmREStreetName                                                   as InsurClmREStreetName,
      _DmgdProperty.InsurClmREPostalCode                                                   as InsurClmREPostalCode,
      _PropertyType.InsurClmInsuredObjectType                                              as InsurClmDmgdPrptyType,
      _PropertyType._PropTypeText.Name                                                     as InsurClmDmgdPrptyTypeName,
      //_Subclaim.InsurClmDmgdSubObject                                                      as InsurClmDmgdSubObject,


      //cast(_Subclaim.InsurClmDmgdSubObject as abap.numc( 3 )  )                            as InsurClmDmgdSubObject,







      _DamVehDets,
      _DmgdBodilyInjured,
      _DmgdProperty,
      _Subclaim,
      _DmgdSvrtyTxt,
      _MakeTxt,
      _PropertyType
}
/*+[internal] {
"BASEINFO":
{
"FROM":
[
"I_INSURCLMDAMAGEASSIGNMENT",
"I_INSURCLMDAMAGEDOBJECT",
"I_INSURCLMDAMAGEDPROPERTYTP",
"I_INSURCLMDAMAGEDVEH",
"I_INSURCLMDMGDPRPTYTYPE",
"I_INSURCLMDMGDPRPTYTYPETXT",
"I_INSURCLMINJUREDPERSNRLTNDETS",
"I_INSURCLMPRTCPNTRELSHPTYPETXT"
],
"ASSOCIATED":
[
"I_INSURCLMDAMAGEASSIGNMENT",
"I_INSURCLMDAMAGEDPROPERTYTP",
"I_INSURCLMDAMAGEDVEH",
"I_INSURCLMDAMAGESEVERITYTEXT",
"I_INSURCLMDMGDPRPTYTYPE",
"I_INSURCLMINJUREDPERSNRLTNDETS",
"I_INSURCLMPARTCIPNTYPE",
"I_INSURCLMVEHICLEMFRTXT"
],
"BASE":
[],
"ANNO_REF":
[],
"SCALAR_FUNCTION":
[],
"VERSION":0,
"ANNOREF_EVALUATION_ERROR":""
}
}*/