C_InsurClmSubclaimCountQ

DDL: C_INSURCLMSUBCLAIMCOUNTQ Type: view CONSUMPTION
15 Fields 1 Data Sources

Anzahl von Teilfällen

Number of Subclaims

C_InsurClmSubclaimCountQ (Consumption)

Package: Explore, extend and adapt the SAP S/4HANA Cloud Private Edition with built-in and side-by-side extension capabilities.

Financial Services

C_InsurClmSubclaimCountQ is a Consumption CDS View that provides data about "Anzahl von Teilfällen" in SAP S/4HANA. It reads from 1 data source (I_InsurClmSubclaimCountC) and exposes 15 fields.

SAP Help Documentation

CategoryVDM Basic Interface Views for FS-CM (C1-Released)
Data CategoryQuery
Purpose
This CDS view provides the claim number, authorization group, claim and subclaim type, line of business, claim status, coverage type, claim handler, and organizational unit. To help you decide which CDS view to use for your purposes, SAP has introduced the annotation ObjectModel.supportedCapabilities that indicates the most appropriate use cases for each CDS view. To find out what use cases are best supported by this CDS view, access the entry of the CDS view in the View Browser app and find the values for this annotation under the Annotation tab. For more information, see Supported Capabilities for CDS Views .

Prerequisites
Authorizations Users who want to use this CDS view can use it only via privilegded mode.

Structure
Parameters Parameter Name Data Element Label P_IntervalEndDate ICL_DATE_TO Period To P_IntervalStartDate ICL_DATE_FROM Period From Important Fields Important fields in this view include the following: Field Name Data Element Description InsuranceClaim ICL_CLAIM Claim Number InsurClmAuthznGrp ICL_AUTHCLM Authorization Group for Claims (VIP) InsurClmType ICL_CLTYPE Claim Type InsurLineOfBus ICL_LINEOFBUS Insurance Line of Business InsurClmLifeCycSts ICL_CLSTATUS Claim Status InsurClmCoverageType ICL_COVTYPE Coverage Type InsurClmSubclmType ICL_SUBCLTYPE Subclaim Type InsurClmSubclaimPerformerObjID ICLX_CLAIMOWNER_D Claim Handler OrganizationalUnit ICL_ORGUNIT Organizational Unit ParentOrganizationalUnit ICL_HL_ORGUNIT_D_PE Higher-Level Organizational Unit NmbrOfOpenInsurClmSubclms ICL_BEG_PENDING_SUBCLAIMS Number of Open Subclaims at Start of Period NmbrOfPndgInsurClmSubclms ICL_NEW_PENDING_SUBCLAIMS Number of Open Subclaims at End of Period NmbrOfReopenedInsurClmSubclms ICL_SUBCLAIMS_REOPENED Number of Reopened Subclaims NmbrOfClsdInsurClmSubclms ICL_SUBCLAIMS_CLOSED Number of Closed Subclaims NmbrOfNewOpenInsurClmSubclms ICL_SUBCLAIMS_OPENED Number of Opened Subclaims

View on SAP Help Portal →

SAP API Hub

StateC1
Line of BusinessFinancial Services
Application ComponentFS-CM
PackageFinancial Services for SAP S/4HANA Cloud Private Edition

Documentation

Data Sources (1)

SourceAliasJoin Type
I_InsurClmSubclaimCountC I_InsurClmSubclaimCountC from

Parameters (2)

NameTypeDefault
P_IntervalStartDate icl_date_from
P_IntervalEndDate icl_date_to

Annotations (10)

NameValueLevelField
EndUserText.label Anzahl von Teilfällen view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
Analytics.query true view
ClientHandling.algorithm #SESSION_VARIABLE view
AbapCatalog.sqlViewName CICLSUBCLCNTQRY view
AbapCatalog.compiler.compareFilter true view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.sizeCategory #XL view
ObjectModel.usageType.serviceQuality #D view
VDM.viewType #CONSUMPTION view

Fields (15)

KeyFieldSource TableSource FieldDescription
InsuranceClaim InsuranceClaim Number of Claim
InsurClmAuthznGrp InsurClmAuthznGrp Authorization Group for Claims (VIP)
InsurClmType InsurClmType Internal Claim Type
InsurLineOfBus InsurLineOfBus Insurance Line of Business
InsurClmLifeCycSts InsurClmLifeCycSts Status of Claim
InsurClmCoverageType InsurClmCoverageType Coverage Type
InsurClmSubclmType InsurClmSubclmType Subclaim Type
InsurClmSubclaimPerformerObjID InsurClmSubclaimPerformerObjID Claim Handler
OrganizationalUnit OrganizationalUnit Organizational Unit
ParentOrganizationalUnit ParentOrganizationalUnit Higher-Level Organizational Unit
NmbrOfOpenInsurClmSubclms NmbrOfOpenInsurClmSubclms Number of Open Subclaims at Start of Period
NmbrOfPndgInsurClmSubclms NmbrOfPndgInsurClmSubclms Number of Open Subclaims at End of Period
NmbrOfReopenedInsurClmSubclms NmbrOfReopenedInsurClmSubclms Number of Reopened Subclaims
NmbrOfClsdInsurClmSubclms NmbrOfClsdInsurClmSubclms Number of Closed Subclaims
NmbrOfNewOpenInsurClmSubclms NmbrOfNewOpenInsurClmSubclms Number of Opened Subclaims

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_InsurClmSubclaimCountQ.
-- 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.
-- Parameters: P_IntervalStartDate : icl_date_from, P_IntervalEndDate : icl_date_to

CREATE VIEW C_InsurClmSubclaimCountQ AS
SELECT
  InsuranceClaim,
  InsurClmAuthznGrp,
  InsurClmType,
  InsurLineOfBus,
  InsurClmLifeCycSts,
  InsurClmCoverageType,
  InsurClmSubclmType,
  InsurClmSubclaimPerformerObjID,
  OrganizationalUnit,
  ParentOrganizationalUnit,
  NmbrOfOpenInsurClmSubclms,
  NmbrOfPndgInsurClmSubclms,
  NmbrOfReopenedInsurClmSubclms,
  NmbrOfClsdInsurClmSubclms,
  NmbrOfNewOpenInsurClmSubclms
FROM I_InsurClmSubclaimCountC
;

Learn More