I_InsurClm1stNotifInsrdDriver

Notice of Loss - Insured Driver | view: ICL1STNFINSRDDRI | Extraction: Not supported | Component: Claims Management
Tables used: ICLCLAIM, ICLPARTOCC, ADCP, ADRC, ADR6, ADR2, BUT020, BUT021_FS, BUT000, T005, T005T, TICL321, TICL007T, BUT021_FS, TB008S, TB008U
Column Name Description
InsuranceContract FK Number of Claim
BusinessPartner FK Claim Participant
InsurClmVehicle Claim Subobject
InsurClmParticipantRole FK Participant Role Key
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
ChangedOnDateTime Changed: Date + Time TZNTSTMPS
LastName Last name of business partner (person) BU_NAME
FirstName First name of business partner (person) BU_NAME
StreetName Street TEXT60
HouseNumber House Number TEXT10
CityName City TEXT40
PostalCode City postal code CHAR10
PhoneNumber null
Master Data Relations Join Conditions
Country key
  • Country/Region Key
  • Client
  • I_INSURCLM1STNOTIFINSRDDRIVER.COUNTRY == T005.LAND1
  • I_INSURCLM1STNOTIFINSRDDRIVER.MANDT == T005.MANDT
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • I_INSURCLM1STNOTIFINSRDDRIVER.MANDT == TSAD3.CLIENT
  • I_INSURCLM1STNOTIFINSRDDRIVER.FORMOFADDRESS == TSAD3.TITLE
Authorization Group for Claims (VIP)
  • Client
  • Authorization Group for Claims (VIP)
  • I_INSURCLM1STNOTIFINSRDDRIVER.MANDT == TICL113.CLIENT
  • I_INSURCLM1STNOTIFINSRDDRIVER.INSURCLMAUTHZNGRP == TICL113.AUTHCLM
Participant Role Key
  • Client
  • Participant Role Key
  • I_INSURCLM1STNOTIFINSRDDRIVER.MANDT == TICL301.CLIENT
  • I_INSURCLM1STNOTIFINSRDDRIVER.INSURCLMPARTICIPANTROLE == TICL301.ROLE
Internal Claim Type
  • ?
  • Client
  • Internal Claim Type
  • I_INSURCLM1STNOTIFINSRDDRIVER.[column in domain "ICL_CLTYPEG"] == TICL011.VERSION
  • I_INSURCLM1STNOTIFINSRDDRIVER.MANDT == TICL011.CLIENT
  • I_INSURCLM1STNOTIFINSRDDRIVER.INSURCLMTYPE == TICL011.CLTYPE
Changed By
  • Changed By
  • Client
  • I_INSURCLM1STNOTIFINSRDDRIVER.LASTCHANGEDBYUSER == USR02.BNAME
  • I_INSURCLM1STNOTIFINSRDDRIVER.MANDT == USR02.MANDT
Region code
  • Country/Region Key
  • Region (State, Province, County)
  • Client
  • I_INSURCLM1STNOTIFINSRDDRIVER.COUNTRY == T005S.LAND1
  • I_INSURCLM1STNOTIFINSRDDRIVER.REGION == T005S.BLAND
  • I_INSURCLM1STNOTIFINSRDDRIVER.MANDT == T005S.MANDT