SAP ABAP View ICL_DIAGHIST_SEL (Selection Structure for Free Selections: Diagnosis History)

Hierarchy

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

Basic Data

View Type	D	Database View
Database View	ICL_DIAGHIST_SEL
Short Description	Selection Structure for Free Selections: Diagnosis History
Root table	ICLDIAGNOSIS	Diagnoses Made

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	ICLDIAGNOSIS	ICLDIAGNOSIS
2	ICLDAMOBJ
3	ICLPARTOCC
4	ICLCLAIM
5	ICLPROCURE

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	ICLDAMOBJ	CLIENT	JL	EQ				0	0
2	ICLDIAGNOSIS	CLIENT	JR	EQ			AND	0	0
3	ICLDAMOBJ	CLAIM	JL	EQ				0	0
4	ICLDIAGNOSIS	CLAIM	JR	EQ			AND	0	0
5	ICLDAMOBJ	DAMAGEDOBJ	JL	EQ				0	0
6	ICLDIAGNOSIS	PATIENT	JR	EQ			AND	0	0
7	ICLDAMOBJ	CLIENT	JL	EQ				0	0
8	ICLPARTOCC	CLIENT	JR	EQ			AND	0	0
9	ICLDAMOBJ	CLAIM	JL	EQ				0	0
10	ICLPARTOCC	CLAIM	JR	EQ			AND	0	0
11	ICLDAMOBJ	DAMAGEDOBJ	JL	EQ				0	0
12	ICLPARTOCC	SUBOBJECT	JR	EQ			AND	0	0
13	ICLCLAIM	CLIENT	JL	EQ				0	0
14	ICLDAMOBJ	CLIENT	JR	EQ			AND	0	0
15	ICLCLAIM	ACTIVE	JL	EQ				0	0
16	ICLDAMOBJ	ACTIVE	JR	EQ			AND	0	0
17	ICLCLAIM	CLAIM	JL	EQ				0	0
18	ICLDAMOBJ	CLAIM	JR	EQ			AND	0	0
19	ICLPROCURE	CLIENT	JL	EQ				0	0
20	ICLDIAGNOSIS	CLIENT	JR	EQ			AND	0	0
21	ICLPROCURE	CLAIM	JL	EQ				0	0
22	ICLDIAGNOSIS	CLAIM	JR	EQ			AND	0	0
23	ICLPROCURE	SUBCLAIM	JL	EQ				0	0
24	ICLDIAGNOSIS	SUBOBJECT	JR	EQ			AND	0	0
25	ICLPROCURE	PDOCCAT	JL	EQ				0	0
26	ICLDIAGNOSIS	DIAGSRCCAT	JR	EQ			AND	0	0
27	ICLCLAIM	POLICY		EQ	'GKV'		AND	0	0
28	ICLPARTOCC	DELETED		NE	'X'		AND	0	0
29	ICLDIAGNOSIS	DELETED		NE	'X'		AND	0	0
30	ICLPROCURE	DELETED		NE	'X'			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	CLIENT	ICLDIAGNOSIS	CLIENT		☐	MANDT	☐	Client
2	CLAIM	ICLDIAGNOSIS	CLAIM		☐	ICL_CLAIM	☐	Number of Claim
3	BPARTNER	ICLPARTOCC	BPARTNER		☐	ICL_PART	☐	Claim Participant
4	PATIENT	ICLDIAGNOSIS	PATIENT		☐	ICL_DAMOBJBI	☐	Injured Person
5	DATEFROM	ICLPROCURE	DATEFROM		☐	ICL_DATEFROM	☐	Start Date of Period
6	ENDDATE	ICLDIAGNOSIS	ENDDATE		☐	ICL_ENDDATE	☐	End Date
7	SUBOBJCAT	ICLDIAGNOSIS	SUBOBJCAT		☐	ICL_SUBOBJCAT	☐	Claim Subobject Category
8	SUBOBJECT	ICLDIAGNOSIS	SUBOBJECT		☐	ICL_SUBOBJECTD	☐	Damaged Objects Occurrence Subobject
9	DIAGSRCCAT	ICLDIAGNOSIS	DIAGSRCCAT		☐	ICL_PDOCCAT	☐	Claim Item Grouping Category
10	DIAGSRCID	ICLDIAGNOSIS	DIAGSRCID		☐	ICL_DIAGSRCID	☐	Diagnosis Source ID
11	CATAID1	ICLDIAGNOSIS	CATAID1		☐	ICL_CATAID	☐	Catalog Code
12	DIAGID1	ICLDIAGNOSIS	DIAGID1		☐	ICL_PRIMDIAGID	☐	Primary Diagnosis
13	DIAGID2	ICLDIAGNOSIS	DIAGID2		☐	ICL_SECDIAGID	☐	Secondary Diagnosis
14	DESCRIPTION	ICLDIAGNOSIS	DESCRIPTION		☐	ICL_DESCRIPTION	☐	Diagnosis Description
15	DIAGTYPE	ICLDIAGNOSIS	DIAGTYPE		☐	ICL_DIAGTYPE	☐	Diagnosis Type
16	LOCALIZATION	ICLDIAGNOSIS	LOCALIZATION		☐	ICL_LOCALIZATION	☐	Side Localization of a Diagnosis
17	SEVERITYCODE	ICLDIAGNOSIS	SEVERITYCODE		☐	ICL_SEVERITYCODE	☐	Severity of Diagnosis
18	MORPHOLOGY	ICLDIAGNOSIS	MORPHOLOGY		☐	ICL_MORPHOLOGY	☐	Morphology
19	EXCORIATION	ICLDIAGNOSIS	EXCORIATION		☐	ICL_EXCORIATION	☐	Excoriation
20	GUARANTEE	ICLDIAGNOSIS	GUARANTEE		☐	ICL_GUARANTEE	☐	Diagnostic Certainty
21	DEPARTMENT	ICLDIAGNOSIS	DEPARTMENT		☐	ICL_DEPARTMENT	☐	Department (Key)

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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