SAP ABAP Table ICLH_ICLH40_MASSINV (Invoice Mass Entry)

Hierarchy

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

Basic Data

Table Category	INTTAB	Structure
Structure	ICLH_ICLH40_MASSINV	Table Relationship Diagram
Short Description	Invoice Mass Entry

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	☐	ICL_NUMBER_MASSINVHEAD	NUMC04	NUMC	4	0	Internal Temporary Number with Mass Invoice Processing
2	SEL	☐	ICL_SELECT	BOOLE	CHAR	1	0	General Selection Indicator
3	XSELECT	☐	ICL_SELECT	BOOLE	CHAR	1	0	General Selection Indicator
4	POLICY	☐	ICL_POLICY	ICL_POLICY	CHAR	17	0	Contract Number
5	LOSSTYPE	☐	ICL_LOSSTYPE	ICL_LOSSTYPE	CHAR	4	0	Incident Type of a Claim	TICL060
6	POLPROD	☐	ICL_POLPROD	ICL_POLPROD	CHAR	6	0	Policy Product	*
7	GENERAT	☐	ICL_GENERAT	ICL_GENERAT	NUMC	5	0	Policy Product Generation	*
8	VERSION	☐	ICL_POLPRODV	ICL_CUST_VERSION	NUMC	5	0	Policy Product Version	*
9	POLPRODN	☐	ICL_POLPRODN	TEXT30	CHAR	30	0	Name of Policy Product
10	PLINEOFBUS	☐	ICL_LINEOFBUS	ICL_LINEOFBUS	CHAR	3	0	Insurance Line of Business	*
11	CLAIMTYPE	☐	ICL_CLTYPE	ICL_CLTYPE	CHAR	4	0	Internal Claim Type	*
12	CLTYPEG	☐	ICL_CLTYPEG	ICL_CLTYPEG	NUMC	5	0	Generation of Internal Claim Type	*
13	CLTYPEV	☐	ICL_CLTYPEV	ICL_CLTYPEV	NUMC	5	0	Internal Claim Type Version	*
14	SUBCLTYPE	☐	ICL_SUBCLTYPE	ICL_SUBCLTYPE	CHAR	4	0	Subclaim Type	TICL004
15	CLAIM	☐	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	*
16	SUBCLAIM	☐	ICL_SUBCL	ICL_SUBCL	CHAR	3	0	Subclaim	*
17	XCREATENEWSUBCLAIM	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
18	XCREATENEWCLAIM	☐	BOOLE_D	BOOLE	CHAR	1	0	Data element for domain BOOLE: TRUE (='X') and FALSE (=' ')
19	ISSUEDATE_PRESCR	☐	ICL_ISSUEDATE_PRESCR	DATS	DATS	8	0	Date Prescription Created Acc. to Invoice
20	CLAIM_APPR	☐	ICL_CLAIM_APPR	ICL_CLAIM	CHAR	17	0	Approval Number	*
21	SUBCLAIM_APPR	☐	ICL_SUBCL_APPR	ICL_SUBCL	CHAR	3	0	Subclaim Number as Second Part of Approval Number	*
22	PROCUREMENT_APPR	☐	ICL_PROCUREMENT_APPR	ICL_PROCUREMENT	NUMC	4	0	ID of Claim Item Grouping as Part of Approval Number	*
23	ACQUISITIONDATE	☐	ICL_ACQUISITIONDATE	DATS	DATS	8	0	Date Entered
24	AMOUNT_INV	☐	ICL_INV_AMOUNT_TOTAL	ICL_AMOUNT	CURR	15	2	Net Total: Total of Net Amounts of All Items (acc.to Inv)
25	BULKINV	☐	ICL_CCEVENT_INVOICE	ICL_CCEVENT	CHAR	17	0	Internal Collective Invoice Number	*
26	CREATEDBY	☐	ICL_CREATEDBY_INV	XUBNAME	CHAR	12	0	Invoice Created by	*
27	CURRENCY	☐	ICL_CURRENCY	WAERS	CUKY	5	0	Currency	TCURC
28	DATEFROM	☐	ICL_DATEFROM_INV	DATS	DATS	8	0	Start of Invoice Period: Date
29	DATETO	☐	ICL_DATETO_INV	DATS	DATS	8	0	End of Invoice Period: Date
30	EXTDOCUMENT	☐	ICL_EXTDOCUMENT	ICL_EXTDOCUMENT	CHAR	16	0	External Document Number
31	EXTERNALREF	☐	ICL_EXTERNALREF	ICL_EXTERNALREF	CHAR	20	0	External Reference of Claim Item Grouping
32	INVOICEREF	☐	ICL_INVOICEREF	CHAR20	CHAR	20	0	External Invoice Number
33	INVOICEREF_BULK	☐	ICL_INVOICEREF_BULK	CHAR16	CHAR	16	0	External Collective Invoice Number
34	EXTERNALREF_BULK	☐	ICL_EXTERNALREF_BULK	ICL_EXTERNALREF_BULK	CHAR	20	0	External Collective Reference
35	INVTYPE	☐	ICL_INVTYPE	ICL_PDOCCATTYPE	CHAR	3	0	Invoice Type	TICL153
36	INVTYPEN	☐	ICL_INVTYPEN	ICL_PDOCCATTYPEN	CHAR	40	0	Text for Invoice Type
37	ISSUEDATE	☐	ICL_ISSUEDATE_INV	DATS	DATS	8	0	Invoice Date
38	RECEIVEDATE	☐	ICL_RECEIVEDATE	DATS	DATS	8	0	Date Received
39	VO_PART	☐	ICLH_VO_PART	BU_PARTNER	CHAR	10	0	Business Partner Number of Prescriber	*
40	DESCRP_VO	☐	ICLH_VO_DESCRP	TEXT50	CHAR	50	0	Description of Business Partner Issuing Prescription
41	ACCIDENT	☐	ICL_ACCIDENT	ICL_ACCIDENT	CHAR	2	0	Accident or Other Reason for Possible Recovery	*
42	SUBROGATION	☐	ICL_SUBROGATION	ICL_SUBROGATION	CHAR	2	0	Indication Whether Recovery Claim Might Be Involved	*
43	DATASOURCE	☐	ICL_DATASOURCE	ICL_DATASOURCE	CHAR	2	0	Data Origin	TICL136
44	COLOR	☐	CHAR4	CHAR4	CHAR	4	0	Not More Closely Defined Area, Possibly Used for Patchlevels
45	PDOCCAT	☐	ICL_PDOCCAT	ICL_PDOCCAT	CHAR	2	0	Claim Item Grouping Category	*
46	STATUS	☐	ICL_INVOICESTATUS	ICL_STATUS	CHAR	2	0	Status of an Invoice	*
47	XCLAIMDETERMINE	☐	XFELD	XFELD	CHAR	1	0	Checkbox
48	.INCLUDE	☐				0	0	Mass Entry: Payee, Invoicing Party, Service Provider
49	LE_PART	☐	ICLH_LE_PART	BU_PARTNER	CHAR	10	0	Business Partner Number of Service Provider	*
50	INV_PART	☐	ICL_INVOICER	BU_PARTNER	CHAR	10	0	Invoicing Party	*
51	PAYEE	☐	ICL_PAYE_INV	BU_PARTNER	CHAR	10	0	Payee Acc. to Invoice	*
52	DESCRP_INV	☐	ICLH_INV_DESCRP	CHAR50	CHAR	50	0	Textual Description of Invoicing Party
53	DESCRP_LE	☐	ICLH_LE_DESCRP	TEXT50	CHAR	50	0	Description of Service Provider Business Partner
54	DESCRP_PAYEE	☐	ICL_PAYEDSC	CHAR50	CHAR	50	0	Payee
55	DESCRP_POLH	☐	ICL_POLHNAME	CHAR50	CHAR	50	0	Short Description of Policyholder
56	POLH_PART	☐	ICL_POLH	BU_PARTNER	CHAR	10	0	Insured	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICLH_ICLH40_MASSINV	CURRENCY	TCURC	WAERS	KEY
2	ICLH_ICLH40_MASSINV	DATASOURCE	TICL136	DATASOURCE	KEY	1	CN
3	ICLH_ICLH40_MASSINV	INVTYPE	TICL153	PDOCCATTYPE	KEY
4	ICLH_ICLH40_MASSINV	LOSSTYPE	TICL060	LOSSTYPE	KEY
5	ICLH_ICLH40_MASSINV	SUBCLTYPE	TICL004	SUBCLTYPE	KEY

History

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