SAP ABAP Table ICL_PROCURE (Claim Item Groupings)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_CDC (Package) FS-CM: Data Capture

Basic Data

Table Category	INTTAB	Structure
Structure	ICL_PROCURE	Table Relationship Diagram
Short Description	Claim Item Groupings

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 Groupings
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_SUBCLP	ICL_SUBCL	CHAR	3	0	Subclaim of Payment	ICLSUBCL
6	PROCUREMENT	☐	ICL_PROCUREMENT	ICL_PROCUREMENT	NUMC	4	0	ID of Claim Item Grouping	*
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	Claim Item Grouping
12	.INCLUDE	☐				0	0	Organizational Include (Short Version)
13	CREATEDBY	☐	ICL_CREATEDBY	XUBNAME	CHAR	12	0	Created By	USR02
14	CREATETIME	☐	ICL_CREATEUTC	ICL_TIMESTAMP	DEC	15	0	Created: UTC Date+Time
15	PDOCTYPE	☐	ICL_PDOCTYPE	ICL_BENTYPE	CHAR	10	0	Benefit Type for Grouping of Lower Level Benefit Types	*
16	PDOCCAT	☐	ICL_PDOCCAT	ICL_PDOCCAT	CHAR	2	0	Claim Item Grouping Category	TICL138
17	ISSUEDATE	☐	ICL_ISSUEDATE1	DATS	DATS	8	0	Date Created
18	RECEIVEDATE	☐	ICL_RECEIVEDATE	DATS	DATS	8	0	Date Received
19	DATEFROM	☐	ICL_DATEFROM	DATS	DATS	8	0	Start Date of Period
20	TIMEFROM	☐	ICL_TIMEFROM	ICL_TIMEFROM	TIMS	6	0	Start Time of Claim Item Group
21	DATETO	☐	ICL_DATETO	DATS	DATS	8	0	End Date of Period
22	TIMETO	☐	ICL_TIMETO	ICL_TIMETO	TIMS	6	0	End Time of Claim Item Group
23	ISSUEDATE_PRESCR	☐	ICL_ISSUEDATE_PRESCR	DATS	DATS	8	0	Date Prescription Created Acc. to Invoice
24	ACQUISITIONDATE	☐	ICL_ACQUISITIONDATE	DATS	DATS	8	0	Date Entered
25	AMOUNT1	☐	ICL_AMOUNT1	ICL_AMOUNT	CURR	15	2	General Amount Field
26	CURRENCY	☐	ICL_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
27	.INCLUDE	☐				0	0	External Numbers for Claim Item Groupings
28	EXTERNALREF	☐	ICL_EXTERNALREF	ICL_EXTERNALREF	CHAR	20	0	External Reference of Claim Item Grouping
29	EXTDOCUMENT	☐	ICL_EXTDOCUMENT	ICL_EXTDOCUMENT	CHAR	16	0	External Document Number
30	EXTCASENO	☐	ICLH_EXTCASENO	ICLH_EXTCASENO	CHAR	15	0	Hospital-Internal ID
31	EXTFILENO	☐	ICLH_EXTFILENO	ICLH_EXTFILENO	CHAR	20	0	HI: External Data Set Identification
32	PROC_REF	☐	ICL_PROCUREMENT	ICL_PROCUREMENT	NUMC	4	0	ID of Claim Item Grouping	ICLPROCURE
33	DISCOUNTAMOUNT	☐	ICL_DISCOUNTAMOUNT	ICL_AMOUNT	CURR	15	2	Discount on Invoice Amount
34	DISCOUNTPERCENT	☐	ICL_DISCOUNTPERCENT	ICL_PERCENT	DEC	5	2	Discount on Total Invoice Amount in Percent
35	.INCLUDE	☐				0	0	Accident or Subro/Recovery Indicator
36	ACCIDENT	☐	ICL_ACCIDENT	ICL_ACCIDENT	CHAR	2	0	Accident or Other Reason for Possible Recovery	TICL158
37	SUBROGATION	☐	ICL_SUBROGATION	ICL_SUBROGATION	CHAR	2	0	Indication Whether Recovery Claim Might Be Involved	TICL157
38	DUEDATE	☐	ICL_DUEDATE	DATE	DATS	8	0	Due Date
39	DUEDATE_ORIG	☐	ICL_DUEDATE_ORIG	DATE	DATS	8	0	Origin of Due Date
40	STATUS	☐	ICL_PROCSTATUS	ICL_STATUS	CHAR	2	0	Status of a Claim Item Grouping	TICL140
41	STATREASON	☐	ICL_FORMSET	ICL_FORMSET	CHAR	2	0	Reason for Changing the Status	TICL018
42	OWNCONTRIB	☐	ICL_OWNCONTRIB	NUMC03	NUMC	3	0	Copayment
43	REASON	☐	ICL_REASON	ICL_REASON	CHAR	3	0	Reason for Creating a Claim Item Grouping	TICL152
44	CAUSE	☐	ICLH_CAUSE	ICLH_CAUSE	CHAR	2	0	Specification of Reason for Creating Claim Item Grouping	*
45	PDOCCATTYPE	☐	ICL_PDOCCATTYPE	ICL_PDOCCATTYPE	CHAR	3	0	Type of Claim Item Grouping Category	TICL153
46	SUBCL_ORIG	☐	ICL_SUBCL_ORIG	ICL_SUBCL	CHAR	3	0	Original Subclaim Multiple Prescription/Curr.Subclm Appraisl	*
47	PROC_ORIG	☐	ICL_PROC_ORIG	ICL_PROCUREMENT	NUMC	4	0	Original Claim Item Grouping of Multiple Prescription	*
48	DATASOURCE	☐	ICL_DATASOURCE	ICL_DATASOURCE	CHAR	2	0	Data Origin	TICL136
49	SETORDERDATE	☐	ICL_SETORDERDATE	DATS	DATS	8	0	Set Order Date
50	COMPLETIONDATE	☐	ICL_COMPLETIONDATE	DATS	DATS	8	0	Completion Date
51	.INCLUDE	☐				0	0	Claim Item Grouping: Dental-Specific Fields
52	FEE	☐	ICLH_FEE	ICL_AMOUNT	CURR	15	2	Fee
53	MATLABCOST	☐	ICLH_MATLABCOST	ICL_AMOUNT	CURR	15	2	Material and Laboratory Costs
54	MATLABCOSTINT	☐	ICLH_MATLABCOSTINT	ICL_AMOUNT	CURR	15	2	will be deleted.
55	ADDCOST	☐	ICLH_ADDCOST	ICL_AMOUNT	CURR	15	2	Other Costs
56	VALPERUNIT	☐	ICL_SERVCAT_POS_VALPERUNIT	ICL_SERVCAT_POS_VALPERUNIT	DEC	20	12	Value per Unit of Benefits Catalog Item
57	SUBSIDYPERCENT	☐	ICLH_SUBSIDYPERCENT	ICL_PERCENT	DEC	5	2	Subsidy in Percent (%)
58	SUBSIDYAMOUNT	☐	ICLH_SUBSIDYAMOUNT	ICL_AMOUNT	CURR	15	2	Subsidy Amount
59	SENTUTC	☐	ICL_SENTUTC	ICL_TIMESTAMP	DEC	15	0	Sent: UTC Date and Time
60	SENT_BY_DME	☐	ICL_SENT_BY_DME	XFELD	CHAR	1	0	Sent via External Interface (Not Yet Used)
61	RECEIPT_BY_DME	☐	ICL_RECEIPT_BY_DME	XFELD	CHAR	1	0	Receipt via External Interface
62	.INCLUDE	☐				0	0	Status for Procurement
63	CANCEL	☐	ICL_STATUS_CANCEL	XFELD	CHAR	1	0	Status "Cancelled"
64	REJECTED	☐	ICL_STATUS_REJECTED	XFELD	CHAR	1	0	Status "Rejected"
65	INSUSPENSE	☐	ICL_STATUS_INSUSPENSE	XFELD	CHAR	1	0	Status "Pending"
66	INPROCESS	☐	ICL_STATUS_INPROCESS	XFELD	CHAR	1	0	Status "In Process"
67	RELEASED	☐	ICL_STATUS_RELEASED	XFELD	CHAR	1	0	Status "Released"
68	XFINISHED	☐	ICL_XFINISHED	XFELD	CHAR	1	0	Complete/Approved/Finished
69	ORDERED	☐	ICL_STATUS_ORDERED	XFELD	CHAR	1	0	Status "Commissioned"
70	TRANSFERRED	☐	ICL_STATUS_TRANSFERRED	XFELD	CHAR	1	0	Status "Reassigned"
71	XCLINICCARD	☐	ICLH_CLINIC_CARD	ICLH_CLINIC_CARD	CHAR	1	0	Flag: Clinic Card
72	PAYFREQPLAN	☐	ICL_PAYFREQPLAN_REP	PKEY_VK	CHAR	2	0	Payment Frequency of a Repetitive Payment	TVS010B
73	ASSIGN_GUID	☐	ICL_ASSIGN_GUID	SYSUUID_C	CHAR	32	0	UUID of Entry to be Linked
74	XREQUEST	☐	ICL_XREQUEST	XFELD	CHAR	1	0	Indicator: Receivable
75	COMPPER_DATEFROM	☐	ICL_COMPPER_DATEFROM_D_PE	ICL_COMPPER_PE	DATS	8	0	Comparison Period From
76	COMPPER_DATETO	☐	ICL_COMPPER_DATETO_D_PE	ICL_COMPPER_PE	DATS	8	0	Comparison Period To
77	PAYOUT_SCENARIO	☐	ICL_PAYOUT_SCENARIO_D	ICL_PAYOUT_SCENARIO	CHAR	1	0	Repetitive Payment Scenario
78	NAME	☐	ICL_ROLEN	TEXT25	CHAR	25	0	Long Name of Participant Role
79	NAME_ORG1	☐	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
80	CITY1	☐	AD_CITY1	TEXT40	CHAR	40	0	City
81	POST_CODE1	☐	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
82	STREET	☐	AD_STREET	TEXT60	CHAR	60	0	Street
83	TITLE	☐	AD_TITLETX	TEXT30	CHAR	30	0	Title text
84	TEL_NUMBER	☐	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
85	XUBNAME	☐	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record	*
86	CONTACT	☐	ICL_SUPPL_CONTACT	CHAR50	CHAR	50	0	Contact Person of a Supplier
87	XBESTSELECTED	☐	ICL_XBEST	CHAR01	CHAR	1	0	Best Supplier to be Selected: No List Display
88	REMARK	☐	ICL_REMARK	TEXT50	CHAR	50	0	Remark on External Service
89	XLOG	☐	ICL_LOG_WRITTEN	XFELD	CHAR	1	0	Flag: Entry regarding assignment made in log
90	ASNUM	☐	ICL_ASNUM	ICL_ASNUM	CHAR	18	0	Activity Number with Vendor Management
91	PDREF	☐	ICL_PDREF	ICL_PDREF_DOMAIN	CHAR	10	0	Reference to Purchasing Document
92	VALUE	☐	ICL_VALUE	ICL_VALUE	INT1	3	0	Overall Evaluation of External Service
93	DISTANCE_INFO	☐	ICL_SUPPL_DIST_INFO	TEXT40	CHAR	40	0	Information on Distance of Service Provider to Loss Location
94	RESUBMITDATE	☐	ICL_RESUBMITDATE	DATS	DATS	8	0	Resubmission Date
95	REASONN	☐	ICL_REASONN	ICL_REASONN	CHAR	80	0	Reason Description
96	CAUSEN	☐	ICLH_CAUSEN	ICLH_CAUSEN	CHAR	80	0	Name of Specification
97	PDOCCATTYPEN	☐	ICL_PDOCCATTYPEN	ICL_PDOCCATTYPEN	CHAR	40	0	Description of Type of Claim Item Grouping Category
98	XDOCSENT	☐	ICL_DOCSENT	BOOLE	CHAR	1	0	Internal Flag: Documents Sent
99	XSELECT	☐	ICL_SELECT	BOOLE	CHAR	1	0	General Selection Indicator
100	XBULKCREATE	☐	ICL_XBULKCREATE	XFELD	CHAR	1	0	Int.Processing Indic.: Collective Invoice Created in DSAVE
101	SEQNUM	☐	ICL_INVSEQNUM	ICL_PROCUREMENT	NUMC	4	0	Sequence Invoice Number Within Invoice	*
102	NEXT_SEQNUM	☐	ICL_SEQNUM	ICL_SEQNUM	NUMC	4	0	Item Sequence Number
103	HEADER_ITEM	☐	ICL_SCLITEM_HEADER	ICL_SCLITEM_CHAR	CHAR	4	0	Number of Claim Item in Claim Item Grouping Header
104	CONTRIB_ITEM	☐	ICL_SCLITEM_HEADER	ICL_SCLITEM_CHAR	CHAR	4	0	Number of Claim Item in Claim Item Grouping Header
105	DISCOUNT_ITEM	☐	ICL_SCLITEM_HEADER	ICL_SCLITEM_CHAR	CHAR	4	0	Number of Claim Item in Claim Item Grouping Header

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICL_PROCURE	ACCIDENT	TICL158	ACCIDENT
2	ICL_PROCURE	CHANGEDBY	USR02	BNAME
3	ICL_PROCURE	CLAIM	ICLCLAIM	CLAIM
4	ICL_PROCURE	CLIENT	T000	MANDT
5	ICL_PROCURE	CREATEDBY	USR02	BNAME
6	ICL_PROCURE	CURRENCY	TCURC	WAERS	KEY
7	ICL_PROCURE	DATASOURCE	TICL136	DATASOURCE	KEY
8	ICL_PROCURE	PAYFREQPLAN	TVS010B	PKEY	REF	1	CN
9	ICL_PROCURE	PDOCCAT	TICL138	PDOCCAT
10	ICL_PROCURE	PDOCCATTYPE	TICL153	PDOCCATTYPE
11	ICL_PROCURE	PROC_REF	ICLPROCURE	PROCUREMENT
12	ICL_PROCURE	REASON	TICL152	REASON	KEY	1	CN
13	ICL_PROCURE	STATREASON	TICL018	FORMOFSET
14	ICL_PROCURE	STATUS	TICL140	STATUS
15	ICL_PROCURE	SUBCLAIM	ICLSUBCL	SUBCLAIM
16	ICL_PROCURE	SUBROGATION	TICL157	SUBROGATION

History

Last changed by/on	SAP	20130529
SAP Release Created in	463