SAP ABAP Table ICL_DENTALHIST_SELECT (Selection Structure of DB: Dental History)

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	INTTAB	Structure
Structure	ICL_DENTALHIST_SELECT	Table Relationship Diagram
Short Description	Selection Structure of DB: Dental History

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	CLIENT	☐	MANDT	MANDT	CLNT	3	0	Client	*
2	CLAIM	☐	ICL_CLAIM	ICL_CLAIM	CHAR	17	0	Number of Claim	*
3	CLTYPE	☐	ICL_CLTYPE	ICL_CLTYPE	CHAR	4	0	Internal Claim Type	*
4	LOSSTYPE	☐	ICL_LOSSTYPE	ICL_LOSSTYPE	CHAR	4	0	Incident Type of a Claim	*
5	BPARTNER	☐	ICL_PART	BU_PARTNER	CHAR	10	0	Claim Participant	*
6	DOBJ	☐	ICL_DAMOBJBI	ICL_DAMOBJ	NUMC	4	0	Injured Person	*
7	SUBOBJCAT	☐	ICL_SUBOBJCAT	ICL_SUBOBJCAT	CHAR	2	0	Claim Subobject Category	*
8	SUBOBJECT	☐	ICL_SUBOBJECTD	ICL_SUBOBJECTD	CHAR	3	0	Damaged Objects Occurrence Subobject
9	.INCLUDE	☐				0	0	Attributes of ICLDENTAL
10	TOOTH	☐	ICL_TOOTH	ICL_TOOTH	NUMC	2	0	Tooth Number
11	FINDING	☐	ICL_FINDING	ICL_FINDING	CHAR	5	0	Findings	TICL366
12	SUB_PLANNING	☐	ICL_SUBSIDIZABLE	ICL_PLANNING	CHAR	5	0	Treatment Plan	TICL367
13	NSUB_PLANNING	☐	ICL_NOTSUBSIDIZABLE	ICL_PLANNING	CHAR	5	0	Cost Overrun Agreement	TICL367
14	SRCCAT	☐	ICL_PDOCCAT	ICL_PDOCCAT	CHAR	2	0	Claim Item Grouping Category	*
15	SRCID	☐	ICL_DIAGSRCID	ICL_DIAGSRCID	CHAR	20	0	Diagnosis Source ID	*
16	ISSUEDATE	☐	ICL_ISSUEDATE1	DATS	DATS	8	0	Date Created
17	COMPLETIONDATE	☐	ICL_COMPLETIONDATE	DATS	DATS	8	0	Completion Date
18	.INCLUDE	☐				0	0	Status for Procurement
19	CANCEL	☐	ICL_STATUS_CANCEL	XFELD	CHAR	1	0	Status "Cancelled"
20	REJECTED	☐	ICL_STATUS_REJECTED	XFELD	CHAR	1	0	Status "Rejected"
21	INSUSPENSE	☐	ICL_STATUS_INSUSPENSE	XFELD	CHAR	1	0	Status "Pending"
22	INPROCESS	☐	ICL_STATUS_INPROCESS	XFELD	CHAR	1	0	Status "In Process"
23	RELEASED	☐	ICL_STATUS_RELEASED	XFELD	CHAR	1	0	Status "Released"
24	XFINISHED	☐	ICL_XFINISHED	XFELD	CHAR	1	0	Complete/Approved/Finished
25	ORDERED	☐	ICL_STATUS_ORDERED	XFELD	CHAR	1	0	Status "Commissioned"
26	TRANSFERRED	☐	ICL_STATUS_TRANSFERRED	XFELD	CHAR	1	0	Status "Reassigned"

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	ICL_DENTALHIST_SELECT	FINDING	TICL366	FINDING	KEY	1	CN
2	ICL_DENTALHIST_SELECT	NSUB_PLANNING	TICL367	PLANNING	KEY	1	CN
3	ICL_DENTALHIST_SELECT	SUB_PLANNING	TICL367	PLANNING	KEY	1	CN

History

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