SAP ABAP Table RNAPP7 (IS-H: Data for SAP Enhancement nr160001/nr160002)

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

Table Category	INTTAB	Structure
Structure	RNAPP7	Table Relationship Diagram
Short Description	IS-H: Data for SAP Enhancement nr160001/nr160002

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	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
2	TMNID	☐	ISH_TMNID	ISH_LNRAPP	CHAR	10	0	IS-H: Identification of Appointment
3	ORGPF	☐	NZUWPF	ORGID	CHAR	8	0	Organizational Unit Assigned to Case	NORG
4	ORGKB	☐	ORGKB	TEXT12	CHAR	12	0	IS-H: Organizational Unit Short Text
5	ORGFA	☐	NZUWFA	ORGID	CHAR	8	0	IS-H: OU with Departmental Responsibility for Case	NORG
6	ORGFAKB	☐	ORGKB	TEXT12	CHAR	12	0	IS-H: Organizational Unit Short Text
7	DOC_NAME	☐	LANGNAME_D	ISH_C50	CHAR	50	0	IS-H: Concatenated name of business partner
8	DOC_NAME1	☐	LANGNAME_D	ISH_C50	CHAR	50	0	IS-H: Concatenated name of business partner
9	STATUS	☐	ISH_ABSTIN	ISH_ABSTIN	CHAR	2	0	IS-H: Internal Status of Outpatient Visit
10	STATUS_EX	☐	ISH_ABSTEX	ISH_ABSTEX	CHAR	2	0	IS-H: External Status of Outpatient Visit	*
11	STATUS_TXT	☐	ISH_ABSTTX	TEXT15	CHAR	15	0	IS-H: Text for External Status of Outpatient Visit
12	STATUS_1	☐	ISH_ABSTEX	ISH_ABSTEX	CHAR	2	0	IS-H: External Status of Outpatient Visit	*
13	STATUS_TX1	☐	ISH_ABSTTX	TEXT15	CHAR	15	0	IS-H: Text for External Status of Outpatient Visit
14	STATUS_2	☐	ISH_ABSTEX	ISH_ABSTEX	CHAR	2	0	IS-H: External Status of Outpatient Visit	*
15	STATUS_TX2	☐	ISH_ABSTTX	TEXT15	CHAR	15	0	IS-H: Text for External Status of Outpatient Visit
16	STATUS_3	☐	ISH_ABSTEX	ISH_ABSTEX	CHAR	2	0	IS-H: External Status of Outpatient Visit	*
17	STATUS_TX3	☐	ISH_ABSTTX	TEXT15	CHAR	15	0	IS-H: Text for External Status of Outpatient Visit
18	STATUS_4	☐	ISH_ABSTEX	ISH_ABSTEX	CHAR	2	0	IS-H: External Status of Outpatient Visit	*
19	STATUS_TX4	☐	ISH_ABSTTX	TEXT15	CHAR	15	0	IS-H: Text for External Status of Outpatient Visit
20	STATUS_5	☐	ISH_ABSTEX	ISH_ABSTEX	CHAR	2	0	IS-H: External Status of Outpatient Visit	*
21	STATUS_TX5	☐	ISH_ABSTTX	TEXT15	CHAR	15	0	IS-H: Text for External Status of Outpatient Visit
22	STATUS_6	☐	ISH_ABSTEX	ISH_ABSTEX	CHAR	2	0	IS-H: External Status of Outpatient Visit	*
23	STATUS_TX6	☐	ISH_ABSTTX	TEXT15	CHAR	15	0	IS-H: Text for External Status of Outpatient Visit
24	STATUS_7	☐	ISH_ABSTEX	ISH_ABSTEX	CHAR	2	0	IS-H: External Status of Outpatient Visit	*
25	STATUS_TX7	☐	ISH_ABSTTX	TEXT15	CHAR	15	0	IS-H: Text for External Status of Outpatient Visit
26	STATUS_8	☐	ISH_ABSTEX	ISH_ABSTEX	CHAR	2	0	IS-H: External Status of Outpatient Visit	*
27	STATUS_TX8	☐	ISH_ABSTTX	TEXT15	CHAR	15	0	IS-H: Text for External Status of Outpatient Visit
28	LFDNR	☐	LFDBEW	LFDBEW	NUMC	5	0	IS-H: Sequence Number of Movement	*
29	BWIDT	☐	BWIDT	RI_DATUM	DATS	8	0	IS-H: Date of Movement
30	BWIZT	☐	BWIZT	UHRZT	TIMS	6	0	IS-H: Time of Movement
31	BEWTY	☐	BEWTY	BEWTY	CHAR	1	0	IS-H: Movement Category
32	BWART	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type	TN14B
33	BEKAT	☐	BEKAT	BEHKATEG	CHAR	6	0	Treatment Category	TN24
34	ZIMMR	☐	ISH_ZIMMID	BAUID	CHAR	8	0	IS-H: Building ID of Room	NBAU
35	ZIKURZ	☐	NZIKURZ	CHAR8	CHAR	8	0	IS-H: Room Identifier
36	BARZT	☐	BARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Attending Physician	*
37	FACHR	☐	FACHRTY5	ISH_FACHR	CHAR	4	0	IS-H: Physician Specialty	TNKFA
38	FATXT	☐	TEXT_KFA	TEXT30	CHAR	30	0	IS-H: Name of Specialty
39	RANK	☐	ISH_RANK	ISH_RANK	CHAR	3	0	IS-H: Rank	TN12R
40	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number
41	PZIFF	☐	PZIFF_PAT	PZIFF	CHAR	1	0	IS-H: Check Digit for Patient
42	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	NFAL
43	FZIFF	☐	PZIFF_FALL	PZIFF	CHAR	1	0	IS-H: Check Digit for Case
44	PNAME	☐	RI_NAME	TEXT30	CHAR	30	0	IS-H: Patient Name
45	NNAME	☐	NNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient Last Name
46	VNAME	☐	VNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient First Name
47	GBDAT	☐	RI_GBDAT	RI_DATUM	DATS	8	0	IS-H: Birthdate
48	GBNAM	☐	GBNAM	TEXT30	CHAR	30	0	IS-H: Birthname
49	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
50	GSCHLE	☐	GSCHLE	GSCHLE	CHAR	1	0	IS-H: Sex Indicator - User-Specific	TN17G
51	TELF1	☐	TELF_PAT	TEXT16	CHAR	16	0	IS-H: Patient Telephone Number
52	KZTXT	☐	TEXT_BEW	TEXT50	CHAR	50	0	Comment on Case Movement
53	LGTXT	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
54	NOTAN	☐	NOTAUF	XFELD	CHAR	1	0	IS-H: Emergency Admission Indicator
55	KRZAN	☐	KURZAUF	XFELD	CHAR	1	0	IS-H: Quick Admission Indicator
56	DSPTY	☐	ISH_DSPT	ISH_DSPTC8	CHAR	8	0	IS-H: Scheduling Type for Visit Scheduling	TN40B
57	DSPTY_TXT	☐	ISH_DTXT	TEXT15	CHAR	15	0	IS-H: Text for Scheduling Type
58	DAUER	☐	ISH_APTIME	ISH_DZEIT	NUMC	4	0	IS-H: Duration in Minutes for Treatment Appointment
59	VISTY	☐	ISH_BT	ISH_BT	CHAR	1	0	IS-H: Code of Visit Category for Visit Scheduling
60	VISTY_TXT	☐	ISH_VTTXT	TEXT15	CHAR	15	0	IS-H: Description of a visit category
61	PELOC	☐	ISH_PELOC	RI_KUNNR	CHAR	10	0	IS-H: Person Being Substituted	*
62	STOID	☐	N1BSTOID	N1STOID	CHAR	3	0	IS-H: Reason for Canceling Movement	N1STGR
63	EXTNR	☐	EXT_PATNR	EXT_PATNR	CHAR	20	0	IS-H: External Patient Identification
64	EXTNR_HLP	☐	EXT_PATNR	EXT_PATNR	CHAR	20	0	IS-H: External Patient Identification
65	CLASS	☐	ISH_PAYCL	ISH_PAYCL	CHAR	4	0	IS-H: Patient Class	TNP01
66	TODKZ	☐	PAT_TOD	XFELD	CHAR	1	0	IS-H: Patient Is Deceased
67	BNKZ	☐	ISH_APP_NOTI_WANTED	XFELD	CHAR	1	0	IS-H: Notification of Appointment Desired
68	BNART	☐	ISH_BNART	KOMMART	CHAR	1	0	IS-H: Type of Notification (Tel., Written)
69	EINBDT	☐	ISH_EINBDT	RI_DATUM	DATS	8	0	IS-H: Date of Appointment of which Patient Last Notified
70	EINBZT	☐	ISH_EINBZT	UHRZT	TIMS	6	0	IS-H: Time of Appointment of which Patient Last Notified
71	EINBOE	☐	ISH_EINBOE	ORGID	CHAR	8	0	Nursing Org. Unit of Patient's Last Scheduled Appointment	*
72	EINBPER	☐	ISH_EINBPER	RI_KUNNR	CHAR	10	0	IS-H: Person/Physician of Last Patient Appt Notification	*
73	EINBZIM	☐	ISH_EINBZIM	BAUID	CHAR	8	0	IS-H: Building Unit of Last Patient Notification	*
74	LOG_NOTIF	☐	ISH_LOG_NOTIF	TEXT10	CHAR	10	0	IS-H: Pushbutton 'Print Log of Admission Notifications'
75	BTTS	☐	ISH_BTTS	UHRZT	TIMS	6	0	IS-H: Start Time for Time Slot in Visit Scheduling
76	ETTS	☐	ISH_ETTS	UHRZT	TIMS	6	0	IS-H: End Time for Time Slot in Visit Scheduling
77	DBEGTI	☐	ISH_DBEGTI	UHRZT	TIMS	6	0	IS-H: Working/Consulting Hours Start Time
78	DENDTI	☐	ISH_DENDTI	UHRZT	TIMS	6	0	IS-H: Working/Consulting Hours End Time
79	VDATTOU	☐	ISH_VDATTOU	ORGID	CHAR	8	0	Treatment Org. Unit for Free Time Slot Search	*
80	VDATTDP	☐	ISH_VDATTDP	ORGID	CHAR	8	0	IS-H: Departmental Org. Unit for Free Time Slot Search	*
81	VDPOBNR	☐	ISH_VDPOBNR	ISH_POBNR	NUMC	10	0	IS-H: Internal Seq. No. Plan. Obj. for Free Time Slot Search	*
82	VDDSPTY	☐	ISH_VDDSPTY	ISH_DSPTC8	CHAR	8	0	IS-H: Scheduling Type for Open Time Slot Search	*
83	VDFACHR	☐	ISH_VDFACHR	ISH_FACHR	CHAR	4	0	IS-H: Physician Specialty for Free Time Slot Search	*
84	VDRANK	☐	ISH_VDRANK	ISH_RANK	CHAR	3	0	IS-H: Rank of Attending Physician for Free Time Slot Search	*
85	VDDATE	☐	ISH_VDDATE	RI_DATUM	DATS	8	0	IS-H: Start Date for Free Time Slot Search
86	EXCL_MON	☐	ISH_EXCLMO	XFELD	CHAR	1	0	IS-H: Except for Monday
87	EXCL_TUE	☐	ISH_EXCLTU	XFELD	CHAR	1	0	IS-H: Except for Tuesday
88	EXCL_WED	☐	ISH_EXCLWE	XFELD	CHAR	1	0	IS-H: Except for Wednesday
89	EXCL_THU	☐	ISH_EXCLTH	XFELD	CHAR	1	0	IS-H: Except for Thursday
90	EXCL_FRI	☐	ISH_EXCLFR	XFELD	CHAR	1	0	IS-H: Except for Friday
91	EXCL_SAT	☐	ISH_EXCLSA	XFELD	CHAR	1	0	IS-H: Except for Saturday
92	EXCL_SUN	☐	ISH_EXCLSO	XFELD	CHAR	1	0	IS-H: Except for Sunday
93	EXCL_VORM	☐	ISH_EXCLVO	XFELD	CHAR	1	0	IS-H: Except for Morning
94	EXCL_NACHM	☐	ISH_EXCLNA	XFELD	CHAR	1	0	IS-H: Except for Afternoon
95	TO_WEEK	☐	ISH_TOWEEK	NUMC03	NUMC	3	0	IS-H: In x Weeks

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RNAPP7	BEKAT	TN24	BEKAT
2	RNAPP7	BWART	TN14B	BWART
3	RNAPP7	CLASS	TNP01	CLASS	REF	1	CN
4	RNAPP7	DSPTY	TN40B	DISPO
5	RNAPP7	EINRI	TN01	EINRI
6	RNAPP7	FACHR	TNKFA	FACHR	REF	1	CN
7	RNAPP7	FALNR	NFAL	FALNR
8	RNAPP7	GSCHLE	TN17G	GSCHLE
9	RNAPP7	ORGFA	NORG	ORGID	REF	1	CN
10	RNAPP7	ORGPF	NORG	ORGID
11	RNAPP7	RANK	TN12R	RANK	REF	1	CN
12	RNAPP7	STOID	N1STGR	STOID
13	RNAPP7	ZIMMR	NBAU	BAUID

History

Last changed by/on	SAP	20130529
SAP Release Created in