SAP ABAP Table ICL_POL (Extended ICLPOL for Global Memory)
Hierarchy
☛
INSURANCE (Software Component) SAP Insurance
⤷ FS-CM (Application Component) Claims Management
⤷ ICL_CDC (Package) FS-CM: Data Capture
⤷ FS-CM (Application Component) Claims Management
⤷ ICL_CDC (Package) FS-CM: Data Capture
Basic Data
Table Category | INTTAB | Structure |
Structure | ICL_POL | Table Relationship Diagram |
Short Description | Extended ICLPOL for Global Memory |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | ACTIVE | ICL_ACTIVE | ICL_ACTIVE | CHAR | 1 | 0 | Table entry is active (A) or in suspense (S) | ||
3 | CLAIM | ICL_CLAIM1 | ICL_CLAIM | CHAR | 17 | 0 | Policy Snapshot for Claim | ICLCLAIM | |
4 | POLVNR | ICL_POLVCNTR | ICL_POLVCNTR | NUMC | 2 | 0 | Counter of Contract Version | * | |
5 | .INCLUDE | 0 | 0 | Shadow Tables Versioning: Include for Original Table | |||||
6 | CHANGETIME | ICL_CHANGEUTC1 | ICL_TIMESTAMP | DEC | 15 | 0 | Changed: UTC Date+Time | ||
7 | CHANGEDBY | ICL_CHANGEDBY | XUBNAME | CHAR | 12 | 0 | Changed By | * | |
8 | DELETED | ICL_RECSTATUS | ICL_RECSTATUS | CHAR | 1 | 0 | Database Line Status (Original, Changed, Deleted) | ||
9 | .INCLUDE | 0 | 0 | Attributes of ICLPOL | |||||
10 | IMPORTSTATUS | ICL_POLIMPSTAT | ICL_POLIMPSTAT | CHAR | 1 | 0 | Import Status of Policy Snapshot | ||
11 | VALIDDATA | ICL_POLVALIDDATA | ICL_POLVALIDDATA | CHAR | 1 | 0 | Overview of Data in Policy Snapshot | ||
12 | MANCHANGE | ICL_POLMANCHNG | BOOLE | CHAR | 1 | 0 | Policy Snapshot Changed Manually | ||
13 | VALIDFROM | ICL_POL01 | ICL_TIMESTAMP | DEC | 15 | 0 | Contract Version: Valid-From Date | ||
14 | VALIDTO | ICL_POL02 | ICL_TIMESTAMP | DEC | 15 | 0 | Contract Version: Valid To Date | ||
15 | SRCCHANGE | ICL_POL03 | ICL_TIMESTAMP | DEC | 15 | 0 | UTC Date and Time of Version Change in Policy System | ||
16 | ISSUED | ICL_ISSUED | ICL_TIMESTAMP | DEC | 15 | 0 | Date of Issue | ||
17 | INCEPTION | ICL_INCEPTION | ICL_TIMESTAMP | DEC | 15 | 0 | Inception of Contract | ||
18 | EXPIRY | ICL_EXPIRY | ICL_TIMESTAMP | DEC | 15 | 0 | End Date and Time of Contract | ||
19 | CURR | ICL_POLB01 | WAERS | CUKY | 5 | 0 | Currency of Limit and Deductible | * | |
20 | JURISCOUNTRY | ICL_JURICOUNTRY | LAND1 | CHAR | 3 | 0 | Jurisdiction Country | T005 | |
21 | JURISREGION | ICL_JURISREGION | REGIO | CHAR | 3 | 0 | Jurisdiction Region | T005S | |
22 | NCBONUS | ICL_NCBONUS | ICL_NCBONUS1 | NUMC | 3 | 0 | Claim-Free Discount | ||
23 | DISTCHAN | ICL_DISTCHAN | ICL_DISTCHAN | CHAR | 1 | 0 | Insurance Distribution Channel | TICL500 | |
24 | POLICY | ICL_POLICY | ICL_POLICY | CHAR | 17 | 0 | Contract Number | ||
25 | POLPROD | ICL_POLPROD | ICL_POLPROD | CHAR | 6 | 0 | Policy Product | TICL320 | |
26 | LRENEWAL | ICL_LRENEWAL | ICL_TIMESTAMP | DEC | 15 | 0 | Last Renewal of Contract Before Claim Date/Time | ||
27 | POLOBJ_CD | ICL_POLOBJ_CD | INSOBJECT_MD | CHAR | 20 | 0 | ID of PM Insurance Object in CD | * | |
28 | BENEXCLPER | ICL_BENEXCLPER | ICL_BENEXCLPER | CHAR | 1 | 0 | Benefit Exclusion Period | ||
29 | POLICY_PM | ICL_PMI_POLEX | ICL_POLICY | CHAR | 17 | 0 | Number of Policy in FS-PM | ||
30 | POLEX_PM | ICL_POLEX_PM | ICL_POLICY | CHAR | 17 | 0 | External Policy | ||
31 | POLICY_PM_TXT | ICL_POLICY_PM_TXT | ICL_PMI_POLICY_PM_TXT | CHAR | 50 | 0 | Short Name of Policy | ||
32 | CONTR_PM_TXT | ICL_CONTR_PM_TXT | ICL_PMI_CONTR_PM_TXT | CHAR | 50 | 0 | Short Name of PM Contract | ||
33 | .INCLUDE | 0 | 0 | ||||||
34 | PROFILE_PR_LEVEL | ICL_PROFILE_PR_LEVEL_D | ICL_PROFILE_PR_LEVEL | CHAR | 5 | 0 | Benefit Processing Profile at Product Level | * | |
35 | ASSIGN_GUID | ICL_GUID32 | SYSUUID_C | CHAR | 32 | 0 | GUID of Length 32 | ||
36 | CLAUSE | ICL_CLAUSE_INFO_D | ICL_CLAUSE_INFO | NUMC | 1 | 0 | Information on Existence of Clauses in Policy Snapshot | ||
37 | POLPRODN | ICL_POLPRODN | TEXT30 | CHAR | 30 | 0 | Name of Policy Product | ||
38 | INSCOND_GEN | ICL_CONDGEN_D | CHAR | 10 | 0 | General Insurance Conditions | |||
39 | INSCOND_GENN | ICL_CONDTEXT_D | CHAR | 50 | 0 | Description of Insurance Conditions | |||
40 | INSCOND_SPEC | ICL_CONDSPEC_D | CHAR | 10 | 0 | Special Insurance Condition | |||
41 | INSCOND_SPECN | ICL_CONDTEXT_D | CHAR | 50 | 0 | Description of Insurance Conditions | |||
42 | BUKRS | BUKRS | BUKRS | CHAR | 4 | 0 | Company Code | * | |
43 | GESNR | ICL_GESNR_D | BU_PARTNER | CHAR | 10 | 0 | Business Partner of Company Code | * | |
44 | PLINEOFBUS | ICL_LINEOFBUS | ICL_LINEOFBUS | CHAR | 3 | 0 | Insurance Line of Business | * | |
45 | DATACOMPLETED | BOOLE_D | BOOLE | CHAR | 1 | 0 | Data element for domain BOOLE: TRUE (='X') and FALSE (=' ') | ||
46 | JURISCOUNTRYN | LANDX | TEXT15 | CHAR | 15 | 0 | Country Name | ||
47 | JURISREGIONN | BEZEI20 | TEXT20 | CHAR | 20 | 0 | Description | ||
48 | POLSGUID | ICL_GUID32 | SYSUUID_C | CHAR | 32 | 0 | GUID of Length 32 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ICL_POL | CLAIM | ICLCLAIM | CLAIM | |||
2 | ICL_POL | CLIENT | T000 | MANDT | |||
3 | ICL_POL | DISTCHAN | TICL500 | DISTCHAN | |||
4 | ICL_POL | JURISCOUNTRY | T005 | LAND1 | |||
5 | ICL_POL | JURISREGION | T005S | BLAND | |||
6 | ICL_POL | POLPROD | TICL320 | POLPROD |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |