SAP ABAP Table N2HL (IS-H*MED: OU-related hit list for diagnoses)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NMED (Package) R/3MED: Medical documentation GSD

Basic Data

Table Category	TRANSP	Transparent table
Transparent table	N2HL	Table Relationship Diagram
Short Description	IS-H*MED: OU-related hit list for diagnoses

Delivery and Maintenance

Pool/cluster
Delivery Class	C	Customizing table, maintenance only by cust., not SAP import
Data Browser/Table View Maintenance	X	Display/Maintenance Allowed

Components

	Field	Key	Data Element	Domain	Data Type	Length	Decimal Places	Short Description	Check table
1	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	EINRI	☑	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
3	ORGID	☑	ORGID	ORGID	CHAR	8	0	IS-H: Organizational Unit Identification Key	NORG
4	DKAT	☑	KATID	KATID	CHAR	2	0	IS-H: Catalog Identification	TNK00
5	DKEY	☑	DIAID	DIAID	CHAR	30	0	IS-H: Diagnosis Code	NKDI
6	SPRAS	☑	SPRAS	SPRAS	LANG	1	0	Language Key	T002
7	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
8	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
9	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
10	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
11	LOEKZ	☐	RI_LOEKZ	XFELD	CHAR	1	0	Deletion Flag/Indicator
12	LOUSR	☐	RI_LOUSR	USNAM	CHAR	12	0	IS-H: User who Deleted Record
13	LODAT	☐	RI_LODAT	RI_DATUM	DATS	8	0	IS-H: Date of Deletion
14	N1PRIO	☐	N1PRIO	N1D003	DEC	3	0	Priority

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N2HL	DKAT	TNK00	KATID	KEY	1	CN
2	N2HL	DKEY	NKDI	DKEY	KEY	1	CN
3	N2HL	EINRI	TN01	EINRI	KEY	1	CN
4	N2HL	MANDT	T000	MANDT	KEY	1	CN
5	N2HL	ORGID	NORG	ORGID	KEY	1	CN
6	N2HL	SPRAS	T002	SPRAS	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in