I_InsurClmParticipant

DDL: I_INSURCLMPARTICIPANT SQL: IICLPARTI Type: view BASIC Package: ICL_VDM_COMMON
10 Fields 1 Data Sources 1 Associations 1 OData Services

Beteiligtensicht

I_InsurClmParticipant is a Basic CDS View that provides data about "Beteiligtensicht" in SAP S/4HANA. It reads from 1 data source (iclpart) and exposes 10 fields with key fields InsuranceClaim, BusinessPartner. It has 1 association to related views. It is exposed through 1 OData service (ICL_CLAIMINQUIRY_R). Part of development package ICL_VDM_COMMON.

Data Sources (1)

SourceAliasJoin Type
iclpart iclpart from

Associations (1)

CardinalityTargetAliasCondition
[1] I_InsuranceClaim _Claim $projection.InsuranceClaim = _Claim.InsuranceClaim

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName IICLPARTI view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
AbapCatalog.preserveKey true view
EndUserText.label Beteiligtensicht view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #BASIC view
ObjectModel.usageType.dataClass #MASTER view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view

OData Services (1)

ServiceBindingVersionContractRelease
ICL_CLAIMINQUIRY_R ICL_UI_CLAIMINQUIRY_R_O2 V2 C1 NOT_RELEASED

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim claim Policy Snapshot
KEY BusinessPartner participant Participant
BirthDate birthdate Date of Birth
InsurClmRelationship reltype Relationship type between classes
InsurClmParticipantType parttype Participtn Type
InsurClmLiabilityRate guiltrate Liability Rate
InsurClmNoInsurance xnoins Not Insured
InsurClmFNOLReferenceNumber reference Value
InsurClmIntraCompany xintracompany Intra-Company
_Claim _Claim

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_InsurClmParticipant.
-- 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: IICLPARTI

CREATE VIEW I_InsurClmParticipant AS
SELECT
  claim AS InsuranceClaim,
  participant AS BusinessPartner,
  BirthDate,
  reltype AS InsurClmRelationship,
  parttype AS InsurClmParticipantType,
  guiltrate AS InsurClmLiabilityRate,
  xnoins AS InsurClmNoInsurance,
  reference AS InsurClmFNOLReferenceNumber,
  xintracompany AS InsurClmIntraCompany
FROM iclpart
LEFT OUTER JOIN I_InsuranceClaim AS _Claim ON InsuranceClaim = _Claim.InsuranceClaim  -- association [1]
;

Learn More