I_InsurClmTotExpndtrWithOrg

Main Data Collection with Org. for Total Expenditure Query | view: IICLTOTEXPNWORG | 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
GrossReserveAmount Total Reserve
InsurClmTotExpndtrAmt Total Reserve
Column Name Description
Column Name Description
InsurClmChangeDate null
Column Name Description
InsurClmLossExpnType Losses or Expenses Show values
Column Name Description Domain name
InsurClmAssignUUID UUID of Entry to be Linked SYSUUID_C
InsurClmSubclaimPerformerObjID Object ID of Performer HROBJID_12
InsurClmPerformerObjID Object ID of Performer HROBJID_12
ParentOrganizationalUnit Higher-Level Organizational Unit HROBJID
InsurLineOfBus Insurance Line of Business ICL_LINEOFBUS
InsuranceContract Contract Number ICL_POLICY
InsurClmSubclaimAssignUUID UUID of Entry to be Linked SYSUUID_C
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)
  • Client
  • Authorization Group for Claims (VIP)
  • I_INSURCLMTOTEXPNDTRWITHORG.MANDT == TICL113.CLIENT
  • I_INSURCLMTOTEXPNDTRWITHORG.INSURCLMAUTHZNGRP == TICL113.AUTHCLM
Coverage Type
  • Client
  • Coverage Type
  • I_INSURCLMTOTEXPNDTRWITHORG.MANDT == TICL322.CLIENT
  • I_INSURCLMTOTEXPNDTRWITHORG.INSURCLMCOVERAGETYPE == TICL322.COVTYPE
Status of Claim
  • Client
  • Status of Claim
  • I_INSURCLMTOTEXPNDTRWITHORG.MANDT == TICL140.CLIENT
  • I_INSURCLMTOTEXPNDTRWITHORG.INSURCLMLIFECYCSTS == TICL140.STATUS
Policy Product
  • Client
  • Policy Product
  • ?
  • I_INSURCLMTOTEXPNDTRWITHORG.MANDT == TICL320.CLIENT
  • I_INSURCLMTOTEXPNDTRWITHORG.INSURCLMPOLICYPRODUCT == TICL320.POLPROD
  • I_INSURCLMTOTEXPNDTRWITHORG.[column in domain "ICL_GENERAT"] == TICL320.VERSION
Currency of Reserve (Transactn Crcy)
  • Client
  • Currency of Reserve (Transactn Crcy)
  • I_INSURCLMTOTEXPNDTRWITHORG.MANDT == TCURC.MANDT
  • I_INSURCLMTOTEXPNDTRWITHORG.INSURCLMRESERVECURRENCY == TCURC.WAERS
Reserve Type
  • Client
  • Reserve Type
  • I_INSURCLMTOTEXPNDTRWITHORG.MANDT == TICL020.CLIENT
  • I_INSURCLMTOTEXPNDTRWITHORG.INSURCLMRSRVTYPE == TICL020.RESTYPE
Subclaim Type
  • Client
  • Subclaim Type
  • I_INSURCLMTOTEXPNDTRWITHORG.MANDT == TICL004.CLIENT
  • I_INSURCLMTOTEXPNDTRWITHORG.INSURCLMSUBCLMTYPE == TICL004.SUBCLTYPE
Internal Claim Type
  • Internal Claim Type
  • Client
  • ?
  • I_INSURCLMTOTEXPNDTRWITHORG.INSURCLMTYPE == TICL011.CLTYPE
  • I_INSURCLMTOTEXPNDTRWITHORG.MANDT == TICL011.CLIENT
  • I_INSURCLMTOTEXPNDTRWITHORG.[column in domain "ICL_CLTYPEG"] == TICL011.VERSION
Generation of Internal Claim Type
  • Internal Claim Type
  • Client
  • Generation of Internal Claim Type
  • I_INSURCLMTOTEXPNDTRWITHORG.INSURCLMTYPE == TICL011.CLTYPE
  • I_INSURCLMTOTEXPNDTRWITHORG.MANDT == TICL011.CLIENT
  • I_INSURCLMTOTEXPNDTRWITHORG.INSURCLMTYPEGENERATION == TICL011.VERSION
Organizational Unit
  • ?
  • Plan Version
  • Client
  • Organizational Unit
  • I_INSURCLMTOTEXPNDTRWITHORG.[column in domain "OTYPE"] == PLOGI.OTYPE
  • I_INSURCLMTOTEXPNDTRWITHORG.PLANVERSION == PLOGI.PLVAR
  • I_INSURCLMTOTEXPNDTRWITHORG.MANDT == PLOGI.MANDT
  • I_INSURCLMTOTEXPNDTRWITHORG.ORGANIZATIONALUNIT == PLOGI.OBJID
Plan Version
  • Plan Version
  • Client
  • I_INSURCLMTOTEXPNDTRWITHORG.PLANVERSION == T778P.PLVAR
  • I_INSURCLMTOTEXPNDTRWITHORG.MANDT == T778P.MANDT