R_InsurClmFNOLDriverSFCTP

DDL: R_INSURCLMFNOLDRIVERSFCTP Type: view_entity TRANSACTIONAL
27 Fields 2 Data Sources 1 Associations

FNOL Driver SFC

R_InsurClmFNOLDriverSFCTP is a Transactional CDS View that provides data about "FNOL Driver SFC" in SAP S/4HANA. It reads from 2 data sources (I_InsurClmFactCapture, I_InsurClmFNOLVehDriver) and exposes 27 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_InsurClmFNOLVehDriver _part from

Associations (1)

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

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label FNOL Driver 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 (27)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim
KEY InsuranceContract
KEY InsurClmSubobject I_InsurClmFNOLVehDriver 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
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
_FactCaptureAnswer I_InsurClmFactCapture _FactCaptureAnswer
_FactCaptureQstn I_InsurClmFactCapture _FactCaptureQstn
_Damaged _Damaged
_InsurClaim _InsurClaim
_Driver _Driver

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_InsurClmFNOLDriverSFCTP.
-- 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_InsurClmFNOLDriverSFCTP 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.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,
  _Facts._FactCaptureAnswer AS _FactCaptureAnswer,
  _Facts._FactCaptureQstn AS _FactCaptureQstn
FROM I_InsurClmFNOLVehDriver AS _part
INNER JOIN I_InsurClmFactCapture AS _Facts ON /* join condition not captured in parsed metadata */
LEFT OUTER JOIN R_InsurClmFNOLTP AS _InsurClaim ON InsuranceClaim = _InsurClaim.InsuranceClaim  -- association [1..1]
;

Learn More