I_InsurClmFNOLDamagedObjectTP

DDL: I_INSURCLMFNOLDAMAGEDOBJECTTP Type: view_entity TRANSACTIONAL

Damaged Object FNOL - TP

I_InsurClmFNOLDamagedObjectTP is a Transactional CDS View that provides data about "Damaged Object FNOL - TP" in SAP S/4HANA. It reads from 1 data source (I_InsurClmDmgdObjChange) and exposes 85 fields with key fields InsuranceClaim, InsurClmDamagedObject, InsurClaimUUID, InsurClmDmgdObjUUID. It has 11 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmDmgdObjChange I_InsurClmDmgdObjChange from

Associations (11)

CardinalityTargetAliasCondition
[0..1] I_Address _InspectionLocAddress $projection.InsurClmDamagedObjectLocation = _InspectionLocAddress.AddressID
[0..*] I_InsurClmDmgdCatTxt _DamObjCatText $projection.InsurClmDamageCategory = _DamObjCatText.InsurClmDamageCategory
[0..*] I_InsurClmFNOLDmgdObjCatVH _DamagedCategory $projection.InsurClmDamageCategory = _DamagedCategory.InsurClmDamageCategory and $projection.InsurClmType = _DamagedCategory.InsurClmType and $projection.InsurClmTypeGeneration = _DamagedCategory.InsurClmTypeGeneration and $projection.InsurClmTypeVers = _DamagedCategory.InsurClmTypeVers
[0..1] I_InsurClmDmgdVehMake _Make $projection.InsurClmInsuredObjectCategory = _Make.InsurClmInsuredObjectCategory and $projection.InsurClmInsuredObjectMake = _Make.InsurClmInsuredObjectMake
[0..1] I_InsurClmDmgdVehModel _Model $projection.InsurClmInsuredObjectCategory = _Model.InsurClmInsuredObjectCategory and $projection.InsurClmInsuredObjectMake = _Model.InsurClmInsuredObjectMake and $projection.InsurClmInsuredObjectModel = _Model.InsurClmInsuredObjectModel
[0..*] I_InsurClmFNOLFactsDmgdVehTP _SFCDMG
[0..*] I_InsurClmFNOLDiagnosisTP _diagnosis
[1..*] I_InsurClmFNOLClmntTP _Clmnt
[1..*] I_InsurClmFNOLSrvcPrvdrTP _SrvsPrvdr
[1..*] I_InsurClmFNOLInjuredSFCTP _injusfc
[1..*] I_InsurClmFNOLVehDriverTP _driver

Annotations (7)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
AccessControl.personalData.blocking #NOT_REQUIRED view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #X view
EndUserText.label Damaged Object FNOL - TP view

Fields (85)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim
KEY InsurClmDamagedObject I_InsurClmDmgdObjChange InsurClmDamagedObject
KEY InsurClaimUUID
KEY InsurClmDmgdObjUUID InsurClmDmgdObjUUID
InsuranceClaimForEdit InsuranceClaim
ChangedOnDateTime ChangedOnDateTime
InsurClmInsuredObject InsurClmInsuredObject
InsurClmDamageCategory InsurClmDamageCategory
InsurClmDmgdCategoryForLineItm InsurClmDamageCategory
InsurClmType
InsurClmTypeGeneration
InsurClmTypeVers
InsurClmDamageSeverity InsurClmDamageSeverity
InsurClmProbableLossAmount InsurClmProbableLossAmount
InsurClmInsuredObjectCategory InsurClmInsuredObjectCategory
InsurClmREStreetName InsurClmREStreetName
InsurClmInjuredPersnStreetName InsurClmInjuredPersnStreetName
InsurClmRECityName InsurClmRECityName
InsurClmInjuredPersnCityName InsurClmInjuredPersnCityName
InsurClmInjuredPersnAddrTxt InsurClmInjuredPersnAddrTxt
InsurClmDmgdObjHasLblty InsurClmDmgdObjHasLblty
InsurClmDmgdObjActionIsChkd
InsurClmFNOLActionIsChkd
InsurClmInsuredObjectType InsurClmInsuredObjectType
InsurClmProbableLossAmountCrcy InsurClmProbableLossAmountCrcy
InsurClmInspectionDate InsurClmInspectionDate
InsurClmDamagedObjectLocation InsurClmDamagedObjectLocation
InsurClmRelationship InsurClmRelationship
InsurClmRelationshipText InsurClmRelationshipText
BusinessPartner BusinessPartner
InsurClmFatalInjury InsurClmFatalInjury
InsurClmImpairmentPercent InsurClmImpairmentPercent
InsurClmIntraCompany InsurClmIntraCompany
InsurClmParticipantType InsurClmParticipantType
InsurClmInjuryInsurCompanyName InsurClmInjuryInsurCompanyName
InsurClmInjuredPersnHouseNmbr InsurClmInjuredPersnHouseNmbr
InsurClmInjuredPersnCountry InsurClmInjuredPersnCountry
InsurClmNoInsurance InsurClmNoInsurance
InsurClmConstructionYear InsurClmConstructionYear
InsurClmVehicleMileage InsurClmVehicleMileage
InsurClmVehicleMileageUnit InsurClmVehicleMileageUnit
InsurClmVehicleValueAmount InsurClmVehicleValueAmount
InsurClmVehObjectValCurrency InsurClmVehObjectValCurrency
InsurClmVehicleIdentification InsurClmVehicleIdentification
InsurClmInsuredObjectMake InsurClmInsuredObjectMake
InsurClmInsuredObjectModel InsurClmInsuredObjectModel
InsurClmVehiclePlateNumber InsurClmVehiclePlateNumber
InsurClmVehicleMfrTxt _MakeTxt InsurClmVehicleMfrTxt
InsurClmVehicleMakeTxt _Make InsurClmVehicleMakeTxt
InsurClmVehicleModelTxt _Model InsurClmVehicleModelTxt
BirthDate BirthDate
BusinessPartnerName I_InsurClmDmgdObjChange BusinessPartnerName
InsurClmDamageCategoryTxt
HouseNumber _InspectionLocAddress HouseNumber
StreetName _InspectionLocAddress StreetName
CityName _InspectionLocAddress CityName
Region _InspectionLocAddress Region
PostalCode _InspectionLocAddress PostalCode
Country _InspectionLocAddress Country
InsurClmBuildingAddress InsurClmBuildingAddress
InsurClmBuildingTypeDesc InsurClmBuildingTypeDesc
InsurClmTotalLoss InsurClmTotalLoss
InsurClmPreferredSupplier InsurClmPreferredSupplier
InsurClmScopeOfLoss InsurClmScopeOfLoss
InsurClmPrimaryMaterial InsurClmPrimaryMaterial
InsurClmDmgdSubObject InsurClmDmgdSubObject
InsurClmClaimantID InsurClmClaimantID
InsurClmClaimantName InsurClmClaimantName
InsurClmRECountry InsurClmRECountry
InsurClmREHouseNmbr InsurClmREHouseNmbr
InsurClmRERegion InsurClmRERegion
InsurClmREPostalCode InsurClmREPostalCode
_DamObjCatText _DamObjCatText
_InspectionLocAddress _InspectionLocAddress
_Subclaim _Subclaim
_Claim _Claim
_SFCDMG _SFCDMG
_diagnosis _diagnosis
_SrvsPrvdr _SrvsPrvdr
_injusfc _injusfc
_driver _driver
_Clmnt _Clmnt
_DamagedCategory _DamagedCategory
_Make _Make
_Model _Model
@AccessControl.authorizationCheck: #CHECK
@AccessControl.personalData.blocking: #NOT_REQUIRED
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.usageType: {
    dataClass: #MIXED,
    sizeCategory: #L,
    serviceQuality: #X
}

@EndUserText.label: 'Damaged Object FNOL - TP'
define view entity I_InsurClmFNOLDamagedObjectTP
  as select from I_InsurClmDmgdObjChange 
  association        to parent I_InsurClmFNOLTP      as _Claim                on  $projection.InsuranceClaim = _Claim.InsuranceClaim
                                                                              and $projection.InsurClaimUUID = _Claim.InsurClaimUUID
  //                                                                         and $projection.InsurClaimUUID = _Claim.InsurClaimUUID

  composition [0..*] of I_InsurClmFNOLFactsDmgdVehTP as _SFCDMG
  composition [0..*] of I_InsurClmFNOLDiagnosisTP    as _diagnosis
  composition [1..*] of I_InsurClmFNOLClmntTP        as _Clmnt
  composition [1..*] of I_InsurClmFNOLSrvcPrvdrTP    as _SrvsPrvdr
  composition [1..*] of I_InsurClmFNOLInjuredSFCTP   as _injusfc
  composition [1..*] of I_InsurClmFNOLVehDriverTP    as _driver               
  association [0..1] to I_Address                    as _InspectionLocAddress on  $projection.InsurClmDamagedObjectLocation = _InspectionLocAddress.AddressID
  association [0..*] to I_InsurClmDmgdCatTxt         as _DamObjCatText        on  $projection.InsurClmDamageCategory = _DamObjCatText.InsurClmDamageCategory
  association [0..*] to I_InsurClmFNOLDmgdObjCatVH   as _DamagedCategory      on  $projection.InsurClmDamageCategory = _DamagedCategory.InsurClmDamageCategory
                                                                              and $projection.InsurClmType           = _DamagedCategory.InsurClmType
                                                                              and $projection.InsurClmTypeGeneration = _DamagedCategory.InsurClmTypeGeneration
                                                                              and $projection.InsurClmTypeVers       = _DamagedCategory.InsurClmTypeVers

  //  association [1..1] to ZCM_DAMAGEDCATEGORY            as _dmgcat               on  $projection.InsurClmDamageCategory = _dmgcat.DamagedCategory

  //  association [1..1] to ZCM_I_InsurClmDamageSeverityVH as _DamgSevVH            on  $projection.InsurClmDamageCategory = _DamgSevVH.InsurClmDamageCategory

  //                                                                                and $projection.InsurClmDamageSeverity = _DamgSevVH.InsurClmDamageSeverity


  //  association [1..1] to C_InsurClmBPQuickView        as _BPDetails            on  $projection.BusinessPartner = _BPDetails.BusinessPartner


  association [0..1] to I_InsurClmDmgdVehMake        as _Make                 on  $projection.InsurClmInsuredObjectCategory = _Make.InsurClmInsuredObjectCategory
                                                                              and $projection.InsurClmInsuredObjectMake     = _Make.InsurClmInsuredObjectMake
  association [0..1] to I_InsurClmDmgdVehModel       as _Model                on  $projection.InsurClmInsuredObjectCategory = _Model.InsurClmInsuredObjectCategory
                                                                              and $projection.InsurClmInsuredObjectMake     = _Model.InsurClmInsuredObjectMake
                                                                              and $projection.InsurClmInsuredObjectModel    = _Model.InsurClmInsuredObjectModel
{
  key         InsuranceClaim,
  key         I_InsurClmDmgdObjChange.InsurClmDamagedObject,
  key         cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) as InsurClaimUUID,
  key         InsurClmDmgdObjUUID,
  
              //cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) as ClaimDraftUUID,

              @ObjectModel.editableFieldFor: 'InsuranceClaim'
              InsuranceClaim                                                                       as InsuranceClaimForEdit,
              ChangedOnDateTime,
              InsurClmInsuredObject,
              InsurClmDamageCategory,
              InsurClmDamageCategory                                                               as InsurClmDmgdCategoryForLineItm,
              cast('' as abap.char( 4 ))                                                           as InsurClmType,
              cast('' as abap.numc(5))                                                             as InsurClmTypeGeneration,
              cast('' as abap.numc( 5 ))                                                           as InsurClmTypeVers,


              InsurClmDamageSeverity,
              //             _DmgSevTxt.InsurClmDamageSeverityName                                                as InsurClmDamageSeverityName,


              InsurClmProbableLossAmount,
              InsurClmInsuredObjectCategory,
              InsurClmREStreetName,
              InsurClmInjuredPersnStreetName,
              InsurClmRECityName,
              InsurClmInjuredPersnCityName,
              InsurClmInjuredPersnAddrTxt,
              //             InsurClmPrprtyConstructionYear,

              //              InsurClmInjuredPersnAddrTxt,

              //InsurClmInjuredPersnAddrTxt,

              InsurClmDmgdObjHasLblty,
              // concat('INJU', BusinessPartner)                                                      as InsurFactsSubobject,

              cast(case InsurClmDamageCategory
              when 'AU'  then ''
              else 'X'
              end as boolean_flg preserving type)                                                  as InsurClmDamObjCatIsVeh,

              cast( case InsurClmDamageCategory
               when 'BI' then ''
               else 'X'
               end as boolean_flg preserving type)                                                 as InsurClmDamObjCatIsInjured,

              cast( '' as abap.char(1) )                                                           as InsurClmDmgdObjActionIsChkd,
              cast( '' as abap.char(1) )                                                           as InsurClmFNOLActionIsChkd,
              InsurClmInsuredObjectType,
              InsurClmProbableLossAmountCrcy,

              // InsurClmDmgdObjLbltyFlag,

              InsurClmInspectionDate,
              InsurClmDamagedObjectLocation,
              InsurClmRelationship,
              InsurClmRelationshipText,

              BusinessPartner,
              InsurClmFatalInjury,
              // InsurClmInjuredPersnAddr,

              InsurClmImpairmentPercent,
              InsurClmIntraCompany,
              InsurClmParticipantType,
              //      _PartTxt.InsurClmParticipantTypeName                   as InsurClmParticipantTypeName,

              InsurClmInjuryInsurCompanyName,
              InsurClmInjuredPersnHouseNmbr,
              // InsurClmInjuredPersnStreet,

              // InsurClmInjuredPersnCity,

              InsurClmInjuredPersnCountry,
              InsurClmNoInsurance,
              InsurClmConstructionYear,
              InsurClmVehicleMileage,
              InsurClmVehicleMileageUnit,
              InsurClmVehicleValueAmount,
              InsurClmVehObjectValCurrency,
              InsurClmVehicleIdentification,
              InsurClmInsuredObjectMake,
              InsurClmInsuredObjectModel,
              InsurClmVehiclePlateNumber,
              _MakeTxt.InsurClmVehicleMfrTxt                                                       as InsurClmVehicleMfrTxt,
              case InsurClmDamageCategory
              when 'AU' then  concat_with_space(_MakeTxt.InsurClmVehicleMfrTxt, InsurClmInsuredObjectModel,1)
              when 'BI' then I_InsurClmDmgdObjChange.BusinessPartnerName
              when 'RE' then InsurClmBuildingTypeDesc
              else ''
              end                                                                                  as InsurClmDmgdObjCatTitle,


              case InsurClmDamageCategory
              when 'AU' then InsurClmVehiclePlateNumber
              when 'BI'  then BusinessPartner
              //              when 'RE'  then InsurClmPrprtyConstructionYear

              else ''
              end                                                                                  as InsurClmDmgdObjCatDesc,

              _Make.InsurClmVehicleMakeTxt                                                         as InsurClmVehicleMakeTxt,
              _Model.InsurClmVehicleModelTxt                                                       as InsurClmVehicleModelTxt,

              BirthDate,
              I_InsurClmDmgdObjChange.BusinessPartnerName,
              //              cast( '' as abap.char(10))                                                           as CreateVehicle,

              //              cast( '' as abap.char(20))                                                           as CopyFrmInsVehicle,

              //              cast( '' as abap.char(20))                                                           as AnotherVehicle,

              //              cast( '' as abap.char(1) )                                                           as InsurClmDmgObjActionHdl,


              _DamObjCatText[1: Language = $session.system_language ].Name                         as InsurClmDamageCategoryTxt,
              _InspectionLocAddress.HouseNumber,
              _InspectionLocAddress.StreetName,
              _InspectionLocAddress.CityName,
              _InspectionLocAddress.Region,
              _InspectionLocAddress.PostalCode,
              _InspectionLocAddress.Country,
              //      _dmgcat.DamagedCategory,



              InsurClmBuildingAddress,
              InsurClmBuildingTypeDesc,
              InsurClmTotalLoss,
              InsurClmPreferredSupplier,
              InsurClmScopeOfLoss,
              InsurClmPrimaryMaterial,
              //            InsurClmPrprtyConstruction,

              //             InsurClmDmgdPrptyType,

              // InsurClmDmgdPrptyTypeName,

              InsurClmDmgdSubObject,
              InsurClmClaimantID,
              InsurClmClaimantName,
              //InsurClmRECity,

              InsurClmRECountry,
              InsurClmREHouseNmbr,
              InsurClmRERegion,
              //InsurClmREStreet,

              InsurClmREPostalCode,
              //             _DamVehDtls,

              _DamObjCatText,
              _InspectionLocAddress,

              //      _dmgcat,

              //            _DmgProperty,

              _Subclaim,
              _Claim,
              _SFCDMG,
              _diagnosis,
              _SrvsPrvdr,
              _injusfc,
              _driver,
              _Clmnt,
              //           _DiagnosisData

              //      _DamgSevVH,

              //      _Propertytype,

              //        _BPDetails

              _DamagedCategory,
              _Make,
              _Model

}