R_InsClmSrvcsPrtcpntSFCTP

DDL: R_INSCLMSRVCSPRTCPNTSFCTP Type: view_entity TRANSACTIONAL
29 Fields 1 Data Sources 1 Associations

Claim Services SFC for Participant TP

R_InsClmSrvcsPrtcpntSFCTP is a Transactional CDS View that provides data about "Claim Services SFC for Participant TP" in SAP S/4HANA. It reads from 1 data source (I_InsurClmSrvcsPrtcpntSFC) and exposes 29 fields with key fields InsuranceClaim, InsurClmSubobject, InsurClmSubobjectCategory, InsurClmParticipantRole, BusinessPartner. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmSrvcsPrtcpntSFC I_InsurClmSrvcsPrtcpntSFC from

Associations (1)

CardinalityTargetAliasCondition
[1..1] R_InsurClmSrvcsInsurClaimTP _InsurClaim $projection.InsuranceClaim = _InsurClaim.InsuranceClaim

Annotations (9)

NameValueLevelField
EndUserText.label Claim Services SFC for Participant TP view
AccessControl.authorizationCheck #MANDATORY 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
ObjectModel.sapObjectNodeType.name InsuranceClaimsServices view

Fields (29)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim Claim Number
KEY InsurClmSubobject InsurClmSubobject Claim Subobject
KEY InsurClmSubobjectCategory InsurClmSubobjectCategory Subobject Cat.
KEY InsurClmParticipantRole InsurClmParticipantRole ParticipantRole
KEY BusinessPartner BusinessPartner Issuing Authority
KEY InsurClmFactCaptureCategory InsurClmFactCaptureCategory
KEY InsurFactsSubobject InsurFactsSubobject
KEY InsurClmFactCaptureQstn InsurClmFactCaptureQstn
KEY InsurClmFactCaptureAnswer InsurClmFactCaptureAnswer
InsurClmFactFreeTextAnswerCat InsurClmFactFreeTextAnswerCat
InsurClmFactCaptureQstnPos InsurClmFactCaptureQstnPos
InsurClmFactCaptureQstnSqnc InsurClmFactCaptureQstnSqnc
InsurClmFactCaptureSqncVersion InsurClmFactCaptureSqncVersion
InsurClmFactCaptureSqncVariant InsurClmFactCaptureSqncVariant
InsurClmFactCaptureQstnCat InsurClmFactCaptureQstnCat
InsurClmFactCaptureQstnShrtTxt InsurClmFactCaptureQstnShrtTxt
InsurClmFactCaptureQstnLongTxt InsurClmFactCaptureQstnLongTxt
InsurClmFactAnswerShortText InsurClmFactAnswerShortText
InsurClmFactAnswerLongText InsurClmFactAnswerLongText
InsurClmFactCaptureTextAnswer InsurClmFactCaptureTextAnswer
InsurClmFactUsrSeldAnswerKeys InsurClmFactUsrSeldAnswerKeys
InsurClmFactQstnIsMltplChoice InsurClmFactQstnIsMltplChoice
InsurClmFactCaptureNextQstn InsurClmFactCaptureNextQstn
InsurClmIsHiddenFlag InsurClmIsHiddenFlag
InsuranceClaimChangeCategory
_FactCaptureAnswer _FactCaptureAnswer
_FactCaptureQstn _FactCaptureQstn
_InsurClmPrtcpnt _InsurClmPrtcpnt
_InsurClaim _InsurClaim

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 R_InsClmSrvcsPrtcpntSFCTP.
-- 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 R_InsClmSrvcsPrtcpntSFCTP AS
SELECT
  InsuranceClaim,
  InsurClmSubobject,
  InsurClmSubobjectCategory,
  InsurClmParticipantRole,
  BusinessPartner,
  InsurClmFactCaptureCategory,
  InsurFactsSubobject,
  InsurClmFactCaptureQstn,
  InsurClmFactCaptureAnswer,
  InsurClmFactFreeTextAnswerCat,
  InsurClmFactCaptureQstnPos,
  InsurClmFactCaptureQstnSqnc,
  InsurClmFactCaptureSqncVersion,
  InsurClmFactCaptureSqncVariant,
  InsurClmFactCaptureQstnCat,
  InsurClmFactCaptureQstnShrtTxt,
  InsurClmFactCaptureQstnLongTxt,
  InsurClmFactAnswerShortText,
  InsurClmFactAnswerLongText,
  InsurClmFactCaptureTextAnswer,
  InsurClmFactUsrSeldAnswerKeys,
  InsurClmFactQstnIsMltplChoice,
  InsurClmFactCaptureNextQstn,
  InsurClmIsHiddenFlag,
  cast ('' as bu_chind preserving type ) AS InsuranceClaimChangeCategory
FROM I_InsurClmSrvcsPrtcpntSFC
LEFT OUTER JOIN R_InsurClmSrvcsInsurClaimTP AS _InsurClaim ON InsuranceClaim = _InsurClaim.InsuranceClaim  -- association [1..1]
;

Learn More