I_InsurClmDiagnosis

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_InsurClmDiagnosis.
-- 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: IICLDIAGNOSIS

CREATE VIEW I_InsurClmDiagnosis AS
SELECT
  claim AS InsuranceClaim,
  subobject AS InsurClmDmgdSubObject,
  subobjcat AS InsurClmSubobjectCategory,
  patient AS InsurClmInjuredPersonNumber,
  diagno AS InsurClmDiagnosisNmbr,
  cataid1 AS InsurClmCatalogCode,
  cast( diagid1 as icl_diagid_api preserving type ) AS InsurClmDiagnosisCode,
  _InsurClmDiagnCatalog.InsurClmDiagnosisGroupCode AS InsurClmDiagnosisGroupCode
FROM icldiagnosis
LEFT OUTER JOIN I_InsurClmDiagnCtlgCode AS _InsurClmDiagnCtlgCode ON InsurClmCatalogCode = _InsurClmDiagnCtlgCode.InsurClmCatalogCode  -- association [0..1]
LEFT OUTER JOIN I_InsurClmDiagnosisCatalog AS _InsurClmDiagnCatalog ON InsurClmCatalogCode = _InsurClmDiagnCatalog.InsurClmCatalogCode AND InsurClmDiagnosisCode = _InsurClmDiagnCatalog.InsurClmDiagnosisCode  -- association [0..1]
;