I_InsuranceClaimServicesPayee

DDL: I_INSURANCECLAIMSERVICESPAYEE Type: view_entity TRANSACTIONAL
41 Fields 1 Data Sources

Claims Services Participant Payee

I_InsuranceClaimServicesPayee is a Transactional CDS View that provides data about "Claims Services Participant Payee" in SAP S/4HANA. It reads from 1 data source (I_InsurClmPrtcpntOccrnc) and exposes 41 fields with key fields InsuranceClaim, InsurClmRecipient, InsurClmSubobjectCategory, InsurClmSubobject, InsurClmParticipantRole.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmPrtcpntOccrnc I_InsurClmPrtcpntOccrnc from

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Claims Services Participant Payee view
AccessControl.personalData.blocking #REQUIRED view
Metadata.ignorePropagatedAnnotations true view
VDM.viewType #TRANSACTIONAL view
VDM.lifecycle.contract.type #SAP_INTERNAL_API view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #XL view

Fields (41)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim I_InsurClmPrtcpntOccrnc InsuranceClaim Claim Number
KEY InsurClmRecipient I_InsurClmPrtcpntOccrnc BusinessPartner Issuing Authority
KEY InsurClmSubobjectCategory I_InsurClmPrtcpntOccrnc InsurClmSubobjectCategory Subobject Cat.
KEY InsurClmSubobject I_InsurClmPrtcpntOccrnc InsurClmSubobject Claim Subobject
KEY InsurClmParticipantRole I_InsurClmPrtcpntOccrnc InsurClmParticipantRole ParticipantRole
KEY InsurClmBenefitSpltSubobject
LastChangedByUser I_InsurClmPrtcpntOccrnc LastChangedByUser User Name
ChangedOnDateTime I_InsurClmPrtcpntOccrnc ChangedOnDateTime Last Changed At
InsurClmDatabaseLineStatus I_InsurClmPrtcpntOccrnc InsurClmDatabaseLineStatus Status
InsClmWrkrsCompnIsInitPrvdr I_InsurClmPrtcpntOccrnc InsClmWrkrsCompnIsInitPrvdr InitialMedProv
InsuranceClaimIsProcure I_InsurClmPrtcpntOccrnc InsuranceClaimIsProcure Procrmnt w. BP
InsurClmAssignUUID I_InsurClmPrtcpntOccrnc InsurClmAssignUUID Link UUID
BusinessPartnerName I_InsurClmPrtcpntOccrnc BusinessPartnerName Extracted Customer Name
FormOfAddress I_InsurClmPrtcpntOccrnc FormOfAddress Title Key
LastName I_InsurClmPrtcpntOccrnc LastName Last Name
FirstName I_InsurClmPrtcpntOccrnc FirstName First Name
StreetName I_InsurClmPrtcpntOccrnc StreetName Text
HouseNumber I_InsurClmPrtcpntOccrnc HouseNumber House Number
CityName I_InsurClmPrtcpntOccrnc CityName Name
PostalCode I_InsurClmPrtcpntOccrnc PostalCode Postal Code
Region I_InsurClmPrtcpntOccrnc Region Venue Region
Country I_InsurClmPrtcpntOccrnc Country Venue: Ctry/Reg
PhoneNumber I_InsurClmPrtcpntOccrnc PhoneNumber Telephone no.
EmailAddress I_InsurClmPrtcpntOccrnc EmailAddress E-Mail Address
BirthDate I_InsurClmPrtcpntOccrnc BirthDate Date of Birth
GenderCodeName I_InsurClmPrtcpntOccrnc GenderCodeName Sex
AuthorizationGroup I_InsurClmPrtcpntOccrnc AuthorizationGroup AuthorizGroup
IsBusinessPurposeCompleted I_InsurClmPrtcpntOccrnc IsBusinessPurposeCompleted Purpose Completed
DataControllerSet I_InsurClmPrtcpntOccrnc DataControllerSet Data Ctrlr. Set
DataController1 I_InsurClmPrtcpntOccrnc DataController1 Data Controller
DataController2 I_InsurClmPrtcpntOccrnc DataController2 Data Controller
DataController3 I_InsurClmPrtcpntOccrnc DataController3 Data Controller
DataController4 I_InsurClmPrtcpntOccrnc DataController4 Data Controller
DataController5 I_InsurClmPrtcpntOccrnc DataController5 Data Controller
DataController6 I_InsurClmPrtcpntOccrnc DataController6 Data Controller
DataController7 I_InsurClmPrtcpntOccrnc DataController7 Data Controller
DataController8 I_InsurClmPrtcpntOccrnc DataController8 Data Controller
DataController9 I_InsurClmPrtcpntOccrnc DataController9 Data Controller
DataController10 I_InsurClmPrtcpntOccrnc DataController10 Data Controller
_BusinessPartner I_InsurClmPrtcpntOccrnc _BusinessPartner
_Claim I_InsurClmPrtcpntOccrnc _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_InsuranceClaimServicesPayee.
-- 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_InsuranceClaimServicesPayee AS
SELECT
  I_InsurClmPrtcpntOccrnc.InsuranceClaim AS InsuranceClaim,
  I_InsurClmPrtcpntOccrnc.BusinessPartner AS InsurClmRecipient,
  I_InsurClmPrtcpntOccrnc.InsurClmSubobjectCategory AS InsurClmSubobjectCategory,
  I_InsurClmPrtcpntOccrnc.InsurClmSubobject AS InsurClmSubobject,
  I_InsurClmPrtcpntOccrnc.InsurClmParticipantRole AS InsurClmParticipantRole,
  substring(I_InsurClmPrtcpntOccrnc.InsurClmSubobject, 5 ,16 ) AS InsurClmBenefitSpltSubobject,
  I_InsurClmPrtcpntOccrnc.LastChangedByUser AS LastChangedByUser,
  I_InsurClmPrtcpntOccrnc.ChangedOnDateTime AS ChangedOnDateTime,
  I_InsurClmPrtcpntOccrnc.InsurClmDatabaseLineStatus AS InsurClmDatabaseLineStatus,
  I_InsurClmPrtcpntOccrnc.InsClmWrkrsCompnIsInitPrvdr AS InsClmWrkrsCompnIsInitPrvdr,
  I_InsurClmPrtcpntOccrnc.InsuranceClaimIsProcure AS InsuranceClaimIsProcure,
  I_InsurClmPrtcpntOccrnc.InsurClmAssignUUID AS InsurClmAssignUUID,
  I_InsurClmPrtcpntOccrnc.BusinessPartnerName AS BusinessPartnerName,
  I_InsurClmPrtcpntOccrnc.FormOfAddress AS FormOfAddress,
  I_InsurClmPrtcpntOccrnc.LastName AS LastName,
  I_InsurClmPrtcpntOccrnc.FirstName AS FirstName,
  I_InsurClmPrtcpntOccrnc.StreetName AS StreetName,
  I_InsurClmPrtcpntOccrnc.HouseNumber AS HouseNumber,
  I_InsurClmPrtcpntOccrnc.CityName AS CityName,
  I_InsurClmPrtcpntOccrnc.PostalCode AS PostalCode,
  I_InsurClmPrtcpntOccrnc.Region AS Region,
  I_InsurClmPrtcpntOccrnc.Country AS Country,
  I_InsurClmPrtcpntOccrnc.PhoneNumber AS PhoneNumber,
  I_InsurClmPrtcpntOccrnc.EmailAddress AS EmailAddress,
  I_InsurClmPrtcpntOccrnc.BirthDate AS BirthDate,
  I_InsurClmPrtcpntOccrnc.GenderCodeName AS GenderCodeName,
  I_InsurClmPrtcpntOccrnc.AuthorizationGroup AS AuthorizationGroup,
  I_InsurClmPrtcpntOccrnc.IsBusinessPurposeCompleted AS IsBusinessPurposeCompleted,
  I_InsurClmPrtcpntOccrnc.DataControllerSet AS DataControllerSet,
  I_InsurClmPrtcpntOccrnc.DataController1 AS DataController1,
  I_InsurClmPrtcpntOccrnc.DataController2 AS DataController2,
  I_InsurClmPrtcpntOccrnc.DataController3 AS DataController3,
  I_InsurClmPrtcpntOccrnc.DataController4 AS DataController4,
  I_InsurClmPrtcpntOccrnc.DataController5 AS DataController5,
  I_InsurClmPrtcpntOccrnc.DataController6 AS DataController6,
  I_InsurClmPrtcpntOccrnc.DataController7 AS DataController7,
  I_InsurClmPrtcpntOccrnc.DataController8 AS DataController8,
  I_InsurClmPrtcpntOccrnc.DataController9 AS DataController9,
  I_InsurClmPrtcpntOccrnc.DataController10 AS DataController10,
  I_InsurClmPrtcpntOccrnc._BusinessPartner AS _BusinessPartner,
  I_InsurClmPrtcpntOccrnc._Claim AS _Claim
FROM I_InsurClmPrtcpntOccrnc
;

Learn More