SAP ABAP Table ICLE_ICLH46_MASSINV_ALV (Invoice, Mass Processing Items: ALV List)

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	ICLE_ICLH46_MASSINV_ALV	Table Relationship Diagram
Short Description	Invoice, Mass Processing Items: ALV List

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

History

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