I_InsurClm1stNotifSrvcPrvdr

Notice of Loss - Service Provider | view: ICL1STNFSP | TRAN | Extraction: Not supported | Component: Claims Management
Tables used: ICLPARTOCC, ADCP, ADRC, ADR6, ADR2, BUT020, BUT021_FS, BUT000, T005, T005T, BUT021_FS, TB008S, TB008U
Column Name Description
InsuranceClaim FK Number of Claim
InsurClmDamagedObject Claim Subobject
Column Name Description
Column Name Description
Column Name Description
Column Name Description
Column Name Description Domain name
BusinessPartnerName null
StreetName Street TEXT60
HouseNumber House Number TEXT10
CityName City TEXT40
PostalCode City postal code CHAR10
PhoneNumber null
EmailAddress null
Master Data Relations Join Conditions
Country key
  • Client
  • Country/Region Key
  • I_INSURCLM1STNOTIFSRVCPRVDR.MANDT == T005.MANDT
  • I_INSURCLM1STNOTIFSRVCPRVDR.COUNTRY == T005.LAND1
Form-of-Address Key
  • Client
  • Form-of-Address Key
  • I_INSURCLM1STNOTIFSRVCPRVDR.MANDT == TSAD3.CLIENT
  • I_INSURCLM1STNOTIFSRVCPRVDR.FORMOFADDRESS == TSAD3.TITLE
Participant Role Key
  • Client
  • Participant Role Key
  • I_INSURCLM1STNOTIFSRVCPRVDR.MANDT == TICL301.CLIENT
  • I_INSURCLM1STNOTIFSRVCPRVDR.INSURCLMPARTICIPANTROLE == TICL301.ROLE
Region code
  • Client
  • Region (State, Province, County)
  • Country/Region Key
  • I_INSURCLM1STNOTIFSRVCPRVDR.MANDT == T005S.MANDT
  • I_INSURCLM1STNOTIFSRVCPRVDR.REGION == T005S.BLAND
  • I_INSURCLM1STNOTIFSRVCPRVDR.COUNTRY == T005S.LAND1