R_InsurClmFNOLClmntTP

DDL: R_INSURCLMFNOLCLMNTTP Type: view_entity TRANSACTIONAL
34 Fields 1 Data Sources 4 Associations

FNOL Claimant Details

R_InsurClmFNOLClmntTP is a Transactional CDS View that provides data about "FNOL Claimant Details" in SAP S/4HANA. It reads from 1 data source (I_InsurClmPrtcpntOccrnc) and exposes 34 fields with key fields InsuranceClaim, BusinessPartner, InsurClmSubobjectCategory, InsurClmSubobject, InsurClmParticipantRole. It has 4 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmPrtcpntOccrnc I_InsurClmPrtcpntOccrnc from

Associations (4)

CardinalityTargetAliasCondition
[0..1] I_Region _Region $projection.Region = _Region.Region and $projection.Country = _Region.Country
[0..1] I_Country _Country _Country.Country = $projection.Country
[1..1] I_InsurClmInjuredPersnRltnDets _Injured $projection.InsuranceClaim = _Injured.InsuranceClaim and $projection.InsurClmSubobject = _Injured.InsurClmInjuredPersonNumber
[1..1] E_InsuranceClaimParticipant _Extension $projection.InsuranceClaim = _Extension.InsuranceClaim and $projection.InsurClmSubobjectCategory = _Extension.InsurClmSubobjectCategory and $projection.InsurClmSubobject = _Extension.InsurClmSubobject and $projection.InsurClmParticipantRole = _Extension.InsurClmParticipantRole and $projection.BusinessPartner = _Extension.BusinessPartner

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label FNOL Claimant Details 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
ObjectModel.sapObjectNodeType.name InsuranceClaim view

Fields (34)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim I_InsurClmPrtcpntOccrnc InsuranceClaim Claim Number
KEY BusinessPartner I_InsurClmPrtcpntOccrnc BusinessPartner Issuing Authority
KEY InsurClmSubobjectCategory I_InsurClmPrtcpntOccrnc InsurClmSubobjectCategory Subobject Cat.
KEY InsurClmSubobject I_InsurClmPrtcpntOccrnc InsurClmSubobject Claim Subobject
KEY InsurClmParticipantRole I_InsurClmPrtcpntOccrnc InsurClmParticipantRole ParticipantRole
LastChangedByUser I_InsurClmPrtcpntOccrnc LastChangedByUser User Name
ChangedOnDateTime I_InsurClmPrtcpntOccrnc ChangedOnDateTime Last Changed At
BusinessPartnerName I_InsurClmPrtcpntOccrnc BusinessPartnerName Extracted Customer Name
FormOfAddress I_InsurClmPrtcpntOccrnc FormOfAddress Title Key
LastName I_InsurClmPrtcpntOccrnc LastName Last Name
FirstName I_InsurClmPrtcpntOccrnc FirstName First Name
StreetName I_InsurClmPrtcpntOccrnc StreetName Text
HouseNumber I_InsurClmPrtcpntOccrnc HouseNumber House Number
CityName I_InsurClmPrtcpntOccrnc CityName Name
PostalCode I_InsurClmPrtcpntOccrnc PostalCode Postal Code
Region I_InsurClmPrtcpntOccrnc Region Venue Region
Country I_InsurClmPrtcpntOccrnc Country Venue: Ctry/Reg
PhoneNumber I_InsurClmPrtcpntOccrnc PhoneNumber Telephone no.
EmailAddress I_InsurClmPrtcpntOccrnc EmailAddress E-Mail Address
BirthDate I_InsurClmPrtcpntOccrnc BirthDate Date of Birth
GenderCodeName I_InsurClmPrtcpntOccrnc GenderCodeName Sex
AuthorizationGroup I_InsurClmPrtcpntOccrnc AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted I_InsurClmPrtcpntOccrnc IsBusinessPurposeCompleted Purpose Completed
InsurClmRelationship _Injured InsurClmRelationship Rel. to PH
InsurClmFatalInjury _Injured InsurClmFatalInjury
InsurClmImpairmentPercent _Injured InsurClmImpairmentPercent
InsurClmIntraCompany _Injured InsurClmIntraCompany Intra-Company
InsurClmNoInsurance _Injured InsurClmNoInsurance Not Insured
InsurClmRelationshipText
InsurClmInjuredPersnAddrTxt _Injured InsurClmInjuredPersnAddrTxt
InsurClmInjuryInsurCompanyName _Injured InsurClmInjuryInsurCompanyName
_BusinessPartner I_InsurClmPrtcpntOccrnc _BusinessPartner
_Claim I_InsurClmPrtcpntOccrnc _Claim
_InsurClaim _InsurClaim

Derived SQL interpretation, reconstructed from the parsed view metadata (data sources, associations, and field mappings). SAP annotations are omitted and the structure is reformulated as SQL — this is a functional approximation, not the verbatim SAP source.

-- Derived SQL interpretation of CDS view R_InsurClmFNOLClmntTP.
-- Reconstructed from parsed metadata (data sources, associations, fields).
-- SAP annotations are omitted and the structure is reformulated as SQL;
-- this is a functional approximation, not the verbatim SAP source. Some join
-- conditions may be unavailable and a few CDS constructs are kept as-is.

CREATE VIEW R_InsurClmFNOLClmntTP AS
SELECT
  I_InsurClmPrtcpntOccrnc.InsuranceClaim AS InsuranceClaim,
  I_InsurClmPrtcpntOccrnc.BusinessPartner AS BusinessPartner,
  I_InsurClmPrtcpntOccrnc.InsurClmSubobjectCategory AS InsurClmSubobjectCategory,
  I_InsurClmPrtcpntOccrnc.InsurClmSubobject AS InsurClmSubobject,
  I_InsurClmPrtcpntOccrnc.InsurClmParticipantRole AS InsurClmParticipantRole,
  I_InsurClmPrtcpntOccrnc.LastChangedByUser AS LastChangedByUser,
  I_InsurClmPrtcpntOccrnc.ChangedOnDateTime AS ChangedOnDateTime,
  I_InsurClmPrtcpntOccrnc.BusinessPartnerName AS BusinessPartnerName,
  I_InsurClmPrtcpntOccrnc.FormOfAddress AS FormOfAddress,
  I_InsurClmPrtcpntOccrnc.LastName AS LastName,
  I_InsurClmPrtcpntOccrnc.FirstName AS FirstName,
  I_InsurClmPrtcpntOccrnc.StreetName AS StreetName,
  I_InsurClmPrtcpntOccrnc.HouseNumber AS HouseNumber,
  I_InsurClmPrtcpntOccrnc.CityName AS CityName,
  I_InsurClmPrtcpntOccrnc.PostalCode AS PostalCode,
  I_InsurClmPrtcpntOccrnc.Region AS Region,
  I_InsurClmPrtcpntOccrnc.Country AS Country,
  I_InsurClmPrtcpntOccrnc.PhoneNumber AS PhoneNumber,
  I_InsurClmPrtcpntOccrnc.EmailAddress AS EmailAddress,
  I_InsurClmPrtcpntOccrnc.BirthDate AS BirthDate,
  I_InsurClmPrtcpntOccrnc.GenderCodeName AS GenderCodeName,
  I_InsurClmPrtcpntOccrnc.AuthorizationGroup AS AuthorizationGroup,
  I_InsurClmPrtcpntOccrnc.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  _Injured.InsurClmRelationship AS InsurClmRelationship,
  _Injured.InsurClmFatalInjury AS InsurClmFatalInjury,
  _Injured.InsurClmImpairmentPercent AS InsurClmImpairmentPercent,
  _Injured.InsurClmIntraCompany AS InsurClmIntraCompany,
  _Injured.InsurClmNoInsurance AS InsurClmNoInsurance,
  _Injured._RelshpTypeTxt.InsurClmRelationshipText AS InsurClmRelationshipText,
  _Injured.InsurClmInjuredPersnAddrTxt AS InsurClmInjuredPersnAddrTxt,
  _Injured.InsurClmInjuryInsurCompanyName AS InsurClmInjuryInsurCompanyName,
  I_InsurClmPrtcpntOccrnc._BusinessPartner AS _BusinessPartner,
  I_InsurClmPrtcpntOccrnc._Claim AS _Claim
FROM I_InsurClmPrtcpntOccrnc
LEFT OUTER JOIN I_Region AS _Region ON Region = _Region.Region AND Country = _Region.Country  -- association [0..1]
LEFT OUTER JOIN I_Country AS _Country ON _Country.Country = Country  -- association [0..1]
LEFT OUTER JOIN I_InsurClmInjuredPersnRltnDets AS _Injured ON InsuranceClaim = _Injured.InsuranceClaim AND InsurClmSubobject = _Injured.InsurClmInjuredPersonNumber  -- association [1..1]
LEFT OUTER JOIN E_InsuranceClaimParticipant AS _Extension ON InsuranceClaim = _Extension.InsuranceClaim AND InsurClmSubobjectCategory = _Extension.InsurClmSubobjectCategory AND InsurClmSubobject = _Extension.InsurClmSubobject AND InsurClmParticipantRole = _Extension.InsurClmParticipantRole AND BusinessPartner = _Extension.BusinessPartner  -- association [1..1]
;

Learn More