I_InsurClm1stNotifTP

Notice of Loss | view: ICL1STNFTP | TRAN | Extraction: Not supported | Component: Claims Management
Tables used: ICLCLAIM, SGBT_NTE_CONT, ICLPARTOCC, ADCP, ADRC, ADR6, ADR2, BUT020, BUT021_FS, BUT000, T005, T005T, ICLTEXT_REPL, BUT021_FS, TB008S, TB008U
Column Name Description
InsuranceClaim Number of Claim
Column Name Description
Column Name Description
Column Name Description
InsurClmDateOfLoss Date of Loss/Claim
Column Name Description
Column Name Description Domain name
InsuranceContract Contract Number ICL_POLICY
ChangedOnDateTime Date on Which Whole Claim Was Last Changed TZNTSTMPS
CreationDateTime Created: Date + Time TZNTSTMPS
InsurClmLossLocStreet Street TEXT60
InsurClmLossLocHouseNumber House Number TEXT10
InsurClmLossLocCity City TEXT40
InsurClmLossLocPostalCode City postal code CHAR10
InsurClmLossLocLongitude Geo location longitude GEOLONLAT
InsurClmLossLocLatitude Geo location latitude GEOLONLAT
InsurClmDescriptionOfLoss Content of note
Master Data Relations | to Other Relations ↓ Join Conditions
Created By
  • Client
  • Created By
  • I_INSURCLM1STNOTIFTP.MANDT == USR02.MANDT
  • I_INSURCLM1STNOTIFTP.CREATEDBYUSER == USR02.BNAME
Authorization Group for Claims (VIP)
  • Client
  • Authorization Group for Claims (VIP)
  • I_INSURCLM1STNOTIFTP.MANDT == TICL113.CLIENT
  • I_INSURCLM1STNOTIFTP.INSURCLMAUTHZNGRP == TICL113.AUTHCLM
Loss Location
  • Client
  • Loss Location
  • ?
  • ?
  • I_INSURCLM1STNOTIFTP.MANDT == ADRC.CLIENT
  • I_INSURCLM1STNOTIFTP.INSURCLMLOSSLOCADDRESSID == ADRC.ADDRNUMBER
  • I_INSURCLM1STNOTIFTP.[column in domain "AD_NATION"] == ADRC.NATION
  • I_INSURCLM1STNOTIFTP.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
Country key
  • Client
  • Country/Region Key
  • I_INSURCLM1STNOTIFTP.MANDT == T005.MANDT
  • I_INSURCLM1STNOTIFTP.INSURCLMLOSSLOCCOUNTRY == T005.LAND1
Region code
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • I_INSURCLM1STNOTIFTP.MANDT == T005S.MANDT
  • I_INSURCLM1STNOTIFTP.INSURCLMLOSSLOCREGION == T005S.BLAND
  • I_INSURCLM1STNOTIFTP.INSURCLMLOSSLOCCOUNTRY == T005S.LAND1
Policy Product Generation
  • Client
  • Policy Product Generation
  • Policy Product
  • I_INSURCLM1STNOTIFTP.MANDT == TICL320.CLIENT
  • I_INSURCLM1STNOTIFTP.INSURCLMPOLICYPRODGENERATION == TICL320.VERSION
  • I_INSURCLM1STNOTIFTP.INSURCLMPOLICYPRODUCT == TICL320.POLPROD
Policy Product
  • Client
  • Policy Product
  • ?
  • I_INSURCLM1STNOTIFTP.MANDT == TICL320.CLIENT
  • I_INSURCLM1STNOTIFTP.INSURCLMPOLICYPRODUCT == TICL320.POLPROD
  • I_INSURCLM1STNOTIFTP.[column in domain "ICL_GENERAT"] == TICL320.VERSION
Policy Product Version
  • Client
  • Policy Product Generation
  • Policy Product
  • Policy Product Version
  • I_INSURCLM1STNOTIFTP.MANDT == TICL321.CLIENT
  • I_INSURCLM1STNOTIFTP.INSURCLMPOLICYPRODGENERATION == TICL321.GENERAT
  • I_INSURCLM1STNOTIFTP.INSURCLMPOLICYPRODUCT == TICL321.POLPROD
  • I_INSURCLM1STNOTIFTP.INSURCLMPOLICYPRODUCTVERSION == TICL321.VERSION
Internal Claim Type
  • Internal Claim Type
  • Client
  • ?
  • I_INSURCLM1STNOTIFTP.INSURCLMTYPE == TICL011.CLTYPE
  • I_INSURCLM1STNOTIFTP.MANDT == TICL011.CLIENT
  • I_INSURCLM1STNOTIFTP.[column in domain "ICL_CLTYPEG"] == TICL011.VERSION
Generation of Internal Claim Type
  • Internal Claim Type
  • Client
  • Generation of Internal Claim Type
  • I_INSURCLM1STNOTIFTP.INSURCLMTYPE == TICL011.CLTYPE
  • I_INSURCLM1STNOTIFTP.MANDT == TICL011.CLIENT
  • I_INSURCLM1STNOTIFTP.INSURCLMTYPEGENERATION == TICL011.VERSION
Internal Claim Type Version
  • Internal Claim Type
  • Client
  • Internal Claim Type Version
  • Generation of Internal Claim Type
  • I_INSURCLM1STNOTIFTP.INSURCLMTYPE == TICL003.CLTYPE
  • I_INSURCLM1STNOTIFTP.MANDT == TICL003.CLIENT
  • I_INSURCLM1STNOTIFTP.INSURCLMTYPEVERS == TICL003.VERSION
  • I_INSURCLM1STNOTIFTP.INSURCLMTYPEGENERATION == TICL003.GENERAT
Changed By
  • Client
  • Changed By
  • I_INSURCLM1STNOTIFTP.MANDT == USR02.MANDT
  • I_INSURCLM1STNOTIFTP.LASTCHANGEDBYUSER == USR02.BNAME
Other Relations | to Master Data Relations ↑ Join Conditions
Cause of Loss/Claim
  • Internal Claim Type
  • Client
  • Internal Claim Type Version
  • Cause of Loss/Claim
  • Generation of Internal Claim Type
  • I_INSURCLM1STNOTIFTP.INSURCLMTYPE == TICL009.CLTYPE
  • I_INSURCLM1STNOTIFTP.MANDT == TICL009.CLIENT
  • I_INSURCLM1STNOTIFTP.INSURCLMTYPEVERS == TICL009.VERSION
  • I_INSURCLM1STNOTIFTP.INSURCLMCAUSEOFLOSS == TICL009.LOSSCAUSE
  • I_INSURCLM1STNOTIFTP.INSURCLMTYPEGENERATION == TICL009.GENERAT
Incident Type of a Claim
  • Client
  • ?
  • ?
  • ?
  • Incident Type of a Claim
  • I_INSURCLM1STNOTIFTP.MANDT == TICL062.CLIENT
  • I_INSURCLM1STNOTIFTP.[column in domain "ICL_POLPROD"] == TICL062.POLPROD
  • I_INSURCLM1STNOTIFTP.[column in domain "ICL_POLPRODV"] == TICL062.VERSION
  • I_INSURCLM1STNOTIFTP.[column in domain "ICL_GENERAT"] == TICL062.GENERAT
  • I_INSURCLM1STNOTIFTP.INSURCLMINCDNTTYPE == TICL062.LOSSTYPE