I_InsurClm1stNotifFactCapture

DDL: I_INSURCLM1STNOTIFFACTCAPTURE SQL: ICL1STNFFACTC Type: view COMPOSITE
22 Fields 1 Data Sources

Schadenmeldung - Sachverhalt

I_InsurClm1stNotifFactCapture is a Composite CDS View that provides data about "Schadenmeldung - Sachverhalt" in SAP S/4HANA. It reads from 1 data source (I_InsurClmFactCapture) and exposes 22 fields with key fields InsuranceClaim, InsurClmFactCaptureCategory, InsurClmSubobject, InsurClmFactCaptureQstn, InsurClmFactCaptureAnswer.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmFactCapture I_InsurClmFactCapture from

Annotations (9)

NameValueLevelField
AbapCatalog.sqlViewName ICL1STNFFACTC view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Schadenmeldung - Sachverhalt view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #C view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #COMPOSITE view

Fields (22)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim Claim Number
KEY InsurClmFactCaptureCategory InsurClmFactCaptureCategory FactsCapt.Cat.
KEY InsurClmSubobject InsurClmSubobject Claim Subobject
KEY InsurClmFactCaptureQstn InsurClmFactCaptureQstn Question
KEY InsurClmFactCaptureAnswer InsurClmFactCaptureAnswer Answer
InsurClmFactCaptureQstnPos InsurClmFactCaptureQstnPos Sequence
InsurClmFactCaptureQstnSqnc InsurClmFactCaptureQstnSqnc Question Seq.
InsurClmFactCaptureSqncVersion InsurClmFactCaptureSqncVersion XML Vers.
InsurClmFactCaptureSqncVariant InsurClmFactCaptureSqncVariant Variant
InsurClmFactCaptureQstnCat _FactCaptureQstn InsurClmFactCaptureQstnCat
InsurClmFactQstnIsMltplChoice _FactCaptureQstn InsurClmFactQstnIsMltplChoice
InsurClmFactCaptureQstnShrtTxt
InsurClmFactCaptureQstnLongTxt
InsurClmFactCaptureTextAnswer _FactCaptureTxtAnswer InsurClmFactCaptureTextAnswer
InsurClmFactAnswerShortText
InsurClmFactAnswerLongText
InsurClmFactCaptureNextQstn _FactCaptureAnswer InsurClmFactCaptureNextQstn
InsurClmFactFreeTextAnswerCat _FactCaptureAnswer InsurClmFactFreeTextAnswerCat
_Claim _Claim
_FactCaptureAnswer _FactCaptureAnswer
_FactCaptureQstn _FactCaptureQstn
_FactCaptureTxtAnswer _FactCaptureTxtAnswer

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_InsurClm1stNotifFactCapture.
-- 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.
-- SQL view name: ICL1STNFFACTC

CREATE VIEW I_InsurClm1stNotifFactCapture AS
SELECT
  InsuranceClaim,
  InsurClmFactCaptureCategory,
  InsurClmSubobject,
  InsurClmFactCaptureQstn,
  InsurClmFactCaptureAnswer,
  InsurClmFactCaptureQstnPos,
  InsurClmFactCaptureQstnSqnc,
  InsurClmFactCaptureSqncVersion,
  InsurClmFactCaptureSqncVariant,
  _FactCaptureQstn.InsurClmFactCaptureQstnCat AS InsurClmFactCaptureQstnCat,
  _FactCaptureQstn.InsurClmFactQstnIsMltplChoice AS InsurClmFactQstnIsMltplChoice,
  _FactCaptureQstn._FactCaptureQstnText[ Language = $session.system_language ].InsurClmFactCaptureQstnShrtTxt AS InsurClmFactCaptureQstnShrtTxt,
  _FactCaptureQstn._FactCaptureQstnText[ Language = $session.system_language ].InsurClmFactCaptureQstnLongTxt AS InsurClmFactCaptureQstnLongTxt,
  _FactCaptureTxtAnswer.InsurClmFactCaptureTextAnswer AS InsurClmFactCaptureTextAnswer,
  _FactCaptureAnswer._FactCaptureAnswerT[ Language = $session.system_language ].InsurClmFactAnswerShortText AS InsurClmFactAnswerShortText,
  _FactCaptureAnswer._FactCaptureAnswerT[ Language = $session.system_language ].InsurClmFactAnswerLongText AS InsurClmFactAnswerLongText,
  _FactCaptureAnswer.InsurClmFactCaptureNextQstn AS InsurClmFactCaptureNextQstn,
  _FactCaptureAnswer.InsurClmFactFreeTextAnswerCat AS InsurClmFactFreeTextAnswerCat
FROM I_InsurClmFactCapture
;

Learn More