SAP ABAP Table ICLH_ICLH40_BULKINVLIST_ALV (CollInvoice ALV: Invoice List - Invoice Header)

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	ICLH_ICLH40_BULKINVLIST_ALV	Table Relationship Diagram
Short Description	CollInvoice ALV: Invoice List - Invoice Header

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICLH_ICLH40_BULKINVLIST_ALV	DATASOURCE	TICL136	DATASOURCE	KEY	1	CN
2	ICLH_ICLH40_BULKINVLIST_ALV	EVCURR_EBR	TCURC	WAERS
3	ICLH_ICLH40_BULKINVLIST_ALV	SUBCLTYPE	TICL004	SUBCLTYPE

History

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