What is C_InsurClmTotExpndtrQuery in SAP S/4HANA?

C_InsurClmTotExpndtrQuery is a consumption CDS view in SAP S/4HANA. Gesamtaufwand It contains 21 fields.

Which tables does C_InsurClmTotExpndtrQuery read from?

C_InsurClmTotExpndtrQuery reads data from: I_InsurClmTotExpndtrCube.

What VDM layer is C_InsurClmTotExpndtrQuery?

C_InsurClmTotExpndtrQuery is classified as a Consumption view optimized for specific business scenarios and reporting.

C_InsurClmTotExpndtrQuery

DDL: C_INSURCLMTOTEXPNDTRQUERY SQL: CICLTOTEXPNQRY Type: view CONSUMPTION

21 Fields 1 Data Sources

Gesamtaufwand

Total Claim Expenditure

C_InsurClmTotExpndtrQuery (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_InsurClmTotExpndtrQuery is a Consumption CDS View that provides data about "Gesamtaufwand" in SAP S/4HANA. It reads from 1 data source (I_InsurClmTotExpndtrCube) and exposes 21 fields with key fields InsuranceClaim, InsurClmLossExpnType, InsurClmRsrvType, InsurClmReserveCurrency.

SAP Help Documentation

Category	VDM Basic Interface Views for FS-CM (C1-Released)
Data Category	Query

Purpose
This CDS view provides the claim number, losses/expenses, reserve type, organizational unit, claim and subclaim type, authorization group, coverage type, claim status, contract number, line of business, claim handler and calendar year. 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_DisplayCurrency VDM_V_DISPLAY_CURRENCY Display Currency Important Fields Important fields in this view include the following: Field Name Data Element Description InsuranceClaim ICL_CLAIM Claim Number InsurClmLossExpnType ICL_LOSSEXP Losses/Expenses InsurClmRsrvType ICL_RESTYPE Reserve Type InsurClmReserveCurrency ICL_RESCURR Currency of Reserve OrganizationalUnit ICL_ORGUNIT Organizational Unit ParentOrganizationalUnit ICL_HL_ORGUNIT_D_PE Higher-Level Organizational Unit InsurClmType ICL_CLTYPE Claim Type InsurClmSubclmType ICL_SUBCLTYPE Subclaim Type InsurClmAuthznGrp ICL_AUTHCLM Authorization Group for Claims (VIP) InsurClmCoverageType ICL_COVTYPE Coverage Type InsurClmLifeCycSts ICL_CLSTATUS Claim Status InsuranceContract ICL_POLICY Contract Number InsurLineOfBus ICL_LINEOFBUS Insurance Line of Business InsurClmSubclaimPerformerObjID ICLX_CLAIMOWNER_D Claim Handler InsurClmDisplayCurrency Display Currency CalendarYear CALENDARYEAR Calendar Year CalendarMonth CALENDARMONTH Calendar Month Calendar Quarter CALENDARQUARTER Calendar Quarter YearQuarter VDM_YEARQUARTER Year Quarter InsurClmTotExpndtrAmt ICL_TOTAL_EXPENDITURE_RESCURR Total Expenditure in Reserve Currency GrossReserveAmount ICL_TOTAL_EXPENDITURE_DISPCURR Total Expenditure in Display Currency

View on SAP Help Portal →

SAP API Hub

State	C1
Line of Business	Financial Services
Application Component	FS-CM
Package	Financial Services for SAP S/4HANA Cloud Private Edition

Documentation

Analytics with CDS Views — Build Analytics for S/4HANA Cloud Private Edition ABAP CDS views replicated to SAP Cloud Platform
CDS Views on SAP Business Accelerator Hub — Explore SAP S/4HANA Cloud Private Edition Private Edition CDS Views on SAP Business Accelerator Hub
Create CDS View as API — Create CDS views in SAP S/4HANA Cloud Private Edition and consume them as APIs
Custom CDS Views — Access data using a Custom Core Data Service view (Custom CDS view)
Key User Extensibility Tools — The Key User Extensibility Tools of S/4HANA
SAP Extensibility Explorer for SAP S/4HANA Cloud Private Edition — Explore SAP S/4HANA Cloud Private Edition Extensibility options by leveraging the sample scenarios from SAP
SAP S/4HANA Extensibility — SAP S/4HANA Extensibility Tutorial
VDM View Types — The Virtual Data Model in SAP S/4HANA Cloud Private Edition
View Browser — Search, browse and tag CDS Views

Data Sources (1)

Source	Alias	Join Type
I_InsurClmTotExpndtrCube	I_InsurClmTotExpndtrCube	from

Parameters (1)

Name	Type	Default
P_DisplayCurrency	vdm_v_display_currency

Annotations (11)

Name	Value	Level
AbapCatalog.sqlViewName	CICLTOTEXPNQRY	view
AbapCatalog.compiler.compareFilter	true	view
AbapCatalog.preserveKey	true	view
AccessControl.authorizationCheck	#PRIVILEGED_ONLY	view
EndUserText.label	Gesamtaufwand	view
Analytics.query	true	view
ClientHandling.algorithm	#SESSION_VARIABLE	view
VDM.viewType	#CONSUMPTION	view
ObjectModel.usageType.dataClass	#TRANSACTIONAL	view
ObjectModel.usageType.sizeCategory	#L	view
ObjectModel.usageType.serviceQuality	#D	view

Fields (21)

Key	Field	Source Field	Description
KEY	InsuranceClaim	InsuranceClaim	Number of Claim
KEY	InsurClmLossExpnType	InsurClmLossExpnType	Losses or Expenses
KEY	InsurClmRsrvType	InsurClmRsrvType	Reserve Type
KEY	InsurClmReserveCurrency	InsurClmReserveCurrency	Currency of Reserve (Transactn Crcy)
	OrganizationalUnit	OrganizationalUnit	Organizational Unit
	ParentOrganizationalUnit	ParentOrganizationalUnit	Higher-Level Organizational Unit
	InsurClmType	InsurClmType	Internal Claim Type
	InsurClmSubclmType	InsurClmSubclmType	Subclaim Type
	InsurClmAuthznGrp	InsurClmAuthznGrp	Authorization Group for Claims (VIP)
	InsurClmCoverageType	InsurClmCoverageType	Coverage Type
	InsurClmLifeCycSts	InsurClmLifeCycSts	Status of Claim
	InsuranceContract	InsuranceContract	Contract Number
	InsurLineOfBus	InsurLineOfBus	Insurance Line of Business
	InsurClmPerformerObjID	InsurClmPerformerObjID	Claim Handler
	InsurClmDisplayCurrency
	CalendarYear	CalendarYear	Calendar Year
	CalendarMonth	CalendarMonth	Calendar Month
	CalendarQuarter	CalendarQuarter	Calendar Quarter
	YearQuarter	YearQuarter	Year Quarter
	InsurClmTotExpndtrAmt	InsurClmTotExpndtrAmt	Total Expenditure in Reserve Currency
	GrossReserveAmount	GrossReserveAmount	Total Expenditure in Display Currency

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_InsurClmTotExpndtrQuery.
-- 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: CICLTOTEXPNQRY
-- Parameters: P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW C_InsurClmTotExpndtrQuery AS
SELECT
  InsuranceClaim,
  InsurClmLossExpnType,
  InsurClmRsrvType,
  InsurClmReserveCurrency,
  OrganizationalUnit,
  ParentOrganizationalUnit,
  InsurClmType,
  InsurClmSubclmType,
  InsurClmAuthznGrp,
  InsurClmCoverageType,
  InsurClmLifeCycSts,
  InsuranceContract,
  InsurLineOfBus,
  InsurClmPerformerObjID,
  $parameters.P_DisplayCurrency AS InsurClmDisplayCurrency,
  CalendarYear,
  CalendarMonth,
  CalendarQuarter,
  YearQuarter,
  InsurClmTotExpndtrAmt,
  GrossReserveAmount
FROM I_InsurClmTotExpndtrCube
;

Depth:

C_InsurClmTotExpndtrQuery view

I_InsurClmTotExpndtrCube view