R_InsurClmFNOLDamagedObjectTP

DDL: R_INSURCLMFNOLDAMAGEDOBJECTTP Type: view_entity TRANSACTIONAL Package: ICL_VDM_FNOL_API

FNOL Damaged Object

R_InsurClmFNOLDamagedObjectTP is a Transactional CDS View that provides data about "FNOL Damaged Object" in SAP S/4HANA. It reads from 1 data source (I_InsurClmDmgdObjChange) and exposes 67 fields with key fields InsuranceClaim, InsurClmDamagedObject, InsurClmDmgdSubObject. It has 5 associations to related views. Part of development package ICL_VDM_FNOL_API.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmDmgdObjChange I_InsurClmDmgdObjChange from

Associations (5)

CardinalityTargetAliasCondition
[0..*] R_InsurClmFNOLFactsDmgdVehTP _QuestionsDmgdVeh $projection.InsuranceClaim = _QuestionsDmgdVeh.InsuranceClaim and $projection.InsurClmDamagedObject = _QuestionsDmgdVeh.InsurFactsSubobject
[1..*] R_InsurClmFNOLDiagnosisTP _Diagnosis $projection.InsuranceClaim = _Diagnosis.InsuranceClaim and $projection.InsurClmDamagedObject = _Diagnosis.InsurClmInjuredPersonNumber
[1..*] R_InsurClmFNOLInjuredSFCTP _QuestionInjured $projection.InsuranceClaim = _QuestionInjured.InsuranceClaim and $projection.InsurClmDamagedObject = _QuestionInjured.InsurClmSubobject
[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

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label FNOL Damaged Object view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (67)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim
KEY InsurClmDamagedObject InsurClmDamagedObject
KEY InsurClmDmgdSubObject InsurClmDmgdSubObject
ChangedOnDateTime ChangedOnDateTime
InsurClmInsuredObject InsurClmInsuredObject
InsurClmDamageCategory InsurClmDamageCategory
InsurClmDmgdCategoryForLineItm InsurClmDamageCategory
InsurClmType
InsurClmTypeGeneration
InsurClmTypeVers
InsurClmDamageSeverity InsurClmDamageSeverity
InsurClmInsuredObjectCategory InsurClmInsuredObjectCategory
InsurClmREStreetName InsurClmREStreetName
InsurClmInjuredPersnStreetName InsurClmInjuredPersnStreetName
InsurClmRECityName InsurClmRECityName
InsurClmInjuredPersnCityName InsurClmInjuredPersnCityName
InsurClmInjuredPersnAddrTxt InsurClmInjuredPersnAddrTxt
InsurClmDmgdObjHasLblty InsurClmDmgdObjHasLblty
InsurClmDmgdObjActionIsChkd
InsurClmFNOLActionIsChkd
InsurClmInsuredObjectType InsurClmInsuredObjectType
InsurClmProbableLossAmount InsurClmProbableLossAmount
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
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
InsurClmBuildingAddress InsurClmBuildingAddress
InsurClmBuildingTypeDesc InsurClmBuildingTypeDesc
InsurClmTotalLoss InsurClmTotalLoss
InsurClmPreferredSupplier InsurClmPreferredSupplier
InsurClmScopeOfLoss InsurClmScopeOfLoss
InsurClmPrimaryMaterial InsurClmPrimaryMaterial
InsurClmClaimantID InsurClmClaimantID
InsurClmClaimantName InsurClmClaimantName
InsurClmRECountry InsurClmRECountry
InsurClmREHouseNmbr InsurClmREHouseNmbr
InsurClmRERegion InsurClmRERegion
InsurClmREPostalCode InsurClmREPostalCode
_Make _Make
_Model _Model
_QuestionInjured _QuestionInjured
_Diagnosis _Diagnosis
_QuestionsDmgdVeh _QuestionsDmgdVeh
_Claim _Claim
@AbapCatalog.viewEnhancementCategory: [#NONE]
@AccessControl.authorizationCheck: #MANDATORY
@EndUserText.label: 'FNOL Damaged Object'
@Metadata.ignorePropagatedAnnotations: true
@VDM: {
  viewType:#TRANSACTIONAL,
  lifecycle.contract.type:#SAP_INTERNAL_API
}
@ObjectModel: {
   semanticKey: [ 'InsuranceClaim' ],
usageType:{
  dataClass:      #TRANSACTIONAL,
  serviceQuality: #C,
  sizeCategory:   #XL
}
}
//@ObjectModel.sapObjectNodeType.name: 'InsuranceClaim'

define view entity R_InsurClmFNOLDamagedObjectTP
  as select from I_InsurClmDmgdObjChange
  association        to parent R_InsurClmFNOLTP      as _Claim                on  $projection.InsuranceClaim = _Claim.InsuranceClaim
  association [0..*] to R_InsurClmFNOLFactsDmgdVehTP as _QuestionsDmgdVeh on $projection.InsuranceClaim      = _QuestionsDmgdVeh.InsuranceClaim
                                                                  and $projection.InsurClmDamagedObject = _QuestionsDmgdVeh.InsurFactsSubobject
 
 
  //composition [0..*] of R_InsurClmFNOLDiagnosisTP    as _Diagnosis

  association [1..*] to R_InsurClmFNOLDiagnosisTP    as _Diagnosis on $projection.InsuranceClaim = _Diagnosis.InsuranceClaim
                                                                  and $projection.InsurClmDamagedObject = _Diagnosis.InsurClmInjuredPersonNumber
  
  //composition [1..*] of R_InsurClmFNOLClmntTP        as _Clmnt

  //composition [1..*] of R_InsurClmFNOLSrvcPrvdrTP    as _ServiceProvider

  association [1..*] to R_InsurClmFNOLInjuredSFCTP   as _QuestionInjured on  $projection.InsuranceClaim      = _QuestionInjured.InsuranceClaim
                                                                         and $projection.InsurClmDamagedObject   = _QuestionInjured.InsurClmSubobject
  //composition [1..*] of R_InsurClmFNOLVehDriverTP    as _Driver

  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
  association to E_InsuranceClaimDamagedObject as _Extension on  $projection.InsuranceClaim        = _Extension.InsuranceClaim
                                                            and $projection.InsurClmDamagedObject = _Extension.InsurClmDamagedObject
{
  key         InsuranceClaim,
  key         InsurClmDamagedObject,
  key         InsurClmDmgdSubObject,
   //           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,
              InsurClmInsuredObjectCategory,
              InsurClmREStreetName,
              InsurClmInjuredPersnStreetName,
              InsurClmRECityName,
              InsurClmInjuredPersnCityName,
              InsurClmInjuredPersnAddrTxt,
              InsurClmDmgdObjHasLblty,
              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,
              @Semantics.booleanIndicator: true
              cast( '' as abap.char(1) )           as InsurClmDmgdObjActionIsChkd,
              @Semantics.booleanIndicator: true
              cast( '' as abap.char(1) )           as InsurClmFNOLActionIsChkd,
              
              InsurClmInsuredObjectType,
              @Semantics.amount.currencyCode: 'InsurClmProbableLossAmountCrcy'
              InsurClmProbableLossAmount,
              InsurClmProbableLossAmountCrcy,
              InsurClmInspectionDate,
              InsurClmDamagedObjectLocation,
              InsurClmRelationship,
              InsurClmRelationshipText,
              BusinessPartner,
              InsurClmFatalInjury,
              InsurClmImpairmentPercent,
              InsurClmIntraCompany,
              InsurClmParticipantType,
              InsurClmInjuryInsurCompanyName,
              InsurClmInjuredPersnHouseNmbr,
              InsurClmInjuredPersnCountry,
              InsurClmNoInsurance,
              InsurClmConstructionYear,
              @Semantics.quantity.unitOfMeasure: 'InsurClmVehicleMileageUnit'
              InsurClmVehicleMileage,
              InsurClmVehicleMileageUnit,
              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,
//              _InspectionLocAddress.HouseNumber,

//              _InspectionLocAddress.StreetName,

//              _InspectionLocAddress.CityName,

//              _InspectionLocAddress.Region,

//              _InspectionLocAddress.PostalCode,

//              _InspectionLocAddress.Country,

              InsurClmBuildingAddress,
              InsurClmBuildingTypeDesc,
              InsurClmTotalLoss,
              InsurClmPreferredSupplier,
              InsurClmScopeOfLoss,
              InsurClmPrimaryMaterial,              
              InsurClmClaimantID,
              InsurClmClaimantName,
              InsurClmRECountry,
              InsurClmREHouseNmbr,
              InsurClmRERegion,
              InsurClmREPostalCode,
//              _InspectionLocAddress,

              _Make,
              _Model,
//              _Driver,

              _QuestionInjured,
 //             _ServiceProvider,

//              _Clmnt,

              _Diagnosis,
              _QuestionsDmgdVeh,
              _Claim

}