SAP ABAP Table N_VNAPP (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	N_VNAPP	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	LNRAPP	☑	ISH_LNRAPP	ISH_LNRAPP	CHAR	10	0	IS-H: Sequence Number of Provisional Appointment
3	TMNID	☐	ISH_TMNID	ISH_LNRAPP	CHAR	10	0	IS-H: Identification of Appointment
4	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
5	LFDNR	☐	LFDBEW	LFDBEW	NUMC	5	0	IS-H: Sequence Number of Movement
6	DSPTY	☐	ISH_DSPT	ISH_DSPTC8	CHAR	8	0	IS-H: Scheduling Type for Visit Scheduling	TN40B
7	VISTY	☐	ISH_BT	ISH_BT	CHAR	1	0	IS-H: Code of Visit Category for Visit Scheduling
8	BWIDT	☐	BWIDT	RI_DATUM	DATS	8	0	IS-H: Date of Movement
9	BWIZT	☐	BWIZT	UHRZT	TIMS	6	0	IS-H: Time of Movement
10	STATU	☐	ISH_ABSTIN	ISH_ABSTIN	CHAR	2	0	IS-H: Internal Status of Outpatient Visit
11	ORGFA	☐	NZUWFA	ORGID	CHAR	8	0	IS-H: OU with Departmental Responsibility for Case	NORG
12	ORGPF	☐	NZUWPF	ORGID	CHAR	8	0	Organizational Unit Assigned to Case	NORG
13	POBNR	☐	ISH_POBNR	ISH_POBNR	NUMC	10	0	IS-H: Internal Sequence Number of Planning Object	NPOB
14	PERNR	☐	PERNR_FALL	RI_KUNNR	CHAR	10	0	IS-H: Person Number	NGPA
15	ZIMMR	☐	ISH_ZIMMID	BAUID	CHAR	8	0	IS-H: Building ID of Room	NBAU
16	KZTXT	☐	TEXT_BEW	TEXT50	CHAR	50	0	Comment on Case Movement
17	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
18	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
19	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
20	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
21	LGTXT	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
22	DAUER	☐	ISH_APTIME	ISH_DZEIT	NUMC	4	0	IS-H: Duration in Minutes for Treatment Appointment
23	FACHR	☐	FACHRTY5	ISH_FACHR	CHAR	4	0	IS-H: Physician Specialty	TNKFA
24	PELOC	☐	ISH_PELOC	RI_KUNNR	CHAR	10	0	IS-H: Person Being Substituted
25	STOID	☐	N1BSTOID	N1STOID	CHAR	3	0	IS-H: Reason for Canceling Movement
26	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
27	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
28	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
29	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number	NPAT
30	PZIFF	☐	PZIFF_PAT	PZIFF	CHAR	1	0	IS-H: Check Digit for Patient
31	EXTNR	☐	EXT_PATNR	EXT_PATNR	CHAR	20	0	IS-H: External Patient Identification
32	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number
33	FZIFF	☐	PZIFF_FALL	PZIFF	CHAR	1	0	IS-H: Check Digit for Case
34	FALAR	☐	FALLART	FALLART	CHAR	1	0	IS-H: Case Type
35	TMNLB	☐	LFDBEW	LFDBEW	NUMC	5	0	IS-H: Sequence Number of Movement
36	TMNOE	☐	ISH_TMNOE	ORGID	CHAR	8	0	IS-H: Planned Organizational Unit	NORG
37	TMNDT	☐	ISH_TMNDT	DATE	DATS	8	0	IS-H: Date of Appointment
38	TMNZT	☐	ISH_TMNZT	UHRZT	TIMS	6	0	IS-H: Time of Appointment
39	TMNDR	☐	ISH_TMDAUER	ISH_DZEIT	NUMC	4	0	IS-H: Duration of Appointment
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	GBNAM	☐	GBNAM	TEXT30	CHAR	30	0	IS-H: Birthname
48	GBNAS	☐	GBNAMS_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Birthname
49	GBDAT	☐	RI_GBDAT	RI_DATUM	DATS	8	0	IS-H: Birthdate
50	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
51	TELF1	☐	TELF_PAT	TEXT16	CHAR	16	0	IS-H: Patient Telephone Number
52	TODKZ	☐	PAT_TOD	XFELD	CHAR	1	0	IS-H: Patient Is Deceased
53	SOURC	☐	ISH_OBJSRC	ISH_OBJSRC	CHAR	1	0	IS-H: Application that Created Object
54	TMTAG	☐	ISH_TMTAG	XFELD	CHAR	1	0	IS-H: Appointment on Given Day
55	REFID	☐	ISH_REFTMNID	ISH_LNRAPP	CHAR	10	0	IS-H: Reference Number of Next Appointment
56	NOTAN	☐	NOTAUF	XFELD	CHAR	1	0	IS-H: Emergency Admission Indicator
57	KRZAN	☐	KURZAUF	XFELD	CHAR	1	0	IS-H: Quick Admission Indicator
58	BEKAT	☐	BEKAT	BEHKATEG	CHAR	6	0	Treatment Category
59	RISKF	☐	ISH_RISIKO	XFELD	CHAR	1	0	IS-H: Risk Information Exists for the Patient
60	CLASS	☐	ISH_PAYCL	ISH_PAYCL	CHAR	4	0	IS-H: Patient Class
61	BNDT	☐	ISH_BNDT	RI_DATUM	DATS	8	0	IS-H: Date on which patient was last notified
62	BNART	☐	ISH_BNART	KOMMART	CHAR	1	0	IS-H: Type of Notification (Tel., Written)
63	BNKZ	☐	ISH_APP_NOTI_WANTED	XFELD	CHAR	1	0	IS-H: Notification of Appointment Desired
64	EINBDT	☐	ISH_EINBDT	RI_DATUM	DATS	8	0	IS-H: Date of Appointment of which Patient Last Notified
65	EINBZT	☐	ISH_EINBZT	UHRZT	TIMS	6	0	IS-H: Time of Appointment of which Patient Last Notified
66	EINBOE	☐	ISH_EINBOE	ORGID	CHAR	8	0	Nursing Org. Unit of Patient's Last Scheduled Appointment
67	EINBPER	☐	ISH_EINBPER	RI_KUNNR	CHAR	10	0	IS-H: Person/Physician of Last Patient Appt Notification
68	EINBZIM	☐	ISH_EINBZIM	BAUID	CHAR	8	0	IS-H: Building Unit of Last Patient Notification
69	BWART	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type
70	TPART	☐	N1TPAE	N1TPAE	CHAR	2	0	Transport Type
71	BWPRIO	☐	N1APRI_D	N1APRI	NUMC	3	0	Prioritization for Request/Movement (Internal)
72	MEDTX	☐	N1MEDTX	N1C050	CHAR	50	0	Medical Text
73	VBUND	☐	ISH_TMVBD	XFELD	CHAR	1	0	Termin verbundrelevant
74	BWGR1	☐	ISH_BWGR1	ISH_BGRUND	CHAR	2	0	Movement Reason - 1st and 2nd Positions	TN14G
75	BWGR2	☐	ISH_BWGR2	ISH_BGRUND	CHAR	2	0	Movement Reason - 3rd and 4th Positions	TN14G
76	UARNR	☐	UARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Referring Physician	NGPA
77	EMAIL	☐	ISH_SMTPADR	AD_SMTPADR	CHAR	241	0	IS-H: Internet Mail (SMTP) Address
78	TMSTG	☐	ISH_TMSTG	N1STOID	CHAR	3	0	Cancellation Reason for an Appointment
79	TMPDT	☐	ISH_TMPDT	DATE	DATS	8	0	IS-H: Date Planned for Appointment
80	TMPZT	☐	ISH_TMPZT	UHRZT	TIMS	6	0	IS-H: Time Planned for Appointment
81	GPLVN	☐	N1GPLVN	USNAM	CHAR	12	0	IS-H*MED: Employee or User who Last Planned Appointment
82	GPLTY	☐	N1GPLTY	N1GPLTY	CHAR	1	0	IS-H*MED: Appointment Changed by: Employee/User ID

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N_VNAPP	BWGR1	TN14G	GRUND		1	CN
2	N_VNAPP	BWGR2	TN14G	GRUND		1	CN
3	N_VNAPP	DSPTY	TN40B	DISPO
4	N_VNAPP	EINRI	TN01	EINRI	REF	1	CN
5	N_VNAPP	FACHR	TNKFA	FACHR	REF	1	CN
6	N_VNAPP	MANDT	T000	MANDT	KEY	1	CN
7	N_VNAPP	ORGFA	NORG	ORGID	REF	1	CN
8	N_VNAPP	ORGPF	NORG	ORGID	REF	1	CN
9	N_VNAPP	PATNR	NPAT	PATNR	REF	1	CN
10	N_VNAPP	PERNR	NGPA	GPART	REF	1	CN
11	N_VNAPP	POBNR	NPOB	POBNR	REF	1	CN
12	N_VNAPP	TMNOE	NORG	ORGID	REF	1	CN
13	N_VNAPP	UARNR	NGPA	GPART
14	N_VNAPP	ZIMMR	NBAU	BAUID	REF	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in