I_InsurClmFNOLDamagedObjectTP
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)
| Source | Alias | Join Type |
|---|---|---|
| I_InsurClmDmgdObjChange | I_InsurClmDmgdObjChange | from |
Associations (11)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [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)
| Name | Value | Level | Field |
|---|---|---|---|
| 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)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| 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
}
Learn More
- What Is a CDS View in SAP S/4HANA?
- Types of CDS Views: Basic, Composite, Consumption, and Transactional
- SAP Tables vs CDS Views — Key Differences
- Understanding Data Lineage in SAP S/4HANA
- VDM (Virtual Data Model) in SAP S/4HANA Explained
- CDS View Annotations — A Complete Guide
- CDS View Field Mapping and Associations
- Understanding the SAP S/4HANA Data Model
- CDS View Extensions and Custom Fields in SAP S/4HANA
- Released APIs and Stability Contracts in SAP S/4HANA