SAP ABAP Table RNPB2 (IS-H: Data structure for Outpatient Clinic Management)

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	RNPB2	Table Relationship Diagram
Short Description	IS-H: Data structure for Outpatient Clinic Management

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	ORGID	☐	ORGID	ORGID	CHAR	8	0	IS-H: Organizational Unit Identification Key	NORG
3	ORGID_COPY	☐	ORGID	ORGID	CHAR	8	0	IS-H: Organizational Unit Identification Key	NORG
4	ORGPF	☐	NZUWPF	ORGID	CHAR	8	0	Organizational Unit Assigned to Case	NORG
5	ORGTY	☐	ORGTYP	ORGTYP	CHAR	2	0	IS-H: Category of Organizational Unit	TN10A
6	ORGKB	☐	ORGKB	TEXT12	CHAR	12	0	IS-H: Organizational Unit Short Text
7	SELDT	☐	ISH_SELDT	RI_DATUM	DATS	8	0	IS-H: Key Date
8	SELZT	☐	SELZT	UHRZT	TIMS	6	0	IS-H: Key time
9	DPSDT	☐	ISH_DPSDT	RI_DATUM	DATS	8	0	IS-H: Start Date for Appt Overview of Visit Scheduling
10	ORGFA	☐	NZUWFA	ORGID	CHAR	8	0	IS-H: OU with Departmental Responsibility for Case	NORG
11	ORGFAKB	☐	ORGKB	TEXT12	CHAR	12	0	IS-H: Organizational Unit Short Text
12	DPSOE	☐	ISH_ATTOU	ORGID	CHAR	8	0	Treatment Organizational Unit	NORG
13	DPSFA	☐	NZUWFA	ORGID	CHAR	8	0	IS-H: OU with Departmental Responsibility for Case	NORG
14	POBNR	☐	ISH_POBNR	ISH_POBNR	NUMC	10	0	IS-H: Internal Sequence Number of Planning Object	*
15	POB_NAME	☐	ISH_POBNAM	CHAR30	CHAR	30	0	IS-H: Name of Planning Object (for F4 Input Help)
16	POBDESC	☐	ISH_POBDESC	ISH_C50	CHAR	50	0	IS-H: Name or Description of Planning Object
17	DAY_NEXT	☐	ISH_DAYNEX	XFELD	CHAR	1	0	IS-H: Next day
18	DAY_PREV	☐	ISH_DAYPRE	XFELD	CHAR	1	0	IS-H: Previous day
19	DOC_NAME	☐	BARNAM	TEXT40	CHAR	40	0	IS-H: Last and first name of attending physician
20	DOC_NAME1	☐	BARNAM	TEXT40	CHAR	40	0	IS-H: Last and first name of attending physician
21	DOC_NAME2	☐	BARNAM	TEXT40	CHAR	40	0	IS-H: Last and first name of attending physician
22	DAY_TXT	☐	ISH_DAYTXT	TEXT15	CHAR	15	0	IS-H: Name of a weekday
23	STATUS	☐	ISH_ABSTIN	ISH_ABSTIN	CHAR	2	0	IS-H: Internal Status of Outpatient Visit
24	STATUS_EX	☐	ISH_ABSTEX	ISH_ABSTEX	CHAR	2	0	IS-H: External Status of Outpatient Visit	*
25	STATUS_TXT	☐	ISH_ABSTTX	TEXT15	CHAR	15	0	IS-H: Text for External Status of Outpatient Visit
26	STATUS_1	☐	ISH_ABSTEX	ISH_ABSTEX	CHAR	2	0	IS-H: External Status of Outpatient Visit	*
27	STATUS_TX1	☐	ISH_ABSTTX	TEXT15	CHAR	15	0	IS-H: Text for External Status of Outpatient Visit
28	STATUS_2	☐	ISH_ABSTEX	ISH_ABSTEX	CHAR	2	0	IS-H: External Status of Outpatient Visit	*
29	STATUS_TX2	☐	ISH_ABSTTX	TEXT15	CHAR	15	0	IS-H: Text for External Status of Outpatient Visit
30	STATUS_3	☐	ISH_ABSTEX	ISH_ABSTEX	CHAR	2	0	IS-H: External Status of Outpatient Visit	*
31	STATUS_TX3	☐	ISH_ABSTTX	TEXT15	CHAR	15	0	IS-H: Text for External Status of Outpatient Visit
32	STATUS_4	☐	ISH_ABSTEX	ISH_ABSTEX	CHAR	2	0	IS-H: External Status of Outpatient Visit	*
33	STATUS_TX4	☐	ISH_ABSTTX	TEXT15	CHAR	15	0	IS-H: Text for External Status of Outpatient Visit
34	STATUS_5	☐	ISH_ABSTEX	ISH_ABSTEX	CHAR	2	0	IS-H: External Status of Outpatient Visit	*
35	STATUS_TX5	☐	ISH_ABSTTX	TEXT15	CHAR	15	0	IS-H: Text for External Status of Outpatient Visit
36	STATUS_6	☐	ISH_ABSTEX	ISH_ABSTEX	CHAR	2	0	IS-H: External Status of Outpatient Visit	*
37	STATUS_TX6	☐	ISH_ABSTTX	TEXT15	CHAR	15	0	IS-H: Text for External Status of Outpatient Visit
38	STATUS_7	☐	ISH_ABSTEX	ISH_ABSTEX	CHAR	2	0	IS-H: External Status of Outpatient Visit	*
39	STATUS_TX7	☐	ISH_ABSTTX	TEXT15	CHAR	15	0	IS-H: Text for External Status of Outpatient Visit
40	STATUS_8	☐	ISH_ABSTEX	ISH_ABSTEX	CHAR	2	0	IS-H: External Status of Outpatient Visit	*
41	STATUS_TX8	☐	ISH_ABSTTX	TEXT15	CHAR	15	0	IS-H: Text for External Status of Outpatient Visit
42	LFDNR	☐	LFDBEW	LFDBEW	NUMC	5	0	IS-H: Sequence Number of Movement	*
43	BWIDT	☐	BWIDT	RI_DATUM	DATS	8	0	IS-H: Date of Movement
44	BWIZT	☐	BWIZT	UHRZT	TIMS	6	0	IS-H: Time of Movement
45	APPTI	☐	ISH_APPTIME	TIME5	CHAR	5	0	IS-H: Time of an outpatient visit appointment (hh:mm)
46	APPTI_S	☐	ISH_APPTIME	TIME5	CHAR	5	0	IS-H: Time of an outpatient visit appointment (hh:mm)
47	APPTI_T	☐	ISH_APPTIME	TIME5	CHAR	5	0	IS-H: Time of an outpatient visit appointment (hh:mm)
48	BEWTY	☐	BEWTY	BEWTY	CHAR	1	0	IS-H: Movement Category
49	BWART	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type	TN14B
50	BWGR1	☐	ISH_BWGR1	ISH_BGRUND	CHAR	2	0	Movement Reason - 1st and 2nd Positions	TN14G
51	BWGR2	☐	ISH_BWGR2	ISH_BGRUND	CHAR	2	0	Movement Reason - 3rd and 4th Positions	TN14G
52	BGTXT	☐	ISH_BGTXTL	TEXT30	CHAR	30	0	Long Text for Movement Reason
53	BEKAT	☐	BEKAT	BEHKATEG	CHAR	6	0	Treatment Category	TN24
54	ZIMMR	☐	ISH_ZIMMID	BAUID	CHAR	8	0	IS-H: Building ID of Room	NBAU
55	ZIKURZ	☐	NZIKURZ	CHAR8	CHAR	8	0	IS-H: Room Identifier
56	ROOMKB	☐	BAUKB	TEXT12	CHAR	12	0	IS-H: Short Text for Building Unit
57	NACH_ZIMMR	☐	ISH_ZIMMID	BAUID	CHAR	8	0	IS-H: Building ID of Room	*
58	ZIKURZ1	☐	NZIKURZ	CHAR8	CHAR	8	0	IS-H: Room Identifier
59	ZIKURZ_S	☐	NZIKURZ	CHAR8	CHAR	8	0	IS-H: Room Identifier
60	ZIKURZ_T	☐	NZIKURZ	CHAR8	CHAR	8	0	IS-H: Room Identifier
61	BARZT	☐	BARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Attending Physician	*
62	FACHR	☐	FACHRTY5	ISH_FACHR	CHAR	4	0	IS-H: Physician Specialty	TNKFA
63	FATXT	☐	TEXT_KFA	TEXT30	CHAR	30	0	IS-H: Name of Specialty
64	RANK	☐	ISH_RANK	ISH_RANK	CHAR	3	0	IS-H: Rank	TN12R
65	NACH_BARZT	☐	BARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Attending Physician	*
66	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number
67	PZIFF	☐	PZIFF_PAT	PZIFF	CHAR	1	0	IS-H: Check Digit for Patient
68	PAPID	☐	ISH_PAPID	ISH_PAPID	CHAR	10	0	IS-H: Provisional Patient Number	*
69	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	NFAL
70	FZIFF	☐	PZIFF_FALL	PZIFF	CHAR	1	0	IS-H: Check Digit for Case
71	PNAME	☐	RI_NAME	TEXT30	CHAR	30	0	IS-H: Patient Name
72	NNAME	☐	NNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient Last Name
73	VNAME	☐	VNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient First Name
74	GBDAT	☐	RI_GBDAT	RI_DATUM	DATS	8	0	IS-H: Birthdate
75	GBNAM	☐	GBNAM	TEXT30	CHAR	30	0	IS-H: Birthname
76	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
77	GSCHLE	☐	GSCHLE	GSCHLE	CHAR	1	0	IS-H: Sex Indicator - User-Specific	TN17G
78	TELF1	☐	TELF_PAT	TEXT16	CHAR	16	0	IS-H: Patient Telephone Number
79	KZTXT	☐	TEXT_BEW	TEXT50	CHAR	50	0	Comment on Case Movement
80	LGTXT	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
81	NOTAN	☐	NOTAUF	XFELD	CHAR	1	0	IS-H: Emergency Admission Indicator
82	KRZAN	☐	KURZAUF	XFELD	CHAR	1	0	IS-H: Quick Admission Indicator
83	DSPTY	☐	ISH_DSPT	ISH_DSPTC8	CHAR	8	0	IS-H: Scheduling Type for Visit Scheduling	TN40B
84	DSPTY_TXT	☐	ISH_DTXT	TEXT15	CHAR	15	0	IS-H: Text for Scheduling Type
85	DAUER	☐	ISH_APTIME	ISH_DZEIT	NUMC	4	0	IS-H: Duration in Minutes for Treatment Appointment
86	VISTY	☐	ISH_BT	ISH_BT	CHAR	1	0	IS-H: Code of Visit Category for Visit Scheduling
87	VISTY_TXT	☐	ISH_VTTXT	TEXT15	CHAR	15	0	IS-H: Description of a visit category
88	BAUID	☐	BAUID	BAUID	CHAR	8	0	IS-H: Identification of Building Unit	NBAU
89	BAUID_COPY	☐	ISH_POBBAU_COPY	BAUID	CHAR	8	0	IS-H: Template Planning Object of Type 'Build. Unit'	*
90	PERNR	☐	RI_PERNR	RI_KUNNR	CHAR	10	0	IS-H: Person Number	NGPA
91	PERNR_COPY	☐	ISH_POBPER_COPY	RI_KUNNR	CHAR	10	0	IS-H: Reference planning object of type 'treat. person'	*
92	APERSC	☐	ISH_APERSC	TEXT50	CHAR	50	0	IS-H: Compound Name of Attending Person
93	APERSC_S	☐	ISH_APERSC	TEXT50	CHAR	50	0	IS-H: Compound Name of Attending Person
94	APERSC_T	☐	ISH_APERSC	TEXT50	CHAR	50	0	IS-H: Compound Name of Attending Person
95	YEAR	☐	ISH_YEAR	GJAHR	NUMC	4	0	IS-H: Year
96	MARK	☐	MARKKZ	XFIELD	CHAR	1	0	IS-H: Selection Indicator
97	POAKT	☐	AKT_POS	ISH_POS	NUMC	3	0	IS-H: Current Item Number
98	POGES	☐	GES_POS	ISH_POS	NUMC	3	0	IS-H: Number of Total Items
99	KW_VON_1	☐	ISH_KW_VON	NUMC02	NUMC	2	0	IS-H: From calendar week
100	KW_VON_2	☐	ISH_KW_VON	NUMC02	NUMC	2	0	IS-H: From calendar week
101	KW_BIS_1	☐	ISH_KW_BIS	NUMC02	NUMC	2	0	IS-H: To calendar week
102	KW_BIS_2	☐	ISH_KW_BIS	NUMC02	NUMC	2	0	IS-H: To calendar week
103	EXCL_MON	☐	ISH_EXCLMO	XFELD	CHAR	1	0	IS-H: Except for Monday
104	EXCL_TUE	☐	ISH_EXCLTU	XFELD	CHAR	1	0	IS-H: Except for Tuesday
105	EXCL_WED	☐	ISH_EXCLWE	XFELD	CHAR	1	0	IS-H: Except for Wednesday
106	EXCL_THU	☐	ISH_EXCLTH	XFELD	CHAR	1	0	IS-H: Except for Thursday
107	EXCL_FRI	☐	ISH_EXCLFR	XFELD	CHAR	1	0	IS-H: Except for Friday
108	EXCL_SAT	☐	ISH_EXCLSA	XFELD	CHAR	1	0	IS-H: Except for Saturday
109	EXCL_SUN	☐	ISH_EXCLSO	XFELD	CHAR	1	0	IS-H: Except for Sunday
110	EXCL_VORM	☐	ISH_EXCLVO	XFELD	CHAR	1	0	IS-H: Except for Morning
111	EXCL_NACHM	☐	ISH_EXCLNA	XFELD	CHAR	1	0	IS-H: Except for Afternoon
112	TO_WEEK	☐	ISH_TOWEEK	NUMC03	NUMC	3	0	IS-H: In x Weeks
113	TGPER	☐	ISH_TP	ISH_TP	CHAR	1	0	IS-H: Part of Day ID Morning/Afternoon
114	LOCBD	☐	ISH_LBEGDT	RI_DATUM	DATS	8	0	IS-H: Substitution Start Date
115	LOCBT	☐	ISH_LBEGZT	UHRZT	TIMS	6	0	IS-H: Substitution Start Time
116	LOCET	☐	ISH_LENDZT	UHRZT	TIMS	6	0	IS-H: Substitution End Time
117	LOCED	☐	ISH_LENDDT	RI_DATUM	DATS	8	0	IS-H: Substitution end date
118	OULOC	☐	NZUWPF	ORGID	CHAR	8	0	Organizational Unit Assigned to Case	*
119	PELOC	☐	ISH_PELOC	RI_KUNNR	CHAR	10	0	IS-H: Person Being Substituted	*
120	STOID	☐	ISH_TMSTG	N1STOID	CHAR	3	0	Cancellation Reason for an Appointment	N1STGR
121	OULKB	☐	ORGKB	TEXT12	CHAR	12	0	IS-H: Organizational Unit Short Text
122	EXTNR	☐	EXT_PATNR	EXT_PATNR	CHAR	20	0	IS-H: External Patient Identification
123	EXTNR_HLP	☐	EXT_PATNR	EXT_PATNR	CHAR	20	0	IS-H: External Patient Identification
124	CLASS	☐	ISH_PAYCL	ISH_PAYCL	CHAR	4	0	IS-H: Patient Class	TNP01
125	TODKZ	☐	PAT_TOD	XFELD	CHAR	1	0	IS-H: Patient Is Deceased
126	LOCIND	☐	ISH_LOCIND	XFELD	CHAR	1	0	IS-H: Substitution Situation Indicator
127	TSLSTR	☐	ISH_TSLSTR	CHAR25	CHAR	25	0	IS-H: Appointment String
128	MARKV	☐	ISH_MARKV	NUMC4	NUMC	4	0	IS-H: Number of Visits Selected
129	FORCI	☐	ISH_FORCIN	XFELD	CHAR	1	0	IS-H: Overbook appointments
130	PNAMC	☐	ISH_PNAMEC	TEXT50	CHAR	50	0	IS-H: Compound Patient Name
131	STATL	☐	ISH_STATUS_LINE	CHAR10	CHAR	10	0	IS-H: Visit Status (Bar Display)
132	PRIVP	☐	ISH_PRIVP	CHAR1	CHAR	1	0	IS-H: Private Patient
133	FRSTV	☐	ISH_FRSTV	CHAR1	CHAR	1	0	IS-H: Visit of Category 'Initial Visit'
134	FIRSTV	☐	ISH_FIRST_VISIT	XFELD	CHAR	1	0	IS-H: Initial Visit
135	FOLLOW_UP	☐	ISH_FOLLOW_UP	XFELD	CHAR	1	0	IS-H: Follow-Up Visit
136	BHSF	☐	ISH_BHSF	CHAR1	CHAR	1	0	IS-H: Treatment Certificate Is Missing
137	MARKFIELD	☐	RI_MARK	XFELD	CHAR	1	0	IS-H: Checkbox to Select a Row
138	ICONTR	☐	ISH_ICON_TR	CHAR4	CHAR	4	0	IS-H: Icon for Provisional Appointment
139	ICONTA	☐	ISH_ICON_TA	CHAR4	CHAR	4	0	IS-H: Icon for Time Slot Maintenance
140	ICONVT	☐	ISH_ICON_VT	CHAR4	CHAR	4	0	IS-H: Icon for Appointment Substitution
141	ICONPOB	☐	ISH_ICON_POB_CHANGE	CHAR4	CHAR	4	0	IS-H: Icon for "Change Planning Object Data"
142	ICONSRCH	☐	ISH_ICON_SRCH_APP	CHAR4	CHAR	4	0	IS-H: Icon for "Open Time Slot Search"
143	COUNTV	☐	ISH_COUNT_VISIT	NUMC04	NUMC	4	0	IS-H: Number of Visits
144	BNKZ	☐	ISH_APP_NOTI_WANTED	XFELD	CHAR	1	0	IS-H: Notification of Appointment Desired
145	NOTI_DONE	☐	ISH_APP_NOTI_DONE	XFELD	CHAR	1	0	IS-H: Patient Already Notified of Appointment
146	BNART	☐	ISH_BNART	KOMMART	CHAR	1	0	IS-H: Type of Notification (Tel., Written)
147	EINBDT	☐	ISH_EINBDT	RI_DATUM	DATS	8	0	IS-H: Date of Appointment of which Patient Last Notified
148	EINBZT	☐	ISH_EINBZT	UHRZT	TIMS	6	0	IS-H: Time of Appointment of which Patient Last Notified
149	EINBOE	☐	ISH_EINBOE	ORGID	CHAR	8	0	Nursing Org. Unit of Patient's Last Scheduled Appointment	*
150	EINBPER	☐	ISH_EINBPER	RI_KUNNR	CHAR	10	0	IS-H: Person/Physician of Last Patient Appt Notification	*
151	EINBZIM	☐	ISH_EINBZIM	BAUID	CHAR	8	0	IS-H: Building Unit of Last Patient Notification	*
152	PROT_APP	☐	ISH_PROT_APP	XFELD	CHAR	1	0	IS-H: Display Log of Appointment Move
153	SAVE_APP	☐	ISH_SAVE_APP	XFELD	CHAR	1	0	IS-H: Save Appointment Move Immediately
154	LOG_NOTIF	☐	ISH_LOG_NOTIF	TEXT10	CHAR	10	0	IS-H: Pushbutton 'Print Log of Admission Notifications'
155	UARNR	☐	UARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Referring Physician	NGPA
156	UANAM	☐	UANAM	TEXT40	CHAR	40	0	IS-H: First and last name of referring physician
157	EMAIL	☐	ISH_SMTPADR	AD_SMTPADR	CHAR	241	0	IS-H: Internet Mail (SMTP) Address
158	REPNO	☐	ISH_REPNO	NUMC02	NUMC	2	0	IS-H: Number of Occurrences
159	REPDAY	☐	ISH_CYCLE_DAY	ISH_CYCLE_DAY	NUMC	2	0	IS-H: Repetition Specification in Days
160	REPWEEK	☐	ISH_CYCLE_WEEK	ISH_CYCLE_WEEK	NUMC	1	0	IS-H: Repetition Specification in Weeks
161	REPMONTH	☐	ISH_CYCLE_MONTH	ISH_CYCLE_MONTH	NUMC	2	0	IS-H: Repetition Specification in Months

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RNPB2	BAUID	NBAU	BAUID
2	RNPB2	BEKAT	TN24	BEKAT
3	RNPB2	BWART	TN14B	BWART
4	RNPB2	BWGR1	TN14G	GRUND	REF	1	CN
5	RNPB2	BWGR2	TN14G	GRUND	REF	1	CN
6	RNPB2	CLASS	TNP01	CLASS	REF	1	CN
7	RNPB2	DPSFA	NORG	ORGID		1	CN
8	RNPB2	DPSOE	NORG	ORGID
9	RNPB2	DSPTY	TN40B	DISPO
10	RNPB2	EINRI	TN01	EINRI
11	RNPB2	FACHR	TNKFA	FACHR	REF	1	CN
12	RNPB2	FALNR	NFAL	FALNR
13	RNPB2	GSCHLE	TN17G	GSCHLE
14	RNPB2	ORGFA	NORG	ORGID	REF	1	CN
15	RNPB2	ORGID	NORG	ORGID
16	RNPB2	ORGID_COPY	NORG	ORGID		1	CN
17	RNPB2	ORGPF	NORG	ORGID
18	RNPB2	ORGTY	TN10A	ORGTY
19	RNPB2	PERNR	NGPA	GPART
20	RNPB2	RANK	TN12R	RANK	REF	1	CN
21	RNPB2	STOID	N1STGR	STOID
22	RNPB2	UARNR	NGPA	GPART
23	RNPB2	ZIMMR	NBAU	BAUID

History

Last changed by/on	SAP	20130529
SAP Release Created in