SAP ABAP Table ICSITEM (Claim Item)
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 | TRANSP | Transparent table |
Transparent table | ICSITEM | Table Relationship Diagram |
Short Description | Claim Item |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | A | Application Table (Master- and Transaction Data) |
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_CLAIM | ICL_CLAIM | CHAR | 17 | 0 | Number of Claim | ICLCLAIM | |
4 | SUBCLAIM | ICL_SUBCL | ICL_SUBCL | CHAR | 3 | 0 | Subclaim | ICLSUBCL | |
5 | ITEM | ICL_SCLITEM | ICL_SCLITEM | CHAR | 4 | 0 | Claim Item | * | |
6 | CHANGETIME | ICL_CHANGEUTC1 | ICL_TIMESTAMP | DEC | 15 | 0 | Changed: UTC Date+Time | ||
7 | .INCLUDE | 0 | 0 | Shadow Tables Versioning: Include for Shade Table | |||||
8 | CHANGEDBY | ICL_CHANGEDBY | XUBNAME | CHAR | 12 | 0 | Changed By | USR02 | |
9 | DELETED | ICL_RECSTATUS | ICL_RECSTATUS | CHAR | 1 | 0 | Database Line Status (Original, Changed, Deleted) | ||
10 | .INCLUDE | 0 | 0 | Attributes of ICLITEM | |||||
11 | .INCLUDE | 0 | 0 | Classification of Claim Items | |||||
12 | ITEMCAT | ICL_ITEMCAT | ICL_ITEMCAT | CHAR | 2 | 0 | Claim Item Category | TICL139 | |
13 | ITEMTYPE | ICL_ITEMTYPE | ICL_IOBTYPE | CHAR | 3 | 0 | Claim Item Object Type | TICL164 | |
14 | ITEMUSE | ICL_ITEMUSE | ICL_ITEMUSE | CHAR | 2 | 0 | Usage Type of Claim Item | TICL332 | |
15 | .INCLUDE | 0 | 0 | Claim Item - Fields for Coverage Check | |||||
16 | COVTYPE | ICL_COVTYPE | ICL_COVTYPE | CHAR | 10 | 0 | Coverage Type | * | |
17 | BENTYPE | ICL_BENTYPE | ICL_BENTYPE | CHAR | 10 | 0 | Benefit Type | TICL055 | |
18 | RCOVTYPE | ICL_RCOVTYPE | ICL_COVTYPE | CHAR | 10 | 0 | Benefit Coverage Type | * | |
19 | XWAITPERIOD | ICL_XWAITPERIOD | XFELD | CHAR | 1 | 0 | Probationary Periods Ignored | ||
20 | COVERAGE | ICL_POLM | ICL_POLM | CHAR | 4 | 0 | Coverage | * | |
21 | .INCLUDE | 0 | 0 | FS-CM: Benefits/Services/Fees Catalogs in ICLITEM | |||||
22 | SCPOSID_INT | ICL_SERVCAT_POSID_INT | SYSUUID_C | CHAR | 32 | 0 | Internal ID of Benefits Catalog Item | ||
23 | SERVCAT | ICL_SERVCATID | ICL_SERVCATID | CHAR | 10 | 0 | ID of a Benefits, Services and Fees Catalog | * | |
24 | SCPOSID_EXT | ICL_SERVCAT_POSID | ICL_SERVCAT_POSID | CHAR | 20 | 0 | ID of a Benefits Catalog Item | ||
25 | .INCLUDE | 0 | 0 | Claim Items - Status Fields | |||||
26 | STATUS | ICL_SCLITEMS | ICL_SCLITEMS | CHAR | 2 | 0 | Status of Claim Item | ||
27 | REJREASON | ICL_REJREASON | ICL_REJREASON | CHAR | 2 | 0 | Claim Item Rejection Reason | TICL043 | |
28 | MODIFIED | ICL_MODIFIED | XFELD | CHAR | 1 | 0 | Modified | ||
29 | PROCURED | ICL_PROCURED | XFELD | CHAR | 1 | 0 | Ordered | ||
30 | CALCULATED | ICL_CALCULATED | XFELD | CHAR | 1 | 0 | Calculated | ||
31 | .INCLUDE | 0 | 0 | Claim Items - Descriptive Fields | |||||
32 | DESCRIPTION | ICL_DPDESC | TEXT40 | CHAR | 40 | 0 | Claim Item Description | ||
33 | DAILY | ICL_DAILY | NUMC | 1 | 0 | Daily | |||
34 | WEEKLY | ICL_WEEKLY | NUMC | 1 | 0 | Weekly | |||
35 | MONTHLY | ICL_MONTHLY | NUMC | 2 | 0 | Monthly | |||
36 | TOTAL | ICL_TOTAL | NUMC | 3 | 0 | Total | |||
37 | .INCLUDE | 0 | 0 | Claim Items - Fields for Data and Time Details | |||||
38 | VALIDFROM | ICL_VALIDFROM | DATE | DATS | 8 | 0 | Claim Item: Valid From | ||
39 | VALIDTO | ICL_VALIDTO | DATE | DATS | 8 | 0 | Claim Item: Valid To | ||
40 | STARTDATE | ICL_STARTDATE | DATE | DATS | 8 | 0 | Start Date | ||
41 | ENDDATE | ICL_ENDDATE | DATUM | DATS | 8 | 0 | End Date | ||
42 | .INCLUDE | 0 | 0 | Claim Items - Fields for Evaluation | |||||
43 | DNUMBER | ICL_NUMBER | DEC5 | DEC | 5 | 0 | Number | ||
44 | EVALUATION | ICL_EVALUATION1 | ICL_EVALUATION | NUMC | 2 | 0 | Valid claim item evaluation | ICLITEMEV | |
45 | EVALCAT | ICL_EVALCAT | ICL_EVALCAT | CHAR | 2 | 0 | Evaluation Category | * | |
46 | EVALBASE | ICL_EVALBASE | ICL_EVALBASE | CHAR | 3 | 0 | Type of Evaluator | TICL026 | |
47 | EVQUANTITY | ICL_EVQUANTITY | ICL_LIMAMT | QUAN | 10 | 3 | Claim Item: Number (Days, Visits, Area) for Evaluation | ||
48 | EVQUANUNIT | ICL_EVQUANUNIT | MEINS | UNIT | 3 | 0 | Claim Item: Unit of Measurement | * | |
49 | EVAMTPERUNIT | ICL_EVAMTPERUNIT | ICL_ITAMT | CURR | 15 | 2 | Amount per Unit | ||
50 | EVAMOUNT | ICL_EVAMOUNT | ICL_ITAMTS | CURR | 15 | 2 | Evaluated Amount | ||
51 | EVCURR | ICL_EVCURR | WAERS | CUKY | 5 | 0 | Currency of Evaluated Amount | TCURC | |
52 | FACTOR | ICLH_FACTOR | ICLH_FACTOR | DEC | 7 | 4 | Factor | ||
53 | ACV | ICL_ACV | ICL_ITAMT | CURR | 15 | 2 | Actual Cash Value | ||
54 | ACVPERCENT | ICL_ACVPER | ICL_PERCENT | DEC | 5 | 2 | Proportion of Actual Cash Value to Original Cash Value in % | ||
55 | CALCEXPRESSION | ICL_CALC_EXPRESSION | BRF_EXPRESSION | CHAR | 20 | 0 | BRF Expression for Calculating Payout Amount | * | |
56 | .INCLUDE | 0 | 0 | Claim Items - Discount Fields | |||||
57 | PERDAY | ICL_PERDAY | ICL_ITAMT | CURR | 15 | 2 | Amount per Day | ||
58 | DISCOUNTPERCENT | ICL_DISCOUNTPERCENT | ICL_PERCENT | DEC | 5 | 2 | Discount on Total Invoice Amount in Percent | ||
59 | XDISCOUNTUSED | ICL_XDISCOUNTUSED | BOOLE | CHAR | 1 | 0 | Discount Amount from Table Applied with Invoice | ||
60 | XDISCOUNTPERCENT | ICL_XDISCOUNTPERCENT | BOOLE | CHAR | 1 | 0 | Discount Amount Without Reference to Percent Discount | ||
61 | XDISC_2B_APPLIED | ICL_XDISC_2B_APPLIED | BOOLE | CHAR | 1 | 0 | Indicator: Discount to Be Applied | ||
62 | .INCLUDE | 0 | 0 | Claim Items - Value-Added Tax Fields | |||||
63 | GROSNET | ICL_GROSNET | XFELD | CHAR | 1 | 0 | Flag: Amount Is Net Amount | ||
64 | TXCOD | ICL_TXCOD | MWSKZ | CHAR | 2 | 0 | Tax Code | * | |
65 | .INCLUDE | 0 | 0 | Claim Items - References to Subobjects of a Claim | |||||
66 | SUBCLREF | ICL_SUBCLREF | ICL_SUBCL | CHAR | 3 | 0 | Subclaim to Which a Claim Item Is Assigned | * | |
67 | PROCUREMENT | ICL_PROCUREMENT | ICL_PROCUREMENT | NUMC | 4 | 0 | ID of Claim Item Grouping | * | |
68 | ITEM_REF | ICL_SCLITEM | ICL_SCLITEM | CHAR | 4 | 0 | Claim Item | * | |
69 | DAMAGEDOBJ | ICL_DAMOBJ | ICL_DAMOBJ | NUMC | 4 | 0 | Damaged Object | ICLDAMOBJ | |
70 | ASSIGN_GUID | ICL_ASSIGN_GUID | SYSUUID_C | CHAR | 32 | 0 | UUID of Entry to be Linked | ||
71 | .INCLUDE | 0 | 0 | Claim Items - External Reference Numbers | |||||
72 | REFNO | ICL_SCLITEMREF | ICL_SCLITEMREF | CHAR | 15 | 0 | External Reference Number | ||
73 | PDREF | ICL_PDREF | ICL_PDREF_DOMAIN | CHAR | 10 | 0 | Reference to Purchasing Document | ||
74 | PDPOS | ICL_PDPOS | ICL_PDPOS | NUMC | 10 | 0 | Reference to Item Number in Purchasing Document | ||
75 | REF_LOCCAT | ICL_EXTSVCS_REFCAT | ICL_EXTSVCS_REFCAT | CHAR | 2 | 0 | Category of Reference Location for External Services | * | |
76 | PTYPE | ICL_PTYPE | ICL_PTYPE | CHAR | 4 | 0 | Transaction Type in Procurement Process | * | |
77 | .INCLUDE | 0 | 0 | Probably Obsolete | |||||
78 | XGENEROS | ICL_XGENEROS | XFELD | CHAR | 1 | 0 | Flag: Ex Gratia Payment? | ||
79 | .INCLUDE | 0 | 0 | Claim Items - Additional Items | |||||
80 | ADDITIONAL_ITEM | ICL_ITEM_SPLIT_D | ICL_ITEM_SPLIT_DO | CHAR | 1 | 0 | Additional Claim Item | ||
81 | ADDIT_ITEM_SUM | ICL_ITEM_SUM_D | XFELD | CHAR | 1 | 0 | Total of Additional Claim Items | ||
82 | REMUN_TYPE | ICL_REMUN_TYPE_D_PE | ICL_REMUN_TYPE_D_PE | CHAR | 4 | 0 | Remuneration Category |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ICSITEM | BENTYPE | TICL055 | BENTYPE | |||
2 | ICSITEM | CHANGEDBY | USR02 | BNAME | |||
3 | ICSITEM | CLAIM | ICLCLAIM | CLAIM | |||
4 | ICSITEM | CLIENT | T000 | MANDT | |||
5 | ICSITEM | DAMAGEDOBJ | ICLDAMOBJ | DAMAGEDOBJ | |||
6 | ICSITEM | EVALBASE | TICL026 | EVALBASE | |||
7 | ICSITEM | EVALUATION | ICLITEMEV | EVALUATION | |||
8 | ICSITEM | EVCURR | TCURC | WAERS | |||
9 | ICSITEM | ITEMCAT | TICL139 | ITEMCAT | |||
10 | ICSITEM | ITEMTYPE | TICL164 | ITEMTYPE | |||
11 | ICSITEM | ITEMUSE | TICL332 | ITEMUSE | KEY | 1 | CN |
12 | ICSITEM | REJREASON | TICL043 | REJREASON | |||
13 | ICSITEM | SUBCLAIM | ICLSUBCL | SUBCLAIM |
History
Last changed by/on | SAP | 20110901 |
SAP Release Created in |