SAP ABAP Table ICL_ITEMLIST (ICL: GUI Structure for Claim Item List (Screen 301))
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_ITEMLIST | Table Relationship Diagram |
Short Description | ICL: GUI Structure for Claim Item List (Screen 301) |
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 | DETAIL_SELECT | ICL_DETAIL_SELECT | CHAR | 50 | 0 | Details | |||
2 | SEL | ICL_PAI_ITEM | BOOLE | CHAR | 1 | 0 | Flag: Pay Out Claim Item? | ||
3 | BENTYPENAME | ICL_BENTYPEN | ICL_BENTYPEN | CHAR | 80 | 0 | Benefit Type Name | ||
4 | EVAMTCCALCOLD | ICL_EVAMOUNT | ICL_ITAMTS | CURR | 15 | 2 | Evaluated Amount | ||
5 | EVCURRNAME | KTEXT_CURT | TEXT15 | CHAR | 15 | 0 | Short text | ||
6 | EVQUANUNITN3 | ICL_EVQMSEH3 | MSEH3 | CHAR | 3 | 0 | External Unit of Measurement in Commercial Format (3-Char.) | ||
7 | EVQUANUNITN6 | ICL_EVQMSEH6 | MSEH6 | CHAR | 6 | 0 | External Unit of Measurement in Technical Format (6-Char.) | ||
8 | EVQUANUNITNT | ICL_EVQMSEHT | TEXT10 | CHAR | 10 | 0 | Unit of Measurement Text (Maximum 10 Characters) | ||
9 | EVQUANUNITNL | ICL_EVQMSEHL | TEXT30 | CHAR | 30 | 0 | Unit of Measurement Text (Maximum 30 Characters) | ||
10 | CLMDAMOUNT | ICL_CLMDAMOUNT | ICL_ITAMTS | CURR | 15 | 2 | Claimed Amount | ||
11 | GROSAMOUNT | ICL_GROSAMOUNT | ICL_ITAMT | CURR | 15 | 2 | Gross Amount | ||
12 | GROSAMTCURR | ICL_GROSAMTCURR | WAERS | CUKY | 5 | 0 | Currency of Gross Amount | TCURC | |
13 | TAXAMOUNT | ICL_TAXAMOUNT | ICL_ITAMT | CURR | 15 | 2 | Value-Added Tax Amount | ||
14 | TAXAMTCURR | ICL_TAXAMTCURR | WAERS | CUKY | 5 | 0 | Currency of Value-Added Tax Amount | TCURC | |
15 | EVDATE | ICL_EVDATE | DATE | DATS | 8 | 0 | Valuation Date | ||
16 | LIABRATE | ICL_LIABRATEI | ICL_PERCENT | DEC | 5 | 2 | Liability Rate in Percent | ||
17 | XARCHDOC | ICL_XARCHDOC | XFELD | CHAR | 1 | 0 | Archived Document Assigned? | ||
18 | REJREASONN | ICL_REJREASONN | TEXT20 | CHAR | 20 | 0 | Claim Item Rejection Reason Name | ||
19 | COVTYPEN | ICL_COVTYPEN | TEXT50 | CHAR | 50 | 0 | Name of Coverage Type | ||
20 | RCOVTYPEN | ICL_RCOVTYPEN | TEXT30 | CHAR | 30 | 0 | Coverage Type Name | ||
21 | SUBCLTYPE | ICL_SUBCLTYPE | ICL_SUBCLTYPE | CHAR | 4 | 0 | Subclaim Type | * | |
22 | SUBCLNAME | ICL_SUBCLDESCRIP | TEXT20 | CHAR | 20 | 0 | Name of Claim/Subclaim | ||
23 | PAID | ICL_PAID | BOOLE | CHAR | 1 | 0 | Has Claim Item Already Been Paid Out (Yes = "X") | ||
24 | PUSH_CITDET_ICLC31 | ICL_PUSH_DET | CHAR10 | CHAR | 10 | 0 | Claim Item Evaluation | ||
25 | DAMAGEDOBJNAME | ICL_DAMAGEDOBJNAME | CHAR30 | CHAR | 30 | 0 | Description of Damaged Object | ||
26 | INSUREDOBJ | ICL_INSOBJ | ICL_INSOBJ | NUMC | 4 | 0 | Insured Object Number | * | |
27 | ITEMTYPEN | ICL_ITEMTYPEN | TEXT30 | CHAR | 30 | 0 | Claim Item Type Description | ||
28 | STATUSTXT | ICL_ISTATTXT | DDTEXT | CHAR | 60 | 0 | Text for Claim Item Status | ||
29 | .INCLUDE | 0 | 0 | Additional Info to Claim Item Evaluation: Procurement Data | |||||
30 | CATALOGID | ICL_CATALOGID | ICL_CATALOGID | CHAR | 4 | 0 | Catalog ID | * | |
31 | CATALOGITEM | ICL_CATALOGITEM | CHAR40 | CHAR | 40 | 0 | Catalog Item Number | ||
32 | MATNR | MATNR | MATNR | CHAR | 18 | 0 | Material Number | * | |
33 | MATGROUP | ICL_MATGROUP | CHAR10 | CHAR | 10 | 0 | EBP: Material Group | ||
34 | PRICE_UNIT | EPEIN | DEC5 | DEC | 5 | 0 | Price unit | ||
35 | VENDOR_CATALOG | ICL_SUPPL | BU_PARTNER | CHAR | 10 | 0 | Supplier | * | |
36 | VENDORMAT | ICL_VENDORMAT | CHAR22 | CHAR | 22 | 0 | Product Number of Vendor | ||
37 | MANUFACTCODE | ICL_MANUFACTCODE | CHAR10 | CHAR | 10 | 0 | EBP: Manufacturer Code | ||
38 | MANUFACTMAT | ICL_MANUFACTMAT | CHAR40 | CHAR | 40 | 0 | EBP: Part Number of Manufacturer | ||
39 | SERVICE | ICL_SERVICE | XFELD | CHAR | 1 | 0 | EBP: Service Flag | ||
40 | CUST_FIELD1 | ICL_CUST_FIELD1 | CHAR10 | CHAR | 10 | 0 | BBP: Catalog - Customer Field 1 | ||
41 | CUST_FIELD2 | ICL_CUST_FIELD2 | CHAR10 | CHAR | 10 | 0 | BBP: Catalog - Customer Field 2 | ||
42 | CUST_FIELD3 | ICL_CUST_FIELD3 | CHAR10 | CHAR | 10 | 0 | BBP: Catalog - Customer Field 3 | ||
43 | CUST_FIELD4 | ICL_CUST_FIELD4 | CHAR20 | CHAR | 20 | 0 | BBP: Catalog - Customer Field 4 | ||
44 | CUST_FIELD5 | ICL_CUST_FIELD5 | CHAR50 | CHAR | 50 | 0 | BBP: Catalog - Customer Field 5 | ||
45 | .INCLUDE | 0 | 0 | Claim Item | |||||
46 | CLIENT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
47 | ACTIVE | ICL_ACTIVE | ICL_ACTIVE | CHAR | 1 | 0 | Table entry is active (A) or in suspense (S) | ||
48 | CLAIM | ICL_CLAIM | ICL_CLAIM | CHAR | 17 | 0 | Number of Claim | ICLCLAIM | |
49 | SUBCLAIM | ICL_SUBCL | ICL_SUBCL | CHAR | 3 | 0 | Subclaim | ICLSUBCL | |
50 | ITEM | ICL_SCLITEM | ICL_SCLITEM | CHAR | 4 | 0 | Claim Item | * | |
51 | .INCLUDE | 0 | 0 | Shadow Tables Versioning: Include for Original Table | |||||
52 | CHANGETIME | ICL_CHANGEUTC1 | ICL_TIMESTAMP | DEC | 15 | 0 | Changed: UTC Date+Time | ||
53 | CHANGEDBY | ICL_CHANGEDBY | XUBNAME | CHAR | 12 | 0 | Changed By | USR02 | |
54 | DELETED | ICL_RECSTATUS | ICL_RECSTATUS | CHAR | 1 | 0 | Database Line Status (Original, Changed, Deleted) | ||
55 | .INCLUDE | 0 | 0 | Attributes of ICLITEM | |||||
56 | .INCLUDE | 0 | 0 | Classification of Claim Items | |||||
57 | ITEMCAT | ICL_ITEMCAT | ICL_ITEMCAT | CHAR | 2 | 0 | Claim Item Category | TICL139 | |
58 | ITEMTYPE | ICL_ITEMTYPE | ICL_IOBTYPE | CHAR | 3 | 0 | Claim Item Object Type | TICL164 | |
59 | ITEMUSE | ICL_ITEMUSE | ICL_ITEMUSE | CHAR | 2 | 0 | Usage Type of Claim Item | TICL332 | |
60 | .INCLUDE | 0 | 0 | Claim Item - Fields for Coverage Check | |||||
61 | COVTYPE | ICL_COVTYPE | ICL_COVTYPE | CHAR | 10 | 0 | Coverage Type | * | |
62 | BENTYPE | ICL_BENTYPE | ICL_BENTYPE | CHAR | 10 | 0 | Benefit Type | TICL055 | |
63 | RCOVTYPE | ICL_RCOVTYPE | ICL_COVTYPE | CHAR | 10 | 0 | Benefit Coverage Type | * | |
64 | XWAITPERIOD | ICL_XWAITPERIOD | XFELD | CHAR | 1 | 0 | Probationary Periods Ignored | ||
65 | COVERAGE | ICL_POLM | ICL_POLM | CHAR | 4 | 0 | Coverage | * | |
66 | .INCLUDE | 0 | 0 | FS-CM: Benefits/Services/Fees Catalogs in ICLITEM | |||||
67 | SCPOSID_INT | ICL_SERVCAT_POSID_INT | SYSUUID_C | CHAR | 32 | 0 | Internal ID of Benefits Catalog Item | ||
68 | SERVCAT | ICL_SERVCATID | ICL_SERVCATID | CHAR | 10 | 0 | ID of a Benefits, Services and Fees Catalog | * | |
69 | SCPOSID_EXT | ICL_SERVCAT_POSID | ICL_SERVCAT_POSID | CHAR | 20 | 0 | ID of a Benefits Catalog Item | ||
70 | .INCLUDE | 0 | 0 | Claim Items - Status Fields | |||||
71 | STATUS | ICL_SCLITEMS | ICL_SCLITEMS | CHAR | 2 | 0 | Status of Claim Item | ||
72 | REJREASON | ICL_REJREASON | ICL_REJREASON | CHAR | 2 | 0 | Claim Item Rejection Reason | TICL043 | |
73 | MODIFIED | ICL_MODIFIED | XFELD | CHAR | 1 | 0 | Modified | ||
74 | PROCURED | ICL_PROCURED | XFELD | CHAR | 1 | 0 | Ordered | ||
75 | CALCULATED | ICL_CALCULATED | XFELD | CHAR | 1 | 0 | Calculated | ||
76 | .INCLUDE | 0 | 0 | Claim Items - Descriptive Fields | |||||
77 | DESCRIPTION | ICL_DPDESC | TEXT40 | CHAR | 40 | 0 | Claim Item Description | ||
78 | DAILY | ICL_DAILY | NUMC | 1 | 0 | Daily | |||
79 | WEEKLY | ICL_WEEKLY | NUMC | 1 | 0 | Weekly | |||
80 | MONTHLY | ICL_MONTHLY | NUMC | 2 | 0 | Monthly | |||
81 | TOTAL | ICL_TOTAL | NUMC | 3 | 0 | Total | |||
82 | .INCLUDE | 0 | 0 | Claim Items - Fields for Data and Time Details | |||||
83 | VALIDFROM | ICL_VALIDFROM | DATE | DATS | 8 | 0 | Claim Item: Valid From | ||
84 | VALIDTO | ICL_VALIDTO | DATE | DATS | 8 | 0 | Claim Item: Valid To | ||
85 | STARTDATE | ICL_STARTDATE | DATE | DATS | 8 | 0 | Start Date | ||
86 | ENDDATE | ICL_ENDDATE | DATUM | DATS | 8 | 0 | End Date | ||
87 | .INCLUDE | 0 | 0 | Claim Items - Fields for Evaluation | |||||
88 | DNUMBER | ICL_NUMBER | DEC5 | DEC | 5 | 0 | Number | ||
89 | EVALUATION | ICL_EVALUATION1 | ICL_EVALUATION | NUMC | 2 | 0 | Valid claim item evaluation | ICLITEMEV | |
90 | EVALCAT | ICL_EVALCAT | ICL_EVALCAT | CHAR | 2 | 0 | Evaluation Category | * | |
91 | EVALBASE | ICL_EVALBASE | ICL_EVALBASE | CHAR | 3 | 0 | Type of Evaluator | TICL026 | |
92 | EVQUANTITY | ICL_EVQUANTITY | ICL_LIMAMT | QUAN | 10 | 3 | Claim Item: Number (Days, Visits, Area) for Evaluation | ||
93 | EVQUANUNIT | ICL_EVQUANUNIT | MEINS | UNIT | 3 | 0 | Claim Item: Unit of Measurement | * | |
94 | EVAMTPERUNIT | ICL_EVAMTPERUNIT | ICL_ITAMT | CURR | 15 | 2 | Amount per Unit | ||
95 | EVAMOUNT | ICL_EVAMOUNT | ICL_ITAMTS | CURR | 15 | 2 | Evaluated Amount | ||
96 | EVCURR | ICL_EVCURR | WAERS | CUKY | 5 | 0 | Currency of Evaluated Amount | TCURC | |
97 | FACTOR | ICLH_FACTOR | ICLH_FACTOR | DEC | 7 | 4 | Factor | ||
98 | ACV | ICL_ACV | ICL_ITAMT | CURR | 15 | 2 | Actual Cash Value | ||
99 | ACVPERCENT | ICL_ACVPER | ICL_PERCENT | DEC | 5 | 2 | Proportion of Actual Cash Value to Original Cash Value in % | ||
100 | CALCEXPRESSION | ICL_CALC_EXPRESSION | BRF_EXPRESSION | CHAR | 20 | 0 | BRF Expression for Calculating Payout Amount | * | |
101 | .INCLUDE | 0 | 0 | Claim Items - Discount Fields | |||||
102 | PERDAY | ICL_PERDAY | ICL_ITAMT | CURR | 15 | 2 | Amount per Day | ||
103 | DISCOUNTPERCENT | ICL_DISCOUNTPERCENT | ICL_PERCENT | DEC | 5 | 2 | Discount on Total Invoice Amount in Percent | ||
104 | XDISCOUNTUSED | ICL_XDISCOUNTUSED | BOOLE | CHAR | 1 | 0 | Discount Amount from Table Applied with Invoice | ||
105 | XDISCOUNTPERCENT | ICL_XDISCOUNTPERCENT | BOOLE | CHAR | 1 | 0 | Discount Amount Without Reference to Percent Discount | ||
106 | XDISC_2B_APPLIED | ICL_XDISC_2B_APPLIED | BOOLE | CHAR | 1 | 0 | Indicator: Discount to Be Applied | ||
107 | .INCLUDE | 0 | 0 | Claim Items - Value-Added Tax Fields | |||||
108 | GROSNET | ICL_GROSNET | XFELD | CHAR | 1 | 0 | Flag: Amount Is Net Amount | ||
109 | TXCOD | ICL_TXCOD | MWSKZ | CHAR | 2 | 0 | Tax Code | * | |
110 | .INCLUDE | 0 | 0 | Claim Items - References to Subobjects of a Claim | |||||
111 | SUBCLREF | ICL_SUBCLREF | ICL_SUBCL | CHAR | 3 | 0 | Subclaim to Which a Claim Item Is Assigned | * | |
112 | PROCUREMENT | ICL_PROCUREMENT | ICL_PROCUREMENT | NUMC | 4 | 0 | ID of Claim Item Grouping | ICLPROCURE | |
113 | ITEM_REF | ICL_SCLITEM | ICL_SCLITEM | CHAR | 4 | 0 | Claim Item | * | |
114 | DAMAGEDOBJ | ICL_DAMOBJ | ICL_DAMOBJ | NUMC | 4 | 0 | Damaged Object | ICLDAMOBJ | |
115 | ASSIGN_GUID | ICL_ASSIGN_GUID | SYSUUID_C | CHAR | 32 | 0 | UUID of Entry to be Linked | ||
116 | .INCLUDE | 0 | 0 | Claim Items - External Reference Numbers | |||||
117 | REFNO | ICL_SCLITEMREF | ICL_SCLITEMREF | CHAR | 15 | 0 | External Reference Number | ||
118 | PDREF | ICL_PDREF | ICL_PDREF_DOMAIN | CHAR | 10 | 0 | Reference to Purchasing Document | ||
119 | PDPOS | ICL_PDPOS | ICL_PDPOS | NUMC | 10 | 0 | Reference to Item Number in Purchasing Document | ||
120 | REF_LOCCAT | ICL_EXTSVCS_REFCAT | ICL_EXTSVCS_REFCAT | CHAR | 2 | 0 | Category of Reference Location for External Services | * | |
121 | PTYPE | ICL_PTYPE | ICL_PTYPE | CHAR | 4 | 0 | Transaction Type in Procurement Process | * | |
122 | .INCLUDE | 0 | 0 | Probably Obsolete | |||||
123 | XGENEROS | ICL_XGENEROS | XFELD | CHAR | 1 | 0 | Flag: Ex Gratia Payment? | ||
124 | .INCLUDE | 0 | 0 | Claim Items - Additional Items | |||||
125 | ADDITIONAL_ITEM | ICL_ITEM_SPLIT_D | ICL_ITEM_SPLIT_DO | CHAR | 1 | 0 | Additional Claim Item | ||
126 | ADDIT_ITEM_SUM | ICL_ITEM_SUM_D | XFELD | CHAR | 1 | 0 | Total of Additional Claim Items | ||
127 | REMUN_TYPE | ICL_REMUN_TYPE_D_PE | ICL_REMUN_TYPE_D_PE | CHAR | 4 | 0 | Remuneration Category | ICL_CREMUNTYPE | |
128 | .INCLUDE | 0 | 0 | ICLH_LVC_INCL_SERVCAT: Include for Benefits/Serv/Fee Catlg | |||||
129 | SERVCATID | ICL_SERVCATID | ICL_SERVCATID | CHAR | 10 | 0 | ID of a Benefits, Services and Fees Catalog | * | |
130 | SERVCATIDLN | ICL_SERVCATNAME | TEXT30 | CHAR | 30 | 0 | Name of Benefits/Services/Fee Catalog | ||
131 | SCPOSID | ICL_SERVCAT_POSID | ICL_SERVCAT_POSID | CHAR | 20 | 0 | ID of a Benefits Catalog Item | ||
132 | SCPOSLN | ICL_SERVCAT_POS_NAME | TEXT100 | CHAR | 100 | 0 | Long Text of Benefits Catalog Item | ||
133 | COLOR | CHAR4 | CHAR4 | CHAR | 4 | 0 | Not More Closely Defined Area, Possibly Used for Patchlevels | ||
134 | XSERV_OK | ICL_XSERV_OKAY | XFELD | CHAR | 1 | 0 | External Services: Status Identified | ||
135 | XSERV_PROCURE | ICL_XSERV_PROCUREMENT | XFELD | CHAR | 1 | 0 | External Services: Vendor Contacted | ||
136 | SEQNUM | ICL_SEQNUM | ICL_SEQNUM | NUMC | 4 | 0 | Item Sequence Number | ||
137 | SUB_SEQNUM | ICL_SUB_SEQNUM_D | NUMC | 2 | 0 | Sequence Subitem Number | |||
138 | COVERAGEN | ICL_COVERAGEN_D | TEXT50 | CHAR | 50 | 0 | Name of Coverage |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | ICL_ITEMLIST | BENTYPE | TICL055 | BENTYPE | |||
2 | ICL_ITEMLIST | CHANGEDBY | USR02 | BNAME | |||
3 | ICL_ITEMLIST | CLAIM | ICLCLAIM | CLAIM | |||
4 | ICL_ITEMLIST | CLIENT | T000 | MANDT | |||
5 | ICL_ITEMLIST | DAMAGEDOBJ | ICLDAMOBJ | DAMAGEDOBJ | |||
6 | ICL_ITEMLIST | EVALBASE | TICL026 | EVALBASE | |||
7 | ICL_ITEMLIST | EVALUATION | ICLITEMEV | EVALUATION | |||
8 | ICL_ITEMLIST | EVCURR | TCURC | WAERS | |||
9 | ICL_ITEMLIST | GROSAMTCURR | TCURC | WAERS | |||
10 | ICL_ITEMLIST | ITEMCAT | TICL139 | ITEMCAT | KEY | 1 | CN |
11 | ICL_ITEMLIST | ITEMTYPE | TICL164 | ITEMTYPE | |||
12 | ICL_ITEMLIST | ITEMUSE | TICL332 | ITEMUSE | KEY | 1 | CN |
13 | ICL_ITEMLIST | PROCUREMENT | ICLPROCURE | PROCUREMENT | |||
14 | ICL_ITEMLIST | REJREASON | TICL043 | REJREASON | |||
15 | ICL_ITEMLIST | REMUN_TYPE | ICL_CREMUNTYPE | REMUN_TYPE | KEY | 1 | CN |
16 | ICL_ITEMLIST | SUBCLAIM | ICLSUBCL | SUBCLAIM | |||
17 | ICL_ITEMLIST | TAXAMTCURR | TCURC | WAERS |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |