SAP ABAP Table N2V_VDNOTE (Generated Table for View N2V_VDNOTE)

Basic Data

Table Category	VIEW	General view structure
General view structure	N2V_VDNOTE	Table Relationship Diagram
Short Description	Generated Table for View N2V_VDNOTE

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client
2	NOTEKEY	☑	N2VD_KEY	N2VD_KEY	CHAR	20	0	PD: PD Key	N2VDNOTE
3	VDKEY	☑	N2VD_KEY	N2VD_KEY	CHAR	20	0	PD: PD Key	N2VD
4	TYPE	☑	N2VD_VDTYPE	N2VD_TYPE	CHAR	10	0	PD: PD Type	TN2VDTYPE
5	RANK	☐	N2VD_RANK	N2VD_RANK	INT1	3	0	PD: Rank of an Entry
6	STATUS	☐	N2VD_STATUS	N2VD_STATUS	CHAR	2	0	PD: Status
7	DESCR	☐	N2VD_ITEMDESCR	N2VD_ITEMDESCR	CHAR	64	0	PD:Short Description
8	ADDED_NOTE	☐	N2VD_ADDED_NOTE	N2VD_FLAG	CHAR	1	0	PD: Supplement Indicator for an Entry
9	RESP	☐	N1MITARB	RI_KUNNR	CHAR	10	0	Employee Responsible	NGPA
10	DOC_UNIT	☐	ORGDO	ORGID	CHAR	8	0	Documenting Organizational Unit	NORG
11	ACTION_DATE	☐	N2VD_ACTION_DATE	N2VD_DATE	DATS	8	0	PD: Reference Date
12	ACTION_TIME	☐	N2VD_ACTION_TIME	N2VD_TIME	TIMS	6	0	PD: Reference Time
13	CANCELLED	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
14	CANCEL_USR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
15	CANCEL_DATE	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
16	INSTITUTION	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
17	CANCEL_CAUSE	☐	N1STOID	N1STOID	CHAR	3	0	Reason for Canceling Medical Object	N1STGR
18	N8CRUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
19	N8CRDATE	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
20	N8CRTIME	☐	RI_ERTIM	UHRZT	TIMS	6	0	IS-H: Time Record Created
21	N8UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
22	N8UPDATE	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
23	N8UPTIME	☐	RI_UPTIM	UHRZT	TIMS	6	0	IS-H: Time of Last Change
24	N8DLFLAG	☐	RI_LOEKZ	XFELD	CHAR	1	0	Deletion Flag/Indicator
25	N8DLUSR	☐	RI_LOUSR	USNAM	CHAR	12	0	IS-H: User who Deleted Record
26	N8DLDATE	☐	RI_LODAT	RI_DATUM	DATS	8	0	IS-H: Date of Deletion
27	N8DLTIME	☐	RI_LOTIM	UHRZT	TIMS	6	0	Deletion Time

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N2V_VDNOTE	CANCEL_CAUSE	N1STGR	STOID	KEY	C	CN
2	N2V_VDNOTE	DOC_UNIT	NORG	ORGID	KEY	C	CN
3	N2V_VDNOTE	INSTITUTION	TN01	EINRI	KEY	1	CN
4	N2V_VDNOTE	NOTEKEY	N2VDNOTE	NOTEKEY	KEY	1	CN
5	N2V_VDNOTE	RESP	NGPA	GPART	KEY	C	CN
6	N2V_VDNOTE	TYPE	TN2VDTYPE	TYPE	KEY	1	CN
7	N2V_VDNOTE	VDKEY	N2VD	VDKEY	KEY	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in