SAP ABAP Table ICL_BW_DIAGNOSIS (Extract Structure for Diagnoses Made)

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_DIAGNOSIS	Table Relationship Diagram
Short Description	Extract Structure for Diagnoses Made

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	Diagnoses Made
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	PATIENT	☐	ICL_DAMOBJBI	ICL_DAMOBJ	NUMC	4	0	Injured Person	ICLDAMOBJ
6	SUBOBJCAT	☐	ICL_SUBOBJCAT	ICL_SUBOBJCAT	CHAR	2	0	Claim Subobject Category	TICL013
7	SUBOBJECT	☐	ICL_SUBOBJECTD	ICL_SUBOBJECTD	CHAR	3	0	Damaged Objects Occurrence Subobject
8	DIAGNO	☐	ICL_DIAGNO	ICL_DIAGNO	CHAR	3	0	Sequence Number of Diagnosis Within A Case
9	.INCLUDE	☐				0	0	Shadow Tables Versioning: Include for Original Table
10	CHANGETIME	☐	ICL_CHANGEUTC1	ICL_TIMESTAMP	DEC	15	0	Changed: UTC Date+Time
11	CHANGEDBY	☐	ICL_CHANGEDBY	XUBNAME	CHAR	12	0	Changed By	USR02
12	DELETED	☐	ICL_RECSTATUS	ICL_RECSTATUS	CHAR	1	0	Database Line Status (Original, Changed, Deleted)
13	.INCLUDE	☐				0	0	Attributes of ICLDIAGNOSIS
14	CATAID1	☐	ICL_CATAID	ICL_CATAID	CHAR	4	0	Catalog Code	TICL350
15	DIAGID1	☐	ICL_PRIMDIAGID	ICL_DIAGID	CHAR	10	0	Primary Diagnosis	TICL351
16	CATAID2	☐	ICL_CATAID	ICL_CATAID	CHAR	4	0	Catalog Code	TICL350
17	DIAGID2	☐	ICL_SECDIAGID	ICL_DIAGID	CHAR	10	0	Secondary Diagnosis	TICL351
18	DIAGNOPARENT	☐	ICL_DIAGNO_OLD_D	ICL_DIAGNO_OLD	NUMC	3	0	Diagnosis Number (Numerical) - Obsolete
19	DESCRIPTION	☐	ICL_DESCRIPTION	TEXT50	CHAR	50	0	Diagnosis Description
20	ENDDATE	☐	ICL_ENDDATE	DATUM	DATS	8	0	End Date
21	DIAGSRCCAT	☐	ICL_PDOCCAT	ICL_PDOCCAT	CHAR	2	0	Claim Item Grouping Category	TICL138
22	DIAGSRCID	☐	ICL_DIAGSRCID	ICL_DIAGSRCID	CHAR	20	0	Diagnosis Source ID	*
23	DIAGTYPE	☐	ICL_DIAGTYPE	ICL_DIAGTYPE	CHAR	2	0	Diagnosis Type	TICL360
24	LOCALIZATION	☐	ICL_LOCALIZATION	ICL_LOCALIZATION	CHAR	1	0	Side Localization of a Diagnosis	TICL352
25	SEVERITYCODE	☐	ICL_SEVERITYCODE	ICL_SEVERITYCODE	CHAR	1	0	Severity of Diagnosis	TICL354
26	MORPHOLOGY	☐	ICL_MORPHOLOGY	ICL_MORPHOLOGY	CHAR	7	0	Morphology	TICL356
27	EXCORIATION	☐	ICL_EXCORIATION	ICL_EXCORIATION	CHAR	5	0	Excoriation	TICL358
28	GUARANTEE	☐	ICL_GUARANTEE	ICL_GUARANTEE	CHAR	1	0	Diagnostic Certainty	TICL363
29	DEPARTMENT	☐	ICL_DEPARTMENT	ICL_DEPARTMENT	CHAR	4	0	Department (Key)	TICL364
30	DIAGORDER	☐	ICL_DIAGORDER		NUMC	3	0	Sequence of Diagnoses
31	LOCALIZATION2	☐	ICL_LOCALIZATION2	ICL_LOCALIZATION	CHAR	1	0	Localization 2	TICL352
32	USED4CALC	☐	ICL_USED4CALC		CHAR	1	0	Used for Grouping
33	ASSIGN_GUID	☐	ICL_ASSIGN_GUID	SYSUUID_C	CHAR	32	0	UUID of Entry to be Linked
34	CLAIMTYPE	☐	ICL_CLTYPE	ICL_CLTYPE	CHAR	4	0	Internal Claim Type	TICL011
35	INJURED	☐	ICL_INJURED	BU_PARTNER	CHAR	10	0	Injured Person	*
36	DATELOSS	☐	ICL_LOSSDATE	DATE	DATS	8	0	Date of Loss/Claim
37	PLINEOFBUS	☐	ICL_LINEOFBUS	ICL_LINEOFBUS	CHAR	3	0	Insurance Line of Business	*
38	COMPANYCODE	☐	BUKRS	BUKRS	CHAR	4	0	Company Code	*
39	ORGUNIT	☐	ICL_ORGUNIT	HR_SOBJID	NUMC	8	0	Organizational Unit	*
40	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_DIAGNOSIS	CATAID1	TICL350	CATAID	KEY	1	CN
2	ICL_BW_DIAGNOSIS	CATAID2	TICL350	CATAID	KEY	1	CN
3	ICL_BW_DIAGNOSIS	CHANGEDBY	USR02	BNAME
4	ICL_BW_DIAGNOSIS	CLAIM	ICLCLAIM	CLAIM	KEY	1	CN
5	ICL_BW_DIAGNOSIS	CLAIMTYPE	TICL011	CLTYPE
6	ICL_BW_DIAGNOSIS	CLIENT	T000	MANDT	KEY	1	CN
7	ICL_BW_DIAGNOSIS	DEPARTMENT	TICL364	DEPARTMENT	KEY	1	CN
8	ICL_BW_DIAGNOSIS	DIAGID1	TICL351	DIAGID	KEY	1	CN
9	ICL_BW_DIAGNOSIS	DIAGID2	TICL351	DIAGID	KEY	1	CN
10	ICL_BW_DIAGNOSIS	DIAGSRCCAT	TICL138	PDOCCAT	KEY	1	CN
11	ICL_BW_DIAGNOSIS	DIAGTYPE	TICL360	DIAGTYPE	KEY	1	CN
12	ICL_BW_DIAGNOSIS	EXCORIATION	TICL358	EXCORIATION	KEY	1	CN
13	ICL_BW_DIAGNOSIS	GUARANTEE	TICL363	GUARANTEE	KEY	1	CN
14	ICL_BW_DIAGNOSIS	LOCALIZATION	TICL352	LOCALIZATION	KEY	1	CN
15	ICL_BW_DIAGNOSIS	LOCALIZATION2	TICL352	LOCALIZATION
16	ICL_BW_DIAGNOSIS	MORPHOLOGY	TICL356	MORPHOLOGY	KEY	1	CN
17	ICL_BW_DIAGNOSIS	PATIENT	ICLDAMOBJ	DAMAGEDOBJ	KEY	1	CN
18	ICL_BW_DIAGNOSIS	SEVERITYCODE	TICL354	SEVERITY	KEY	1	CN
19	ICL_BW_DIAGNOSIS	SUBOBJCAT	TICL013	SUBOBJCAT	KEY	1	CN

History

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