C_InsurClmSubclaimVH

DDL: C_INSURCLMSUBCLAIMVH SQL: CICLSUBCLSRHHLP Type: view CONSUMPTION

Subclaim Search Help

C_InsurClmSubclaimVH is a Consumption CDS View that provides data about "Subclaim Search Help" in SAP S/4HANA. It reads from 1 data source (I_InsurClmSubclaimUnionVH) and exposes 10 fields with key fields InsuranceClaim, InsurClmSubclm.

Data Sources (1)

SourceAliasJoin Type
I_InsurClmSubclaimUnionVH I_InsurClmSubclaimUnionVH from

Annotations (12)

NameValueLevelField
AbapCatalog.sqlViewName CICLSUBCLSRHHLP view
AbapCatalog.compiler.compareFilter true view
AbapCatalog.preserveKey true view
AccessControl.authorizationCheck #CHECK view
EndUserText.label Subclaim Search Help view
ObjectModel.usageType.serviceQuality #C view
ObjectModel.usageType.sizeCategory #S view
ObjectModel.usageType.dataClass #MIXED view
VDM.viewType #CONSUMPTION view
ObjectModel.dataCategory #VALUE_HELP view
ClientHandling.algorithm #SESSION_VARIABLE view
Search.searchable false view

Fields (10)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim Claim
KEY InsurClmSubclm InsurClmSubclm Subclaim
InsurClmSubclaimDescription InsurClmSubclaimDescription Subclaim Description
InsurClmSubclmTypeName InsurClmSubclmTypeName Subclaim Type Name
InsurClmSubclmType InsurClmSubclmType Subclaim Type
InsurClmSubobjectCategory InsurClmSubobjectCategory Subobject Cat.
InsurClmAuthznGrp InsurClmAuthznGrp AuthGroup (VIP)
InsurClmType InsurClmType Claim Type
InsurClmTypeGeneration InsurClmTypeGeneration Generation
InsurClmTypeVers InsurClmTypeVers Clm Type Versn

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_InsurClmSubclaimVH.
-- 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: CICLSUBCLSRHHLP

CREATE VIEW C_InsurClmSubclaimVH AS
SELECT
  InsuranceClaim,
  InsurClmSubclm,
  InsurClmSubclaimDescription,
  InsurClmSubclmTypeName,
  InsurClmSubclmType,
  InsurClmSubobjectCategory,
  InsurClmAuthznGrp,
  InsurClmType,
  InsurClmTypeGeneration,
  InsurClmTypeVers
FROM I_InsurClmSubclaimUnionVH
;