I_InsurClmFactCaptureQstn

DDL: I_INSURCLMFACTCAPTUREQSTN SQL: ICLMSFACTCQSTN Type: view BASIC
8 Fields 1 Data Sources 1 Associations

Sachverhaltserfassung: Frage

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

Data Sources (1)

SourceAliasJoin Type
tbsfc001 tbsfc001 from

Associations (1)

CardinalityTargetAliasCondition
[0..*] I_InsurClmFactCaptureQstnText _FactCaptureQstnText $projection.InsurClmFactCaptureQstnSqnc = _FactCaptureQstnText.InsurClmFactCaptureQstnSqnc and $projection.InsurClmFactCaptureSqncVersion = _FactCaptureQstnText.InsurClmFactCaptureSqncVersion and $projection.InsurClmFactCaptureQstn = _FactCaptureQstnText.InsurClmFactCaptureQstn

Annotations (10)

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

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY InsurClmFactCaptureQstnSqnc queseq Question Seq.
KEY InsurClmFactCaptureSqncVersion version XML Vers.
KEY InsurClmFactCaptureQstn question Question
InsurClmFactStrtgQstnPos qposition Sequence
InsurClmFactQstnIsStrtgQstn xstartquestion Start question
InsurClmFactCaptureQstnCat qtype Q. Type
InsurClmFactQstnIsMltplChoice xmultiple Multip. answers
_FactCaptureQstnText _FactCaptureQstnText

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_InsurClmFactCaptureQstn.
-- 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: ICLMSFACTCQSTN

CREATE VIEW I_InsurClmFactCaptureQstn AS
SELECT
  queseq AS InsurClmFactCaptureQstnSqnc,
  version AS InsurClmFactCaptureSqncVersion,
  question AS InsurClmFactCaptureQstn,
  qposition AS InsurClmFactStrtgQstnPos,
  xstartquestion AS InsurClmFactQstnIsStrtgQstn,
  qtype AS InsurClmFactCaptureQstnCat,
  xmultiple AS InsurClmFactQstnIsMltplChoice
FROM tbsfc001
LEFT OUTER JOIN I_InsurClmFactCaptureQstnText AS _FactCaptureQstnText ON InsurClmFactCaptureQstnSqnc = _FactCaptureQstnText.InsurClmFactCaptureQstnSqnc AND InsurClmFactCaptureSqncVersion = _FactCaptureQstnText.InsurClmFactCaptureSqncVersion AND InsurClmFactCaptureQstn = _FactCaptureQstnText.InsurClmFactCaptureQstn  -- association [0..*]
;

Learn More