I_InsurClmInjuredPersonDetails

DDL: I_INSURCLMINJUREDPERSONDETAILS SQL: IICLINJUPERSON Type: view COMPOSITE
16 Fields 1 Data Sources 3 Associations

Verletzte Person für Fallauskunft

I_InsurClmInjuredPersonDetails is a Composite CDS View that provides data about "Verletzte Person für Fallauskunft" in SAP S/4HANA. It reads from 1 data source (I_InsurClmInjuredPerson) and exposes 16 fields with key fields InsuranceClaim, BusinessPartner, InsurClmSubobjectCategory, InsurClmSubobject, InsurClmParticipantRole. It has 3 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmInjuredPerson I_InsurClmInjuredPerson from

Associations (3)

CardinalityTargetAliasCondition
[1..1] I_InsurClmParticipant _Part $projection.InsuranceClaim = _Part.InsuranceClaim and $projection.BusinessPartner = _Part.BusinessPartner
[0..1] I_InsurClmDamageAssignment _Itad $projection.InsuranceClaim = _Itad.InsuranceClaim and $projection.InsurClmSubobject = _Itad.InsurClmDamagedObject and _Itad.InsurClmSubobjectCategory = 'DD'
[0..*] I_InsurClmPrtcpntOccrnc _Insu $projection.InsuranceClaim = _Insu.InsuranceClaim and _Insu.InsurClmSubobjectCategory = 'PA' and _Insu.InsurClmParticipantRole = 'EXTI' and $projection.BusinessPartner = _Insu.InsurClmSubobject

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IICLINJUPERSON view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Verletzte Person für Fallauskunft view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view
AbapCatalog.preserveKey true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view

Fields (16)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim I_InsurClmInjuredPerson InsuranceClaim Claim Number
KEY BusinessPartner I_InsurClmInjuredPerson BusinessPartner Issuing Authority
KEY InsurClmSubobjectCategory I_InsurClmInjuredPerson InsurClmSubobjectCategory Subobject Cat.
KEY InsurClmSubobject I_InsurClmInjuredPerson InsurClmSubobject Claim Subobject
KEY InsurClmParticipantRole I_InsurClmInjuredPerson InsurClmParticipantRole ParticipantRole
KEY InsurClmDamagedObject _Itad InsurClmDmgdSubObject Subobject
KEY InsurClmInjuryDetails _Insu InsurClmSubobject Claim Subobject
BusinessPartnerName I_InsurClmInjuredPerson BusinessPartnerName Extracted Customer Name
BirthDate I_InsurClmInjuredPerson BirthDate Date of Birth
HouseNumber I_InsurClmInjuredPerson HouseNumber House Number
StreetName I_InsurClmInjuredPerson StreetName Text
CityName I_InsurClmInjuredPerson CityName Name
Country I_InsurClmInjuredPerson Country Venue: Ctry/Reg
InsurClmInjuryInsurCompanyName _Insu BusinessPartnerName Extracted Customer Name
InsurClmRelationship _Part InsurClmRelationship Rel. to PH
InsurClmParticipantType _Part InsurClmParticipantType Participtn Type

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 I_InsurClmInjuredPersonDetails.
-- 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.
-- SQL view name: IICLINJUPERSON

CREATE VIEW I_InsurClmInjuredPersonDetails AS
SELECT
  I_InsurClmInjuredPerson.InsuranceClaim AS InsuranceClaim,
  I_InsurClmInjuredPerson.BusinessPartner AS BusinessPartner,
  I_InsurClmInjuredPerson.InsurClmSubobjectCategory AS InsurClmSubobjectCategory,
  I_InsurClmInjuredPerson.InsurClmSubobject AS InsurClmSubobject,
  I_InsurClmInjuredPerson.InsurClmParticipantRole AS InsurClmParticipantRole,
  _Itad.InsurClmDmgdSubObject AS InsurClmDamagedObject,
  _Insu.InsurClmSubobject AS InsurClmInjuryDetails,
  I_InsurClmInjuredPerson.BusinessPartnerName AS BusinessPartnerName,
  I_InsurClmInjuredPerson.BirthDate AS BirthDate,
  I_InsurClmInjuredPerson.HouseNumber AS HouseNumber,
  I_InsurClmInjuredPerson.StreetName AS StreetName,
  I_InsurClmInjuredPerson.CityName AS CityName,
  I_InsurClmInjuredPerson.Country AS Country,
  _Insu.BusinessPartnerName AS InsurClmInjuryInsurCompanyName,
  _Part.InsurClmRelationship AS InsurClmRelationship,
  _Part.InsurClmParticipantType AS InsurClmParticipantType
FROM I_InsurClmInjuredPerson
LEFT OUTER JOIN I_InsurClmParticipant AS _Part ON InsuranceClaim = _Part.InsuranceClaim AND BusinessPartner = _Part.BusinessPartner  -- association [1..1]
LEFT OUTER JOIN I_InsurClmDamageAssignment AS _Itad ON InsuranceClaim = _Itad.InsuranceClaim AND InsurClmSubobject = _Itad.InsurClmDamagedObject AND _Itad.InsurClmSubobjectCategory = 'DD'  -- association [0..1]
LEFT OUTER JOIN I_InsurClmPrtcpntOccrnc AS _Insu ON InsuranceClaim = _Insu.InsuranceClaim AND _Insu.InsurClmSubobjectCategory = 'PA' AND _Insu.InsurClmParticipantRole = 'EXTI' AND BusinessPartner = _Insu.InsurClmSubobject  -- association [0..*]
;

Learn More