SAP ABAP Table ICLE_BULKINV_SEARCH_ALV (Collective Invoice: Search Template (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	ICLE_BULKINV_SEARCH_ALV	Table Relationship Diagram
Short Description	Collective Invoice: Search Template (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	BULKINV	☐	ICL_BULKINV	ICL_CCEVENT	CHAR	17	0	Collective Invoice	*
2	INVTYPE	☐	ICL_BULKINVTYPE	ICL_CCEVENTTY	CHAR	2	0	Collective Invoice Type	*
3	.INCLUDE	☐				0	0	Claim Bundle
4	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
5	ACTIVE	☐	ICL_ACTIVE	ICL_ACTIVE	CHAR	1	0	Table entry is active (A) or in suspense (S)
6	CCEVENT	☐	ICL_CCEVENT	ICL_CCEVENT	CHAR	17	0	Claim Bundle	*
7	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
8	CHANGETIME	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
9	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
10	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
11	.INCLUDE	☐				0	0	Claim Bundle
12	.INCLUDE	☐				0	0	Organizational Include (Short Version)
13	CREATEDBY	☐	ICL_CREATEDBY	XUBNAME	CHAR	12	0	Created By	USR02
14	CREATETIME	☐	ICL_CREATEUTC	ICL_TIMESTAMP	DEC	15	0	Created: UTC Date+Time
15	CCTYPE	☐	ICL_CCEVENTCAT	ICL_CCEVENTCAT	CHAR	2	0	Claim Bundle Type	TICL001
16	SUBTYPE	☐	ICL_CCEVENTTY	ICL_CCEVENTTY	CHAR	2	0	Subtype of Claim Bundle Type	TICL002
17	CURR	☐	ICL_CCEVENTCUR	WAERS	CUKY	5	0	Currency of Claim Bundle Reserve	TCURC
18	LIMIT	☐	ICL_CCEVENTLIM	ICL_TOAMT	CURR	17	2	Claim Bundle Compensation Reserve
19	LIMITE	☐	ICL_CCEVENTLIME		CURR	17	2	Claim Bundle Expenses Reserve
20	CODE	☐	ICL_CCEVENTCODE	CHAR12	CHAR	12	0	External Name for Claim Bundle
21	NAME	☐	ICL_CCEVENTNAME	TEXT20	CHAR	20	0	Name of Claim Bundle
22	RANGEFROM	☐	ICL_CCEVENTFROM	DATE	DATS	8	0	Event Period: Date From
23	RANGETO	☐	ICL_CCEVENTTO	DATE	DATS	8	0	Event Period: Date To
24	HOTLINE	☐	ICL_CCEVENTTEL	CHAR30	CHAR	30	0	Coordinator phone number
25	LOCATYPE	☐	ICL_CCEVENTLOCA	ICL_LOCTYPE	NUMC	1	0	Define Location via Region '1', Postal Code '2', Address '3'
26	STATUS	☐	ICLE_BUNDLE_STATUS_D	ICL_STATUS	CHAR	2	0	Status of Claim Bundle	TICL140
27	BUNDLECAUSE	☐	ICL_BUNDLECAUSE	ICL_BUNDLECAUSE	CHAR	3	0	Reason for Creation of Claim Bundle	TICL012
28	OWNER	☐	ICL_BUNDLEOWNER	XUBNAME	CHAR	12	0	Claim Bundle Handler	USR02
29	INVOICEREF_BULK	☐	ICL_INVOICEREF_BULK	CHAR16	CHAR	16	0	External Collective Invoice Number
30	EXTERNALREF_BULK	☐	ICL_EXTERNALREF_BULK	ICL_EXTERNALREF_BULK	CHAR	20	0	External Collective Reference
31	ISSUEDATE	☐	ICL_ISSUEDATE_INVBULK	DATS	DATS	8	0	Collective Invoice Date
32	AMOUNT_TOTAL	☐	ICL_AMOUNT_BULKINV_TOTAL	ICL_AMOUNT	CURR	15	2	Net Total Amount of Collective Invoice (acc. to Coll.Inv.)
33	PAYMENTLEVEL	☐	ICL_PAYMENTLEVEL	ICL_PAYMENTLEVEL	NUMC	1	0	Payment Level of a Collective Invoice
34	DATASOURCE	☐	ICL_DATASOURCE	ICL_DATASOURCE	CHAR	2	0	Data Origin	TICL136
35	RECEIVEDATE	☐	ICL_RECEIVEDATE	DATS	DATS	8	0	Date Received
36	CLMINPROCESS	☐	ICL_CLMSTATUS_INPROCESS	XFELD	CHAR	1	0	Dependent Claim Exists with Status "In Process"
37	RELEASED	☐	ICL_STATUS_RELEASED	XFELD	CHAR	1	0	Status "Released"
38	CANCEL	☐	ICL_STATUS_CANCEL	XFELD	CHAR	1	0	Status "Cancelled"
39	INPROCESS	☐	ICL_STATUS_INPROCESS	XFELD	CHAR	1	0	Status "In Process"
40	CLMINPROC_CNTR	☐	ICL_CLMSTATUS_INPROCESS_CNTR	ICL_CLMSTATUS_INPROCESS_CNTR	INT4	10	0	Counter for Number of Open Claims
41	STHANDLER	☐	ICLE_STHANDLER	XFELD	CHAR	1	0	"Bundle Processing" Process Is Active
42	WF_STATUS	☐	ICL_WF_STATUS	ICL_WF_STATUS	NUMC	1	0	Workflow Status
43	.INCLUDE	☐				0	0	Collective Subrogation: Special Attributes
44	CCSBRBNDL	☐	ICL_CCSBRBNDL	ICL_CCEVENT	CHAR	17	0	Number of Collective Subrogation/Recovery	ICLCCEVENT
45	CCSBRTYPE	☐	ICL_CCSBRTYPE	ICL_CCSBRTYPE	CHAR	2	0	Subrogation Claim Type in Subrogation	TICL177
46	CHREASONSBR	☐	ICL_CHREASONSBR	ICL_CHREASONSBR	CHAR	2	0	Change Reason for Status of Collective Subrogation/Recovery	TICL175
47	BILLINGDATE	☐	ICL_BILLINGDATE	DATE	DATS	8	0	Next Billing Date
48	RESUBDATE	☐	ICL_RESUBDATE	DATE	DATS	8	0	Date of Resubmission
49	SBRNOTIFDATE	☐	ICL_SBRNOTIFDATE	DATE	DATS	8	0	Date on Which Subrogation Claim Was Reported
50	.INCLUDE	☐				0	0	Collective Invoice: Participants
51	INVOICER	☐	ICL_INVOICER	BU_PARTNER	CHAR	10	0	Invoicing Party	*
52	INVOICERN	☐	ICLH_INV_DESCRP	CHAR50	CHAR	50	0	Textual Description of Invoicing Party
53	SERVICEPROV	☐	ICLH_LE_PART	BU_PARTNER	CHAR	10	0	Business Partner Number of Service Provider	*
54	SERVICEPROVN	☐	ICLH_LE_DESCRP	TEXT50	CHAR	50	0	Description of Service Provider Business Partner
55	PAYEE	☐	ICL_PAYE_INV	BU_PARTNER	CHAR	10	0	Payee Acc. to Invoice	*
56	PAYEEN	☐	ICL_PAYEDSC	CHAR50	CHAR	50	0	Payee

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICLE_BULKINV_SEARCH_ALV	BUNDLECAUSE	TICL012	BUNDLECAUSE
2	ICLE_BULKINV_SEARCH_ALV	CCSBRBNDL	ICLCCEVENT	CCEVENT	REF	1	CN
3	ICLE_BULKINV_SEARCH_ALV	CCSBRTYPE	TICL177	CCSBRTYPE	REF	1	CN
4	ICLE_BULKINV_SEARCH_ALV	CCTYPE	TICL001	CCTYPE
5	ICLE_BULKINV_SEARCH_ALV	CHANGEDBY	USR02	BNAME
6	ICLE_BULKINV_SEARCH_ALV	CHREASONSBR	TICL175	CHREASONSBR	REF	1	CN
7	ICLE_BULKINV_SEARCH_ALV	CLIENT	T000	MANDT
8	ICLE_BULKINV_SEARCH_ALV	CREATEDBY	USR02	BNAME
9	ICLE_BULKINV_SEARCH_ALV	CURR	TCURC	WAERS
10	ICLE_BULKINV_SEARCH_ALV	DATASOURCE	TICL136	DATASOURCE	KEY
11	ICLE_BULKINV_SEARCH_ALV	OWNER	USR02	BNAME
12	ICLE_BULKINV_SEARCH_ALV	STATUS	TICL140	STATUS
13	ICLE_BULKINV_SEARCH_ALV	SUBTYPE	TICL002	SUBTYPE

History

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