C_InsurClmTotExpndtrQuery

Total Claim Expenditure | view: CICLTOTEXPNQRY | TRAN | Extraction: Not supported | Component: Claims Management
Column Name Description
InsuranceClaim Number of Claim
InsurClmLossExpnType Losses or Expenses Show values
InsurClmRsrvType Reserve Type
InsurClmReserveCurrency Currency of Reserve (Transactn Crcy)
Column Name Description
💲 Currency of Reserve (Transactn Crcy) (InsurClmReserveCurrency):
InsurClmTotExpndtrAmt Total Expenditure in Reserve Currency
💲 null (InsurClmDisplayCurrency):
GrossReserveAmount Total Expenditure in Display Currency
Column Name Description
Column Name Description
Column Name Description
InsurClmLossExpnType Losses or Expenses Show values
Column Name Description Domain name
ParentOrganizationalUnit Higher-Level Organizational Unit HROBJID
InsuranceContract Contract Number ICL_POLICY
InsurLineOfBus Insurance Line of Business ICL_LINEOFBUS
InsurClmPerformerObjID Claim Handler ICL_CLAIMOWNER
CalendarYear Calendar Year NUM4
CalendarMonth Calendar Month NUM2
CalendarQuarter Calendar Quarter NUM1
YearQuarter Year Quarter NUM5
Master Data Relations Join Conditions
Authorization Group for Claims (VIP)
  • Authorization Group for Claims (VIP)
  • Client
  • C_INSURCLMTOTEXPNDTRQUERY.INSURCLMAUTHZNGRP == TICL113.AUTHCLM
  • C_INSURCLMTOTEXPNDTRQUERY.MANDT == TICL113.CLIENT
Coverage Type
  • Coverage Type
  • Client
  • C_INSURCLMTOTEXPNDTRQUERY.INSURCLMCOVERAGETYPE == TICL322.COVTYPE
  • C_INSURCLMTOTEXPNDTRQUERY.MANDT == TICL322.CLIENT
Status of Claim
  • Client
  • Status of Claim
  • C_INSURCLMTOTEXPNDTRQUERY.MANDT == TICL140.CLIENT
  • C_INSURCLMTOTEXPNDTRQUERY.INSURCLMLIFECYCSTS == TICL140.STATUS
Subclaim Type
  • Subclaim Type
  • Client
  • C_INSURCLMTOTEXPNDTRQUERY.INSURCLMSUBCLMTYPE == TICL004.SUBCLTYPE
  • C_INSURCLMTOTEXPNDTRQUERY.MANDT == TICL004.CLIENT
Internal Claim Type
  • ?
  • Internal Claim Type
  • Client
  • C_INSURCLMTOTEXPNDTRQUERY.[column in domain "ICL_CLTYPEG"] == TICL011.VERSION
  • C_INSURCLMTOTEXPNDTRQUERY.INSURCLMTYPE == TICL011.CLTYPE
  • C_INSURCLMTOTEXPNDTRQUERY.MANDT == TICL011.CLIENT
Organizational Unit
  • Organizational Unit
  • Client
  • ?
  • ?
  • C_INSURCLMTOTEXPNDTRQUERY.ORGANIZATIONALUNIT == PLOGI.OBJID
  • C_INSURCLMTOTEXPNDTRQUERY.MANDT == PLOGI.MANDT
  • C_INSURCLMTOTEXPNDTRQUERY.[column in domain "OTYPE"] == PLOGI.OTYPE
  • C_INSURCLMTOTEXPNDTRQUERY.[column in domain "PLVAR"] == PLOGI.PLVAR