SAP ABAP Table N2V_VDNOTE_CTX (Generated Table for View N2V_VDNOTE_CTX)

Basic Data

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

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	CONTEXTID	☑	N2VD_CONTEXTID	N2VD_CONTEXTID	CHAR	10	0	PD: Context Code
7	INSTITUTION	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution
8	CASEID	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	NFAL
9	MOVEMENTID	☐	LFDBEW	LFDBEW	NUMC	5	0	IS-H: Sequence Number of Movement	NBEW
10	SERVICEID	☐	LNRLS	LNRLS	CHAR	10	0	IS-H: Service Sequence Number
11	DOKAR	☐	N2_DOKART	DOKAR	CHAR	3	0	Document Type
12	DOKNR	☐	DOKNR	DOKNR	CHAR	25	0	Document number
13	DOKVR	☐	DOKVR	DOKVR	CHAR	2	0	Document version
14	DOKTL	☐	DOKTL_D	DOKTL	CHAR	3	0	Document part
15	REFERENCE1	☐	N2_REFKEY	CHAR20	CHAR	20	0	Reference Key of a Referenced Object
16	SCHEDULE_ID	☐	N2GL_TM_ID	SYSUUID_C	CHAR	32	0	Patient Pathway Key
17	STEP_ID	☐	N2GL_STEP_ID	SYSUUID_C	CHAR	32	0	Step Key
18	STEPNOTE_CAT	☐	N2GL_NOTECAT_ID	N2GL_NOTECAT_ID	CHAR	3	0	Category ID of Note	TN2GL_NOTECAT
19	REFERENCE2	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
20	REFERENCE3	☐	SYSUUID_C	SYSUUID_C	CHAR	32	0	UUID in character form
21	STATUS	☐	N2VD_STATUS	N2VD_STATUS	CHAR	2	0	PD: Status
22	DESCR	☐	N2VD_ITEMDESCR	N2VD_ITEMDESCR	CHAR	64	0	PD:Short Description
23	ADDED_NOTE	☐	N2VD_ADDED_NOTE	N2VD_FLAG	CHAR	1	0	PD: Supplement Indicator for an Entry
24	RESP	☐	N1MITARB	RI_KUNNR	CHAR	10	0	Employee Responsible	NGPA
25	DOC_UNIT	☐	ORGDO	ORGID	CHAR	8	0	Documenting Organizational Unit	NORG
26	ACTION_DATE	☐	N2VD_ACTION_DATE	N2VD_DATE	DATS	8	0	PD: Reference Date
27	ACTION_TIME	☐	N2VD_ACTION_TIME	N2VD_TIME	TIMS	6	0	PD: Reference Time
28	CANCELLED	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
29	CANCEL_USR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
30	CANCEL_DATE	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
31	CANCEL_CAUSE	☐	N1STOID	N1STOID	CHAR	3	0	Reason for Canceling Medical Object
32	N8CRUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
33	N8CRDATE	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
34	N8CRTIME	☐	RI_ERTIM	UHRZT	TIMS	6	0	IS-H: Time Record Created
35	N8UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
36	N8UPDATE	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
37	N8UPTIME	☐	RI_UPTIM	UHRZT	TIMS	6	0	IS-H: Time of Last Change
38	N8DLFLAG	☐	RI_LOEKZ	XFELD	CHAR	1	0	Deletion Flag/Indicator
39	N8DLUSR	☐	RI_LOUSR	USNAM	CHAR	12	0	IS-H: User who Deleted Record
40	N8DLDATE	☐	RI_LODAT	RI_DATUM	DATS	8	0	IS-H: Date of Deletion
41	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_CTX	CASEID	NFAL	FALNR	KEY	1	CN
2	N2V_VDNOTE_CTX	DOC_UNIT	NORG	ORGID	KEY	C	CN
3	N2V_VDNOTE_CTX	MOVEMENTID	NBEW	LFDNR	KEY	1	CN
4	N2V_VDNOTE_CTX	NOTEKEY	N2VDNOTE	NOTEKEY	KEY	1	CN
5	N2V_VDNOTE_CTX	RESP	NGPA	GPART	KEY	C	CN
6	N2V_VDNOTE_CTX	STEPNOTE_CAT	TN2GL_NOTECAT	NOTECAT_ID
7	N2V_VDNOTE_CTX	TYPE	TN2VDTYPE	TYPE	KEY	1	CN
8	N2V_VDNOTE_CTX	VDKEY	N2VD	VDKEY	KEY	1	CN

History

Last changed by/on	SAP	20050224
SAP Release Created in