I_InsurClmTotExpndtrPlcyProd

Claim with Policy Product for Total Expenditure Query | view: IICLTOTEXPPLCP | TRAN | Extraction: Not supported | Component: Claims Management
Tables used: ICLCLAIM, ICLPOL, TICL321
Column Name Description
InsuranceClaim Number of Claim
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
InsuranceContract Contract Number ICL_POLICY
InsurClmAssignUUID UUID of Entry to be Linked SYSUUID_C
InsurLineOfBus Insurance Line of Business ICL_LINEOFBUS
Master Data Relations Join Conditions
Authorization Group for Claims (VIP)
  • Authorization Group for Claims (VIP)
  • Client
  • I_INSURCLMTOTEXPNDTRPLCYPROD.INSURCLMAUTHZNGRP == TICL113.AUTHCLM
  • I_INSURCLMTOTEXPNDTRPLCYPROD.MANDT == TICL113.CLIENT
Status of Claim
  • Status of Claim
  • Client
  • I_INSURCLMTOTEXPNDTRPLCYPROD.INSURCLMLIFECYCSTS == TICL140.STATUS
  • I_INSURCLMTOTEXPNDTRPLCYPROD.MANDT == TICL140.CLIENT
Policy Product Generation
  • Client
  • Policy Product Generation
  • Policy Product
  • I_INSURCLMTOTEXPNDTRPLCYPROD.MANDT == TICL320.CLIENT
  • I_INSURCLMTOTEXPNDTRPLCYPROD.INSURCLMPOLICYPRODGENERATION == TICL320.VERSION
  • I_INSURCLMTOTEXPNDTRPLCYPROD.INSURCLMPOLICYPRODUCT == TICL320.POLPROD
Policy Product
  • ?
  • Client
  • Policy Product
  • I_INSURCLMTOTEXPNDTRPLCYPROD.[column in domain "ICL_GENERAT"] == TICL320.VERSION
  • I_INSURCLMTOTEXPNDTRPLCYPROD.MANDT == TICL320.CLIENT
  • I_INSURCLMTOTEXPNDTRPLCYPROD.INSURCLMPOLICYPRODUCT == TICL320.POLPROD
Policy Product Version
  • Client
  • Policy Product Generation
  • Policy Product Version
  • Policy Product
  • I_INSURCLMTOTEXPNDTRPLCYPROD.MANDT == TICL321.CLIENT
  • I_INSURCLMTOTEXPNDTRPLCYPROD.INSURCLMPOLICYPRODGENERATION == TICL321.GENERAT
  • I_INSURCLMTOTEXPNDTRPLCYPROD.INSURCLMPOLICYPRODUCTVERSION == TICL321.VERSION
  • I_INSURCLMTOTEXPNDTRPLCYPROD.INSURCLMPOLICYPRODUCT == TICL321.POLPROD
Internal Claim Type
  • ?
  • Client
  • Internal Claim Type
  • I_INSURCLMTOTEXPNDTRPLCYPROD.[column in domain "ICL_CLTYPEG"] == TICL011.VERSION
  • I_INSURCLMTOTEXPNDTRPLCYPROD.MANDT == TICL011.CLIENT
  • I_INSURCLMTOTEXPNDTRPLCYPROD.INSURCLMTYPE == TICL011.CLTYPE
Generation of Internal Claim Type
  • Generation of Internal Claim Type
  • Client
  • Internal Claim Type
  • I_INSURCLMTOTEXPNDTRPLCYPROD.INSURCLMTYPEGENERATION == TICL011.VERSION
  • I_INSURCLMTOTEXPNDTRPLCYPROD.MANDT == TICL011.CLIENT
  • I_INSURCLMTOTEXPNDTRPLCYPROD.INSURCLMTYPE == TICL011.CLTYPE