R_InsurClmFNOLFactsDmgdVehTP

DDL: R_INSURCLMFNOLFACTSDMGDVEHTP Type: view_entity TRANSACTIONAL Package: ICL_VDM_FNOL_API
27 Fields 1 Data Sources 1 Associations

FNOL Damaged Vehicle SFC

R_InsurClmFNOLFactsDmgdVehTP is a Transactional CDS View that provides data about "FNOL Damaged Vehicle SFC" in SAP S/4HANA. It reads from 1 data source (I_InsurClmFactCapture) and exposes 27 fields with key fields InsuranceClaim, InsuranceContract, InsurClmFactCaptureCategory, InsurClmSFCSubobj, InsurFactsSubobject. It has 1 association to related views. Part of development package ICL_VDM_FNOL_API.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmFactCapture I_InsurClmFactCapture from

Associations (1)

CardinalityTargetAliasCondition
[1..1] E_InsurClmFactCapture _Extension $projection.InsuranceClaim = _Extension.InsuranceClaim and $projection.InsurClmFactCaptureCategory = _Extension.InsurClmFactCaptureCategory and $projection.InsurClmSFCSubobj = _Extension.InsurClmSFCSubobj and $projection.InsurClmFactCaptureQstn = _Extension.InsurClmFactCaptureQstn and $projection.InsurClmFactCaptureAnswer = _Extension.InsurClmFactCaptureAnswer

Annotations (9)

NameValueLevelField
AccessControl.authorizationCheck #MANDATORY view
EndUserText.label FNOL Damaged Vehicle 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 I_InsurClmFactCapture InsuranceClaim Claim Number
KEY InsuranceContract I_InsurClmFactCapture InsuranceContract Contract
KEY InsurClmFactCaptureCategory I_InsurClmFactCapture InsurClmFactCaptureCategory FactsCapt.Cat.
KEY InsurClmSFCSubobj I_InsurClmFactCapture InsurClmSubobject Claim Subobject
KEY InsurFactsSubobject I_InsurClmFactCapture InsurFactsSubobject Triggering obj.
KEY InsurClmFactCaptureQstn I_InsurClmFactCapture InsurClmFactCaptureQstn Question
KEY InsurClmFactCaptureAnswer I_InsurClmFactCapture InsurClmFactCaptureAnswer Answer
InsurClmFactFreeTextAnswerCat _FactCaptureAnswer InsurClmFactFreeTextAnswerCat
InsurClmFactCaptureSqncVariant I_InsurClmFactCapture InsurClmFactCaptureSqncVariant Variant
InsurClmFactCaptureQstnPos I_InsurClmFactCapture InsurClmFactCaptureQstnPos Sequence
InsurClmFactCaptureQstnSqnc I_InsurClmFactCapture InsurClmFactCaptureQstnSqnc Question Seq.
InsurClmFactCaptureSqncVersion I_InsurClmFactCapture InsurClmFactCaptureSqncVersion XML Vers.
InsurClmFactCaptureQstnCat _FactCaptureQstn InsurClmFactCaptureQstnCat
InsurClmFactCaptureQstnShrtTxt
InsurClmFactCaptureQstnLongTxt
InsurClmFactAnswerShortText
InsurClmFactAnswerLongText
InsurClmFactCaptureTextAnswer
InsurClmFactUsrSeldAnswerKeys _FactCaptureTxtAnswer InsurClmFactCaptureTextAnswer
InsurClmFactQstnIsMltplChoice
InsurClmFactCaptureNextQstn
InsurClmIsHiddenFlag
_Claim I_InsurClmFactCapture _Claim
_FactCaptureAnswer I_InsurClmFactCapture _FactCaptureAnswer
_FactCaptureQstn I_InsurClmFactCapture _FactCaptureQstn
_FactCaptureTxtAnswer I_InsurClmFactCapture _FactCaptureTxtAnswer
_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_InsurClmFNOLFactsDmgdVehTP.
-- 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_InsurClmFNOLFactsDmgdVehTP AS
SELECT
  I_InsurClmFactCapture.InsuranceClaim AS InsuranceClaim,
  I_InsurClmFactCapture.InsuranceContract AS InsuranceContract,
  I_InsurClmFactCapture.InsurClmFactCaptureCategory AS InsurClmFactCaptureCategory,
  I_InsurClmFactCapture.InsurClmSubobject AS InsurClmSFCSubobj,
  I_InsurClmFactCapture.InsurFactsSubobject AS InsurFactsSubobject,
  I_InsurClmFactCapture.InsurClmFactCaptureQstn AS InsurClmFactCaptureQstn,
  I_InsurClmFactCapture.InsurClmFactCaptureAnswer AS InsurClmFactCaptureAnswer,
  _FactCaptureAnswer.InsurClmFactFreeTextAnswerCat AS InsurClmFactFreeTextAnswerCat,
  I_InsurClmFactCapture.InsurClmFactCaptureSqncVariant AS InsurClmFactCaptureSqncVariant,
  I_InsurClmFactCapture.InsurClmFactCaptureQstnPos AS InsurClmFactCaptureQstnPos,
  I_InsurClmFactCapture.InsurClmFactCaptureQstnSqnc AS InsurClmFactCaptureQstnSqnc,
  I_InsurClmFactCapture.InsurClmFactCaptureSqncVersion AS InsurClmFactCaptureSqncVersion,
  _FactCaptureQstn.InsurClmFactCaptureQstnCat AS InsurClmFactCaptureQstnCat,
  _FactCaptureQstn._FactCaptureQstnText[ Language = $session.system_language ].InsurClmFactCaptureQstnShrtTxt AS InsurClmFactCaptureQstnShrtTxt,
  _FactCaptureQstn._FactCaptureQstnText[ Language = $session.system_language ].InsurClmFactCaptureQstnLongTxt AS InsurClmFactCaptureQstnLongTxt,
  _FactCaptureAnswer._FactCaptureAnswerT[ Language = $session.system_language ].InsurClmFactAnswerShortText AS InsurClmFactAnswerShortText,
  _FactCaptureAnswer._FactCaptureAnswerT[ Language = $session.system_language ].InsurClmFactAnswerLongText AS InsurClmFactAnswerLongText,
  _FactCaptureTxtAnswer. InsurClmFactCaptureTextAnswer AS InsurClmFactCaptureTextAnswer,
  _FactCaptureTxtAnswer.InsurClmFactCaptureTextAnswer AS InsurClmFactUsrSeldAnswerKeys,
  _FactCaptureQstn. InsurClmFactQstnIsMltplChoice AS InsurClmFactQstnIsMltplChoice,
  _FactCaptureAnswer. InsurClmFactCaptureNextQstn AS InsurClmFactCaptureNextQstn,
  cast('' as xfeld preserving type ) AS InsurClmIsHiddenFlag,
  I_InsurClmFactCapture._Claim AS _Claim,
  I_InsurClmFactCapture._FactCaptureAnswer AS _FactCaptureAnswer,
  I_InsurClmFactCapture._FactCaptureQstn AS _FactCaptureQstn,
  I_InsurClmFactCapture._FactCaptureTxtAnswer AS _FactCaptureTxtAnswer
FROM I_InsurClmFactCapture
LEFT OUTER JOIN E_InsurClmFactCapture AS _Extension ON InsuranceClaim = _Extension.InsuranceClaim AND InsurClmFactCaptureCategory = _Extension.InsurClmFactCaptureCategory AND InsurClmSFCSubobj = _Extension.InsurClmSFCSubobj AND InsurClmFactCaptureQstn = _Extension.InsurClmFactCaptureQstn AND InsurClmFactCaptureAnswer = _Extension.InsurClmFactCaptureAnswer  -- association [1..1]
;

Learn More