SAP ABAP Table N_VNDAE (Generated Table for View)

Basic Data

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

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	T000
2	DOKAR	☑	DOKAR	DOKAR	CHAR	3	0	Document Type	TDWA
3	DOKNR	☑	DOKNR	DOKNR	CHAR	25	0	Document number	DRAW
4	DOKVR	☑	DOKVR	DOKVR	CHAR	2	0	Document version
5	DOKTL	☑	DOKTL_D	DOKTL	CHAR	3	0	Document part
6	ENTLEIHER	☑	ENTLEIHNR	ENTLNR	CHAR	10	0	Borrower for Document Management
7	ENTLTYP	☑	ENTLEIHTYP	ENTLEIHTYP	CHAR	2	0	IS-H: Borrower Category
8	LEIHDAT	☑	ISH_LEIDAT	RI_DATUM	DATS	8	0	IS-H: Date at which a Medical Record Is Borrowed/Requested
9	LEIZEIT	☑	ISH_LEIZEI	UHRZT	TIMS	6	0	IS-H: Borrowing time
10	LFDDOK	☑	LFDDOK	INT4_NOS	INT4	10	0	Sequence Number of Document
11	ORGKR	☐	ORGKREIS	ORG_KR	CHAR	4	0	IS-H: Organizational group for borrowing authorizations
12	ENTZW	☐	ISH_ENTLZW	ISH_ENTLZW	CHAR	2	0	IS-H: Reason for Borrowing Medical Record/Document	TND01
13	RUEKDAT	☐	ISH_RUEKDT	RI_DATUM	DATS	8	0	IS-H: Date Medical Record Returned
14	STATUS	☐	ISH_LEISTA	ISH_LEISTA	CHAR	1	0	IS-H: Borrowing Status
15	ANZMAH	☐	ISH_ANZMAH	INT2	INT2	5	0	IS-H: Number of Reminders for Medical Records
16	ERMAHN	☐	ISH_AKM1DT	RI_DATUM	DATS	8	0	IS-H: Date of 1st Reminder for Medical Record
17	LEMAHN	☐	ISH_AKM2DT	RI_DATUM	DATS	8	0	IS-H: Date of Last Reminder
18	ENTTEXT	☐	TEXTENT	TEXT50	CHAR	50	0	IS-H: Comment on Borrowing Episode
19	ENTLEND	☐	ISH_ENTLEN	RI_DATUM	DATS	8	0	IS-H: Scheduled Borrowed-To Date
20	VERANTW	☐	VERANTWORT	ENTLNR	CHAR	10	0	IS-H: Person Responsible for Medical Records/Documents
21	ORGFORM	☐	ORGFORM	ORGFORM	CHAR	1	0	IS-H: Organization Form for Medical Record Management
22	EXTNR	☐	ISH_DOCEXT	CHAR15	CHAR	15	0	IS-H: External Medical Record/Document ID
23	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number	NPAT
24	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number
25	FALAR	☐	FALLART	FALLART	CHAR	1	0	IS-H: Case Type
26	ORGFA	☐	NZUWFA	ORGID	CHAR	8	0	IS-H: OU with Departmental Responsibility for Case	NORG
27	ORGPF	☐	NZUWPF	ORGID	CHAR	8	0	Organizational Unit Assigned to Case	NORG
28	ORGDO	☐	ORGDO	ORGID	CHAR	8	0	Documenting Organizational Unit	NORG
29	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
30	MEDOK	☐	MEDOK	XFELD	CHAR	1	0	Indicator for a Medical Document
31	ARCHIV	☐	ARCHIV_ID	ORGID	CHAR	8	0	IS-H: Organizational ID of the medical record archive	NORG
32	STANDORT	☐	ISH_ARCHST	BAUID	CHAR	8	0	IS-H: Building ID of building unit in the 'archive' OU	NBAU
33	ROLLNO	☐	ISH_ROLLNO	CHAR10	CHAR	10	0	IS-H: Roll Number of a Micro Film
34	MICROF	☐	ISH_MICROF	XFELD	CHAR	1	0	IS-H: Patient's medical record is microfilmed
35	INFOMR	☐	ISH_INFOMR	TEXT50	CHAR	50	0	IS-H: Informational Text for Medical Record
36	TEMPMR	☐	ISH_TEMPMR	XFELD	CHAR	1	0	IS-H: Flags a Medical Record as Temporary Medical Record
37	ALBUM	☐	ISH_ALBUM	CHAR10	CHAR	10	0	IS-H: Album Id for microfilm
38	MFYEAR	☐	ISH_MFYEAR	NUMC4	NUMC	4	0	IS-H: Year Until when Data Archived on Microfilm
39	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
40	NNAME	☐	NNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient Last Name
41	VNAME	☐	VNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient First Name
42	NNAMS	☐	NNAMES_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Last Name
43	VNAMS	☐	VNAMES_PAT	CHAR30	CHAR	30	0	Standardized First Name
44	TITEL	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title
45	NAMZU	☐	RI_NAMZU	TITEL	CHAR	15	0	IS-H: Name Affix
46	VORSW	☐	RI_VORSW	TITEL	CHAR	15	0	IS-H: Name Prefix
47	GBDAT	☐	RI_GBDAT	RI_DATUM	DATS	8	0	IS-H: Birthdate
48	PATEX	☐	EXT_PATNR	EXT_PATNR	CHAR	20	0	IS-H: External Patient Identification
49	REDO_KZ	☐	ISH_REDO_KZ	XFELD	CHAR	1	0	IS-H: Indicator for Renewable Document Management

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N_VNDAE	ARCHIV	NORG	ORGID		1	CN
2	N_VNDAE	DOKAR	TDWA	DOKAR	KEY	1	CN
3	N_VNDAE	DOKNR	DRAW	DOKNR	KEY	1	CN
4	N_VNDAE	ENTZW	TND01	ENTZW
5	N_VNDAE	MANDT	T000	MANDT	KEY	1	CN
6	N_VNDAE	ORGDO	NORG	ORGID	KEY	1	CN
7	N_VNDAE	ORGFA	NORG	ORGID
8	N_VNDAE	ORGPF	NORG	ORGID	KEY	1	CN
9	N_VNDAE	PATNR	NPAT	PATNR	KEY	1	CN
10	N_VNDAE	STANDORT	NBAU	BAUID		1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in