SAP ABAP Table ICL_INVOICE_DI_INPUT (DI Input for Change to/Creation of Collective Invoice)

Hierarchy

☛

INSURANCE (Software Component) SAP Insurance
⤷

FS-CM (Application Component) Claims Management
⤷

ICL_EVENT (Package) FS-CM: Claim Bundle

Basic Data

Table Category	INTTAB	Structure
Structure	ICL_INVOICE_DI_INPUT	Table Relationship Diagram
Short Description	DI Input for Change to/Creation of Collective Invoice

Delivery and Maintenance

Pool/cluster
Delivery Class
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

Components


	Field	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	IS_PROCURE	ICL_PROCURE		STRU	0	0
2	.INCLUDE				0	0	Claim Item Groupings
3	CLIENT	MANDT	MANDT	CLNT	3	0	Client
4	ACTIVE	ICL_ACTIVE	ICL_ACTIVE	CHAR	1	0	Table entry is active (A) or in suspense (S)
5	CLAIM	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim
6	SUBCLAIM	ICL_SUBCLP	ICL_SUBCL	CHAR	3	0	Subclaim of Payment
7	PROCUREMENT	ICL_PROCUREMENT	ICL_PROCUREMENT	NUMC	4	0	ID of Claim Item Grouping
8	.INCLUDE				0	0	Shadow Tables Versioning: Include for Original Table
9	CHANGETIME	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
10	CHANGEDBY	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By
11	DELETED	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
12	.INCLUDE				0	0	Claim Item Grouping
13	.INCLUDE				0	0	Organizational Include (Short Version)
14	CREATEDBY	ICL_CREATEDBY	XUBNAME	CHAR	12	0	Created By
15	CREATETIME	ICL_CREATEUTC	ICL_TIMESTAMP	DEC	15	0	Created: UTC Date+Time
16	PDOCTYPE	ICL_PDOCTYPE	ICL_BENTYPE	CHAR	10	0	Benefit Type for Grouping of Lower Level Benefit Types
17	PDOCCAT	ICL_PDOCCAT	ICL_PDOCCAT	CHAR	2	0	Claim Item Grouping Category
18	ISSUEDATE	ICL_ISSUEDATE1	DATS	DATS	8	0	Date Created
19	RECEIVEDATE	ICL_RECEIVEDATE	DATS	DATS	8	0	Date Received
20	DATEFROM	ICL_DATEFROM	DATS	DATS	8	0	Start Date of Period
21	TIMEFROM	ICL_TIMEFROM	ICL_TIMEFROM	TIMS	6	0	Start Time of Claim Item Group
22	DATETO	ICL_DATETO	DATS	DATS	8	0	End Date of Period
23	TIMETO	ICL_TIMETO	ICL_TIMETO	TIMS	6	0	End Time of Claim Item Group
24	ISSUEDATE_PRESCR	ICL_ISSUEDATE_PRESCR	DATS	DATS	8	0	Date Prescription Created Acc. to Invoice
25	ACQUISITIONDATE	ICL_ACQUISITIONDATE	DATS	DATS	8	0	Date Entered
26	AMOUNT1	ICL_AMOUNT1	ICL_AMOUNT	CURR	15	2	General Amount Field
27	CURRENCY	ICL_CURRENCY	WAERS	CUKY	5	0	Currency
28	.INCLUDE				0	0	External Numbers for Claim Item Groupings
29	EXTERNALREF	ICL_EXTERNALREF	ICL_EXTERNALREF	CHAR	20	0	External Reference of Claim Item Grouping
30	EXTDOCUMENT	ICL_EXTDOCUMENT	ICL_EXTDOCUMENT	CHAR	16	0	External Document Number
31	EXTCASENO	ICLH_EXTCASENO	ICLH_EXTCASENO	CHAR	15	0	Hospital-Internal ID
32	EXTFILENO	ICLH_EXTFILENO	ICLH_EXTFILENO	CHAR	20	0	HI: External Data Set Identification
33	PROC_REF	ICL_PROCUREMENT	ICL_PROCUREMENT	NUMC	4	0	ID of Claim Item Grouping
34	DISCOUNTAMOUNT	ICL_DISCOUNTAMOUNT	ICL_AMOUNT	CURR	15	2	Discount on Invoice Amount
35	DISCOUNTPERCENT	ICL_DISCOUNTPERCENT	ICL_PERCENT	DEC	5	2	Discount on Total Invoice Amount in Percent
36	.INCLUDE				0	0	Accident or Subro/Recovery Indicator
37	ACCIDENT	ICL_ACCIDENT	ICL_ACCIDENT	CHAR	2	0	Accident or Other Reason for Possible Recovery
38	SUBROGATION	ICL_SUBROGATION	ICL_SUBROGATION	CHAR	2	0	Indication Whether Recovery Claim Might Be Involved
39	DUEDATE	ICL_DUEDATE	DATE	DATS	8	0	Due Date
40	DUEDATE_ORIG	ICL_DUEDATE_ORIG	DATE	DATS	8	0	Origin of Due Date
41	STATUS	ICL_PROCSTATUS	ICL_STATUS	CHAR	2	0	Status of a Claim Item Grouping
42	STATREASON	ICL_FORMSET	ICL_FORMSET	CHAR	2	0	Reason for Changing the Status
43	OWNCONTRIB	ICL_OWNCONTRIB	NUMC03	NUMC	3	0	Copayment
44	REASON	ICL_REASON	ICL_REASON	CHAR	3	0	Reason for Creating a Claim Item Grouping
45	CAUSE	ICLH_CAUSE	ICLH_CAUSE	CHAR	2	0	Specification of Reason for Creating Claim Item Grouping
46	PDOCCATTYPE	ICL_PDOCCATTYPE	ICL_PDOCCATTYPE	CHAR	3	0	Type of Claim Item Grouping Category
47	SUBCL_ORIG	ICL_SUBCL_ORIG	ICL_SUBCL	CHAR	3	0	Original Subclaim Multiple Prescription/Curr.Subclm Appraisl
48	PROC_ORIG	ICL_PROC_ORIG	ICL_PROCUREMENT	NUMC	4	0	Original Claim Item Grouping of Multiple Prescription
49	DATASOURCE	ICL_DATASOURCE	ICL_DATASOURCE	CHAR	2	0	Data Origin
50	SETORDERDATE	ICL_SETORDERDATE	DATS	DATS	8	0	Set Order Date
51	COMPLETIONDATE	ICL_COMPLETIONDATE	DATS	DATS	8	0	Completion Date
52	.INCLUDE				0	0	Claim Item Grouping: Dental-Specific Fields
53	FEE	ICLH_FEE	ICL_AMOUNT	CURR	15	2	Fee
54	MATLABCOST	ICLH_MATLABCOST	ICL_AMOUNT	CURR	15	2	Material and Laboratory Costs
55	MATLABCOSTINT	ICLH_MATLABCOSTINT	ICL_AMOUNT	CURR	15	2	will be deleted.
56	ADDCOST	ICLH_ADDCOST	ICL_AMOUNT	CURR	15	2	Other Costs
57	VALPERUNIT	ICL_SERVCAT_POS_VALPERUNIT	ICL_SERVCAT_POS_VALPERUNIT	DEC	20	12	Value per Unit of Benefits Catalog Item
58	SUBSIDYPERCENT	ICLH_SUBSIDYPERCENT	ICL_PERCENT	DEC	5	2	Subsidy in Percent (%)
59	SUBSIDYAMOUNT	ICLH_SUBSIDYAMOUNT	ICL_AMOUNT	CURR	15	2	Subsidy Amount
60	SENTUTC	ICL_SENTUTC	ICL_TIMESTAMP	DEC	15	0	Sent: UTC Date and Time
61	SENT_BY_DME	ICL_SENT_BY_DME	XFELD	CHAR	1	0	Sent via External Interface (Not Yet Used)
62	RECEIPT_BY_DME	ICL_RECEIPT_BY_DME	XFELD	CHAR	1	0	Receipt via External Interface
63	.INCLUDE				0	0	Status for Procurement
64	CANCEL	ICL_STATUS_CANCEL	XFELD	CHAR	1	0	Status "Cancelled"
65	REJECTED	ICL_STATUS_REJECTED	XFELD	CHAR	1	0	Status "Rejected"
66	INSUSPENSE	ICL_STATUS_INSUSPENSE	XFELD	CHAR	1	0	Status "Pending"
67	INPROCESS	ICL_STATUS_INPROCESS	XFELD	CHAR	1	0	Status "In Process"
68	RELEASED	ICL_STATUS_RELEASED	XFELD	CHAR	1	0	Status "Released"
69	XFINISHED	ICL_XFINISHED	XFELD	CHAR	1	0	Complete/Approved/Finished
70	ORDERED	ICL_STATUS_ORDERED	XFELD	CHAR	1	0	Status "Commissioned"
71	TRANSFERRED	ICL_STATUS_TRANSFERRED	XFELD	CHAR	1	0	Status "Reassigned"
72	XCLINICCARD	ICLH_CLINIC_CARD	ICLH_CLINIC_CARD	CHAR	1	0	Flag: Clinic Card
73	PAYFREQPLAN	ICL_PAYFREQPLAN_REP	PKEY_VK	CHAR	2	0	Payment Frequency of a Repetitive Payment
74	ASSIGN_GUID	ICL_ASSIGN_GUID	SYSUUID_C	CHAR	32	0	UUID of Entry to be Linked
75	XREQUEST	ICL_XREQUEST	XFELD	CHAR	1	0	Indicator: Receivable
76	COMPPER_DATEFROM	ICL_COMPPER_DATEFROM_D_PE	ICL_COMPPER_PE	DATS	8	0	Comparison Period From
77	COMPPER_DATETO	ICL_COMPPER_DATETO_D_PE	ICL_COMPPER_PE	DATS	8	0	Comparison Period To
78	PAYOUT_SCENARIO	ICL_PAYOUT_SCENARIO_D	ICL_PAYOUT_SCENARIO	CHAR	1	0	Repetitive Payment Scenario
79	NAME	ICL_ROLEN	TEXT25	CHAR	25	0	Long Name of Participant Role
80	NAME_ORG1	BU_NAMEOR1	BU_NAME	CHAR	40	0	Name 1 of organization
81	CITY1	AD_CITY1	TEXT40	CHAR	40	0	City
82	POST_CODE1	AD_PSTCD1	CHAR10	CHAR	10	0	City postal code
83	STREET	AD_STREET	TEXT60	CHAR	60	0	Street
84	TITLE	AD_TITLETX	TEXT30	CHAR	30	0	Title text
85	TEL_NUMBER	AD_TLNMBR1	CHAR30	CHAR	30	0	First telephone no.: dialling code+number
86	XUBNAME	XUBNAME	XUBNAME	CHAR	12	0	User Name in User Master Record
87	CONTACT	ICL_SUPPL_CONTACT	CHAR50	CHAR	50	0	Contact Person of a Supplier
88	XBESTSELECTED	ICL_XBEST	CHAR01	CHAR	1	0	Best Supplier to be Selected: No List Display
89	REMARK	ICL_REMARK	TEXT50	CHAR	50	0	Remark on External Service
90	XLOG	ICL_LOG_WRITTEN	XFELD	CHAR	1	0	Flag: Entry regarding assignment made in log
91	ASNUM	ICL_ASNUM	ICL_ASNUM	CHAR	18	0	Activity Number with Vendor Management
92	PDREF	ICL_PDREF	ICL_PDREF_DOMAIN	CHAR	10	0	Reference to Purchasing Document
93	VALUE	ICL_VALUE	ICL_VALUE	INT1	3	0	Overall Evaluation of External Service
94	DISTANCE_INFO	ICL_SUPPL_DIST_INFO	TEXT40	CHAR	40	0	Information on Distance of Service Provider to Loss Location
95	RESUBMITDATE	ICL_RESUBMITDATE	DATS	DATS	8	0	Resubmission Date
96	REASONN	ICL_REASONN	ICL_REASONN	CHAR	80	0	Reason Description
97	CAUSEN	ICLH_CAUSEN	ICLH_CAUSEN	CHAR	80	0	Name of Specification
98	PDOCCATTYPEN	ICL_PDOCCATTYPEN	ICL_PDOCCATTYPEN	CHAR	40	0	Description of Type of Claim Item Grouping Category
99	XDOCSENT	ICL_DOCSENT	BOOLE	CHAR	1	0	Internal Flag: Documents Sent
100	XSELECT	ICL_SELECT	BOOLE	CHAR	1	0	General Selection Indicator
101	XBULKCREATE	ICL_XBULKCREATE	XFELD	CHAR	1	0	Int.Processing Indic.: Collective Invoice Created in DSAVE
102	SEQNUM	ICL_INVSEQNUM	ICL_PROCUREMENT	NUMC	4	0	Sequence Invoice Number Within Invoice
103	NEXT_SEQNUM	ICL_SEQNUM	ICL_SEQNUM	NUMC	4	0	Item Sequence Number
104	HEADER_ITEM	ICL_SCLITEM_HEADER	ICL_SCLITEM_CHAR	CHAR	4	0	Number of Claim Item in Claim Item Grouping Header
105	CONTRIB_ITEM	ICL_SCLITEM_HEADER	ICL_SCLITEM_CHAR	CHAR	4	0	Number of Claim Item in Claim Item Grouping Header
106	DISCOUNT_ITEM	ICL_SCLITEM_HEADER	ICL_SCLITEM_CHAR	CHAR	4	0	Number of Claim Item in Claim Item Grouping Header
107	I_XCOMMIT	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
108	I_XUPDTASK	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
109	I_XBAPI	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
110	I_XTEST	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
111	I_CCEVENT	ICL_CCEVENT	ICL_CCEVENT	CHAR	17	0	Claim Bundle	*
112	I_AKTYP	BU_AKTYP	BU_AKTYP	CHAR	2	0	Activity Category	*
113	I_CCTYPE	ICL_CCEVENTCAT	ICL_CCEVENTCAT	CHAR	2	0	Claim Bundle Type	*
114	I_SUBTYPE	ICL_CCEVENTTY	ICL_CCEVENTTY	CHAR	2	0	Subtype of Claim Bundle Type	*
115	I_RANGEFROM	ICL_DATE_DI		CHAR	8	0	Date (Direct Input)
116	I_RANGETO	ICL_DATE_DI		CHAR	8	0	Date (Direct Input)
117	IS_CCEVENT	ICLCCEVENT_DI		STRU	0	0
118	CHIND_CCEVT	BU_CHIND	BU_CHIND	CHAR	1	0	Change category
119	CURR	ICL_CUKY_DI		CHAR	5	0	Currency (Direct Input)
120	LIMIT	ICL_CCEVENTLIM_DI		CHAR	17	0	Claim Bundle: Loss Reserve from Direct Input
121	LIMITE	ICL_CCEVENTLIME_DI		CHAR	17	0	Claim Bundle: Expense Reserve from Direct Input
122	CODE	ICL_CCEVENTCODE	CHAR12	CHAR	12	0	External Name for Claim Bundle
123	NAME	ICL_CCEVENTNAME	TEXT20	CHAR	20	0	Name of Claim Bundle
124	HOTLINE	ICL_CCEVENTTEL	CHAR30	CHAR	30	0	Coordinator phone number
125	LOCATYPE	ICL_CCEVENTLOCA_DI		CHAR	1	0	DI:Define Location via Region "1", PCode "2", Address "3"
126	STATUS	ICL_CCEVENTSTAT	ICL_STATUS	CHAR	2	0	Status of Claim Bundle
127	BUNDLECAUSE	ICL_BUNDLECAUSE	ICL_BUNDLECAUSE	CHAR	3	0	Reason for Creation of Claim Bundle
128	OWNER	ICL_BUNDLEOWNER	XUBNAME	CHAR	12	0	Claim Bundle Handler
129	INVOICEREF_BULK	ICL_INVOICEREF_BULK	CHAR16	CHAR	16	0	External Collective Invoice Number
130	EXTERNALREF_BULK	ICL_EXTERNALREF_BULK	ICL_EXTERNALREF_BULK	CHAR	20	0	External Collective Reference
131	ISSUEDATE	ICL_DATE_DI		CHAR	8	0	Date (Direct Input)
132	AMOUNT_TOTAL	ICL_AMOUNT_BULKINV_TOT_DI	ICL_AMOUNT_DI	CHAR	15	0	Total Amount of Collective Invoice
133	PAYMENTLEVEL	ICL_PAYMENTLEVEL_DI	CHAR1	CHAR	1	0	DI: Payment Level of a Collective Invoice (0 Coll., 1 Sing.)
134	DATASOURCE	ICL_DATASOURCE	ICL_DATASOURCE	CHAR	2	0	Data Origin
135	RECEIVEDATE	ICL_DATE_DI		CHAR	8	0	Date (Direct Input)
136	CLMINPROCESS	ICL_CLMSTATUS_INPROCESS	XFELD	CHAR	1	0	Dependent Claim Exists with Status "In Process"
137	RELEASED	ICL_STATUS_RELEASED	XFELD	CHAR	1	0	Status "Released"
138	CCSBRTYPE	ICL_CCSBRTYPE	ICL_CCSBRTYPE	CHAR	2	0	Subrogation Claim Type in Subrogation
139	CHREASONSBR	ICL_CHREASONSBR	ICL_CHREASONSBR	CHAR	2	0	Change Reason for Status of Collective Subrogation/Recovery
140	RESUBDATE	ICL_DATE_DI		CHAR	8	0	Date (Direct Input)
141	SBRNOTIFDATE	ICL_DATE_DI		CHAR	8	0	Date (Direct Input)
142	I_XSKIPDUPLCHECK	ICL_XSKIPDUPLCHECK	XFELD	CHAR	1	0	Flag: Skip Duplicate Check in Direct Input
143	I_XCALL_FROM_BDT_IN_SUBSCR	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
144	IT_ICLCCEVENTB	ICLCCEVENTB_DI_TAB		TTYP	0	0
145	IT_ICLCCEVENTL	ICLCCEVENTL_DI_TAB		TTYP	0	0
146	IT_ICLCCEVENTP	ICLCCEVENTP_DI_TAB		TTYP	0	0
147	IT_ICLCCEVENTR	ICLCCEVENTR_DI_TAB		TTYP	0	0
148	IT_ICLCCEVENTU	ICLCCEVENTU_DI_TAB		TTYP	0	0
149	CT_GEN	IT_ICLGEN_DI		TTYP	0	0