SAP ABAP View V_N2SAMPLE_LABOR (Test Laboratory)

Hierarchy

☛ IS-H (Software Component) SAP Healthcare
   ⤷ IS-HMED (Application Component) Clinical System
     ⤷ NMED_SAMPLE (Package) IS-H*MED: Examples and Test Programs

Basic Data

View Type	D	Database View
Database View	V_N2SAMPLE_LABOR
Short Description	Test Laboratory
Root table	N2LABOR001	IS-H*MED: Lab data (secondary table docCateg. N2_LABOR)

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	N2LABOR001	N2LABOR001
2	N2LABOR

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	N2LABOR001	MANDT	JL	EQ				0	0
2	N2LABOR	MANDT	JR	EQ			AND	0	0
3	N2LABOR001	DOKAR	JL	EQ				0	0
4	N2LABOR	DOKAR	JR	EQ			AND	0	0
5	N2LABOR001	DOKNR	JL	EQ				0	0
6	N2LABOR	DOKNR	JR	EQ			AND	0	0
7	N2LABOR001	DOKVR	JL	EQ				0	0
8	N2LABOR	DOKVR	JR	EQ			AND	0	0
9	N2LABOR001	DOKTL	JL	EQ				0	0
10	N2LABOR	DOKTL	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	N2LABOR001	MANDT		☐	MANDT	☐	Client
2	DOKAR	N2LABOR001	DOKAR		☐	DOKAR	☐	Document Type
3	DOKNR	N2LABOR001	DOKNR		☐	DOKNR	☐	Document number
4	DOKVR	N2LABOR001	DOKVR		☐	DOKVR	☐	Document version
5	DOKTL	N2LABOR001	DOKTL		☐	DOKTL_D	☐	Document part
6	MUSEQ	N2LABOR001	MUSEQ		☐	MUSEQ	☐	Row Number in Multiple Structures
7	N2LAEINRI	N2LABOR	N2LAEINRI		☐	EINRI	☐	IS-H: Institution
8	N2LAPATNR	N2LABOR	N2LAPATNR		☐	PATNR	☐	IS-H: Patient Number
9	N2LAFALNR	N2LABOR	N2LAFALNR		☐	FALNR	☐	IS-H: Case Number
10	N2LEISTID	N2LABOR001	N2LEISTID		☐	N2_LEISTID	☐	Code for the Service
11	N2KATTEXT	N2LABOR001	N2KATTEXT		☐	N2_KTEXT	☐	Catalog Service Text
12	N2VALUE	N2LABOR001	N2VALUE		☐	N2_VALUE	☐	Result Value
13	N2UNIT	N2LABOR001	N2UNIT		☐	N2_UNIT	☐	Result Unit
14	N2NORMAL	N2LABOR001	N2NORMAL		☐	N2_NORMAL	☐	Normal Lab Value
15	N2ABNORMAL	N2LABOR001	N2ABNORMAL		☐	N2_ABNORM	☐	Abnormal Values Indicator for Laboratory Values
16	N2DATE	N2LABOR001	N2DATE		☐	N2_LADATE	☐	Date for Lab Values
17	N2TIME	N2LABOR001	N2TIME		☐	N2_LATIME	☐	Time of Lab Values
18	N2PRIORITY	N2LABOR001	N2PRIORITY		☐	N2_LABPRIORITY	☐	Priority of Laboratory Request
19	N2VSTATUS	N2LABOR001	N2VSTATUS		☐	N2_VSTATUS	☐	Status of Lab Value

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	20070917
SAP Release Created in	700