SAP ABAP Table ICLEBULKSBR (Coll.Subro/Recovery Settlement)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_EVENT (Package) FS-CM: Claim Bundle

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ICLEBULKSBR	Table Relationship Diagram
Short Description	Coll.Subro/Recovery Settlement

Delivery and Maintenance

Pool/cluster
Delivery Class	A	Application Table (Master- and Transaction Data)
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	CLIENT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	ACTIVE	☑	ICL_ACTIVE	ICL_ACTIVE	CHAR	1	0	Table entry is active (A) or in suspense (S)
3	CCEVENT	☑	ICL_CCEVENT	ICL_CCEVENT	CHAR	17	0	Claim Bundle	ICLCCEVENT
4	BULKSBR	☑	ICL_BULKSBR	ICL_BULKSBR	CHAR	3	0	Number of Collective Subrogation/Recovery Settlement
5	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
6	CHANGETIME	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
7	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
8	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
9	.INCLUDE	☐				0	0	Collective Subrogation/Recovery Attributes
10	SUBTYPE	☐	ICLE_BSR_BILL_TYPE	ICL_CCEVENTTY	CHAR	2	0	Subtype Settlement Collective Subrogation/Recovery	TICL002
11	CCSBRTYPE	☐	ICLE_BSR_BILL_SBRTYPE	ICL_CCSBRTYPE	CHAR	2	0	Subrogation Claim Type Settlement Collective Subro/Recovery	TICL177
12	BSR_PAYER	☐	ICL_PAYER	BU_PARTNER	CHAR	10	0	Payer	*
13	RANGEFROM	☐	ICL_PAYM_FROM	DATE	DATS	8	0	Payment Assignment: Date From
14	RANGETO	☐	ICL_PAYM_TO	DATE	DATS	8	0	Payment Assignment: Date To
15	STATUS	☐	ICLE_BSR_BILL_STATUS_D	ICL_STATUS	CHAR	2	0	Status of Settlement in Collective Subrogation/Recovery	TICL140
16	WF_STATUS	☐	ICL_WF_STATUS	ICL_WF_STATUS	NUMC	1	0	Workflow Status
17	CHREASONSBR	☐	ICLE_BSR_BILL_CHREASON_TRANS_D	ICL_CHREASONSBR	CHAR	2	0	Transferred Change Reason for Settlement in Coll.Subro/Rcvry	TICL175
18	BILLINGDATE	☐	ICL_BILLINGDATE	DATE	DATS	8	0	Next Billing Date
19	REQUESTDATE	☐	ICL_REQUESTDATE	DATE	DATS	8	0	Date of Subro/Recovery Receivable (Actual Settlement Date)
20	RESUBDATE	☐	ICL_RESUBDATE	DATE	DATS	8	0	Date of Resubmission
21	SBRNOTIFDATE	☐	ICL_SBRNOTIFDATE	DATE	DATS	8	0	Date on Which Subrogation Claim Was Reported
22	ASSIGN_GUID16	☐	ICL_ASSIGN_GUID16	CHAR16	CHAR	16	0	Compressed UUID (16 Character)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICLEBULKSBR	CCEVENT	ICLCCEVENT	CCEVENT	KEY	1	CN
2	ICLEBULKSBR	CCSBRTYPE	TICL177	CCSBRTYPE	REF	1	CN
3	ICLEBULKSBR	CHANGEDBY	USR02	BNAME
4	ICLEBULKSBR	CHREASONSBR	TICL175	CHREASONSBR	REF	1	CN
5	ICLEBULKSBR	CLIENT	T000	MANDT	KEY	1	CN
6	ICLEBULKSBR	STATUS	TICL140	STATUS	REF	1	CN
7	ICLEBULKSBR	SUBTYPE	TICL002	SUBTYPE	REF	1	CN

History

Last changed by/on	SAP	20110901
SAP Release Created in	600