I_InsurClmFNOLTP
FNOL Header - TP
I_InsurClmFNOLTP is a Transactional CDS View that provides data about "FNOL Header - TP" in SAP S/4HANA. It reads from 1 data source (I_InsuranceClaim) and exposes 51 fields with key fields InsuranceClaim, InsurClaimUUID. It has 15 associations to related views. Part of development package ICL_VDM_FIRSTNOTICEOFLOSS_RAP.
Data Sources (1)
| Source | Alias | Join Type |
|---|---|---|
| I_InsuranceClaim | I_InsuranceClaim | from |
Associations (15)
| Cardinality | Target | Alias | Condition |
|---|---|---|---|
| [1..1] | I_InsurClmIncdntType | _IncidentType | $projection.InsurClmPolicyProduct = _IncidentType.InsurClmPolicyProduct and $projection.InsurClmPolicyProdGeneration = _IncidentType.InsurClmPolicyProdGeneration and $projection.InsurClmPolicyProductVersion = _IncidentType.InsurClmPolicyProductVersion and $projection.InsurClmIncdntType = _IncidentType.InsurClmIncdntType |
| [0..1] | I_InsurClmLossCause | _LossCause | $projection.InsurClmType = _LossCause.InsurClmType and $projection.InsurClmTypeGeneration = _LossCause.InsurClmTypeGeneration and $projection.InsurClmTypeVers = _LossCause.InsurClmTypeVers and $projection.InsurClmCauseOfLoss = _LossCause.InsurClmCauseOfLoss |
| [0..1] | I_InsurClmLossDesc | _LossDescription | $projection.InsuranceClaim = _LossDescription.InsuranceClaim |
| [0..1] | I_Address | _LossLocationAddress | $projection.InsurClmLossLocAddressID = _LossLocationAddress.AddressID |
| [0..1] | I_InsurClmHandler | _ClaimHandler | $projection.InsuranceClaim = _ClaimHandler.InsuranceClaim |
| [0..1] | I_InsurClmStatus | _ClaimStatus | $projection.InsurClmLifeCycSts = _ClaimStatus.InsurClmLifeCycSts |
| [1..*] | I_InsurClmPrtcpntOccrnc | _PolicyHolder | $projection.InsuranceClaim = _PolicyHolder.InsuranceClaim and _PolicyHolder.InsurClmSubobjectCategory = 'PO' and _PolicyHolder.InsurClmSubobject = '' and _PolicyHolder.InsurClmParticipantRole = 'POLH' |
| [1..1] | I_InsurClmFNOLPaymentDetails | _FnolPay | $projection.InsurClmPolicyProduct = _FnolPay.InsurClmPolicyProduct and $projection.InsurClmIncdntType = _FnolPay.InsurClmIncdntType |
| [1..1] | I_InsurClmProdNameVH | _ProductName | $projection.InsurClmPolicyProduct = _ProductName.InsurClmPolicyProduct and $projection.InsurClmPolicyProdGeneration = _ProductName.InsurClmPolicyProdGeneration |
| [0..*] | I_InsurClmFNOLDamagedObjectTP | _DamagedVehicle | |
| [0..*] | I_InsurClmFNOLNoteTP | _Note | |
| [1..*] | I_InsurClmFNOLFactsOriginTP | _Facts | |
| [0..*] | I_InsurClmFNOLWtnssTP | _Witness | |
| [1..*] | I_InsurClmFNOLFactsLossLocTP | _SFCLoss | |
| [1..*] | I_InsurClmFNOLPaytAppTP | _Payment | |
Annotations (7)
| Name | Value | Level | Field |
|---|---|---|---|
| AccessControl.authorizationCheck | #CHECK | view | |
| EndUserText.label | FNOL Header - TP | view | |
| VDM.viewType | #TRANSACTIONAL | view | |
| ObjectModel.usageType.dataClass | #TRANSACTIONAL | view | |
| ObjectModel.usageType.sizeCategory | #L | view | |
| ObjectModel.usageType.serviceQuality | #X | view | |
| AccessControl.personalData.blocking | #REQUIRED | view |
Fields (51)
| Key | Field | Source Table | Source Field | Description |
|---|---|---|---|---|
| KEY | InsuranceClaim | InsuranceClaim | ||
| KEY | InsurClaimUUID | |||
| InsuranceClaimDraftIdentifier | InsuranceClaimDraftIdentifier | |||
| InsuranceContract | InsuranceContract | |||
| ChangedOnDateTime | ChangedOnDateTime | |||
| LastChangedByUser | LastChangedByUser | |||
| CreationDateTime | CreationDateTime | |||
| CreatedByUser | CreatedByUser | |||
| InsurClmType | InsurClmType | |||
| InsurClmTypeGeneration | InsurClmTypeGeneration | |||
| InsurClmTypeVers | InsurClmTypeVers | |||
| InsurClmLifeCycSts | InsurClmLifeCycSts | |||
| InsurClmLifeCycStsName | ||||
| InsurClmAuthznGrp | InsurClmAuthznGrp | |||
| InsurClmIncdntType | I_InsuranceClaim | InsurClmIncdntType | ||
| InsurClmIncdntTypeName | ||||
| InsurClmDateOfLoss | InsurClmDateOfLoss | |||
| InsurClmCauseOfLoss | InsurClmCauseOfLoss | |||
| InsurClmCauseOfLossName | ||||
| InsurClmLossLocAddressID | InsurClmLossLocAddressID | |||
| InsurClmPolicyProduct | I_InsuranceClaim | InsurClmPolicyProduct | ||
| InsurClmPolicyProdGeneration | I_InsuranceClaim | InsurClmPolicyProdGeneration | ||
| InsurClmPolicyProductVersion | I_InsuranceClaim | InsurClmPolicyProductVersion | ||
| InsurClmPlcyProdGnrtnSrchHelp | I_InsuranceClaim | InsurClmPolicyProdGeneration | ||
| InsurClmPolicyProdVersSrchHelp | I_InsuranceClaim | InsurClmPolicyProductVersion | ||
| InsurClmPlcyProdName | ||||
| InsurClmPolicyHolderName | _PolicyHolder | BusinessPartnerName | ||
| BirthDate | _PolicyHolder | BirthDate | ||
| FullName | _ClaimHandler | FullName | ||
| ContactCardID | _ClaimHandler | ContactCardID | ||
| InsurancePolicyholder | _PolicyHolder | BusinessPartner | ||
| InsurClmDescriptionOfLoss | _LossDescription | InsurClmDescriptionOfLoss | ||
| InsurClmLossLocStreet | _LossLocationAddress | StreetName | ||
| InsurClmLossLocHouseNumber | _LossLocationAddress | HouseNumber | ||
| InsurClmLossLocCity | _LossLocationAddress | CityName | ||
| InsurClmLossLocRegion | _LossLocationAddress | Region | ||
| InsurClmLossLocPostalCode | _LossLocationAddress | PostalCode | ||
| InsurClmLossLocCountry | _LossLocationAddress | Country | ||
| InsurClmLossLocLongitude | ||||
| InsurClmLossLocLatitude | ||||
| InsurClmImageURL | ||||
| _PolicyHolder | _PolicyHolder | |||
| _IncidentType | _IncidentType | |||
| _LossCause | _LossCause | |||
| _DamagedVehicle | _DamagedVehicle | |||
| _Note | _Note | |||
| _ClaimHandler | _ClaimHandler | |||
| _Witness | _Witness | |||
| _SFCLoss | _SFCLoss | |||
| _Facts | _Facts | |||
| _Payment | _Payment |
////@AbapCatalog.sqlViewName: 'ICLFNOLRAPTP'
//@AbapCatalog.compiler.compareFilter: true
//@AbapCatalog.preserveKey: true
@AccessControl.authorizationCheck: #CHECK
@EndUserText.label: ' FNOL Header - TP'
//@Metadata.allowExtensions: true
//@ClientHandling.algorithm: #SESSION_VARIABLE
@VDM.viewType: #TRANSACTIONAL
@ObjectModel.usageType: {
dataClass: #TRANSACTIONAL,
sizeCategory: #L,
serviceQuality: #X
}
//@ClientHandling.algorithm: #SESSION_VARIABLE
@AccessControl.personalData.blocking: #REQUIRED
define root view entity I_InsurClmFNOLTP
as select from I_InsuranceClaim
// association [1..1] to I_InsurClmFNOLContract as _Contract on $projection.InsuranceContract = _Contract.InsuranceContract
association [1..1] to I_InsurClmIncdntType as _IncidentType on $projection.InsurClmPolicyProduct = _IncidentType.InsurClmPolicyProduct
and $projection.InsurClmPolicyProdGeneration = _IncidentType.InsurClmPolicyProdGeneration
and $projection.InsurClmPolicyProductVersion = _IncidentType.InsurClmPolicyProductVersion
and $projection.InsurClmIncdntType = _IncidentType.InsurClmIncdntType
association [0..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 [0..1] to I_InsurClmLossDesc as _LossDescription on $projection.InsuranceClaim = _LossDescription.InsuranceClaim
association [0..1] to I_Address as _LossLocationAddress on $projection.InsurClmLossLocAddressID = _LossLocationAddress.AddressID
composition [0..*] of I_InsurClmFNOLDamagedObjectTP as _DamagedVehicle
//on $projection.InsuranceClaim = _DamagedVehicle.InsuranceClaim
composition [0..*] of I_InsurClmFNOLNoteTP as _Note
//on $projection.InsuranceClaim = _Note.InsuranceClaim
association [0..1] to I_InsurClmHandler as _ClaimHandler on $projection.InsuranceClaim = _ClaimHandler.InsuranceClaim
association [0..1] to I_InsurClmStatus as _ClaimStatus on $projection.InsurClmLifeCycSts = _ClaimStatus.InsurClmLifeCycSts
association [1..*] to I_InsurClmPrtcpntOccrnc as _PolicyHolder on $projection.InsuranceClaim = _PolicyHolder.InsuranceClaim
and _PolicyHolder.InsurClmSubobjectCategory = 'PO'
and _PolicyHolder.InsurClmSubobject = ''
and _PolicyHolder.InsurClmParticipantRole = 'POLH'
association [1..1] to I_InsurClmFNOLPaymentDetails as _FnolPay on $projection.InsurClmPolicyProduct = _FnolPay.InsurClmPolicyProduct
and $projection.InsurClmIncdntType = _FnolPay.InsurClmIncdntType
association [1..1] to I_InsurClmProdNameVH as _ProductName on $projection.InsurClmPolicyProduct = _ProductName.InsurClmPolicyProduct
and $projection.InsurClmPolicyProdGeneration = _ProductName.InsurClmPolicyProdGeneration
// association [1..1] to C_InsurClmBPQuickView as _BPDetails on $projection.InsurancePolicyholder = _BPDetails.BusinessPartner
composition [1..*] of I_InsurClmFNOLFactsOriginTP as _Facts
//on $projection.InsuranceClaim = _Facts.InsuranceClaim
composition [0..*] of I_InsurClmFNOLWtnssTP as _Witness
composition [1..*] of I_InsurClmFNOLFactsLossLocTP as _SFCLoss
// composition [1..*] of I_InsurClmFNOLSFCDMGDOBJ as _SFCDMG
//on $projection.InsuranceClaim = _Witness.InsuranceClaim
/////////////////////////////////////////////////////////
///////////Payment Section///////
////////////////////////////////////////////////////////
composition [1..*] of I_InsurClmFNOLPaytAppTP as _Payment
{
key InsuranceClaim,
// key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) as InsurClaimUUID,
key cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) as InsurClaimUUID,
// InsuranceClaim as InsuranceClaimForEdit,
// @Consumption.valueHelp: '_Contract'
// InsuranceClaim as InsuranceClaimDraftIdentifier,
InsuranceClaimDraftIdentifier,
InsuranceContract,
ChangedOnDateTime,
LastChangedByUser,
CreationDateTime,
CreatedByUser,
// InsuranceClaimExternalNumber,
InsurClmType,
InsurClmTypeGeneration,
InsurClmTypeVers,
InsurClmLifeCycSts,
_ClaimStatus._ClaimStatusText[ Language = $session.system_language ].InsurClmLifeCycStsName as InsurClmLifeCycStsName,
InsurClmAuthznGrp,
I_InsuranceClaim.InsurClmIncdntType,
_IncidentType._IncidentTypeText[ Language = $session.system_language ].InsurClmIncdntTypeName as InsurClmIncdntTypeName,
InsurClmDateOfLoss,
InsurClmCauseOfLoss,
_LossCause._LossCauseText[ Language = $session.system_language].InsurClmCauseOfLossName as InsurClmCauseOfLossName,
InsurClmLossLocAddressID,
I_InsuranceClaim.InsurClmPolicyProduct,
I_InsuranceClaim.InsurClmPolicyProdGeneration,
I_InsuranceClaim.InsurClmPolicyProductVersion,
// Start of New fields for Benefit Type Search Help in payments tab Only
// These fields are manupulated in Class to get the correct results for the search Help
// Please do not use these or manupulate them in class, it may result in search help failure
I_InsuranceClaim.InsurClmPolicyProdGeneration as InsurClmPlcyProdGnrtnSrchHelp,
I_InsuranceClaim.InsurClmPolicyProductVersion as InsurClmPolicyProdVersSrchHelp,
// End of new fields for search help
_ProductName[Language = $session.system_language].InsurClmPlcyProdName as InsurClmPlcyProdName,
_PolicyHolder.BusinessPartnerName as InsurClmPolicyHolderName,
_PolicyHolder.BirthDate,
_ClaimHandler.FullName,
_ClaimHandler.ContactCardID as ContactCardID,
_PolicyHolder.BusinessPartner as InsurancePolicyholder,
_LossDescription.InsurClmDescriptionOfLoss as InsurClmDescriptionOfLoss,
_LossLocationAddress.StreetName as InsurClmLossLocStreet,
_LossLocationAddress.HouseNumber as InsurClmLossLocHouseNumber,
_LossLocationAddress.CityName as InsurClmLossLocCity,
_LossLocationAddress.Region as InsurClmLossLocRegion,
_LossLocationAddress.PostalCode as InsurClmLossLocPostalCode,
_LossLocationAddress.Country as InsurClmLossLocCountry,
cast(0 as geolon) as InsurClmLossLocLongitude,
cast(0 as geolat) as InsurClmLossLocLatitude,
cast ( '/sap/bc/ui5_ui5/sap/INS_FNOL2S1/images/Fnol.jpg' as abap.char( 48 ) ) as InsurClmImageURL,
case InsurClmLifeCycSts
when '0' then 1
when '1' then 1
when '2' then 3
else 1
end as InsurClmCriticalityCat,
// cast ( 'X' as boolean_flg preserving type ) as InsurClmPaymentFlag,
cast( case _FnolPay.InsurClmIncdntType
when ' ' then 'X'
else ' '
end as boolean_flg) as InsurClmPaymentFlag,
// Associations
_PolicyHolder,
// _Contract,
_IncidentType,
_LossCause,
_DamagedVehicle,
_Note,
_ClaimHandler,
_Witness,
_SFCLoss,
_Facts,
/// Payment Section
_Payment
// _BPDetails
}
where
InsuranceClaim <> InsuranceContract
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