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