I_InsurClmClaimOverview

Claim Overview | view: IICLCLAIMOVW | TRAN | Extraction: Not supported | Component: Claims Management
Tables used: ICLCLAIM, ICLPOLM, ICLCLAIM, ICLCLAIMASSIGN, ICL_RBP, SGBT_NTE_CONT, ICLCLAIMASSIGN, SGBT_NTE_CONT, SGBT_NTE_CONT, ICLCLAIMA, ICLPAY, ICLPAYI, ICLPOL, ICLPARTOCC, ICLRESERVE, ICLCLAIM, ICLSUBCL, ICL_SUBROG, ADCP, ADRC, ADR6, ADR2, BUT020, BUT021_FS, BUT000, T005, T005T, TICL321, TICL055, ICL_CPROFILE_BT, ICLPOLBF, TICL160, TICL161, TICL015T, TICL060T, ICLTEXT_REPL, TICL008T, ICLTEXT_REPL, ICLTEXT_REPL, TICL020, TICL020T, TICL140, TICL140T, ICL_CSUBROGREAS, TICL003, ADCP, ADR2, ADR3, ADR6, ADRP, USR21, BUT021_FS, TB008S, TB008U, TICL162, TICL009, ICL_CRBPCLTYPE, ICL_CRBPPRORO, TICL100, TICL053, TICL005, TICL323
Column Name Description
InsuranceClaim Number of Claim
Column Name Description
InsurClmExpnExpenditureAmount null
InsurClmLossExpenditureAmount null
InsurClmTotalRecoveryPaytAmt null
InsurClmLossPaytAmt null
InsurClmExpensePaytAmt null
InsurClmLossReserveAmt null
InsurClmExpenseReserveAmount null
InsurClmSalvagePaytAmt null
InsurClmSubrogtnRcvryPaytAmt null
InsurClmRecoveryPaytAmt null
Column Name Description
Column Name Description
InsurClmDateOfLoss Date of Loss/Claim
InsurClmTimeOfLoss Time of Claim/Loss
InsurClmAgentReportedDate Date on Which Claim Was Reported to Agent
Column Name Description
InsurClmCovered Indication of Compensability Show values
Column Name Description Domain name
InsuranceContract Contract Number ICL_POLICY
InsurClmLifeCycStsName Status Description TEXT25
InsurClmIncdntTypeName Name of Incident Type TEXT30
InsurLineOfBus Insurance Line of Business ICL_LINEOFBUS
InsurClmDescriptionOfLossLoc Content of note
InsurClmIncidentDetailsText Content of note
InsurClaimBundle Claims Management Object ICL_OBJECT
InsurClmComplexityName (Sub)Claim Complexity Name TEXT15
InsurancePolicy Number of Policy in FS-PM ICL_POLICY
InsurClmContractStartDateTime Date on Which Whole Claim Was Last Changed TZNTSTMPS
InsurClmContractEndDateTime Date on Which Whole Claim Was Last Changed TZNTSTMPS
InsurClmLocationText null
InsurClmDescriptionOfLoss Content of note
InsurClmCauseOfLossName Name for Cause of Claim/Loss TEXT60
FullName Full Name of Person TEXT80
InsurClmPolicyHolderName null
InsurClmPaymentCurrency Character String - 8 User-Defined Characters CHAR0008
Master Data Relations | to Other Relations ↓ Join Conditions
Authorization Group for Claims (VIP)
  • Authorization Group for Claims (VIP)
  • Client
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMAUTHZNGRP == TICL113.AUTHCLM
  • I_INSURCLMCLAIMOVERVIEW.MANDT == TICL113.CLIENT
Status of Claim
  • Status of Claim
  • Client
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMLIFECYCSTS == TICL140.STATUS
  • I_INSURCLMCLAIMOVERVIEW.MANDT == TICL140.CLIENT
Loss Location
  • ?
  • ?
  • Client
  • Loss Location
  • I_INSURCLMCLAIMOVERVIEW.[column in domain "AD_NATION"] == ADRC.NATION
  • I_INSURCLMCLAIMOVERVIEW.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_INSURCLMCLAIMOVERVIEW.MANDT == ADRC.CLIENT
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMLOSSLOCADDRESSID == ADRC.ADDRNUMBER
Policy Product Generation
  • Policy Product
  • Client
  • Policy Product Generation
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMPOLICYPRODUCT == TICL320.POLPROD
  • I_INSURCLMCLAIMOVERVIEW.MANDT == TICL320.CLIENT
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMPOLICYPRODGENERATION == TICL320.VERSION
Policy Product
  • Policy Product
  • ?
  • Client
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMPOLICYPRODUCT == TICL320.POLPROD
  • I_INSURCLMCLAIMOVERVIEW.[column in domain "ICL_GENERAT"] == TICL320.VERSION
  • I_INSURCLMCLAIMOVERVIEW.MANDT == TICL320.CLIENT
Policy Product Version
  • Policy Product
  • Policy Product Version
  • Client
  • Policy Product Generation
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMPOLICYPRODUCT == TICL321.POLPROD
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMPOLICYPRODUCTVERSION == TICL321.VERSION
  • I_INSURCLMCLAIMOVERVIEW.MANDT == TICL321.CLIENT
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMPOLICYPRODGENERATION == TICL321.GENERAT
Internal Claim Type
  • ?
  • Client
  • Internal Claim Type
  • I_INSURCLMCLAIMOVERVIEW.[column in domain "ICL_CLTYPEG"] == TICL011.VERSION
  • I_INSURCLMCLAIMOVERVIEW.MANDT == TICL011.CLIENT
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMTYPE == TICL011.CLTYPE
Generation of Internal Claim Type
  • Client
  • Generation of Internal Claim Type
  • Internal Claim Type
  • I_INSURCLMCLAIMOVERVIEW.MANDT == TICL011.CLIENT
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMTYPEGENERATION == TICL011.VERSION
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMTYPE == TICL011.CLTYPE
Internal Claim Type Version
  • Client
  • Generation of Internal Claim Type
  • Internal Claim Type Version
  • Internal Claim Type
  • I_INSURCLMCLAIMOVERVIEW.MANDT == TICL003.CLIENT
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMTYPEGENERATION == TICL003.GENERAT
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMTYPEVERS == TICL003.VERSION
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMTYPE == TICL003.CLTYPE
Other Relations | to Master Data Relations ↑ Join Conditions
Cause of Loss/Claim
  • Client
  • Generation of Internal Claim Type
  • Internal Claim Type Version
  • Internal Claim Type
  • Cause of Loss/Claim
  • I_INSURCLMCLAIMOVERVIEW.MANDT == TICL009.CLIENT
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMTYPEGENERATION == TICL009.GENERAT
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMTYPEVERS == TICL009.VERSION
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMTYPE == TICL009.CLTYPE
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMCAUSEOFLOSS == TICL009.LOSSCAUSE
Complexity of Claim/Subclaim
  • ?
  • Client
  • Generation of Internal Claim Type
  • Internal Claim Type Version
  • Internal Claim Type
  • Complexity of Claim/Subclaim
  • I_INSURCLMCLAIMOVERVIEW.[column in domain "ICL_SUBCLTYPE"] == TICL027.SUBCLTYPE
  • I_INSURCLMCLAIMOVERVIEW.MANDT == TICL027.CLIENT
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMTYPEGENERATION == TICL027.GENERAT
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMTYPEVERS == TICL027.VERSION
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMTYPE == TICL027.CLTYPE
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMCOMPLEXITY == TICL027.COMPLEX
Incident Type of a Claim
  • ?
  • ?
  • ?
  • Client
  • Incident Type of a Claim
  • I_INSURCLMCLAIMOVERVIEW.[column in domain "ICL_POLPROD"] == TICL062.POLPROD
  • I_INSURCLMCLAIMOVERVIEW.[column in domain "ICL_POLPRODV"] == TICL062.VERSION
  • I_INSURCLMCLAIMOVERVIEW.[column in domain "ICL_GENERAT"] == TICL062.GENERAT
  • I_INSURCLMCLAIMOVERVIEW.MANDT == TICL062.CLIENT
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMINCDNTTYPE == TICL062.LOSSTYPE
Reason for Changing the Status
  • Reason for Changing the Status
  • Status of Claim
  • ?
  • Client
  • Generation of Internal Claim Type
  • Internal Claim Type Version
  • Internal Claim Type
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMSTATREASON == TICL047.FORMOFSET
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMLIFECYCSTS == TICL047.STATUS
  • I_INSURCLMCLAIMOVERVIEW.[column in domain "ICL_SUBCLTYPE"] == TICL047.SUBCLTYPE
  • I_INSURCLMCLAIMOVERVIEW.MANDT == TICL047.CLIENT
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMTYPEGENERATION == TICL047.GENERAT
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMTYPEVERS == TICL047.VERSION
  • I_INSURCLMCLAIMOVERVIEW.INSURCLMTYPE == TICL047.CLTYPE