I_InsurClmFactCaptureAnswer

DDL: I_INSURCLMFACTCAPTUREANSWER SQL: ICLMSFACTCANS Type: view BASIC
9 Fields 1 Data Sources 1 Associations

Sachverhaltserfassung: Antwort

I_InsurClmFactCaptureAnswer is a Basic CDS View that provides data about "Sachverhaltserfassung: Antwort" in SAP S/4HANA. It reads from 1 data source (tbsfc002) and exposes 9 fields with key fields InsurClmFactCaptureQstnSqnc, InsurClmFactCaptureSqncVersion, InsurClmFactCaptureQstn, InsurClmFactCaptureAnswer, InsurClmFactCaptureSqncVariant. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
tbsfc002 tbsfc002 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_InsurClmFactCaptureAnswerT _FactCaptureAnswerT $projection.InsurClmFactCaptureQstnSqnc = _FactCaptureAnswerT.InsurClmFactCaptureQstnSqnc and $projection.InsurClmFactCaptureSqncVersion = _FactCaptureAnswerT.InsurClmFactCaptureSqncVersion and $projection.InsurClmFactCaptureQstn = _FactCaptureAnswerT.InsurClmFactCaptureQstn and $projection.InsurClmFactCaptureAnswer = _FactCaptureAnswerT.InsurClmFactCaptureAnswer and $projection.InsurClmFactCaptureSqncVariant = _FactCaptureAnswerT.InsurClmFactCaptureSqncVariant

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName ICLMSFACTCANS view
AbapCatalog.compiler.compareFilter true view
AccessControl.authorizationCheck #NOT_REQUIRED view
EndUserText.label Sachverhaltserfassung: Antwort view
Metadata.allowExtensions true view
VDM.viewType #BASIC view
ClientHandling.algorithm #SESSION_VARIABLE view
ObjectModel.usageType.dataClass #CUSTOMIZING view
ObjectModel.usageType.sizeCategory #M view
ObjectModel.usageType.serviceQuality #A view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY InsurClmFactCaptureQstnSqnc queseq Question Seq.
KEY InsurClmFactCaptureSqncVersion version XML Vers.
KEY InsurClmFactCaptureQstn question Question
KEY InsurClmFactCaptureAnswer answer Answer
KEY InsurClmFactCaptureSqncVariant avariant Variant
InsurClmFactCaptureNextQstn nextquestion Question
InsurClmFactFreeTextAnswerCat xfreetext User-DefTextInp
InsurClmFactCaptureAnswerPos aposition Answer Position
_FactCaptureAnswerT _FactCaptureAnswerT

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_InsurClmFactCaptureAnswer.
-- 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: ICLMSFACTCANS

CREATE VIEW I_InsurClmFactCaptureAnswer AS
SELECT
  queseq AS InsurClmFactCaptureQstnSqnc,
  version AS InsurClmFactCaptureSqncVersion,
  question AS InsurClmFactCaptureQstn,
  answer AS InsurClmFactCaptureAnswer,
  avariant AS InsurClmFactCaptureSqncVariant,
  nextquestion AS InsurClmFactCaptureNextQstn,
  xfreetext AS InsurClmFactFreeTextAnswerCat,
  aposition AS InsurClmFactCaptureAnswerPos
FROM tbsfc002
LEFT OUTER JOIN I_InsurClmFactCaptureAnswerT AS _FactCaptureAnswerT ON InsurClmFactCaptureQstnSqnc = _FactCaptureAnswerT.InsurClmFactCaptureQstnSqnc AND InsurClmFactCaptureSqncVersion = _FactCaptureAnswerT.InsurClmFactCaptureSqncVersion AND InsurClmFactCaptureQstn = _FactCaptureAnswerT.InsurClmFactCaptureQstn AND InsurClmFactCaptureAnswer = _FactCaptureAnswerT.InsurClmFactCaptureAnswer AND InsurClmFactCaptureSqncVariant = _FactCaptureAnswerT.InsurClmFactCaptureSqncVariant  -- association [0..*]
;

Learn More