R_InsurClmFNOLInjuredSFCTP

DDL: R_INSURCLMFNOLINJUREDSFCTP Type: view_entity TRANSACTIONAL
25 Fields 2 Data Sources 1 Associations

FNOL Injured Person SFC

R_InsurClmFNOLInjuredSFCTP is a Transactional CDS View that provides data about "FNOL Injured Person SFC" in SAP S/4HANA. It reads from 2 data sources (I_InsurClmFactCapture, I_InsurClmFNOLInjuredPersonTP) and exposes 25 fields with key fields InsuranceClaim, InsuranceContract, InsurClmSubobject, InsurClmFactCaptureCategory, InsurFactsSubobject. It has 1 association to related views.

Data Sources (2)

SourceAliasJoin Type
I_InsurClmFactCapture _facts inner
I_InsurClmFNOLInjuredPersonTP _part from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_InsuranceClaimParticipant _Extension $projection.InsuranceClaim = _Extension.InsuranceClaim and _part.InsurClmSubobjectCategory = _Extension.InsurClmSubobjectCategory and _part.InsurClmSubobject = _Extension.InsurClmSubobject and _part.InsurClmParticipantRole = _Extension.InsurClmParticipantRole and _part.BusinessPartner = _Extension.BusinessPartner

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label FNOL Injured Person SFC 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 InsuranceClaim view

Fields (25)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim I_InsurClmFactCapture InsuranceClaim Claim Number
KEY InsuranceContract I_InsurClmFactCapture InsuranceContract Contract
KEY InsurClmSubobject I_InsurClmFNOLInjuredPersonTP InsurClmSubobject Claim Subobject
KEY InsurClmFactCaptureCategory I_InsurClmFactCapture InsurClmFactCaptureCategory FactsCapt.Cat.
KEY InsurFactsSubobject I_InsurClmFactCapture InsurFactsSubobject Triggering obj.
KEY InsurClmFactCaptureQstn I_InsurClmFactCapture InsurClmFactCaptureQstn Question
KEY InsurClmFactCaptureAnswer I_InsurClmFactCapture InsurClmFactCaptureAnswer Answer
InsurClmFactFreeTextAnswerCat
InsurClmFactCaptureQstnForEdit I_InsurClmFactCapture InsurClmFactCaptureQstn Question
InsurClmFactCaptureAnswForEdit I_InsurClmFactCapture InsurClmFactCaptureAnswer Answer
InsurClmFactCaptureQstnPos I_InsurClmFactCapture InsurClmFactCaptureQstnPos Sequence
InsurClmFactCaptureQstnSqnc I_InsurClmFactCapture InsurClmFactCaptureQstnSqnc Question Seq.
InsurClmFactCaptureSqncVersion I_InsurClmFactCapture InsurClmFactCaptureSqncVersion XML Vers.
InsurClmFactCaptureSqncVariant I_InsurClmFactCapture InsurClmFactCaptureSqncVariant Variant
InsurClmFactCaptureQstnCat
InsurClmFactCaptureQstnShrtTxt
InsurClmFactCaptureQstnLongTxt
InsurClmFactAnswerShortText
InsurClmFactAnswerLongText
InsurClmFactCaptureTextAnswer
InsurClmFactUsrSeldAnswerKeys
InsurClmFactQstnIsMltplChoice
InsurClmFactCaptureNextQstn
InsurClmIsHiddenFlag
_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_InsurClmFNOLInjuredSFCTP.
-- 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_InsurClmFNOLInjuredSFCTP AS
SELECT
  _facts.InsuranceClaim AS InsuranceClaim,
  _facts.InsuranceContract AS InsuranceContract,
  _part.InsurClmSubobject AS InsurClmSubobject,
  _facts.InsurClmFactCaptureCategory AS InsurClmFactCaptureCategory,
  _facts.InsurFactsSubobject AS InsurFactsSubobject,
  _facts.InsurClmFactCaptureQstn AS InsurClmFactCaptureQstn,
  _facts.InsurClmFactCaptureAnswer AS InsurClmFactCaptureAnswer,
  _facts._FactCaptureAnswer.InsurClmFactFreeTextAnswerCat AS InsurClmFactFreeTextAnswerCat,
  _facts.InsurClmFactCaptureQstn AS InsurClmFactCaptureQstnForEdit,
  _facts.InsurClmFactCaptureAnswer AS InsurClmFactCaptureAnswForEdit,
  _facts.InsurClmFactCaptureQstnPos AS InsurClmFactCaptureQstnPos,
  _facts.InsurClmFactCaptureQstnSqnc AS InsurClmFactCaptureQstnSqnc,
  _facts.InsurClmFactCaptureSqncVersion AS InsurClmFactCaptureSqncVersion,
  _facts.InsurClmFactCaptureSqncVariant AS InsurClmFactCaptureSqncVariant,
  _facts._FactCaptureQstn.InsurClmFactCaptureQstnCat AS InsurClmFactCaptureQstnCat,
  _facts._FactCaptureQstn._FactCaptureQstnText[ Language = $session.system_language ].InsurClmFactCaptureQstnShrtTxt AS InsurClmFactCaptureQstnShrtTxt,
  _facts._FactCaptureQstn._FactCaptureQstnText[ Language = $session.system_language ].InsurClmFactCaptureQstnLongTxt AS InsurClmFactCaptureQstnLongTxt,
  _facts._FactCaptureAnswer._FactCaptureAnswerT[ Language = $session.system_language ].InsurClmFactAnswerShortText AS InsurClmFactAnswerShortText,
  _facts._FactCaptureAnswer._FactCaptureAnswerT[ Language = $session.system_language ].InsurClmFactAnswerLongText AS InsurClmFactAnswerLongText,
  _facts._FactCaptureTxtAnswer. InsurClmFactCaptureTextAnswer AS InsurClmFactCaptureTextAnswer,
  _facts._FactCaptureTxtAnswer.InsurClmFactCaptureTextAnswer AS InsurClmFactUsrSeldAnswerKeys,
  _facts._FactCaptureQstn. InsurClmFactQstnIsMltplChoice AS InsurClmFactQstnIsMltplChoice,
  _facts._FactCaptureAnswer. InsurClmFactCaptureNextQstn AS InsurClmFactCaptureNextQstn,
  cast('' as xfeld preserving type ) AS InsurClmIsHiddenFlag
FROM I_InsurClmFNOLInjuredPersonTP AS _part
INNER JOIN I_InsurClmFactCapture AS _facts ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN E_InsuranceClaimParticipant AS _Extension ON InsuranceClaim = _Extension.InsuranceClaim AND _part.InsurClmSubobjectCategory = _Extension.InsurClmSubobjectCategory AND _part.InsurClmSubobject = _Extension.InsurClmSubobject AND _part.InsurClmParticipantRole = _Extension.InsurClmParticipantRole AND _part.BusinessPartner = _Extension.BusinessPartner  -- association [1..1]
;

Learn More