SAP ABAP Table ICLE_ICLH46_MASSINV (Mass Processing: Invoice Items)

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

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

History

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