SAP ABAP Table ICL_ICLI91_INVLIST_ALV (Differences Log: Single Invoice Overview in Collective Inv.)

Hierarchy

☛

INSURANCE (Software Component) SAP Insurance
⤷

FS-CM (Application Component) Claims Management
⤷

ICL_HEALTH (Package) FS-CM: Health Line of Insurance

Basic Data

Table Category	INTTAB	Structure
Structure	ICL_ICLI91_INVLIST_ALV	Table Relationship Diagram
Short Description	Differences Log: Single Invoice Overview in Collective Inv.

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	.INCLUDE				0	0	General Data for Invoice Header
2	XSELECT	ICL_SELECT	BOOLE	CHAR	1	0	General Selection Indicator
3	DETAIL_SELECT	ICL_DETAIL_SELECT		CHAR	50	0	Details
4	CLAIM	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	*
5	SUBCLAIM	ICL_SUBCL	ICL_SUBCL	CHAR	3	0	Subclaim	*
6	PROCUREMENT	ICL_PROCUREMENT	ICL_PROCUREMENT	NUMC	4	0	ID of Claim Item Grouping	*
7	.INCLUDE				0	0	View ICLH37: InvEntry Header Top
8	PARTNER	ICL_INSURED	BU_PARTNER	CHAR	10	0	Insured Person	*
9	DESCRP_PARTNER	ICL_DESCRIP	CHAR50	CHAR	50	0	Participant in Claim: Description
10	ACQUISITIONDATE	ICL_ACQUISITIONDATE	DATS	DATS	8	0	Date Entered
11	CREATEDBY	ICL_CREATEDBY_INV	XUBNAME	CHAR	12	0	Invoice Created by	*
12	INVTYPE	ICL_INVTYPE	ICL_PDOCCATTYPE	CHAR	3	0	Invoice Type	*
13	INVTYPEN	ICL_INVTYPEN	ICL_PDOCCATTYPEN	CHAR	40	0	Text for Invoice Type
14	LOSSTYPE	ICL_LOSSTYPE	ICL_LOSSTYPE	CHAR	4	0	Incident Type of a Claim	*
15	SUBCLTYPE	ICL_SUBCLTYPE	ICL_SUBCLTYPE	CHAR	4	0	Subclaim Type	TICL004
16	STATUS	ICL_INVOICESTATUS	ICL_STATUS	CHAR	2	0	Status of an Invoice	*
17	STATUSN	ICL_INVOICESTATUSN	TEXT25	CHAR	25	0	Name of Invoice Status
18	.INCLUDE				0	0	View ICLH51, InvE+Proc Hdr: InvCreationDte, InvReceipt Date
19	ISSUEDATE	ICL_ISSUEDATE_INV	DATS	DATS	8	0	Invoice Date
20	RECEIVEDATE	ICL_RECEIVEDATE	DATS	DATS	8	0	Date Received
21	DATEFROM	ICL_DATEFROM_INV	DATS	DATS	8	0	Start of Invoice Period: Date
22	DATETO	ICL_DATETO_INV	DATS	DATS	8	0	End of Invoice Period: Date
23	.INCLUDE				0	0	InvE+ProcHdr: ExtCollIRef + ExtCollInvNo
24	EXTERNALREF_BULK	ICL_EXTERNALREF_BULK	ICL_EXTERNALREF_BULK	CHAR	20	0	External Collective Reference
25	INVOICEREF_BULK	ICL_INVOICEREF_BULK	CHAR16	CHAR	16	0	External Collective Invoice Number
26	.INCLUDE				0	0	InvEntry+Proc Hdr: Int CollLInv, ExtInvNo
27	CCEVENT	ICL_CCEVENT_INVOICE	ICL_CCEVENT	CHAR	17	0	Internal Collective Invoice Number	*
28	EXTERNALREF	ICL_INVOICEREF	CHAR20	CHAR	20	0	External Invoice Number
29	.INCLUDE				0	0	InvEntry Header: Total Amt, Deductible, Use, Currency
30	CURRENCY	ICL_CURRENCY	WAERS	CUKY	5	0	Currency	*
31	PURPOSE	ICL_PURPOSE		CHAR	50	0	Purpose
32	CONTRIBAMOUNT_INV	ICL_CONTRIBAMOUNT_INV	ICL_AMOUNT	CURR	15	2	Amount of Copayment (Acc. to Invoice)
33	XCONTRIBAMOUNT_INV	ICL_XHDCTRB_AMOUNT_INV	BOOLE	CHAR	1	0	Header Deductible Amount Distributed to Items (Acc. to Inv)
34	AMOUNT_INV	ICL_INV_AMOUNT_TOTAL	ICL_AMOUNT	CURR	15	2	Net Total: Total of Net Amounts of All Items (acc.to Inv)
35	FEE	ICLH_FEE	ICL_AMOUNT	CURR	15	2	Fee
36	MATLABCOST	ICLH_MATLABCOST	ICL_AMOUNT	CURR	15	2	Material and Laboratory Costs
37	MATLABCOSTINT	ICLH_MATLABCOSTINT	ICL_AMOUNT	CURR	15	2	will be deleted.
38	ADDCOST	ICLH_ADDCOST	ICL_AMOUNT	CURR	15	2	Other Costs
39	AMOUNT	ICL_AMOUNT_TOTAL	ICL_AMOUNT	CURR	15	2	Total Amount (Sum of Net Amounts of All Items)
40	CONTRIBAMOUNT	ICL_AMOUNT_CONTRIB	ICL_AMOUNT	CURR	15	2	Copayment Deducted by Service Provider
41	XCONTRIBAMOUNT	ICL_XCONTRIBAMOUNT_POS	BOOLE	CHAR	1	0	Deductible Transferred from Invoice Header to Invoice Item
42	AMOUNT_CANCELED	ICL_AMOUNT_CANCELED	ICL_AMOUNT	CURR	15	2	Difference Amount of Items with Reason
43	XCANCEL	ICL_XCANCELED	XFELD	CHAR	1	0	Rejected
44	.INCLUDE				0	0	Approval Number for Invoice
45	CLAIM_APPR	ICL_CLAIM_APPR	ICL_CLAIM	CHAR	17	0	Approval Number	*
46	PROCUREMENT_APPR	ICL_PROCUREMENT_APPR	ICL_PROCUREMENT	NUMC	4	0	ID of Claim Item Grouping as Part of Approval Number	*
47	SUBCLAIM_APPR	ICL_SUBCL_APPR	ICL_SUBCL	CHAR	3	0	Subclaim Number as Second Part of Approval Number	*
48	.INCLUDE				0	0	Data Origin + Document Number
49	DATASOURCE	ICL_DATASOURCE	ICL_DATASOURCE	CHAR	2	0	Data Origin	TICL136
50	EXTDOCUMENT	ICL_EXTDOCUMENT	ICL_EXTDOCUMENT	CHAR	16	0	External Document Number
51	DISCOUNTAMOUNT	ICL_DISCOUNTAMOUNT	ICL_AMOUNT	CURR	15	2	Discount on Invoice Amount
52	DISCOUNTPERCENT	ICL_DISCOUNTPERCENT	ICL_PERCENT	DEC	5	2	Discount on Total Invoice Amount in Percent
53	XDISCOUNTPERCENT	ICL_XDISCOUNTPERCENT	BOOLE	CHAR	1	0	Discount Amount Without Reference to Percent Discount
54	XDISCOUNT_POS	ICL_XDISCOUNT_POS	BOOLE	CHAR	1	0	Discount Transferred from Invoice Items
55	TOBEPAIDAMOUNT	ICL_AMOUNT_TOBEPAID	ICL_AMOUNT	CURR	15	2	Payout Amount
56	METHOD	ICL_PAYMETHOD_INV	PYMET_KK	CHAR	1	0	Payment Method acc. to Invoice	*
57	METHODTXT	ICL_METHODTXT	FORMT_PAY	CHAR	30	0	Name of Payment Method	*
58	PAYEE_SCR	ICL_PAYE_INV	BU_PARTNER	CHAR	10	0	Payee Acc. to Invoice	*
59	PAYEE	ICL_PAYE_INV	BU_PARTNER	CHAR	10	0	Payee Acc. to Invoice	*
60	DESCRP_PAYEE	ICL_PAYEDSC	CHAR50	CHAR	50	0	Payee
61	PAYEE_ROLE	ICL_ROLE	ICL_ROLE	CHAR	4	0	Participant Role Key	*
62	LE_PART_SCR	ICLH_LE_PART	BU_PARTNER	CHAR	10	0	Business Partner Number of Service Provider	*
63	LE_PART	ICLH_LE_PART	BU_PARTNER	CHAR	10	0	Business Partner Number of Service Provider	*
64	DESCRP_LE	ICLH_LE_DESCRP	TEXT50	CHAR	50	0	Description of Service Provider Business Partner
65	LE_ROLE	ICL_ROLE	ICL_ROLE	CHAR	4	0	Participant Role Key	*
66	VO_PART_SCR	ICLH_VO_PART	BU_PARTNER	CHAR	10	0	Business Partner Number of Prescriber	*
67	VO_PART	ICLH_VO_PART	BU_PARTNER	CHAR	10	0	Business Partner Number of Prescriber	*
68	DESCRP_VO	ICLH_VO_DESCRP	TEXT50	CHAR	50	0	Description of Business Partner Issuing Prescription
69	VO_ROLE	ICL_ROLE	ICL_ROLE	CHAR	4	0	Participant Role Key	*
70	OWNER	ICL_CLAIMOWNER	ICL_CLAIMOWNER	CHAR	12	0	ID of Claim Handler
71	INV_PART_SCR	ICL_INVOICER	BU_PARTNER	CHAR	10	0	Invoicing Party	*
72	INV_PART	ICL_INVOICER	BU_PARTNER	CHAR	10	0	Invoicing Party	*
73	DESCRP_INV	ICLH_INV_DESCRP	CHAR50	CHAR	50	0	Textual Description of Invoicing Party
74	INV_ROLE	ICL_ROLE	ICL_ROLE	CHAR	4	0	Participant Role Key	*
75	EBR_PART_SCR	ICLH_EBR_PART	BU_PARTNER	CHAR	10	0	Business Partner Number of External Bill Reviewer	*
76	EBR_PART	ICLH_EBR_PART	BU_PARTNER	CHAR	10	0	Business Partner Number of External Bill Reviewer	*
77	DESCRP_EBR	ICLH_EBR_DESCRP	CHAR50	CHAR	50	0	Description of External Bill Review Provider
78	EBR_ROLE	ICL_ROLE	ICL_ROLE	CHAR	4	0	Participant Role Key	*
79	POLH_PART	ICL_POLH	BU_PARTNER	CHAR	10	0	Insured	*
80	DESCRP_POLH	ICLH_POLH_DESCRP	CHAR50	CHAR	50	0	Text Description of Policyholder in Invoice
81	COST_ROLE	ICL_ROLE	ICL_ROLE	CHAR	4	0	Participant Role Key	*
82	COST_PART_SCR	ICL_COSTCARRIER	BU_PARTNER	CHAR	10	0	Carrier	*
83	COST_PART	ICL_COSTCARRIER	BU_PARTNER	CHAR	10	0	Carrier	*
84	DESCRP_COST	ICL_COSTCARRIERN	CHAR50	CHAR	50	0	Description of Carrier
85	.INCLUDE				0	0	InvProcessing Hdr: Checkbox "Serial Error Exists"
86	XBULKERROR	ICL_XBULKERROR	XFELD	CHAR	1	0	Serial Error in Cross Collective Invoice
87	.INCLUDE				0	0	Invoice Header: Ins Obj Fields from DME, Mass Entry
88	ISSUEDATE_PRESCR	ICL_ISSUEDATE_PRESCR	DATS	DATS	8	0	Date Prescription Created Acc. to Invoice
89	DUEDATE	ICL_DUEDATE_PAY	DATE	DATS	8	0	Payment Target
90	DUEDATE_ORIG	ICL_DUEDATE_PAY_ORIG	ICL_DUEDATE_PAY_ORIG	CHAR	1	0	Origin of Payment Target
91	COLOR	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
92	XREIMBURSE	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
93	XREQUEST	ICL_XREQUEST	XFELD	CHAR	1	0	Indicator: Receivable
94	.INCLUDE				0	0	Status for Procurement
95	CANCEL	ICL_STATUS_CANCEL	XFELD	CHAR	1	0	Status "Cancelled"
96	REJECTED	ICL_STATUS_REJECTED	XFELD	CHAR	1	0	Status "Rejected"
97	INSUSPENSE	ICL_STATUS_INSUSPENSE	XFELD	CHAR	1	0	Status "Pending"
98	INPROCESS	ICL_STATUS_INPROCESS	XFELD	CHAR	1	0	Status "In Process"
99	RELEASED	ICL_STATUS_RELEASED	XFELD	CHAR	1	0	Status "Released"
100	XFINISHED	ICL_XFINISHED	XFELD	CHAR	1	0	Complete/Approved/Finished
101	ORDERED	ICL_STATUS_ORDERED	XFELD	CHAR	1	0	Status "Commissioned"
102	TRANSFERRED	ICL_STATUS_TRANSFERRED	XFELD	CHAR	1	0	Status "Reassigned"
103	INVSEQNUM	ICL_INVSEQNUM	ICL_PROCUREMENT	NUMC	4	0	Sequence Invoice Number Within Invoice	*
104	.INCLUDE				0	0	External Bill Review: Header (#1)
105	DESCRIPTION_EBR	ICL_DPDESC_EBR	TEXT40	CHAR	40	0	Description of Claim Item (EBR)
106	REJREASON_EBR	ICL_ADJREASON	ICL_REJREASON	CHAR	2	0	Adjustment Reason	*
107	REFNO_EBR	ICL_SCLITEMREF_EBR	ICL_SCLITEMREF	CHAR	15	0	External Reference Number (EBR)
108	STARTDATE_EBR	ICL_STARTDATE_EBR	DATE	DATS	8	0	Start Data Acc.to External Bill Reviewer
109	ENDDATE_EBR	ICL_ENDDATE_EBR	DATUM	DATS	8	0	End Date According to Invoice (External Bill Review)
110	PDREF_EBR	ICL_PDREF_EBR	ICL_PDREF_DOMAIN	CHAR	10	0	Reference to Purchasing Document
111	PDPOS_EBR	ICL_PDPOS_EBR	ICL_PDPOS	NUMC	10	0	Reference to Item Number (EBR)
112	.INCLUDE				0	0	External Bill Review: Header (#2)
113	EBR_AMOUNT_TOTAL	ICL_EBR_AMOUNT_TOTAL	ICL_AMOUNT	CURR	15	2	Net Total: Sum of Net Amounts of All Items (EBR)
114	DISCOUNTAMOUNT_EBR	ICL_DISCOUNTAMOUNT_EBR	ICL_AMOUNT	CURR	15	2	Deduction - Invoice Amount (EBR)
115	CONTRIBAMOUNT_EBR	ICL_CONTRIBAMOUNT_EBR	ICL_AMOUNT	CURR	15	2	Copayment Amount (EBR)
116	EVCURR_EBR	ICL_EVCURR	WAERS	CUKY	5	0	Currency of Evaluated Amount	TCURC
117	DIFFAMT_TEXT	ICLH_DIFFAMT_TEXT	ICL_AMOUNT	CURR	15	2	Confirmed Difference Amount
118	DIFFAMT_OPEN	ICLH_DIFFAMT_OPEN	ICL_AMOUNT	CURR	15	2	Open Difference Amount