C_InsurClmParticipantTP

DDL: C_INSURCLMPARTICIPANTTP Type: view_entity CONSUMPTION Package: ICL_VDM_PARTICIPANT
47 Fields 1 Data Sources 1 Associations 1 OData Services

Claim Participant TP

C_InsurClmParticipantTP is a Consumption CDS View that provides data about "Claim Participant TP" in SAP S/4HANA. It reads from 1 data source (I_InsurClmParticipantTP) and exposes 47 fields with key fields InsuranceClaim, BusinessPartner, InsurClmPrtcpntUUID, InsurClmSubobjectCategory, InsurClmSubobject. It has 1 association to related views. It is exposed through 1 OData service (ICL_CLAIMPARTICIPANT). Part of development package ICL_VDM_PARTICIPANT.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmParticipantTP I_InsurClmParticipantTP projection

Associations (1)

CardinalityTargetAliasCondition
[0..1] I_InsuranceClaimGenderText _genderTxt $projection.GenderCodeName = _genderTxt.GenderCodeName

Annotations (8)

NameValueLevelField
EndUserText.label Claim Participant TP view
AccessControl.authorizationCheck #CHECK view
Metadata.allowExtensions true view
VDM.viewType #CONSUMPTION view
AccessControl.personalData.blocking #REQUIRED view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #D view

OData Services (1)

ServiceBindingVersionContractRelease
ICL_CLAIMPARTICIPANT ICL_UI_CLAIMPARTICIPANT V2 C1 NOT_RELEASED

Fields (47)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim Claim Number
KEY BusinessPartner BusinessPartner Issuing Authority
KEY InsurClmPrtcpntUUID InsurClmPrtcpntUUID
KEY InsurClmSubobjectCategory InsurClmSubobjectCategory Subobject Cat.
KEY InsurClmSubobject InsurClmSubobject Claim Subobject
KEY InsurClmParticipantRole InsurClmParticipantRole ParticipantRole
InsuranceClaimForEdit InsuranceClaimForEdit Claim Number
BusinessPartnerForEdit BusinessPartnerForEdit Busn. Partner
InsurClmSubobjCategoryForEdit InsurClmSubobjCategoryForEdit Subobject Cat.
InsurClmSubobjectForEdit InsurClmSubobjectForEdit Claim Subobject
InsurClmParticipantRoleForEdit InsurClmParticipantRoleForEdit ParticipantRole
InsurClmRelationship InsurClmRelationship Rel. to PH
InsurClmParticipantType InsurClmParticipantType Participtn Type
InsurClmNoInsurance InsurClmNoInsurance Not Insured
InsurClmIntraCompany InsurClmIntraCompany Intra-Company
InsurClmSubobjectName InsurClmSubobjectName
InsurClmSubobjectCategoryName InsurClmSubobjectCategoryName
InsurClmParticipantRoleName InsurClmParticipantRoleName
CountryName CountryName Country
FormOfAddressName FormOfAddressName Title
InsurClmRelationshipText InsurClmRelationshipText
InsurClmParticipantTypeText InsurClmParticipantTypeText
BusinessPartnerName BusinessPartnerName Extracted Customer Name
LastChangedByUser LastChangedByUser User Name
ChangedOnDateTime ChangedOnDateTime Last Changed At
FormOfAddress FormOfAddress Title Key
LastName LastName Last Name
FirstName FirstName First Name
StreetName StreetName Text
HouseNumber HouseNumber House Number
CityName CityName Name
PostalCode PostalCode Postal Code
Region Region Venue Region
Country Country Venue: Ctry/Reg
PhoneNumber PhoneNumber Telephone no.
EmailAddress EmailAddress E-Mail Address
BirthDate BirthDate Date of Birth
GenderCodeName GenderCodeName Sex
InsurClmImageURL InsurClmImageURL
InsurClmNewPrtcpntActionIsChkd InsurClmNewPrtcpntActionIsChkd
AuthorizationGroup AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted IsBusinessPurposeCompleted Purpose Completed
InsurClmType InsurClmType Claim Type
InsurClmAuthznGrp _Claim InsurClmAuthznGrp AuthGroup (VIP)
_BusinessPartner _BusinessPartner
_Claim _Claim
_genderTxt _genderTxt

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 C_InsurClmParticipantTP.
-- 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 C_InsurClmParticipantTP AS
SELECT
  InsuranceClaim,
  BusinessPartner,
  InsurClmPrtcpntUUID,
  InsurClmSubobjectCategory,
  InsurClmSubobject,
  InsurClmParticipantRole,
  InsuranceClaimForEdit,
  BusinessPartnerForEdit,
  InsurClmSubobjCategoryForEdit,
  InsurClmSubobjectForEdit,
  InsurClmParticipantRoleForEdit,
  InsurClmRelationship,
  InsurClmParticipantType,
  InsurClmNoInsurance,
  InsurClmIntraCompany,
  InsurClmSubobjectName,
  InsurClmSubobjectCategoryName,
  InsurClmParticipantRoleName,
  CountryName,
  FormOfAddressName,
  InsurClmRelationshipText,
  InsurClmParticipantTypeText,
  BusinessPartnerName,
  LastChangedByUser,
  ChangedOnDateTime,
  FormOfAddress,
  LastName,
  FirstName,
  StreetName,
  HouseNumber,
  CityName,
  PostalCode,
  Region,
  Country,
  PhoneNumber,
  EmailAddress,
  BirthDate,
  GenderCodeName,
  InsurClmImageURL,
  InsurClmNewPrtcpntActionIsChkd,
  AuthorizationGroup,
  IsBusinessPurposeCompleted,
  InsurClmType,
  _Claim.InsurClmAuthznGrp AS InsurClmAuthznGrp
FROM I_InsurClmParticipantTP
LEFT OUTER JOIN I_InsuranceClaimGenderText AS _genderTxt ON GenderCodeName = _genderTxt.GenderCodeName  -- association [0..1]
;

Learn More