SAP ABAP Table ICSDIPL (Distribution Plan (Shadow Table))

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_MULTIPLE_INSURANCE (Package) FS-CM: Multiple Insurance

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ICSDIPL	Table Relationship Diagram
Short Description	Distribution Plan (Shadow Table)

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	CLAIM	☑	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	ICLCLAIM
4	DIPL_ID	☑	ICL_MI_DIPL_ID	SYSUUID_C	CHAR	32	0	Distribution Plan ID	ICLDIPL
5	CHANGETIME	☑	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
6	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Shade Table
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	Distribution Plan (Data Set ICLDIPL)
10	DIPL_NAME	☐	ICL_MI_DIPL_NAME	ICL_MI_DIPL_NAME	CHAR	20	0	Name of Distribution Plan
11	DIPL_DESCR	☐	ICL_MI_DIPL_DESCR	ICL_MI_DIPL_DESCR	CHAR	100	0	Description of Distribution Plan
12	VALFR_TS	☐	ICL_MI_VALFR_TS	ICL_TIMESTAMP	DEC	15	0	Time Stamp From Which Distribution Plan Is Valid
13	VALTO_TS	☐	ICL_MI_VALTO_TS	ICL_TIMESTAMP	DEC	15	0	Time Stamp to Which Distribution Plan Is Valid
14	DIPLTY	☐	ICL_MI_DIPLTY	ICL_MI_DIPLTY	CHAR	10	0	Distribution Plan Type in Multiple Insurance	TICL285
15	PRIO	☐	ICL_MI_PRIO	ICL_MI_PRIO	NUMC	2	0	Priority of Distribution Plan
16	CURR	☐	ICL_MI_CURR	WAERS	CUKY	5	0	Distribution Plan: Currency	TCURC
17	POLVNR	☐	ICL_POLVCNTR	ICL_POLVCNTR	NUMC	2	0	Counter of Contract Version	ICLPOL
18	COVTYPE	☐	ICL_COVTYPE	ICL_COVTYPE	CHAR	10	0	Coverage Type	TICL322
19	XDIST_RES	☐	ICL_MI_DIST_RES	CHAR01	CHAR	1	0	Reserve Distribution Is Necessary
20	XFOREIGN_LEAD	☐	ICL_MI_FOREIGN_LEAD	CHAR01	CHAR	1	0	Other Insurance Company Is Leading Insurer

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICSDIPL	CHANGEDBY	USR02	BNAME
2	ICSDIPL	CLAIM	ICLCLAIM	CLAIM
3	ICSDIPL	CLIENT	T000	MANDT
4	ICSDIPL	COVTYPE	TICL322	COVTYPE
5	ICSDIPL	CURR	TCURC	WAERS
6	ICSDIPL	DIPLTY	TICL285	DIPLTY
7	ICSDIPL	DIPL_ID	ICLDIPL	DIPL_ID
8	ICSDIPL	POLVNR	ICLPOL	POLVNR

History

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