I_InsurClmParticipantTP

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_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 I_InsurClmParticipantTP AS
SELECT
  InsuranceClaim,
  BusinessPartner,
  InsurClmPrtcpntUUID,
  InsurClmSubobjectCategory,
  InsurClmSubobject,
  InsurClmParticipantRole,
  InsuranceClaim AS InsuranceClaimForEdit,
  BusinessPartner AS BusinessPartnerForEdit,
  InsurClmSubobjectCategory AS InsurClmSubobjCategoryForEdit,
  InsurClmSubobject AS InsurClmSubobjectForEdit,
  InsurClmParticipantRole AS InsurClmParticipantRoleForEdit,
  _SubobjectCategoryText.InsurClmSubobjectCategoryName AS InsurClmSubobjectCategoryName,
  _InsurClmPrtcpntRoleText.InsurClmParticipantRoleName AS InsurClmParticipantRoleName,
  _CountryText.CountryName AS CountryName,
  _FormOfAddressText.FormOfAddressName AS FormOfAddressName,
  _InsurClmPrtcpntRelshpTypeTxt.InsurClmRelationshipText AS InsurClmRelationshipText,
  _InsurClmPartcipnTypeTxt.InsurClmParticipantTypeText AS InsurClmParticipantTypeText,
  InsurClmRelationship,
  InsurClmParticipantType,
  InsurClmNoInsurance,
  InsurClmIntraCompany,
  LastChangedByUser,
  ChangedOnDateTime,
  BusinessPartnerName,
  FormOfAddress,
  LastName,
  FirstName,
  StreetName,
  HouseNumber,
  CityName,
  PostalCode,
  Region,
  Country,
  PhoneNumber,
  EmailAddress,
  BirthDate,
  GenderCodeName,
  AuthorizationGroup,
  IsBusinessPurposeCompleted,
  cast( '/sap/bc/ui5_ui5/sap/INS_MNTNPARTCS1/images/Participant.jpg' as mr_url ) AS InsurClmImageURL,
  cast( '' as abap.char(1) ) AS InsurClmNewPrtcpntActionIsChkd,
  cast( ' ' as abap.char(60) ) AS InsurClmSubobjectName,
  _Claim.InsurClmType AS InsurClmType,
  _Claim.InsurClmAuthznGrp AS InsurClmAuthznGrp
FROM I_InsurClmParticipantList
LEFT OUTER JOIN I_InsurClmSubobjCatText AS _SubobjectCategoryText ON InsurClmSubobjectCategory = _SubobjectCategoryText.InsurClmSubobjectCategory AND _SubobjectCategoryText.InsurClmObjectCategory = 'C' AND _SubobjectCategoryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_InsurClmPrtcpntRoleText AS _InsurClmPrtcpntRoleText ON InsurClmParticipantRole = _InsurClmPrtcpntRoleText.InsurClmParticipantRole AND _InsurClmPrtcpntRoleText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_CountryText AS _CountryText ON Country = _CountryText.Country AND _CountryText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_FormOfAddressText AS _FormOfAddressText ON FormOfAddress = _FormOfAddressText.FormOfAddress AND _FormOfAddressText.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_InsurClmPrtcpntRelshpTypeTxt AS _InsurClmPrtcpntRelshpTypeTxt ON InsurClmRelationship = _InsurClmPrtcpntRelshpTypeTxt.InsurClmRelationship AND _InsurClmPrtcpntRelshpTypeTxt.Language = $session.system_language  -- association [0..1]
LEFT OUTER JOIN I_InsurClmPartcipnTypeTxt AS _InsurClmPartcipnTypeTxt ON InsurClmParticipantType = _InsurClmPartcipnTypeTxt.InsurClmParticipantType AND _InsurClmPartcipnTypeTxt.Language = $session.system_language  -- association [0..1]
;