I_InsuranceClaimParticipant_3

DDL: I_INSURANCECLAIMPARTICIPANT_3 Type: view_entity BASIC

Basic Interface Claim Participant

I_InsuranceClaimParticipant_3 is a Basic CDS View that provides data about "Basic Interface Claim Participant" in SAP S/4HANA. It reads from 1 data source (iclpart) and exposes 30 fields with key fields InsurClmActive, InsuranceClaim, InsurClmBusinessPartner.

Data Sources (1)

SourceAliasJoin Type
iclpart iclpart from

Annotations (8)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label Basic Interface Claim Participant view
Metadata.ignorePropagatedAnnotations true view
ObjectModel.usageType.serviceQuality #X view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #BASIC view
AccessControl.personalData.blocking #REQUIRED view

Fields (30)

KeyFieldSource TableSource FieldDescription
KEY InsurClmActive active Usage Active
KEY InsuranceClaim claim Policy Snapshot
KEY InsurClmBusinessPartner participant Participant
ChangedOnDateTime Created
LastChangedByUser changedby User Name
InsurClmDatabaseLineStatus deleted Truth Value
InsurClmRefNmbrPrtcpntData reference Value
InsurClmRelationship reltype Relationship type between classes
InsurClmPrtcpntRespPoliceText text01 Long Text
InsurClmPrtcpntFileReqDate file_requested File requested
InsurClmPrtcpntDesc descrip Participant
InsurClmAssignUUID assign_guid Link UUID
InsurClmParticipantType parttype Participtn Type
InsurClmPrtcpntHasLawyer xlawyer Lawyer?
InsurClmValueAddedTaxIsPaid xsalestax No Val.Add Tax
InsurClmPrtcpntLiabilityRate guiltrate Liability Rate
InsurClmIntraCompany xintracompany Intra-Company
InsurClmNoInsurance xnoins Not Insured
InsuranceClaimPrtcpntSeatPos seat Position in Veh
InsuranceClaimDamagedVehicle vehicle Vehicle Number
InsurClmPrtcpntWtnssType wireptype Type
InsurClmPrtcpntStmntIsConfd xconfirm Confirmed
InsurClmPrtcpntWtnssEval judgement Evaluation
InsurClmWtnssIsKnownToClaimant xknown2driver Knows claimant
InsurClmWtnssIsKnownToInsured xknown2insurd Knows PH?
InsurClmParticipantAgeValue age TP Write-off Age
InsurClmPrtcpntLicIssueDate issuedate Order End Date
BusinessPartnerBirthDate birthdate Date of Birth
InsurClmPrtcpntRprstvCategory repr_type Represent. Cat.
InsuranceDataAgingObjectDate _dataaging Data Aging

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_InsuranceClaimParticipant_3.
-- 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 I_InsuranceClaimParticipant_3 AS
SELECT
  active AS InsurClmActive,
  claim AS InsuranceClaim,
  participant AS InsurClmBusinessPartner,
  cast(changetime as icl_achangetime_fiori preserving type) AS ChangedOnDateTime,
  changedby AS LastChangedByUser,
  deleted AS InsurClmDatabaseLineStatus,
  reference AS InsurClmRefNmbrPrtcpntData,
  reltype AS InsurClmRelationship,
  text01 AS InsurClmPrtcpntRespPoliceText,
  file_requested AS InsurClmPrtcpntFileReqDate,
  descrip AS InsurClmPrtcpntDesc,
  assign_guid AS InsurClmAssignUUID,
  parttype AS InsurClmParticipantType,
  xlawyer AS InsurClmPrtcpntHasLawyer,
  xsalestax AS InsurClmValueAddedTaxIsPaid,
  guiltrate AS InsurClmPrtcpntLiabilityRate,
  xintracompany AS InsurClmIntraCompany,
  xnoins AS InsurClmNoInsurance,
  seat AS InsuranceClaimPrtcpntSeatPos,
  vehicle AS InsuranceClaimDamagedVehicle,
  wireptype AS InsurClmPrtcpntWtnssType,
  xconfirm AS InsurClmPrtcpntStmntIsConfd,
  judgement AS InsurClmPrtcpntWtnssEval,
  xknown2driver AS InsurClmWtnssIsKnownToClaimant,
  xknown2insurd AS InsurClmWtnssIsKnownToInsured,
  age AS InsurClmParticipantAgeValue,
  issuedate AS InsurClmPrtcpntLicIssueDate,
  birthdate AS BusinessPartnerBirthDate,
  repr_type AS InsurClmPrtcpntRprstvCategory
FROM iclpart
;