SAP ABAP View N_VNAPP_NPAT (IS-H: Appointment Data for Patient; Access via NAPP)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NPVS (Package) Application development patient management system

Basic Data

View Type	D	Database View
Database View	N_VNAPP_NPAT
Short Description	IS-H: Appointment Data for Patient; Access via NAPP
Root table	NAPP	IS-H: Provisional appointments for visit planning

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	NAPP	NAPP
2	NTMN
3	NPAT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	NAPP	MANDT	JL	EQ				0	0
2	NTMN	MANDT	JR	EQ			AND	0	0
3	NAPP	TMNID	JL	EQ				0	0
4	NTMN	TMNID	JR	EQ			AND	0	0
5	NPAT	MANDT	JL	EQ				0	0
6	NTMN	MANDT	JR	EQ			AND	0	0
7	NPAT	PATNR	JL	EQ				0	0
8	NTMN	PATNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	NAPP	MANDT		☐	MANDT	☐	Client
2	LNRAPP	NAPP	LNRAPP		☐	ISH_LNRAPP	☐	IS-H: Sequence Number of Provisional Appointment
3	TMNID	NAPP	TMNID		☐	ISH_TMNID	☐	IS-H: Identification of Appointment
4	PATNR	NTMN	PATNR		☐	PATNR	☐	IS-H: Patient Number
5	PZIFF	NTMN	PZIFF		☐	PZIFF_PAT	☐	IS-H: Check Digit for Patient
6	EXTNR	NPAT	EXTNR		☐	EXT_PATNR	☐	IS-H: External Patient Identification
7	EINRI	NTMN	EINRI		☐	EINRI	☐	IS-H: Institution
8	FALNR	NTMN	FALNR		☐	FALNR	☐	IS-H: Case Number
9	FZIFF	NTMN	FZIFF		☐	PZIFF_FALL	☐	IS-H: Check Digit for Case
10	FALAR	NTMN	FALAR		☐	FALLART	☐	IS-H: Case Type
11	TMNLB	NTMN	TMNLB		☐	LFDBEW	☐	IS-H: Sequence Number of Movement
12	TMNOE	NTMN	TMNOE		☐	ISH_TMNOE	☐	IS-H: Planned Organizational Unit
13	TMNDT	NTMN	TMNDT		☐	ISH_TMNDT	☐	IS-H: Date of Appointment
14	TMNZT	NTMN	TMNZT		☐	ISH_TMNZT	☐	IS-H: Time of Appointment
15	TMNDR	NTMN	TMNDR		☐	ISH_TMDAUER	☐	IS-H: Duration of Appointment
16	SOURC	NTMN	SOURC		☐	ISH_OBJSRC	☐	IS-H: Application that Created Object
17	TMTAG	NTMN	TMTAG		☐	ISH_TMTAG	☐	IS-H: Appointment on Given Day
18	REFID	NTMN	REFID		☐	ISH_REFTMNID	☐	IS-H: Reference Number of Next Appointment
19	NOTAN	NTMN	NOTAN		☐	NOTAUF	☐	IS-H: Emergency Admission Indicator
20	KRZAN	NTMN	KRZAN		☐	KURZAUF	☐	IS-H: Quick Admission Indicator
21	BEKAT	NTMN	BEKAT		☐	BEKAT	☐	Treatment Category
22	CLASS	NTMN	CLASS		☐	ISH_PAYCL	☐	IS-H: Patient Class
23	BNKZ	NTMN	BNKZ		☐	ISH_APP_NOTI_WANTED	☐	IS-H: Notification of Appointment Desired
24	BNDT	NTMN	BNDT		☐	ISH_BNDT	☐	IS-H: Date on which patient was last notified
25	BNART	NTMN	BNART		☐	ISH_BNART	☐	IS-H: Type of Notification (Tel., Written)
26	EINBDT	NTMN	EINBDT		☐	ISH_EINBDT	☐	IS-H: Date of Appointment of which Patient Last Notified
27	EINBZT	NTMN	EINBZT		☐	ISH_EINBZT	☐	IS-H: Time of Appointment of which Patient Last Notified
28	EINBOE	NTMN	EINBOE		☐	ISH_EINBOE	☐	Nursing Org. Unit of Patient's Last Scheduled Appointment
29	EINBPER	NTMN	EINBPER		☐	ISH_EINBPER	☐	IS-H: Person/Physician of Last Patient Appt Notification
30	EINBZIM	NTMN	EINBZIM		☐	ISH_EINBZIM	☐	IS-H: Building Unit of Last Patient Notification
31	BWART	NTMN	BWART		☐	RI_BWART	☐	IS-H: Movement Type
32	TPART	NTMN	TPART		☐	N1TPAE	☐	Transport Type
33	BWPRIO	NTMN	BWPRIO		☐	N1APRI_D	☐	Prioritization for Request/Movement (Internal)
34	MEDTX	NTMN	MEDTX		☐	N1MEDTX	☐	Medical Text
35	TMSTG	NTMN	TMSTG		☐	ISH_TMSTG	☐	Cancellation Reason for an Appointment
36	STORN	NTMN	STORN		☐	RI_STORN	☐	IS-H: Cancellation Indicator
37	STUSR	NTMN	STUSR		☐	STORN_USER	☐	IS-H: Name of User who Canceled Data Record
38	STDAT	NTMN	STDAT		☐	STORN_DAT	☐	Date of Cancellation
39	VBUND	NTMN	VBUND		☐	ISH_TMVBD	☐	Termin verbundrelevant
40	BWGR1	NTMN	BWGR1		☐	ISH_BWGR1	☐	Movement Reason - 1st and 2nd Positions
41	BWGR2	NTMN	BWGR2		☐	ISH_BWGR2	☐	Movement Reason - 3rd and 4th Positions
42	UARNR	NTMN	UARNR		☐	UARNR	☐	IS-H: Personnel Number of Referring Physician
43	TMPDT	NTMN	TMPDT		☐	ISH_TMPDT	☐	IS-H: Date Planned for Appointment
44	TMPZT	NTMN	TMPZT		☐	ISH_TMPZT	☐	IS-H: Time Planned for Appointment
45	GPLVN	NTMN	GPLVN		☐	N1GPLVN	☐	IS-H*MED: Employee or User who Last Planned Appointment
46	GPLTY	NTMN	GPLTY		☐	N1GPLTY	☐	IS-H*MED: Appointment Changed by: Employee/User ID
47	BEWTY	NTMN	BEWTY		☐	BEWTY	☐	IS-H: Movement Category
48	CHAINID	NTMN	CHAINID		☐	ISH_APP_CHAINID	☐	IS-H: Link ID for Interdependent Appointments
49	UNITID	NTMN	UNITID		☐	ISH_TREATM_UNITID	☐	IS-H: Treatment Unit ID
50	DISTMIN	NTMN	DISTMIN		☐	ISH_APPDIST_MIN	☐	IS-H: Minimum Interval Between Appointments
51	DISTMAX	NTMN	DISTMAX		☐	ISH_APPDIST_MAX	☐	IS-H: Maximum Interval Between Appointments
52	DISTUNIT	NTMN	DISTUNIT		☐	ISH_APPDIST_UNIT	☐	IS-H: Time Unit for Interval Between Two Appointments
53	CYCLE	NTMN	CYCLE		☐	ISH_APPCYCLE	☐	IS-H: Appointment Cycle
54	CYCLEUNIT	NTMN	CYCLEUNIT		☐	ISH_APPCYCLE_UNIT	☐	IS-H: Time Unit for Appointment Cycle
55	VKGID	NTMN	VKGID		☐	N1VKGID	☐	IS-H: CORD/PREG: ID of an Order Item (Preregistration)
56	PAPID	NTMN	PAPID		☐	ISH_PAPID	☐	IS-H: Provisional Patient Number
57	ENDPL	NTMN	ENDPL		☐	N1ENDPL	☐	IS-H: Planning Complete
58	LFDNR	NAPP	LFDNR		☐	LFDBEW	☐	IS-H: Sequence Number of Movement
59	DSPTY	NAPP	DSPTY		☐	ISH_DSPT	☐	IS-H: Scheduling Type for Visit Scheduling
60	PTINP	NAPP	PTINP		☐	N1PTINP	☐	IS-H: Inpatient Scheduling Type
61	VISTY	NAPP	VISTY		☐	ISH_BT	☐	IS-H: Code of Visit Category for Visit Scheduling
62	BWIDT	NAPP	BWIDT		☐	BWIDT	☐	IS-H: Date of Movement
63	BWIZT	NAPP	BWIZT		☐	BWIZT	☐	IS-H: Time of Movement
64	STATU	NAPP	STATU		☐	ISH_ABSTIN	☐	IS-H: Internal Status of Outpatient Visit
65	STATUS	NAPP	STATU		☐	ISH_ABSTIN	☐	IS-H: Internal Status of Outpatient Visit
66	ORGFA	NAPP	ORGFA		☐	NZUWFA	☐	IS-H: OU with Departmental Responsibility for Case
67	ORGPF	NAPP	ORGPF		☐	NZUWPF	☐	Organizational Unit Assigned to Case
68	POBNR	NAPP	POBNR		☐	ISH_POBNR	☐	IS-H: Internal Sequence Number of Planning Object
69	PERNR	NAPP	PERNR		☐	PERNR_FALL	☐	IS-H: Person Number
70	ZIMMR	NAPP	ZIMMR		☐	ISH_ZIMMID	☐	IS-H: Building ID of Room
71	KZTXT	NAPP	KZTXT		☐	TEXT_BEW	☐	Comment on Case Movement
72	ERDAT	NAPP	ERDAT		☐	RI_ERDAT	☐	IS-H: Date when Record Created
73	ERUSR	NAPP	ERUSR		☐	RI_ERNAM	☐	IS-H: Name of Employee who Created Record
74	UPDAT	NAPP	UPDAT		☐	RI_UPDAT	☐	IS-H: Date of Last Change
75	UPUSR	NAPP	UPUSR		☐	RI_UPNAM	☐	IS-H: Name of Person who Last Changed Data
76	LGTXT	NAPP	LGTXT		☐	RI_LGTXT	☐	Indicator that Long Text Exists
77	DAUER	NAPP	DAUER		☐	ISH_APTIME	☐	IS-H: Duration in Minutes for Treatment Appointment
78	FACHR	NAPP	FACHR		☐	FACHRTY5	☐	IS-H: Physician Specialty
79	PELOC	NAPP	PELOC		☐	ISH_PELOC	☐	IS-H: Person Being Substituted
80	STOID	NAPP	STOID		☐	N1BSTOID	☐	IS-H: Reason for Canceling Movement
81	GSCHL	NPAT	GSCHL		☐	GSCHL	☐	IS-H: Sex Indicator - Internal
82	NNAME	NPAT	NNAME		☐	NNAME_PAT	☐	IS-H: Patient Last Name
83	NNAMS	NPAT	NNAMS		☐	NNAMES_PAT	☐	IS-H: Standardized Last Name
84	VNAME	NPAT	VNAME		☐	VNAME_PAT	☐	IS-H: Patient First Name
85	VNAMS	NPAT	VNAMS		☐	VNAMES_PAT	☐	Standardized First Name
86	TITEL	NPAT	TITEL		☐	RI_TITEL	☐	IS-H: Title
87	NAMZU	NPAT	NAMZU		☐	RI_NAMZU	☐	IS-H: Name Affix
88	VORSW	NPAT	VORSW		☐	RI_VORSW	☐	IS-H: Name Prefix
89	GBDAT	NPAT	GBDAT		☐	RI_GBDAT	☐	IS-H: Birthdate
90	GBNAM	NPAT	GBNAM		☐	GBNAM	☐	IS-H: Birthname
91	GBNAS	NPAT	GBNAS		☐	GBNAMS_PAT	☐	IS-H: Standardized Birthname
92	TODKZ	NPAT	TODKZ		☐	PAT_TOD	☐	IS-H: Patient Is Deceased
93	RISKF	NPAT	RISKF		☐	ISH_RISIKO	☐	IS-H: Risk Information Exists for the Patient
94	TELF1	NPAT	TELF1		☐	TELF_PAT	☐	IS-H: Patient Telephone Number
95	EMAIL	NTMN	EMAIL		☐	ISH_SMTPADR	☐	IS-H: Internet Mail (SMTP) Address
96	ADRNR	NPAT	ADRNR		☐	ISH_ADRNR	☐	IS-H: Address Number
97	ADROB	NPAT	ADROB		☐	ISH_ADROBJ	☐	IS-H: Address Object

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20130529
SAP Release Created in	463