I_InsurClmTotExpndtrCube

Cube-Level View for Total Expenditure | view: IICLTOTEXPNDCUBE | TRAN | Extraction: Not supported | Component: Claims Management
Tables used: SCAL_TT_DATE, ICLCLAIM, ICLPOLM, ICLCLAIMASSIGN, ICLPAY, ICLPAYI, ICLPOL, ICLRESERVE, ICLSUBCL, ICLCLAIM, ICLCLAIMASSIGN, ICL_RBP, ICL_SUBROG, ICLPOL, TICL321, TICL055, HRP1001, TICL020, TICL020T, ICL_CSUBROGREAS
Column Name Description
InsuranceClaim FK Number of Claim
InsurClmLossExpnType Losses or Expenses Show values
InsurClmRsrvType FK Reserve Type
InsurClmReserveCurrency FK Currency of Reserve (Transactn Crcy)
InsurClmSubclm FK Subclaim
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
InsurClmChangeDate null
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
InsurClmAssignUUID UUID of Entry to be Linked SYSUUID_C
InsurClmSubclaimAssignUUID UUID of Entry to be Linked SYSUUID_C
InsurClmSubclaimPerformerObjID Object ID of Performer HROBJID_12
InsurClmPerformerObjID Claim Handler ICL_CLAIMOWNER
InsurClmRsrvChangeTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
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
  • I_INSURCLMTOTEXPNDTRCUBE.INSURCLMAUTHZNGRP == TICL113.AUTHCLM
  • I_INSURCLMTOTEXPNDTRCUBE.MANDT == TICL113.CLIENT
Coverage Type
  • Coverage Type
  • Client
  • I_INSURCLMTOTEXPNDTRCUBE.INSURCLMCOVERAGETYPE == TICL322.COVTYPE
  • I_INSURCLMTOTEXPNDTRCUBE.MANDT == TICL322.CLIENT
Status of Claim
  • Status of Claim
  • Client
  • I_INSURCLMTOTEXPNDTRCUBE.INSURCLMLIFECYCSTS == TICL140.STATUS
  • I_INSURCLMTOTEXPNDTRCUBE.MANDT == TICL140.CLIENT
Policy Product
  • ?
  • Client
  • Policy Product
  • I_INSURCLMTOTEXPNDTRCUBE.[column in domain "ICL_GENERAT"] == TICL320.VERSION
  • I_INSURCLMTOTEXPNDTRCUBE.MANDT == TICL320.CLIENT
  • I_INSURCLMTOTEXPNDTRCUBE.INSURCLMPOLICYPRODUCT == TICL320.POLPROD
Currency of Reserve (Transactn Crcy)
  • Currency of Reserve (Transactn Crcy)
  • Client
  • I_INSURCLMTOTEXPNDTRCUBE.INSURCLMRESERVECURRENCY == TCURC.WAERS
  • I_INSURCLMTOTEXPNDTRCUBE.MANDT == TCURC.MANDT
Reserve Type
  • Reserve Type
  • Client
  • I_INSURCLMTOTEXPNDTRCUBE.INSURCLMRSRVTYPE == TICL020.RESTYPE
  • I_INSURCLMTOTEXPNDTRCUBE.MANDT == TICL020.CLIENT
Subclaim Type
  • Client
  • Subclaim Type
  • I_INSURCLMTOTEXPNDTRCUBE.MANDT == TICL004.CLIENT
  • I_INSURCLMTOTEXPNDTRCUBE.INSURCLMSUBCLMTYPE == TICL004.SUBCLTYPE
Internal Claim Type
  • ?
  • Internal Claim Type
  • Client
  • I_INSURCLMTOTEXPNDTRCUBE.[column in domain "ICL_CLTYPEG"] == TICL011.VERSION
  • I_INSURCLMTOTEXPNDTRCUBE.INSURCLMTYPE == TICL011.CLTYPE
  • I_INSURCLMTOTEXPNDTRCUBE.MANDT == TICL011.CLIENT
Generation of Internal Claim Type
  • Internal Claim Type
  • Generation of Internal Claim Type
  • Client
  • I_INSURCLMTOTEXPNDTRCUBE.INSURCLMTYPE == TICL011.CLTYPE
  • I_INSURCLMTOTEXPNDTRCUBE.INSURCLMTYPEGENERATION == TICL011.VERSION
  • I_INSURCLMTOTEXPNDTRCUBE.MANDT == TICL011.CLIENT
Organizational Unit
  • ?
  • Plan Version
  • Client
  • Organizational Unit
  • I_INSURCLMTOTEXPNDTRCUBE.[column in domain "OTYPE"] == PLOGI.OTYPE
  • I_INSURCLMTOTEXPNDTRCUBE.PLANVERSION == PLOGI.PLVAR
  • I_INSURCLMTOTEXPNDTRCUBE.MANDT == PLOGI.MANDT
  • I_INSURCLMTOTEXPNDTRCUBE.ORGANIZATIONALUNIT == PLOGI.OBJID
Plan Version
  • Plan Version
  • Client
  • I_INSURCLMTOTEXPNDTRCUBE.PLANVERSION == T778P.PLVAR
  • I_INSURCLMTOTEXPNDTRCUBE.MANDT == T778P.MANDT