I_InsurClmChange

Composite View for Claim Change | view: ICLCLAIMCHANGE | TRAN | Extraction: Not supported | Component: Claims Management
Tables used: ICLCLAIM, ICLCLAIMA, ICLPOL, ICLPARTOCC, ADCP, ADRC, ADR6, ADR2, BUT020, BUT021_FS, BUT000, T005, T005T, TICL015T, TICL060T, TICL008T, TICL140, TICL140T, TB008S, TB008U
Column Name Description
InsuranceClaim Number of Claim
InsurClaimUUID 16 Byte UUID in 16 Bytes (Raw Format)
Column Name Description
Column Name Description
Column Name Description
InsurClmDateOfLoss Date of Loss/Claim
InsurClmTimeOfLoss Time of Claim/Loss
InsurClmReportedDate Date Claim Reported to Insurance Company
InsurClmAgentReportedDate Date on Which Claim Was Reported to Agent
Column Name Description
InsurClmSensitiveClaim Sensitive Claim? Show values
Column Name Description Domain name
InsuranceContract Contract Number ICL_POLICY
ChangedOnDateTime Date on Which Whole Claim Was Last Changed TZNTSTMPS
InsurLineOfBus Insurance Line of Business ICL_LINEOFBUS
InsurClmContractStartDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
InsurClmContractEndDateTime UTC Time Stamp in Short Form (YYYYMMDDhhmmss) TZNTSTMPS
InsurClmIncdntTypeName Name of Incident Type TEXT30
InsurClaimBundle Claims Management Object ICL_OBJECT
InsurClmComplexityName (Sub)Claim Complexity Name TEXT15
InsurClmLifeCycStsName Status Description TEXT25
InsurClmPolicyHolderName null
StreetName Street TEXT60
CityName City TEXT40
PostalCode City postal code CHAR10
HouseNumber House Number TEXT10
InsurClmCauseOfLossName Name for Cause of Claim/Loss TEXT60
Master Data Relations | to Other Relations ↓ Join Conditions
Country key
  • Client
  • Country/Region Key
  • I_INSURCLMCHANGE.MANDT == T005.MANDT
  • I_INSURCLMCHANGE.COUNTRY == T005.LAND1
Authorization Group for Claims (VIP)
  • Client
  • Authorization Group for Claims (VIP)
  • I_INSURCLMCHANGE.MANDT == TICL113.CLIENT
  • I_INSURCLMCHANGE.INSURCLMAUTHZNGRP == TICL113.AUTHCLM
Status of Claim
  • Client
  • Status of Claim
  • I_INSURCLMCHANGE.MANDT == TICL140.CLIENT
  • I_INSURCLMCHANGE.INSURCLMLIFECYCSTS == TICL140.STATUS
Loss Location
  • ?
  • ?
  • Client
  • Loss Location
  • I_INSURCLMCHANGE.[column in domain "AD_NATION"] == ADRC.NATION
  • I_INSURCLMCHANGE.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • I_INSURCLMCHANGE.MANDT == ADRC.CLIENT
  • I_INSURCLMCHANGE.INSURCLMLOSSLOCADDRESSID == ADRC.ADDRNUMBER
Policy Product Generation
  • Client
  • Policy Product Generation
  • Policy Product
  • I_INSURCLMCHANGE.MANDT == TICL320.CLIENT
  • I_INSURCLMCHANGE.INSURCLMPOLICYPRODGENERATION == TICL320.VERSION
  • I_INSURCLMCHANGE.INSURCLMPOLICYPRODUCT == TICL320.POLPROD
Policy Product
  • ?
  • Client
  • Policy Product
  • I_INSURCLMCHANGE.[column in domain "ICL_GENERAT"] == TICL320.VERSION
  • I_INSURCLMCHANGE.MANDT == TICL320.CLIENT
  • I_INSURCLMCHANGE.INSURCLMPOLICYPRODUCT == TICL320.POLPROD
Internal Claim Type
  • ?
  • Client
  • Internal Claim Type
  • I_INSURCLMCHANGE.[column in domain "ICL_CLTYPEG"] == TICL011.VERSION
  • I_INSURCLMCHANGE.MANDT == TICL011.CLIENT
  • I_INSURCLMCHANGE.INSURCLMTYPE == TICL011.CLTYPE
Generation of Internal Claim Type
  • Client
  • Generation of Internal Claim Type
  • Internal Claim Type
  • I_INSURCLMCHANGE.MANDT == TICL011.CLIENT
  • I_INSURCLMCHANGE.INSURCLMTYPEGENERATION == TICL011.VERSION
  • I_INSURCLMCHANGE.INSURCLMTYPE == TICL011.CLTYPE
Internal Claim Type Version
  • Client
  • Internal Claim Type Version
  • Generation of Internal Claim Type
  • Internal Claim Type
  • I_INSURCLMCHANGE.MANDT == TICL003.CLIENT
  • I_INSURCLMCHANGE.INSURCLMTYPEVERS == TICL003.VERSION
  • I_INSURCLMCHANGE.INSURCLMTYPEGENERATION == TICL003.GENERAT
  • I_INSURCLMCHANGE.INSURCLMTYPE == TICL003.CLTYPE
Region code
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • I_INSURCLMCHANGE.MANDT == T005S.MANDT
  • I_INSURCLMCHANGE.REGION == T005S.BLAND
  • I_INSURCLMCHANGE.COUNTRY == T005S.LAND1
Other Relations | to Master Data Relations ↑ Join Conditions
Cause of Loss/Claim
  • Client
  • Internal Claim Type Version
  • Generation of Internal Claim Type
  • Internal Claim Type
  • Cause of Loss/Claim
  • I_INSURCLMCHANGE.MANDT == TICL009.CLIENT
  • I_INSURCLMCHANGE.INSURCLMTYPEVERS == TICL009.VERSION
  • I_INSURCLMCHANGE.INSURCLMTYPEGENERATION == TICL009.GENERAT
  • I_INSURCLMCHANGE.INSURCLMTYPE == TICL009.CLTYPE
  • I_INSURCLMCHANGE.INSURCLMCAUSEOFLOSS == TICL009.LOSSCAUSE
Complexity of Claim/Subclaim
  • ?
  • Client
  • Internal Claim Type Version
  • Generation of Internal Claim Type
  • Complexity of Claim/Subclaim
  • Internal Claim Type
  • I_INSURCLMCHANGE.[column in domain "ICL_SUBCLTYPE"] == TICL027.SUBCLTYPE
  • I_INSURCLMCHANGE.MANDT == TICL027.CLIENT
  • I_INSURCLMCHANGE.INSURCLMTYPEVERS == TICL027.VERSION
  • I_INSURCLMCHANGE.INSURCLMTYPEGENERATION == TICL027.GENERAT
  • I_INSURCLMCHANGE.INSURCLMCOMPLEXITY == TICL027.COMPLEX
  • I_INSURCLMCHANGE.INSURCLMTYPE == TICL027.CLTYPE
Incident Type of a Claim
  • ?
  • ?
  • ?
  • Client
  • Incident Type of a Claim
  • I_INSURCLMCHANGE.[column in domain "ICL_POLPROD"] == TICL062.POLPROD
  • I_INSURCLMCHANGE.[column in domain "ICL_POLPRODV"] == TICL062.VERSION
  • I_INSURCLMCHANGE.[column in domain "ICL_GENERAT"] == TICL062.GENERAT
  • I_INSURCLMCHANGE.MANDT == TICL062.CLIENT
  • I_INSURCLMCHANGE.INSURCLMINCDNTTYPE == TICL062.LOSSTYPE
Reason for Changing the Status
  • ?
  • Client
  • Internal Claim Type Version
  • Generation of Internal Claim Type
  • Internal Claim Type
  • Reason for Changing the Status
  • Status of Claim
  • I_INSURCLMCHANGE.[column in domain "ICL_SUBCLTYPE"] == TICL047.SUBCLTYPE
  • I_INSURCLMCHANGE.MANDT == TICL047.CLIENT
  • I_INSURCLMCHANGE.INSURCLMTYPEVERS == TICL047.VERSION
  • I_INSURCLMCHANGE.INSURCLMTYPEGENERATION == TICL047.GENERAT
  • I_INSURCLMCHANGE.INSURCLMTYPE == TICL047.CLTYPE
  • I_INSURCLMCHANGE.INSURCLMSTATREASON == TICL047.FORMOFSET
  • I_INSURCLMCHANGE.INSURCLMLIFECYCSTS == TICL047.STATUS