SAP ABAP Table ICLH_ICLH46 (Items for Invoice and Payment Proposal)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICLH_INVOICE (Package) Bill

Basic Data

Table Category	INTTAB	Structure
Structure	ICLH_ICLH46	Table Relationship Diagram
Short Description	Items for Invoice and Payment Proposal

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	InvItem GUI Structure: Basic Data
2	CLTYPE	☐	ICL_CLTYPE	ICL_CLTYPE	CHAR	4	0	Internal Claim Type	*
3	GENERAT	☐	ICL_CLTYPEG	ICL_CLTYPEG	NUMC	5	0	Generation of Internal Claim Type	*
4	VERSION	☐	ICL_CLTYPEV	ICL_CLTYPEV	NUMC	5	0	Internal Claim Type Version	*
5	SUBCLTYPE	☐	ICL_SUBCLTYPE	ICL_SUBCLTYPE	CHAR	4	0	Subclaim Type	*
6	XSELECT	☐	ICL_SELECT	BOOLE	CHAR	1	0	General Selection Indicator
7	PDOCTYPE	☐	ICL_PDOCTYPE	ICL_BENTYPE	CHAR	10	0	Benefit Type for Grouping of Lower Level Benefit Types	*
8	XINVPAY	☐	ICL_SEL_INVPAY	BOOLE	CHAR	1	0	Flag: Transfer Invoice Item to Payment
9	CLAIM	☐	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	*
10	SUBCLAIM	☐	ICL_SUBCL	ICL_SUBCL	CHAR	3	0	Subclaim	*
11	SUBCLREF	☐	ICL_SUBCLREF	ICL_SUBCL	CHAR	3	0	Subclaim to Which a Claim Item Is Assigned	*
12	PROCUREMENT	☐	ICL_PROCUREMENT	ICL_PROCUREMENT	NUMC	4	0	ID of Claim Item Grouping	*
13	PROCUREMENT_PAY	☐	ICL_PROCUREMENT_PAY	ICL_PROCUREMENT	NUMC	4	0	ID of a Claim Item Grouping (Obsolete)	*
14	ITEM	☐	ICL_SCLITEM	ICL_SCLITEM	CHAR	4	0	Claim Item	*
15	ITEM_PAY	☐	ICL_SCLITEM_PAY	ICL_SCLITEM	CHAR	4	0	Claim Item (Obsolete)	*
16	.INCLUDE	☐				0	0	InvItem GUI Structure: Basic Data, Benefit and Coverage Type
17	POSNR_INV	☐	ICL_INVPOSNR_INV	ICL_BENTYPE	CHAR	10	0	Benefit Type According to Invoice	*
18	POSNRN_INV	☐	ICL_INVDESCR_INV	ICL_TXT80	CHAR	80	0	Description of an Invoice Item (Acc. to Invoice)
19	COVTYPE_INV	☐	ICL_COVTYPE_INV	ICL_COVTYPE	CHAR	10	0	Coverage Type Acc. to Invoice	*
20	EVCURR	☐	ICL_EVCURR	WAERS	CUKY	5	0	Currency of Evaluated Amount	*
21	POSNR	☐	ICL_INVPOSNR	ICL_BENTYPE	CHAR	10	0	Benefit Type for Invoice	*
22	POSNRN	☐	ICL_INVDESCR		CHAR	80	0	Textual Description of an Invoice Item
23	COVTYPE	☐	ICL_COVTYPE	ICL_COVTYPE	CHAR	10	0	Coverage Type	*
24	RCOVTYPE	☐	ICL_RCOVTYPE	ICL_COVTYPE	CHAR	10	0	Benefit Coverage Type	*
25	XWAITPERIOD	☐	ICL_XWAITPERIOD	XFELD	CHAR	1	0	Probationary Periods Ignored
26	REJREASON	☐	ICL_REJREASON	ICL_REJREASON	CHAR	2	0	Claim Item Rejection Reason	*
27	EVAMTPERUNIT	☐	ICL_EVAMTPERUNIT_INVPAY	ICL_ITAMTPRO_SIGN	CURR	15	2	Original Amount per Quantity Unit
28	DAILY_APPROVED	☐	ICL_DAILY_APPROVED		NUMC	1	0	Daily of Daily Approved Claim Items
29	WEEKLY_APPROVED	☐	ICL_WEEKLY_APPROVED		NUMC	1	0	Weekly (Approved)
30	MONTHLY_APPROVED	☐	ICL_MONTHLY_APPROVED		NUMC	2	0	Number of Monthly Approved Claim Items
31	QUAN_APPROVED	☐	ICL_QUAN_APPROVED	ICL_LIMAMT	QUAN	10	3	Approved Quantity (Days, Visits, Area)
32	QUAN_SUM	☐	ICL_QUAN_SUM	ICL_LIMAMT	QUAN	10	3	Total of Approvals (Days, Visits, Area)
33	EVQUANUNIT	☐	ICL_INVQUANUNIT	MEINS	UNIT	3	0	Unit for Quantity in Invoice Item	T006
34	EVQUANTITY	☐	ICL_INVQUANTITY	ICL_LIMAMT	QUAN	10	3	Invoiced Quantity (Days, Visits, Area)
35	EVAMOUNT	☐	ICL_INVAMOUNT	ICL_ITAMTS	CURR	15	2	Disbursement Amount
36	NETAMOUNT	☐	ICL_NETAMOUNT	ICL_AMOUNT	CURR	15	2	Net Amount (with Plus/Minus Sign)
37	GROSAMOUNT	☐	ICL_GROSAMOUNT_SIGN	ICL_AMOUNT	CURR	15	2	Gross Amount (with Plus/Minus)
38	DISCOUNTAMOUNT	☐	ICL_DISCOUNTAMOUNT	ICL_AMOUNT	CURR	15	2	Discount on Invoice Amount
39	DISCOUNTPERCENT	☐	ICL_DISCOUNTPERCENT	ICL_PERCENT	DEC	5	2	Discount on Total Invoice Amount in Percent
40	XDISCOUNTPCT	☐	ICL_XDISCOUNTPERCENT	BOOLE	CHAR	1	0	Discount Amount Without Reference to Percent Discount
41	CONTRIBAMOUNT	☐	ICL_CONTRIBAMOUNT	ICL_AMOUNT	CURR	15	2	Amount of Copayment
42	XCONTRIBAMOUNT	☐	ICL_XCONTRIBAMOUNT	BOOLE	CHAR	1	0	Copayment Amount Without Reference to Copayment %
43	CONTRIBPERCENT	☐	ICL_CONTRIBPERCENT	ICL_PERCENT	DEC	5	2	Percentage of Copayment
44	.INCLUDE	☐				0	0	Approval Item Number (Inv)
45	CLAIM_APPR_INV	☐	ICL_CLAIM_APPR	ICL_CLAIM	CHAR	17	0	Approval Number	*
46	SUBCLAIM_APPR_INV	☐	ICL_SUBCL_APPR	ICL_SUBCL	CHAR	3	0	Subclaim Number as Second Part of Approval Number	*
47	PROCUREMENT_APPR_INV	☐	ICL_PROCUREMENT_APPR	ICL_PROCUREMENT	NUMC	4	0	ID of Claim Item Grouping as Part of Approval Number	*
48	ITEM_APPR_INV	☐	ICL_SCLITEM	ICL_SCLITEM	CHAR	4	0	Claim Item	*
49	APPR_REC_REF	☐	ICL_INV_APPRAIS		CHAR	7	0	Referenced Appraisal Receipt
50	CLAIM_APPR	☐	ICL_CLAIM_APPR	ICL_CLAIM	CHAR	17	0	Approval Number	*
51	SUBCLAIM_APPR	☐	ICL_SUBCL_APPR	ICL_SUBCL	CHAR	3	0	Subclaim Number as Second Part of Approval Number	*
52	PROCUREMENT_APPR	☐	ICL_PROCUREMENT_APPR	ICL_PROCUREMENT	NUMC	4	0	ID of Claim Item Grouping as Part of Approval Number	*
53	ITEM_APPR	☐	ICL_SCLITEM_INVPAY	ICL_SCLITEM	CHAR	4	0	Claim Item as Part of Approval Item Number	*
54	.INCLUDE	☐				0	0	Invoice item
55	STARTDATE_INV	☐	ICL_STARTDATE_INVOICE	DATE	DATS	8	0	Start Data According to Invoice Entry
56	ENDDATE_INV	☐	ICL_ENDDATE_INVOICE	DATUM	DATS	8	0	End Date According to Invoice
57	REFNO_INV	☐	ICL_SCLITEMREF	ICL_SCLITEMREF	CHAR	15	0	External Reference Number
58	STATUS_INV	☐	ICL_SCLITEMS	ICL_SCLITEMS	CHAR	2	0	Status of Claim Item
59	TAXCODE_INV	☐	ICL_TAXCODE_INV	ICL_TAXCODE_INV	CHAR	2	0	Type of Sales Tax Calculation	*
60	ITEMUSE_INV	☐	ICL_ITEMUSE_INV	ICL_ITEMUSE	CHAR	2	0	Usage Type of Claim Item (Acc. to Invoice)	*
61	EVQUANUNIT_INV	☐	ICL_INVQUANUNIT_INV	MEINS	UNIT	3	0	Unit for Quantity in Invoice Item (Acc. to Invoice)	T006
62	EVQUANTITY_INV	☐	ICL_INVQUANTITY_INV	ICL_LIMAMT	QUAN	10	3	Invoiced Quantity (Days, Visit, Area) Acc. to Invoice
63	EVAMOUNT_INV	☐	ICL_INVAMOUNT_INV	ICL_RESAMOUNT	CURR	15	2	Payout Amount According to Invoice
64	DNUMBER_INV	☐	ICL_NUMBER_INV	NUMC5	NUMC	5	0	Quantity (Inv.)
65	FACTOR_INV	☐	ICLH_FACTOR_INV	ICLH_FACTOR	DEC	7	4	Factor (Inv)
66	GROSAMOUNT_INV	☐	ICL_GROSAMOUNT_INV	ICL_AMOUNT	CURR	15	2	Gross Amount Acc. to Invoice
67	NETAMOUNT_INV	☐	ICL_NETAMOUNT_INV	ICL_AMOUNT	CURR	15	2	Net Amount Acc. to Invoice (with Plus/Minus Sign)
68	EVAMTPERUNIT_INV	☐	ICL_EVAMTPERUNIT_INV	ICL_ITAMTPRO_SIGN	CURR	15	2	Original Amount per Quantity Unit (acc. to Invoice)
69	DISCOUNTAMOUNT_INV	☐	ICL_DISCOUNTAMOUNT_INV	ICL_AMOUNT	CURR	15	2	Discount on Invoide Amount According to Invoice
70	DISCOUNTPERCENT_INV	☐	ICL_DISCOUNTPERCENT_INV	ICL_PERCENT	DEC	5	2	Discount on Total Invoice Amount in Percent (Acc. to Inv)
71	XDISCOUNTPCT_INV	☐	ICL_XDISCOUNTPERCENT_INV	BOOLE	CHAR	1	0	Discount Amount Calculated from Percentage (Acc. to Invoice)
72	CONTRIBAMOUNT_INV	☐	ICL_CONTRIBAMOUNT_INV	ICL_AMOUNT	CURR	15	2	Amount of Copayment (Acc. to Invoice)
73	XCONTRIBAMOUNT_INV	☐	ICL_XCONTRIBAMOUNT_INV	BOOLE	CHAR	1	0	Copayment Amount Without Reference to Copayment % (Invoice)
74	CONTRIBPERCENT_INV	☐	ICL_CONTRIBPERCENT_INV	ICL_PERCENT	DEC	5	2	Copayment in Percent (acc. to Invoice)
75	STARTDATE	☐	ICL_STARTDATE_APPROVED	DATE	DATS	8	0	Start Date in Invoice Processing
76	ENDDATE	☐	ICL_ENDDATE_APPROVED	DATUM	DATS	8	0	End Date in Invoice Processing
77	REFNO	☐	ICL_SCLITEMREF	ICL_SCLITEMREF	CHAR	15	0	External Reference Number
78	STATUS	☐	ICL_SCLITEMS	ICL_SCLITEMS	CHAR	2	0	Status of Claim Item
79	ITEMUSE	☐	ICL_ITEMUSE	ICL_ITEMUSE	CHAR	2	0	Usage Type of Claim Item	TICL332
80	TAXCODE	☐	ICL_TAXCODE_INVPAY	ICL_TAXCODE_INV	CHAR	2	0	Type of Sales Tax Calculation	TICL333
81	XERROR	☐	ICL_XERROR_INV	XFELD	CHAR	1	0	Task for Invoice Item Exists
82	COLOR	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
83	XREIMBURSE	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
84	SEQNUM	☐	ICL_SEQNUM	ICL_SEQNUM	NUMC	4	0	Item Sequence Number
85	SUB_SEQNUM	☐	ICL_SUB_SEQNUM_D		NUMC	2	0	Sequence Subitem Number
86	.INCLUDE	☐				0	0	ICLH Inv/PP: Ben/Service/Fees Catalog to Invoice/Payt Propsl
87	SERVCATID	☐	ICL_SERVCATID	ICL_SERVCATID	CHAR	10	0	ID of a Benefits, Services and Fees Catalog	*
88	SERVCATIDLN	☐	ICL_SERVCATNAME	TEXT30	CHAR	30	0	Name of Benefits/Services/Fee Catalog
89	SCPOSID	☐	ICL_SERVCAT_POSID	ICL_SERVCAT_POSID	CHAR	20	0	ID of a Benefits Catalog Item
90	SCPOSLN	☐	ICL_SERVCAT_POS_NAME	TEXT100	CHAR	100	0	Long Text of Benefits Catalog Item
91	SCPOSID_INT	☐	ICL_SERVCAT_POSID_INT	SYSUUID_C	CHAR	32	0	Internal ID of Benefits Catalog Item
92	SCPOS_VALPERUNIT_INV	☐	ICL_SERVCAT_POS_VALPERUNIT	ICL_SERVCAT_POS_VALPERUNIT	DEC	20	12	Value per Unit of Benefits Catalog Item
93	SCPOS_VALPERUNIT	☐	ICL_SERVCAT_POS_VALPERUNIT	ICL_SERVCAT_POS_VALPERUNIT	DEC	20	12	Value per Unit of Benefits Catalog Item
94	.INCLUDE	☐				0	0	InvItm GUI Structure: Basic Data, BenServFeeCatlg, BC Item
95	SERVCATID_INV	☐	ICL_SERVCATID	ICL_SERVCATID	CHAR	10	0	ID of a Benefits, Services and Fees Catalog	*
96	SERVCATIDLN_INV	☐	ICL_SERVCATNAME	TEXT30	CHAR	30	0	Name of Benefits/Services/Fee Catalog
97	SCPOSID_INV	☐	ICL_SERVCAT_POSID	ICL_SERVCAT_POSID	CHAR	20	0	ID of a Benefits Catalog Item
98	SCPOSLN_INV	☐	ICL_SERVCAT_POS_NAME	TEXT100	CHAR	100	0	Long Text of Benefits Catalog Item
99	SCPOSID_INT_INV	☐	ICL_SERVCAT_POSID_INT	SYSUUID_C	CHAR	32	0	Internal ID of Benefits Catalog Item
100	.INCLUDE	☐				0	0	FS-CM: Quantity and Unit for Value per Unit of Catalog Item
101	SCQUANUNIT_INV	☐	ICL_INVQUANUNIT_INV	MEINS	UNIT	3	0	Unit for Quantity in Invoice Item (Acc. to Invoice)	T006
102	SCQUANTITY_INV	☐	ICL_INVQUANTITY_INV	ICL_LIMAMT	QUAN	10	3	Invoiced Quantity (Days, Visit, Area) Acc. to Invoice
103	SCQUANUNIT	☐	ICL_INVQUANUNIT	MEINS	UNIT	3	0	Unit for Quantity in Invoice Item	T006
104	SCQUANTITY	☐	ICL_INVQUANTITY	ICL_LIMAMT	QUAN	10	3	Invoiced Quantity (Days, Visits, Area)
105	DNUMBER	☐	ICL_NUMBER_PYS	NUMC5	NUMC	5	0	Number
106	FACTOR	☐	ICLH_FACTOR	ICLH_FACTOR	DEC	7	4	Factor
107	SINGLE_AMOUNT	☐	ICL_SINGLE_AMOUNT	ICL_ITAMTS	CURR	15	2	Single Amount
108	SINGLE_AMOUNT_INV	☐	ICL_SINGLE_AMOUNT_INV	ICL_ITAMTS	CURR	15	2	Single Amount (Inv)
109	DESCRIPTION	☐	ICL_DPDESC	TEXT40	CHAR	40	0	Claim Item Description
110	DESCRIPTION_INV	☐	ICL_DPDESC_INV	TEXT40	CHAR	40	0	Description of Claim Item (Inv)
111	NUM_OF_DECPL	☐			NUMC	2	0
112	NUM_OF_DECPL_INV	☐			NUMC	2	0
113	.INCLUDE	☐				0	0	External Bill Review: Item Detail (#1)
114	DESCRIPTION_EBR	☐	ICL_DPDESC_EBR	TEXT40	CHAR	40	0	Description of Claim Item (EBR)
115	REJREASON_EBR	☐	ICL_ADJREASON	ICL_REJREASON	CHAR	2	0	Adjustment Reason	*
116	REFNO_EBR	☐	ICL_SCLITEMREF	ICL_SCLITEMREF	CHAR	15	0	External Reference Number
117	STARTDATE_EBR	☐	ICL_STARTDATE_EBR	DATE	DATS	8	0	Start Data Acc.to External Bill Reviewer
118	ENDDATE_EBR	☐	ICL_ENDDATE_EBR	DATUM	DATS	8	0	End Date According to Invoice (External Bill Review)
119	PDREF_EBR	☐	ICL_PDREF_EBR	ICL_PDREF_DOMAIN	CHAR	10	0	Reference to Purchasing Document
120	PDPOS_EBR	☐	ICL_PDPOS_EBR	ICL_PDPOS	NUMC	10	0	Reference to Item Number (EBR)
121	.INCLUDE	☐				0	0	External Bill Review: Item Detail (#2)
122	EVQUANUNIT_EBR	☐	ICL_INVQUANUNIT_EBR	MEINS	UNIT	3	0	Unit for Quantity/Number in an Invoice Item (EBR)	T006
123	EVQUANTITY_EBR	☐	ICL_INVQUANTITY_EBR	ICL_LIMAMT	QUAN	10	3	Invoiced Quantity (Days, Visit, Area) Acc. to EBR
124	EVAMTPERUNIT_EBR	☐	ICL_EVAMTPERUNIT_EBR	ICL_ITAMTPRO_SIGN	CURR	15	2	Original Amount per Quantity Unit (EBR)
125	EVAMOUNT_EBR	☐	ICL_INVAMOUNT_EBR	ICL_AMOUNT	CURR	15	2	Payout Amount Acc. to External Bill Review
126	DISCOUNTAMOUNT_EBR	☐	ICL_DISCOUNTAMOUNT_EBR	ICL_AMOUNT	CURR	15	2	Deduction - Invoice Amount (EBR)
127	EVCURR_EBR	☐	ICL_EVCURR	WAERS	CUKY	5	0	Currency of Evaluated Amount	TCURC
128	.INCLUDE	☐				0	0	Claim Items - Additional Items
129	ADDITIONAL_ITEM	☐	ICL_ITEM_SPLIT_D	ICL_ITEM_SPLIT_DO	CHAR	1	0	Additional Claim Item
130	ADDIT_ITEM_SUM	☐	ICL_ITEM_SUM_D	XFELD	CHAR	1	0	Total of Additional Claim Items
131	.INCLUDE	☐				0	0	Remuneration Category
132	.INCLUDE	☐				0	0	Remuneration Category
133	REMUN_TYPE	☐	ICL_REMUN_TYPE_D_PE	ICL_REMUN_TYPE_D_PE	CHAR	4	0	Remuneration Category	ICL_CREMUNTYPE
134	NAME_SHORT	☐	ICL_REMUN_NAME_SHORT_D_PE	ICL_REMUN_NAME_SHORT_D_PE	CHAR	10	0	Name of Remuneration Category
135	NAME	☐	ICL_REMUN_NAME_D_PE	ICL_REMUN_NAME_D_PE	CHAR	30	0	Description of Remuneration Category

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICLH_ICLH46	EVCURR_EBR	TCURC	WAERS
2	ICLH_ICLH46	EVQUANUNIT	T006	MSEHI	KEY
3	ICLH_ICLH46	EVQUANUNIT_EBR	T006	MSEHI
4	ICLH_ICLH46	EVQUANUNIT_INV	T006	MSEHI	KEY	1	CN
5	ICLH_ICLH46	ITEMUSE	TICL332	ITEMUSE	REF	1	CN
6	ICLH_ICLH46	REMUN_TYPE	ICL_CREMUNTYPE	REMUN_TYPE	KEY	1	CN
7	ICLH_ICLH46	SCQUANUNIT	T006	MSEHI	REF	1	CN
8	ICLH_ICLH46	SCQUANUNIT_INV	T006	MSEHI	REF	1	CN
9	ICLH_ICLH46	TAXCODE	TICL333	TAXCODE_INV	REF	1	CN

History

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