C_InsurClmExpenseReservesInqry

Consumption View for Expense Reserves | view: CICLEXPNRESERVE | TRAN | Extraction: Not supported | Component: Claims Management
Tables used: ICLCLAIM, ICLPOLM, ICLPAY, ICLPAYI, ICLPOL, ICLPARTOCC, ICLRESERVE, ICLSUBCL, ADCP, ADRC, ADR6, ADR2, BUT020, BUT021_FS, BUT000, T005, T005T, TICL321, TICL055, ICL_CPROFILE_BT, ICLPOLBF, TICL160, TICL161, TICL020, TICL020T, TICL030, TICL030T, TICL004T, TICL003, BUT021_FS, TB008S, TB008U, TICL162, TICL100, TICL053, TICL005, TICL323
Column Name Description
InsuranceClaim FK Number of Claim
InsurClmSubclm FK Subclaim
InsurClmRsrvType FK Reserve Type
InsurClmReserveCurrency FK Currency of Reserve (Transactn Crcy)
InsurClmReserveUUID 16 Byte UUID in 16 Bytes (Raw Format)
Column Name Description
💲 Currency of Reserve (Transactn Crcy) (InsurClmReserveCurrency):
GrossReserveAmount Expenditure per Reserve Type
InsurClmNetReserveAmount Expenditure per Reserve Type
InsurClmOutsdngRsrvAmt Expenditure per Reserve Type
InsurClmReservePaytAmt null
InsurClmRsrvPendingAmount Pending Reserve
Column Name Description
Column Name Description
InsurClmChangeDate null
PostingDate Posting Date
Column Name Description
InsurClmLossExpnType Losses or Expenses Show values
InsurClmExpectationReserve Expectation Reserve Show values
InsurClmRsrvMethodName Reserving Method Show values
Column Name Description Domain name
InsurClmRsrvChangeTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
InsurClmRsrvPaidToDatePct null
InsurClmRsrvMethodText Short Text for Fixed Values
InsurClmReserveChangeRsnName Name of Claim Reserve Change Reason TEXT25
InsurClmImageURL null
InsurClmRsrvTypeDesc null
InsurClmSubclmDescriptionText null
Master Data Relations Join Conditions
Reserve Change Reason
  • Client
  • Reserve Change Reason
  • C_INSURCLMEXPENSERESERVESINQRY.MANDT == TICL030.CLIENT
  • C_INSURCLMEXPENSERESERVESINQRY.INSURCLMRESERVECHANGERSN == TICL030.RESCHREASON
Currency of Reserve (Transactn Crcy)
  • Client
  • Currency of Reserve (Transactn Crcy)
  • Currency of Reserve (Transactn Crcy)
  • C_INSURCLMEXPENSERESERVESINQRY.MANDT == TCURC.MANDT
  • C_INSURCLMEXPENSERESERVESINQRY.INSURCLMRESERVECURRENCYFOREDIT == TCURC.WAERS
  • C_INSURCLMEXPENSERESERVESINQRY.INSURCLMRESERVECURRENCY == TCURC.WAERS
Currency of Reserve (Transactn Crcy)
  • Client
  • Currency of Reserve (Transactn Crcy)
  • Currency of Reserve (Transactn Crcy)
  • C_INSURCLMEXPENSERESERVESINQRY.MANDT == TCURC.MANDT
  • C_INSURCLMEXPENSERESERVESINQRY.INSURCLMRESERVECURRENCYFOREDIT == TCURC.WAERS
  • C_INSURCLMEXPENSERESERVESINQRY.INSURCLMRESERVECURRENCY == TCURC.WAERS
Reserve Type
  • Client
  • Reserve Type
  • Reserve Type
  • C_INSURCLMEXPENSERESERVESINQRY.MANDT == TICL020.CLIENT
  • C_INSURCLMEXPENSERESERVESINQRY.INSURCLMRSRVTYPE == TICL020.RESTYPE
  • C_INSURCLMEXPENSERESERVESINQRY.INSURCLMRESERVETYPEFOREDIT == TICL020.RESTYPE
Reserve Type
  • Client
  • Reserve Type
  • Reserve Type
  • C_INSURCLMEXPENSERESERVESINQRY.MANDT == TICL020.CLIENT
  • C_INSURCLMEXPENSERESERVESINQRY.INSURCLMRSRVTYPE == TICL020.RESTYPE
  • C_INSURCLMEXPENSERESERVESINQRY.INSURCLMRESERVETYPEFOREDIT == TICL020.RESTYPE
Subclaim Type
  • Client
  • Subclaim Type
  • C_INSURCLMEXPENSERESERVESINQRY.MANDT == TICL004.CLIENT
  • C_INSURCLMEXPENSERESERVESINQRY.INSURCLMSUBCLMTYPE == TICL004.SUBCLTYPE
Internal Claim Type
  • Client
  • Internal Claim Type
  • ?
  • C_INSURCLMEXPENSERESERVESINQRY.MANDT == TICL011.CLIENT
  • C_INSURCLMEXPENSERESERVESINQRY.INSURCLMTYPE == TICL011.CLTYPE
  • C_INSURCLMEXPENSERESERVESINQRY.[column in domain "ICL_CLTYPEG"] == TICL011.VERSION
Generation of Internal Claim Type
  • Client
  • Internal Claim Type
  • Generation of Internal Claim Type
  • C_INSURCLMEXPENSERESERVESINQRY.MANDT == TICL011.CLIENT
  • C_INSURCLMEXPENSERESERVESINQRY.INSURCLMTYPE == TICL011.CLTYPE
  • C_INSURCLMEXPENSERESERVESINQRY.INSURCLMTYPEGENERATION == TICL011.VERSION
Internal Claim Type Version
  • Client
  • Internal Claim Type Version
  • Internal Claim Type
  • Generation of Internal Claim Type
  • C_INSURCLMEXPENSERESERVESINQRY.MANDT == TICL003.CLIENT
  • C_INSURCLMEXPENSERESERVESINQRY.INSURCLMTYPEVERS == TICL003.VERSION
  • C_INSURCLMEXPENSERESERVESINQRY.INSURCLMTYPE == TICL003.CLTYPE
  • C_INSURCLMEXPENSERESERVESINQRY.INSURCLMTYPEGENERATION == TICL003.GENERAT