C_InsurClmPaymentQuery

DDL: C_INSURCLMPAYMENTQUERY SQL: CICLPAYMENTQUERY Type: view CONSUMPTION
20 Fields 1 Data Sources

Fallzahlungen

Claim Payments

C_InsurClmPaymentQuery (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_InsurClmPaymentQuery is a Consumption CDS View that provides data about "Fallzahlungen" in SAP S/4HANA. It reads from 1 data source (I_InsurClmPaymentCube) and exposes 20 fields with key field InsuranceClaim.

SAP Help Documentation

CategoryVDM Basic Interface Views for FS-CM (C1-Released)
Data CategoryQuery
Purpose
This CDS view provides the claim number, benefit type, payment amount, display and claim payment currency, coverage type, record type of payment, posting date, calendar year, losses/expenses, line of business, claim and subclaim type, authorization group, contract number, claim status, 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_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 InsurBnftType ICL_BENTYPE Benefit Type InsurClmPaytAmt ICL_SCLITEMAP Payment Amount DisplayCurrency VDM_V_DISPLAY_CURRENCY Display Currency InsurClmPaymentCurrency ICL_PAYMENTCUR Claim Payment Currency InsurClmCoverageType ICL_COVTYPE Coverage Type InsurClmPaytCat ICL_PAYCAT Record Type of Payment InsurClmPaytPostgDte ICL_POSTDATE Posting Date InsurClmPaytPostgYear CALENDARYEAR Calendar Year InsurClmPaytPostgQtr VDM_YEARQUARTER Year Quarter InsurClmPaytPostgMnth VDM_YEARMONTH Year Month InsurClmLossExpnType ICL_LOSSEXP Losses/Expenses InsurLineOfBus ICL_LINEOFBUS Insurance Line of Business InsurClmType ICL_CLTYPE Claim Type InsurClmAuthznGrp ICL_AUTHCLM Authorization Group for Claims (VIP) InsurClmLifeCycSts ICL_CLSTATUS Claim Status InsurClmSubclmType ICL_SUBCLTYPE Subclaim Type InsuranceContract ICL_POLICY Contract Type OrganizationalUnit ICL_ORGUNIT Organizational Unit ParentOrganizationalUnit ICL_HL_ORGUNIT_D_PE Higher-Level Organizational Unit

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_InsurClmPaymentCube I_InsurClmPaymentCube from

Parameters (1)

NameTypeDefault
P_DisplayCurrency vdm_v_display_currency

Annotations (10)

NameValueLevelField
AbapCatalog.sqlViewName CICLPAYMENTQUERY view
EndUserText.label Fallzahlungen view
Analytics.query true view
AccessControl.authorizationCheck #PRIVILEGED_ONLY view
AbapCatalog.compiler.compareFilter true view
ClientHandling.algorithm #SESSION_VARIABLE view
VDM.viewType #CONSUMPTION view
ObjectModel.usageType.dataClass #MIXED view
ObjectModel.usageType.serviceQuality #D view
ObjectModel.usageType.sizeCategory #XL view

Fields (20)

KeyFieldSource TableSource FieldDescription
KEY InsuranceClaim InsuranceClaim Number of Claim
InsurBnftType InsurBnftType Benefit Type
InsurClmPaytAmt InsurClmPaytAmt Payment Amount
DisplayCurrency DisplayCurrency Display Currency
InsurClmPaymentCurrency InsurClmPaymentCurrency Claim Payment Currency
InsurClmCoverageType InsurClmCoverageType Coverage Type
InsurClmPaytCat InsurClmPaytCat Record Type of Payment
InsurClmPaytPostgDte InsurClmPaytPostgDte Posting Date
InsurClmPaytPostgYear InsurClmPaytPostgYear Calendar Year
InsurClmPaytPostgQtr InsurClmPaytPostgQtr Year Quarter
InsurClmPaytPostgMnth InsurClmPaytPostgMnth Year Month
InsurClmLossExpnType InsurClmLossExpnType Losses or Expenses
InsurLineOfBus InsurLineOfBus Insurance Line of Business
InsurClmType InsurClmType Internal Claim Type
InsurClmAuthznGrp InsurClmAuthznGrp Authorization Group for Claims (VIP)
InsurClmLifeCycSts InsurClmLifeCycSts Status of Claim
InsurClmSubclmType InsurClmSubclmType Subclaim Type
InsuranceContract InsuranceContract Contract Number
OrganizationalUnit OrganizationalUnit Organizational Unit
ParentOrganizationalUnit ParentOrganizationalUnit Higher-Level Organizational Unit

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_InsurClmPaymentQuery.
-- 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: CICLPAYMENTQUERY
-- Parameters: P_DisplayCurrency : vdm_v_display_currency

CREATE VIEW C_InsurClmPaymentQuery AS
SELECT
  InsuranceClaim,
  InsurBnftType,
  InsurClmPaytAmt,
  DisplayCurrency,
  InsurClmPaymentCurrency,
  InsurClmCoverageType,
  InsurClmPaytCat,
  InsurClmPaytPostgDte,
  InsurClmPaytPostgYear,
  InsurClmPaytPostgQtr,
  InsurClmPaytPostgMnth,
  InsurClmLossExpnType,
  InsurLineOfBus,
  InsurClmType,
  InsurClmAuthznGrp,
  InsurClmLifeCycSts,
  InsurClmSubclmType,
  InsuranceContract,
  OrganizationalUnit,
  ParentOrganizationalUnit
FROM I_InsurClmPaymentCube
;

Learn More