SAP ABAP Table ICLDENTAL (Dental Diagnosis and Dental Treatment)

Hierarchy

☛ INSURANCE (Software Component) SAP Insurance
   ⤷ FS-CM (Application Component) Claims Management
     ⤷ ICL_HEALTH (Package) FS-CM: Health Line of Insurance

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	ICLDENTAL	Table Relationship Diagram
Short Description	Dental Diagnosis and Dental Treatment

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	DOBJ	☑	ICL_DAMOBJBI	ICL_DAMOBJ	NUMC	4	0	Injured Person	ICLDAMOBJ
5	SUBOBJCAT	☑	ICL_SUBOBJCAT	ICL_SUBOBJCAT	CHAR	2	0	Claim Subobject Category	TICL013
6	SUBOBJECT	☑	ICL_SUBOBJECTD	ICL_SUBOBJECTD	CHAR	3	0	Damaged Objects Occurrence Subobject
7	DENTALNO	☑	ICL_DENTALNO	ICL_DENTALNO	NUMC	3	0	Sequence No. Dental Diagnosis/Treatment in Case
8	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
9	CHANGETIME	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
10	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
11	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
12	.INCLUDE	☐				0	0	Attributes of ICLDENTAL
13	TOOTH	☐	ICL_TOOTH	ICL_TOOTH	NUMC	2	0	Tooth Number
14	FINDING	☐	ICL_FINDING	ICL_FINDING	CHAR	5	0	Findings	TICL366
15	SUB_PLANNING	☐	ICL_SUBSIDIZABLE	ICL_PLANNING	CHAR	5	0	Treatment Plan	TICL367
16	NSUB_PLANNING	☐	ICL_NOTSUBSIDIZABLE	ICL_PLANNING	CHAR	5	0	Cost Overrun Agreement	TICL367
17	SRCCAT	☐	ICL_PDOCCAT	ICL_PDOCCAT	CHAR	2	0	Claim Item Grouping Category	TICL138
18	SRCID	☐	ICL_DIAGSRCID	ICL_DIAGSRCID	CHAR	20	0	Diagnosis Source ID	*

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICLDENTAL	CHANGEDBY	USR02	BNAME
2	ICLDENTAL	CLAIM	ICLCLAIM	CLAIM	KEY	1	CN
3	ICLDENTAL	CLIENT	T000	MANDT	KEY	1	CN
4	ICLDENTAL	DOBJ	ICLDAMOBJ	DAMAGEDOBJ	KEY	1	CN
5	ICLDENTAL	FINDING	TICL366	FINDING	KEY	1	CN
6	ICLDENTAL	NSUB_PLANNING	TICL367	PLANNING	KEY	1	CN
7	ICLDENTAL	SRCCAT	TICL138	PDOCCAT	KEY	1	CN
8	ICLDENTAL	SUBOBJCAT	TICL013	SUBOBJCAT	KEY	1	CN
9	ICLDENTAL	SUB_PLANNING	TICL367	PLANNING	KEY	1	CN

History

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