C_InsurClm1stNotifFactTP

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 C_InsurClm1stNotifFactTP.
-- 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 C_InsurClm1stNotifFactTP AS
SELECT
  InsuranceClaim,
  InsurClmFactCaptureCategory,
  InsurClmSubobject,
  InsurClmFactCaptureQstn,
  InsurClmFactCaptureAnswer,
  InsurClmFactFreeTextAnswerCat,
  InsurClmFactCaptureQstnCat,
  InsurClmFactCaptureQstnShrtTxt,
  InsurClmFactCaptureQstnForEdit,
  InsurClmFactCaptureAnswForEdit,
  InsurClmFactCaptureQstnPos,
  InsurClmFactCaptureQstnSqnc,
  InsurClmFactCaptureSqncVersion,
  InsurClmFactCaptureSqncVariant,
  InsurClmFactCaptureQstnLongTxt,
  InsurClmFactAnswerShortText,
  InsurClmFactAnswerLongText,
  InsurClmFactQstnIsMltplChoice,
  InsurClmFactCaptureNextQstn,
  InsurClmFactCaptureTextAnswer,
  InsurClmFactUsrSeldAnswerKeys
FROM I_InsurClm1stNotifFactTP
LEFT OUTER JOIN C_InsurClm1stNotifTP AS _Claim ON InsuranceClaim = _Claim.InsuranceClaim  -- association [1..1]
LEFT OUTER JOIN I_InsurClm1stNotifFactAnswerVH AS _FactAnswerVH ON InsurClmFactCaptureQstnSqnc = _FactAnswerVH.InsurClmFactCaptureQstnSqnc AND InsurClmFactCaptureSqncVersion = _FactAnswerVH.InsurClmFactCaptureSqncVersion AND InsurClmFactCaptureQstnForEdit = _FactAnswerVH.InsurClmFactCaptureQstn AND InsurClmFactCaptureSqncVariant = _FactAnswerVH.InsurClmFactCaptureSqncVariant  -- association [0..*]
;