SAP ABAP Table ICL_BW_SUBROG (Extract Structure for Subrogation/Recovery)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_EXTRACT (Package) FS-CM: Claims Management: Data Extracts

Basic Data

Table Category	INTTAB	Structure
Structure	ICL_BW_SUBROG	Table Relationship Diagram
Short Description	Extract Structure for Subrogation/Recovery

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	Subrogation/Recovery (Header)
2	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	ACTIVE	☐	ICL_ACTIVE	ICL_ACTIVE	CHAR	1	0	Table entry is active (A) or in suspense (S)
4	CLAIM	☐	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	ICLCLAIM
5	SUBROG_GUID	☐	ICL_SUBROG_GUID_D_PE	SYSUUID_C	CHAR	32	0	Universal Unique Identifier of Subrogation/Recovery
6	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
7	CHANGETIME	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
8	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
9	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
10	.INCLUDE	☐				0	0	Subrogation/Recovery Attributes
11	TYPE	☐	ICL_SUBROG_TYPE_D_PE	ICL_SUBROG_TYPE	CHAR	10	0	Type of Subrogation/Recovery	ICL_CSUBROGTYPE
12	REASON	☐	ICL_SUBROG_REASON_D_PE	ICL_SUBROG_REASON	CHAR	10	0	Subrogation/Recovery Reason	ICL_CSUBROGREAS
13	ESTIMAMOUNT	☐	ICL_SUBROG_ESTIMAMOUNT_D_PE	ICL_SUBROG_AMOUNT	CURR	15	2	Estimated Subrogation/Recovery Amount
14	CURRENCY	☐	ICL_SUBROG_CURRENCY_D_PE	WAERS	CUKY	5	0	Subrogation/Recovery Currency	TCURC
15	LIABRATE	☐	ICL_SUBROG_LIABRATE_D_PE		DEC	5	2	Liability Rate for Subrogation/Recovery
16	PROBABILITY	☐	ICL_SUBROG_PROBABILITY_D_PE		DEC	5	2	Subrogation/Recovery Probability
17	BP_SBRG_MAIN	☐	ICL_SUBROG_BP_SBRG_D_PE	BU_PARTNER	CHAR	10	0	Party Liable	*
18	LITHGUID	☐	ICL_LITHGUID	SYSUUID_C	CHAR	32	0	Universal Unique Identifier of Litigation
19	.INCLUDE	☐				0	0	Subrogation/Recovery Status
20	SR_STATUS	☐	ICL_SUBROG_STATUS_D_PE	ICL_SUBROG_STATUS	CHAR	1	0	Subrogation/Recovery Status
21	SENTDATE	☐	ICL_SUBROG_SENTDATE_D_PE	DATS	DATS	8	0	Date Sent (Notification of Subrogation/Recovery Activation)
22	FINISHED	☐	ICL_SUBROG_FINISHED_D_PE	BOOLE	CHAR	1	0	Subrogation/Recovery Status "Completed"
23	CLOSEREASON	☐	ICL_SR_CLOSE_REASON_D_PE	TEXT80	CHAR	80	0	Closure Reason for Subrogation/Recovery
24	.INCLUDE	☐				0	0	Subrogation/Recovery IDs
25	SUBROG_ID	☐	ICL_SUBROG_ID_D_PE		NUMC	5	0	Number of Subrogation/Recovery
26	SUBROG_CGUID	☐	ICL_SUBROG_CGUID_D_PE		CHAR	16	0	Subrogation/Recovery: Compressed GUID (Univ.Unique Identif.)
27	CLAIMTYPE	☐	ICL_CLTYPE	ICL_CLTYPE	CHAR	4	0	Internal Claim Type	*
28	DATELOSS	☐	ICL_LOSSDATE	DATE	DATS	8	0	Date of Loss/Claim
29	PLINEOFBUS	☐	ICL_LINEOFBUS	ICL_LINEOFBUS	CHAR	3	0	Insurance Line of Business	*
30	COMPANYCODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
31	UPDMOD	☐	RODMUPDMOD	RODMUPDMOD	CHAR	1	0	BW Delta Process: Record Mode

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICL_BW_SUBROG	CHANGEDBY	USR02	BNAME
2	ICL_BW_SUBROG	CLAIM	ICLCLAIM	CLAIM	KEY	1	CN
3	ICL_BW_SUBROG	CLIENT	T000	MANDT	KEY	1	CN
4	ICL_BW_SUBROG	CURRENCY	TCURC	WAERS	KEY	1	CN
5	ICL_BW_SUBROG	REASON	ICL_CSUBROGREAS	REASON	KEY	1	CN
6	ICL_BW_SUBROG	TYPE	ICL_CSUBROGTYPE	TYPE	KEY	1	CN

History

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