C_InsurClmDiagnosis

DDL: C_INSURCLMDIAGNOSIS SQL: CICLDIAGNOSIS Type: view CONSUMPTION
9 Fields 1 Data Sources 2 Associations

Diagnosensicht für verletzte Person

C_InsurClmDiagnosis is a Consumption CDS View that provides data about "Diagnosensicht für verletzte Person" in SAP S/4HANA. It reads from 1 data source (I_InsurClmDiagnosis) and exposes 9 fields with key fields InsuranceClaim, InsurClmDmgdSubObject, InsurClmSubobjectCategory, InsurClmInjuredPersonNumber, InsurClmDiagnosisNmbr. It has 2 associations to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmDiagnosis I_InsurClmDiagnosis from

Associations (2)

CardinalityTargetAliasCondition
[1..1] I_InsurClmDiagnosisText _diag $projection.InsurClmCatalogCode = _diag.InsurClmCatalogCode and $projection.InsurClmDiagnosisCode = _diag.InsurClmDiagnosisCode
[1..1] I_InsuranceClaim _Claim $projection.InsuranceClaim = _Claim.InsuranceClaim

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName CICLDIAGNOSIS view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Diagnosensicht für verletzte Person view
Metadata.allowExtensions true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #L view
ObjectModel.usageType.serviceQuality #D view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view

Fields (9)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim Claim Number
KEY InsurClmDmgdSubObject InsurClmDmgdSubObject Subobject
KEY InsurClmSubobjectCategory InsurClmSubobjectCategory Subobject Cat.
KEY InsurClmInjuredPersonNumber InsurClmInjuredPersonNumber Injured person
KEY InsurClmDiagnosisNmbr InsurClmDiagnosisNmbr Diagnosis No.
KEY InsurClmCatalogCode InsurClmCatalogCode Katalog-ID
KEY InsurClmDiagnosisCode InsurClmDiagnosisCode Diagnose-ID
InsurClmDiagnosisName Diagnosebezeichnung
_Claim _Claim

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_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: CICLDIAGNOSIS

CREATE VIEW C_InsurClmDiagnosis AS
SELECT
  InsuranceClaim,
  InsurClmDmgdSubObject,
  InsurClmSubobjectCategory,
  InsurClmInjuredPersonNumber,
  InsurClmDiagnosisNmbr,
  InsurClmCatalogCode,
  InsurClmDiagnosisCode,
  _diag[Language = $session.system_language].InsurClmDiagnosisName AS InsurClmDiagnosisName
FROM I_InsurClmDiagnosis
LEFT OUTER JOIN I_InsurClmDiagnosisText AS _diag ON InsurClmCatalogCode = _diag.InsurClmCatalogCode AND InsurClmDiagnosisCode = _diag.InsurClmDiagnosisCode  -- association [1..1]
LEFT OUTER JOIN I_InsuranceClaim AS _Claim ON InsuranceClaim = _Claim.InsuranceClaim  -- association [1..1]
;

Learn More