SAP ABAP Table ICL_WCMP_ICLW40_ALV_S_UI (Workers Comp - View ICLW40 ALV Grid)
Hierarchy
☛
INSURANCE (Software Component) SAP Insurance
⤷ FS-CM (Application Component) Claims Management
⤷ ICL_WCOMP (Package) Workers Compensation
⤷ FS-CM (Application Component) Claims Management
⤷ ICL_WCOMP (Package) Workers Compensation
Basic Data
Table Category | INTTAB | Structure |
Structure | ICL_WCMP_ICLW40_ALV_S_UI | Table Relationship Diagram |
Short Description | Workers Comp - View ICLW40 ALV Grid |
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 | .INCLUDE | 0 | 0 | Workers Comp - Header Data | |||||
2 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | * | |
3 | ACTIVE | ICL_ACTIVE | ICL_ACTIVE | CHAR | 1 | 0 | Table entry is active (A) or in suspense (S) | ||
4 | CLAIM | ICL_CLAIM | ICL_CLAIM | CHAR | 17 | 0 | Number of Claim | * | |
5 | SUBCLAIM | ICL_SUBCL | ICL_SUBCL | CHAR | 3 | 0 | Subclaim | * | |
6 | WCMPH_SEQNUM | ICL_WCMP_SEQNUM | SYSUUID_C | CHAR | 32 | 0 | Sequence Number of Header Data | ||
7 | .INCLUDE | 0 | 0 | Shadow Tables Versioning: Include for Original Table | |||||
8 | CHANGETIME | ICL_CHANGEUTC1 | ICL_TIMESTAMP | DEC | 15 | 0 | Changed: UTC Date+Time | ||
9 | CHANGEDBY | ICL_CHANGEDBY | XUBNAME | CHAR | 12 | 0 | Changed By | USR02 | |
10 | DELETED | ICL_RECSTATUS | ICL_RECSTATUS | CHAR | 1 | 0 | Database Line Status (Original, Changed, Deleted) | ||
11 | .INCLUDE | 0 | 0 | Workers Compensation - Header Structure | |||||
12 | .INCLUDE | 0 | 0 | Workers Compensation - Benefits Catalag (Ext.Catalog Item) | |||||
13 | COUNTRY | ICL_JURICOUNTRY | LAND1 | CHAR | 3 | 0 | Jurisdiction Country | T005 | |
14 | REGION | ICL_JURISREGION | REGIO | CHAR | 3 | 0 | Jurisdiction Region | T005S | |
15 | DISABILITY_CLASS | ICL_DISABILITY_CLASS | ICL_DISABILITY_CLASS | CHAR | 2 | 0 | Disability Class | TICL460 | |
16 | AWW | ICL_EMP_PREINJURY_AWW | ICL_RESAMOUNT | CURR | 15 | 2 | Pre-Injury Average Weekly Wage | ||
17 | POST_AWW | ICL_EMP_POSTINJURY_AWW | ICL_RESAMOUNT | CURR | 15 | 2 | Average Weekly Wage After Injury | ||
18 | LOSSDATE | ICL_LOSSDATE | DATE | DATS | 8 | 0 | Date of Loss/Claim | ||
19 | STARTDATE | ICL_WCMP_STARTDATE | ICL_WCMP_DATE | DATS | 8 | 0 | Last Day Worked | ||
20 | EXPENDDATE | ICL_WCMP_EXPENDDATE | ICL_WCMP_DATE | DATS | 8 | 0 | Expected Date of Return to Work (YYYYMMDD) | ||
21 | ENDDATE | ICL_EMP_INITIALRTW | ICL_INITIALRTW | DATS | 8 | 0 | Initial Return to Work Date | ||
22 | MMI_DATE | ICL_EMP_MMI_DATE | ICL_MMI_DATE | DATS | 8 | 0 | Date of Maximum Medical Improvement | ||
23 | NUM_EXEMPT | ICL_EMP_NUMOFENTEXEMPTIONS | NUM2 | NUMC | 2 | 0 | Employee Number of Entitled Exemptions | ||
24 | NUMOFWHDEXEMPTIO | ICL_EMP_NUMOFWHDEXEMPTIONS | NUM2 | NUMC | 2 | 0 | Employee Number of Withholding Exemptions | ||
25 | CURRENCY | ICL_CURRENCY | WAERS | CUKY | 5 | 0 | Currency | * | |
26 | SERVCAT | ICL_SERVCAT_POSID_INT | SYSUUID_C | CHAR | 32 | 0 | Internal ID of Benefits Catalog Item | ||
27 | NUM_DEPENDANTS | ICL_EMP_NUMOFDEPENDENTS | NUM2 | NUMC | 2 | 0 | Employee Number of Dependents | ||
28 | MARITAL_STATUS | ICL_WCMP_MARITALSTATUS | ICL_WCMP_MARST | CHAR | 1 | 0 | Marital Status | ||
29 | BENEFIT_OFFSET | ICL_WCMP_OFFSET | ICL_ITAMTS | CURR | 15 | 2 | Amount Offset | ||
30 | PAID_FOR_DOI | ICL_WCMP_PAID_FOR_DOI | XFELD | CHAR | 1 | 0 | Paid for Day of Injury | ||
31 | COLOR | ICL_COLOR | CHAR10 | CHAR | 10 | 0 | Color | ||
32 | DISABILITY_CLASST | ICL_DISABILITY_CLASST | ICL_TXT50 | CHAR | 50 | 0 | Name of Disability Class | ||
33 | DETAIL_SELECT | ICL_DETAIL_SELECT | CHAR | 50 | 0 | Details | |||
34 | CALCULATION | CL_ICL_WCMP_CALC_AL | REF | 0 | 0 | ||||
35 | REPPAY_EXISTS | ICL_WCMP_REPREIMB_EXISTS | XFELD | CHAR | 1 | 0 | Repetitive Payment Record Exists |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ICL_WCMP_ICLW40_ALV_S_UI | CHANGEDBY | USR02 | BNAME | |||
2 | ICL_WCMP_ICLW40_ALV_S_UI | COUNTRY | T005 | LAND1 | |||
3 | ICL_WCMP_ICLW40_ALV_S_UI | DISABILITY_CLASS | TICL460 | DISABILITY_CLASS | 1 | CN | |
4 | ICL_WCMP_ICLW40_ALV_S_UI | REGION | T005S | BLAND |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in | 600 |