C_InsurClm1stNotifTP

Notice of Loss | view: CICL1STNFTP | TRAN | Extraction: Not supported | Component: Claims Management
Tables used: ICLCLAIM, SGBT_NTE_CONT, ICLPARTOCC, ADCP, ADRC, ADR6, ADR2, BUT020, BUT021_FS, BUT000, T005, T005T, TICL321, TICL060T, TICL007T, 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
IsReviewed Table entry is active (A) or in suspense (S) Show values
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
FirstName First name of business partner (person) BU_NAME
LastName Last name of business partner (person) BU_NAME
InsurancePolicyholderName Name of Policyholder TEXT81
InsurClmIncdntTypeName Name of Incident Type TEXT30
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
Authorization Group
  • ?
  • Authorization Group
  • Client
  • C_INSURCLM1STNOTIFTP.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • C_INSURCLM1STNOTIFTP.AUTHORIZATIONGROUP == TB037.AUGRP
  • C_INSURCLM1STNOTIFTP.MANDT == TB037.CLIENT
Created By
  • Client
  • Created By
  • C_INSURCLM1STNOTIFTP.MANDT == USR02.MANDT
  • C_INSURCLM1STNOTIFTP.CREATEDBYUSER == USR02.BNAME
Authorization Group for Claims (VIP)
  • Client
  • Authorization Group for Claims (VIP)
  • C_INSURCLM1STNOTIFTP.MANDT == TICL113.CLIENT
  • C_INSURCLM1STNOTIFTP.INSURCLMAUTHZNGRP == TICL113.AUTHCLM
Loss Location
  • ?
  • ?
  • Client
  • Loss Location
  • C_INSURCLM1STNOTIFTP.[column in domain "AD_NATION"] == ADRC.NATION
  • C_INSURCLM1STNOTIFTP.[column in domain "AD_DATE_FR"] == ADRC.DATE_FROM
  • C_INSURCLM1STNOTIFTP.MANDT == ADRC.CLIENT
  • C_INSURCLM1STNOTIFTP.INSURCLMLOSSLOCADDRESSID == ADRC.ADDRNUMBER
Country key
  • Client
  • Country/Region Key
  • C_INSURCLM1STNOTIFTP.MANDT == T005.MANDT
  • C_INSURCLM1STNOTIFTP.INSURCLMLOSSLOCCOUNTRY == T005.LAND1
Region code
  • Client
  • Country/Region Key
  • Region (State, Province, County)
  • C_INSURCLM1STNOTIFTP.MANDT == T005S.MANDT
  • C_INSURCLM1STNOTIFTP.INSURCLMLOSSLOCCOUNTRY == T005S.LAND1
  • C_INSURCLM1STNOTIFTP.INSURCLMLOSSLOCREGION == T005S.BLAND
Policy Product Generation
  • Policy Product Generation
  • Policy Product
  • Client
  • C_INSURCLM1STNOTIFTP.INSURCLMPOLICYPRODGENERATION == TICL320.VERSION
  • C_INSURCLM1STNOTIFTP.INSURCLMPOLICYPRODUCT == TICL320.POLPROD
  • C_INSURCLM1STNOTIFTP.MANDT == TICL320.CLIENT
Policy Product
  • ?
  • Policy Product
  • Client
  • C_INSURCLM1STNOTIFTP.[column in domain "ICL_GENERAT"] == TICL320.VERSION
  • C_INSURCLM1STNOTIFTP.INSURCLMPOLICYPRODUCT == TICL320.POLPROD
  • C_INSURCLM1STNOTIFTP.MANDT == TICL320.CLIENT
Policy Product Version
  • Policy Product Generation
  • Policy Product
  • Policy Product Version
  • Client
  • C_INSURCLM1STNOTIFTP.INSURCLMPOLICYPRODGENERATION == TICL321.GENERAT
  • C_INSURCLM1STNOTIFTP.INSURCLMPOLICYPRODUCT == TICL321.POLPROD
  • C_INSURCLM1STNOTIFTP.INSURCLMPOLICYPRODUCTVERSION == TICL321.VERSION
  • C_INSURCLM1STNOTIFTP.MANDT == TICL321.CLIENT
Internal Claim Type
  • ?
  • Internal Claim Type
  • Client
  • C_INSURCLM1STNOTIFTP.[column in domain "ICL_CLTYPEG"] == TICL011.VERSION
  • C_INSURCLM1STNOTIFTP.INSURCLMTYPE == TICL011.CLTYPE
  • C_INSURCLM1STNOTIFTP.MANDT == TICL011.CLIENT
Generation of Internal Claim Type
  • Internal Claim Type
  • Client
  • Generation of Internal Claim Type
  • C_INSURCLM1STNOTIFTP.INSURCLMTYPE == TICL011.CLTYPE
  • C_INSURCLM1STNOTIFTP.MANDT == TICL011.CLIENT
  • C_INSURCLM1STNOTIFTP.INSURCLMTYPEGENERATION == TICL011.VERSION
Internal Claim Type Version
  • Internal Claim Type
  • Client
  • Generation of Internal Claim Type
  • Internal Claim Type Version
  • C_INSURCLM1STNOTIFTP.INSURCLMTYPE == TICL003.CLTYPE
  • C_INSURCLM1STNOTIFTP.MANDT == TICL003.CLIENT
  • C_INSURCLM1STNOTIFTP.INSURCLMTYPEGENERATION == TICL003.GENERAT
  • C_INSURCLM1STNOTIFTP.INSURCLMTYPEVERS == TICL003.VERSION
Changed By
  • Changed By
  • Client
  • C_INSURCLM1STNOTIFTP.LASTCHANGEDBYUSER == USR02.BNAME
  • C_INSURCLM1STNOTIFTP.MANDT == USR02.MANDT
Other Relations | to Master Data Relations ↑ Join Conditions
Cause of Loss/Claim
  • Internal Claim Type
  • Client
  • Cause of Loss/Claim
  • Generation of Internal Claim Type
  • Internal Claim Type Version
  • C_INSURCLM1STNOTIFTP.INSURCLMTYPE == TICL009.CLTYPE
  • C_INSURCLM1STNOTIFTP.MANDT == TICL009.CLIENT
  • C_INSURCLM1STNOTIFTP.INSURCLMCAUSEOFLOSS == TICL009.LOSSCAUSE
  • C_INSURCLM1STNOTIFTP.INSURCLMTYPEGENERATION == TICL009.GENERAT
  • C_INSURCLM1STNOTIFTP.INSURCLMTYPEVERS == TICL009.VERSION
Incident Type of a Claim
  • ?
  • ?
  • ?
  • Client
  • Incident Type of a Claim
  • C_INSURCLM1STNOTIFTP.[column in domain "ICL_POLPROD"] == TICL062.POLPROD
  • C_INSURCLM1STNOTIFTP.[column in domain "ICL_POLPRODV"] == TICL062.VERSION
  • C_INSURCLM1STNOTIFTP.[column in domain "ICL_GENERAT"] == TICL062.GENERAT
  • C_INSURCLM1STNOTIFTP.MANDT == TICL062.CLIENT
  • C_INSURCLM1STNOTIFTP.INSURCLMINCDNTTYPE == TICL062.LOSSTYPE