I_InsurClmDiagnosisLink

DDL: I_INSURCLMDIAGNOSISLINK SQL: IICLDIAGLINK Type: view COMPOSITE
8 Fields 1 Data Sources 1 Associations

Link Diagn Subobj and Subobject Category

I_InsurClmDiagnosisLink is a Composite CDS View that provides data about "Link Diagn Subobj and Subobject Category" in SAP S/4HANA. It reads from 1 data source (I_InsurClmDiagnosis) and exposes 8 fields with key fields InsuranceClaim, char3asInsurClmDmgdSubObject, char2asInsurClmSubobjectCategory, InsurClmInjuredPersonNumber, InsurClmDiagnosisNmbr. It has 1 association to related views.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmDiagnosis I_InsurClmDiagnosis from

Associations (1)

CardinalityTargetAliasCondition
[1..*] I_InsurClmDamageAssignment _Subclaim $projection.InsuranceClaim = _Subclaim.InsuranceClaim and $projection.InsurClmInjuredPersonNumber = _Subclaim.InsurClmDamagedObject

Annotations (11)

NameValueLevelField
AbapCatalog.sqlViewName IICLDIAGLINK view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #NOT_REQUIRED view
VDM.viewType #COMPOSITE view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.serviceQuality #D view
AccessControl.personalData.blocking #REQUIRED view
ClientHandling.algorithm #SESSION_VARIABLE view
EndUserText.label Link Diagn Subobj and Subobject Category view

Fields (8)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim Claim Number
KEY char3asInsurClmDmgdSubObject
KEY char2asInsurClmSubobjectCategory
KEY InsurClmInjuredPersonNumber InsurClmInjuredPersonNumber Injured person
KEY InsurClmDiagnosisNmbr InsurClmDiagnosisNmbr Diagnosis No.
InsurClmCatalogCode InsurClmCatalogCode Catalog
InsurClmDiagnosisCode InsurClmDiagnosisCode Primary Diagn.
InsurClmDiagnosisGroupCode InsurClmDiagnosisGroupCode

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_InsurClmDiagnosisLink.
-- 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: IICLDIAGLINK

CREATE VIEW I_InsurClmDiagnosisLink AS
SELECT
  InsuranceClaim,
  cast( case when _Subclaim.InsurClmDmgdSubObject is null then '000' else _Subclaim.InsurClmDmgdSubObject end as abap.char(3) ) as InsurClmDmgdSubObject AS char3asInsurClmDmgdSubObject,
  cast( case when _Subclaim.InsurClmSubobjectCategory is null then 'C' else _Subclaim.InsurClmSubobjectCategory end as abap.char(2) ) as InsurClmSubobjectCategory AS char2asInsurClmSubobjectCategory,
  InsurClmInjuredPersonNumber,
  InsurClmDiagnosisNmbr,
  InsurClmCatalogCode,
  InsurClmDiagnosisCode,
  InsurClmDiagnosisGroupCode
FROM I_InsurClmDiagnosis
LEFT OUTER JOIN I_InsurClmDamageAssignment AS _Subclaim ON InsuranceClaim = _Subclaim.InsuranceClaim AND InsurClmInjuredPersonNumber = _Subclaim.InsurClmDamagedObject  -- association [1..*]
;

Learn More