I_InsurClmFNOLDriverSFCTP

DDL: I_INSURCLMFNOLDRIVERSFCTP SQL: Type: view_entity TRANSACTIONAL
32 Fields 2 Data Sources 1 Associations

Facts Captured Driver FNOL - TP

I_InsurClmFNOLDriverSFCTP is a Transactional CDS View that provides data about "Facts Captured Driver FNOL - TP" in SAP S/4HANA. It reads from 2 data sources (I_InsurClmFactCapture, I_InsurClmFNOLVehDriver) and exposes 32 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] I_InsurClmFNOLTP _Claim $projection.InsuranceClaim = _Claim.InsuranceClaim and $projection.InsurClaimUUID = _Claim.InsurClaimUUID

Annotations (6)

NameValueLevelField
AccessControl.authorizationCheck #CHECK view
VDM.viewType #TRANSACTIONAL view
ObjectModel.usageType.dataClass #TRANSACTIONAL view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #X view
EndUserText.label Facts Captured Driver FNOL - TP view

Fields (32)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim
KEY InsuranceContract
KEY InsurClmSubobject I_InsurClmFNOLVehDriver InsurClmSubobject Claim Subobject
KEY InsurClmFactCaptureCategory I_InsurClmFactCapture InsurClmFactCaptureCategory FactsCapt.Cat.
KEY InsurFactsSubobject
KEY InsurClmFactCaptureQstn
KEY InsurClmFactCaptureAnswer
KEY InsurClaimUUID
KEY InsurClmDmgdObjUUID
KEY InsurClmVehDriverUUID
InsurClmFactFreeTextAnswerCat
InsurClmFactCaptureQstnForEdit
InsurClmFactCaptureAnswForEdit
InsurClmFactCaptureQstnPos
InsurClmFactCaptureQstnSqnc
InsurClmFactCaptureSqncVersion
InsurClmFactCaptureSqncVariant
InsurClmFactCaptureQstnCat
InsurClmFactCaptureQstnShrtTxt
InsurClmFactCaptureQstnLongTxt
InsurClmFactAnswerShortText
InsurClmFactAnswerLongText
InsurClmFactCaptureTextAnswer
InsurClmFactUsrSeldAnswerKeys
InsurClmFactQstnIsMltplChoice
InsurClmFactCaptureNextQstn
InsurClmIsHiddenFlag
_FactCaptureAnswer
_FactCaptureQstn
_damgdobj _damgdobj
_Driver _Driver
_Claim _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_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 I_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,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS InsurClaimUUID,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS InsurClmDmgdObjUUID,
  cast ( hextobin('00000000000000000000000000000000') as sysuuid_x16 preserving type ) AS InsurClmVehDriverUUID,
  _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,
  _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 I_InsurClmFNOLTP AS _Claim ON InsuranceClaim = _Claim.InsuranceClaim AND InsurClaimUUID = _Claim.InsurClaimUUID  -- association [1..1]
;

Learn More