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

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_VNTMN_NPAT
Short Description	IS-H: Appointment Data for Patient; Access via NTMN
Root table	NTMN	IS-H: Patient-Specific Appointments (Header Table for NAPP)

Table

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

Join Conditions

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

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