I_InsurClmFNOLContract

Composite View for Contract Details Fnol | view: ICLFNOLCONTR | TRAN | 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 Contract Number
Column Name Description
Column Name Description
Column Name Description
BirthDate Date of Birth of Business Partner
Column Name Description
Column Name Description Domain name
ChangedOnDateTime Date on Which Whole Claim Was Last Changed TZNTSTMPS
CreationDateTime Created: Date + Time TZNTSTMPS
LastName Last name of business partner (person) BU_NAME
FirstName First name of business partner (person) BU_NAME
InsurancePolicyholderName Name of Policyholder TEXT81
StreetName Street TEXT60
HouseNumber House Number TEXT10
CityName City TEXT40
PostalCode City postal code CHAR10
PhoneNumber null
EmailAddress null
InsurLineOfBusName Name of Insurance Line of Business TEXT30
Master Data Relations Join Conditions
Authorization Group
  • ?
  • Client
  • Authorization Group
  • I_INSURCLMFNOLCONTRACT.[column in domain "BU_AUOBJ"] == TB037.AUOBJ
  • I_INSURCLMFNOLCONTRACT.MANDT == TB037.CLIENT
  • I_INSURCLMFNOLCONTRACT.AUTHORIZATIONGROUP == TB037.AUGRP
Created By
  • Client
  • Created By
  • I_INSURCLMFNOLCONTRACT.MANDT == USR02.MANDT
  • I_INSURCLMFNOLCONTRACT.CREATEDBYUSER == USR02.BNAME
Authorization Group for Claims (VIP)
  • Client
  • Authorization Group for Claims (VIP)
  • I_INSURCLMFNOLCONTRACT.MANDT == TICL113.CLIENT
  • I_INSURCLMFNOLCONTRACT.INSURCLMAUTHZNGRP == TICL113.AUTHCLM
Policy Product Generation
  • Client
  • Policy Product Generation
  • Policy Product
  • I_INSURCLMFNOLCONTRACT.MANDT == TICL320.CLIENT
  • I_INSURCLMFNOLCONTRACT.INSURCLMPOLICYPRODGENERATION == TICL320.VERSION
  • I_INSURCLMFNOLCONTRACT.INSURCLMPOLICYPRODUCT == TICL320.POLPROD
Policy Product
  • ?
  • Client
  • Policy Product
  • I_INSURCLMFNOLCONTRACT.[column in domain "ICL_GENERAT"] == TICL320.VERSION
  • I_INSURCLMFNOLCONTRACT.MANDT == TICL320.CLIENT
  • I_INSURCLMFNOLCONTRACT.INSURCLMPOLICYPRODUCT == TICL320.POLPROD
Policy Product Version
  • Client
  • Policy Product Version
  • Policy Product Generation
  • Policy Product
  • I_INSURCLMFNOLCONTRACT.MANDT == TICL321.CLIENT
  • I_INSURCLMFNOLCONTRACT.INSURCLMPOLICYPRODUCTVERSION == TICL321.VERSION
  • I_INSURCLMFNOLCONTRACT.INSURCLMPOLICYPRODGENERATION == TICL321.GENERAT
  • I_INSURCLMFNOLCONTRACT.INSURCLMPOLICYPRODUCT == TICL321.POLPROD
Internal Claim Type
  • ?
  • Internal Claim Type
  • Client
  • I_INSURCLMFNOLCONTRACT.[column in domain "ICL_CLTYPEG"] == TICL011.VERSION
  • I_INSURCLMFNOLCONTRACT.INSURCLMTYPE == TICL011.CLTYPE
  • I_INSURCLMFNOLCONTRACT.MANDT == TICL011.CLIENT
Changed By
  • Changed By
  • Client
  • I_INSURCLMFNOLCONTRACT.LASTCHANGEDBYUSER == USR02.BNAME
  • I_INSURCLMFNOLCONTRACT.MANDT == USR02.MANDT