SAP ABAP Table BAPI2097OVIN (IS-H Create Structure for Outpatient Visit and Change Case)

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	BAPI2097OVIN	Table Relationship Diagram
Short Description	IS-H Create Structure for Outpatient Visit and Change Case

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	CASETYPE_EXT	☐	FALLARTE	FALLARTE	CHAR	1	0	IS-H: Case Type - User-Specific	*
2	CASETYPE_EXTX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
3	CASE_COMMENT	☐	TEXT_NFAL	RI_BEMERK	CHAR	30	0	IS-H: Comment on Case
4	CASE_COMMENTX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
5	CASE_CATEGORY	☐	ISH_CASETYPE	ISH_CASETYPE	CHAR	2	0	Case Category	TN15C
6	CASE_CATEGORYX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
7	FOREIGN_CASE	☐	ISH_FOREIG	XFELD	CHAR	1	0	IS-H: Foreign Case
8	FOREIGN_CASEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
9	NON_RESIDENT	☐	ISH_RESID	XFELD	CHAR	1	0	IS-H: Indicator that Patient is Non-Resident
10	NON_RESIDENTX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
11	GEOGR_AREA	☐	EINZGEBIET	EINZGEBIET	CHAR	9	0	IS-H: Geographical Area
12	GEOGR_AREAX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
13	EMERG_ADM	☐	NOTAUF	XFELD	CHAR	1	0	IS-H: Emergency Admission Indicator
14	EMERG_ADMX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
15	QUICK_ADM	☐	KURZAUF	XFELD	CHAR	1	0	IS-H: Quick Admission Indicator
16	QUICK_ADMX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
17	START_DATE	☐	BEGDT_FAL	RI_DATUM	DATS	8	0	IS-H: Start Date of Case
18	START_DATEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
19	END_DATE	☐	ENDDT_FAL	RI_DATUM	DATS	8	0	IS-H: End Date of Case
20	END_DATEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
21	CASEENDTYPE	☐	ISH_CASEEND	ISH_CASEEND	CHAR	2	0	IS-H: Type of Case End	TN15D
22	CASEENDTYPEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
23	WORK_INCAPACITY	☐	ARBUN	RI_DATUM	DATS	8	0	IS-H: Work Incapacity To-Date
24	WORK_INCAPACITYX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
25	BILL_BLOCK	☐	FSPER	ISH_FSPER	CHAR	1	0	IS-H: Billing Block for Case
26	BILL_BLOCKX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
27	STATSTC_BLOCK	☐	ISH_STASP	XFELD	CHAR	1	0	IS-H: Indicator for Admission Type "Statistics Block"
28	STATSTC_BLOCKX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
29	PPA_RELEV	☐	ISH_KV_KZ	XFELD	CHAR	1	0	IS-H: Relevant for Panel Physician Association Billing
30	PPA_RELEVX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
31	REC_ORDER	☐	ISH_EAUFN	AUFNR	CHAR	12	0	IS-HCO: Receiver (Order)	AUFK
32	REC_ORDERX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
33	CHILDREN	☐	ISH_CHILD	ISH_CHILD	CHAR	2	0	IS-H: Number of Children
34	CHILDRENX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
35	EMPLOYEE_TYPE	☐	ISH_EMTYPE	ISH_EMTYPE	CHAR	2	0	IS-H: Employee Type	TN15G
36	EMPLOYEE_TYPEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
37	CANTON_TARIFF	☐	NCH_TARCDE	NCH_TARCDE	CHAR	3	0	IS-H CH: Canton Tariff	TNCH12
38	CANTON_TARIFFX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
39	CANTON_CONVTN	☐	NCH_AGREEMENT	NCH_AGREEMENT	CHAR	3	0	IS-H CH: Convention (Hospital <-> Canton)	TNCH13
40	CANTON_CONVTNX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
41	APPLSTATUS	☐	ISH_APSTATE	ISH_APSTATE	CHAR	2	0	IS-H: Application Status	TNC301SA
42	APPLSTATUSX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
43	SPECIALTY	☐	FACHRTY7	ISH_FACHR	CHAR	4	0	IS-H: Specialty for Organizational Unit	*
44	SPECIALTYX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
45	MOVEMNT_TYPE	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type	TN14B
46	MOVEMNT_DATE	☐	BWIDT	RI_DATUM	DATS	8	0	IS-H: Date of Movement
47	MOVEMNT_TIME	☐	BWIZT	UHRZT	TIMS	6	0	IS-H: Time of Movement
48	MOVEMNT_REAS1	☐	ISH_BWGR1	ISH_BGRUND	CHAR	2	0	Movement Reason - 1st and 2nd Positions	TN14G
49	MOVEMNT_REAS2	☐	ISH_BWGR2	ISH_BGRUND	CHAR	2	0	Movement Reason - 3rd and 4th Positions	TN14G
50	EXT_VISIT_STAT	☐	ISH_ABSTEX	ISH_ABSTEX	CHAR	2	0	IS-H: External Status of Outpatient Visit	TN14E
51	MOVEMNT_ENDDATE	☐	BWEDT	RI_DATUM	DATS	8	0	IS-H: Movement End Date, Start Date of Subsequent Movement
52	MOVEMNT_ENDTIME	☐	BWEZT	UHRZT	TIMS	6	0	IS-H: Movement End Time, Start Time of Subsequent Movement
53	EMERG_CASE	☐	RI_NOTKZ	XFELD	CHAR	1	0	IS-H: Emergency Case Indicator
54	ACCIDENT	☐	UNFART	UNFART	CHAR	3	0	IS-H: Accident Type	TN14C
55	ACCIDENT_NO	☐	UNFNR	UNFNR	CHAR	12	0	IS-H: File Number / Processing Number for Accident
56	ACCIDENT_LOC	☐	ORT01_UNF	TEXT25	CHAR	25	0	IS-H: Accident Location
57	ACCIDENT_TIME	☐	UNFZT	UHRZT	TIMS	6	0	IS-H: Time of Accident
58	ACCIDENT_DATE	☐	UNFDT	RI_DATUM	DATS	8	0	IS-H: Accident date
59	ACCIDENT_EMSTYP	☐	ISH_RESCTY	ISH_RESCTY	CHAR	4	0	IS-H: Emergency Services	TN14I
60	ACCIDENT_EMSVCE	☐	ISH_RETTNR	ISH_RETTNR	CHAR	15	0	IS-H: Number of the Emergency Service for Accident
61	ACCIDENT_3RDPTY	☐	N1FVS	XFELD	CHAR	1	0	IS-H: Third-Party Responsibility
62	LATEST_ADM	☐	AUFDT_LAST	RI_DATUM	DATS	8	0	IS-H: Latest Admission Date
63	SPECIALTY_VISIT	☐	FACHRTY5	ISH_FACHR	CHAR	4	0	IS-H: Physician Specialty	TNKFA
64	DEPARTMENT	☐	NZUWFA	ORGID	CHAR	8	0	IS-H: OU with Departmental Responsibility for Case	NORG
65	NURS_TREAT_OU	☐	NZUWPF	ORGID	CHAR	8	0	Organizational Unit Assigned to Case	NORG
66	ROOM	☐	ISH_ZIMMID	BAUID	CHAR	8	0	IS-H: Building ID of Room	NBAU
67	BED	☐	BETTID	BAUID	CHAR	8	0	IS-H: Building ID of Bed Location	NBAU
68	LENGTH_OF_STAY	☐	ISH_DAUER	NUMC5	NUMC	5	0	IS-H: Estimated Length of Stay or Treatment
69	REF_HOSPITAL	☐	EXTKH	RI_KUNNR	CHAR	10	0	IS-H: Identification of an External Hospital	NGPA
70	ADMITT_DEPT	☐	ORGAU	ORGID	CHAR	8	0	IS-H: Org. ID of Admitting Facility	NORG
71	TREATMCATEGORY	☐	BEKAT	BEHKATEG	CHAR	6	0	Treatment Category	TN24
72	CLASS	☐	ISH_PAYCL	ISH_PAYCL	CHAR	4	0	IS-H: Patient Class	TNP01
73	REF_PSTTRT_TYPE	☐	ISH_REFSRC	ISH_REFSRC	CHAR	2	0	IS-H: Referral, Postdischarge Treatment Type	TN14H
74	ARRIVAL_MODE	☐	ISH_ARRIVE	ISH_ARRIVE	CHAR	2	0	IS-H: Mode of Arrival	TN14K
75	WAITLIST_PRIO	☐	WLPRI	WLPRI	CHAR	2	0	IS-H: Priority for Preregistration/Waiting List Management	TN14P
76	WAITLIST_TYPE	☐	ISH_WLTYPE	CHAR6	CHAR	6	0	IS-H: Waiting List	TN42A
77	WAITLIST_STATUS	☐	ISH_WLSTATUS	CHAR2	CHAR	2	0	IS-H: Preregistration/Waiting List Status	TN42C
78	WAITLIST_HOSP	☐	ISH_WLHOSP	RI_KUNNR	CHAR	10	0	IS-H: Waiting List Postdischarge Hospital	NGPA
79	WAITLIST_INCLON	☐	ISH_WLADAT	DATUM	DATS	8	0	IS-H: Date when Patient Added to Waiting List
80	WAITLIST_DELDAT	☐	ISH_WLRDAT	DATUM	DATS	8	0	IS-H: Date when Movement Removed From Waiting List
81	WAITLIST_DELREAS	☐	ISH_WLRRSN	CHAR3	CHAR	3	0	IS-H: Reason for Removal from Waiting List	TN42B
82	CREATION_DATE	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
83	CREATION_USER	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
84	DOC_TYPE	☐	ISH_PASSTY	ISH_PASSTY	CHAR	2	0	Type of Identification Document	TN17D
85	DOC_TYPEX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
86	DOC_NO	☐	ISH_PASSNR	ISH_PASSNR	CHAR	15	0	IS-H: Identification Document Number
87	DOC_NOX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
88	CHOICE_CL	☐	ISH_WKAT	ISH_WKAT	CHAR	1	0	IS-H: Choice of Ward Class	*
89	CHOICE_CLX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
90	PAT_WEIGHT	☐	ISH_PATGEW	ISH_GEWICH	QUAN	7	3	IS-H: Weight of Patient at Admission
91	PAT_WEIGHTX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
92	WEIGHT_UNIT	☐	ISH_EINGEW	MEINS	UNIT	3	0	IS-H: Unit of Measurement for Patient Weight	*
93	WEIGHT_UNIT_ISO	☐	ISH_EINGEW_ISO	ISOCD_UNIT	CHAR	3	0	IS-H: ISO Unit of Measurement for Patient Weight	*
94	WEIGHT_UNITX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
95	PAT_HEIGHT	☐	ISH_PATGRO	ISH_GROESS	QUAN	5	2	IS-H: Height of Patient at Admission
96	PAT_HEIGHTX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
97	HEIGHT_UNIT	☐	ISH_EINGRO	MEINS	UNIT	3	0	IS-H: Unit of Measurement for Patient Size	*
98	HEIGHT_UNIT_ISO	☐	ISH_EINGRO_ISO	ISOCD_UNIT	CHAR	3	0	IS-H: ISO Unit of Measurement for Patient Height (Size)	*
99	HEIGHT_UNITX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
100	DOC_REF_FL	☐	ISH_DOCWKZ	XFELD	CHAR	1	0	IS-H: Named Referral Indicator
101	DOC_REF_FLX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
102	PAT_REF_FL	☐	ISH_PATWKZ	XFELD	CHAR	1	0	IS-H: Patient Requested Referral Indicator
103	PAT_REF_FLX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
104	TREAT_CODE	☐	ISH_BCODE	ISH_BCODE	CHAR	1	0	IS-H: Treatment Program	TN14M
105	CREATION_TIME	☐	RI_ERTIM	UHRZT	TIMS	6	0	IS-H: Time Record Created
106	RESPIRATION	☐	ISH_RESPIRATION	NUM5	NUMC	5	0	IS-H: Duration of Mechanical Ventilation in Hours
107	RESPIRATIONX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
108	EXT_CASE_ID	☐	ISH_EXTNR_FAL	ISH_EXTNR_FAL	CHAR	20	0	IS-H: External Case Identification
109	EXT_CASE_IDX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
110	EXT_MOVEMENT_ID	☐	ISH_EXTNR_BEW	ISH_EXTNR_BEW	CHAR	20	0	IS-H: External Movement Identification
111	REF_PHYS2	☐	UARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Referring Physician	*
112	FAM_PHYS	☐	HARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Family Physician	*
113	ATT_PHYS	☐	BARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Attending Physician	*
114	OP_PHYS	☐	OARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Operating Surgeon	*
115	ANAE_PHYS	☐	ISH_AARNR	RI_KUNNR	CHAR	10	0	IS-H: Pesonnel Number of Anesthetist	*
116	REF_PHYS_BSNR	☐	ISH_BSNR_EDOC	ISH_BSNR	CHAR	9	0	Betriebsstättennummer des ein-/überweisenden Arztes
117	REF_PHYS_LANR	☐	ISH_LANR_EDOC	ISH_LANR	CHAR	9	0	Lebenslange Arztnummer des ein-/überweisenden Arztes
118	ATT_PHYS_LANR	☐	ISH_LANR_BA	ISH_LANR	CHAR	9	0	Lebenslange Arztnummer des behandelnden Arztes
119	REF_HOSPITAL_NAME2	☐	ISH_EXTHOSP_NAME2_EHP_5	NAME	CHAR	35	0	This Field Is Not Supported Until IS-H 6.05 (EHP5)
120	REF_HOSPITAL_NAME3	☐	ISH_EXTHOSP_NAME3_EHP_5	NAME	CHAR	35	0	This Field Is Not Supported Until IS-H 6.05 (EHP5)
121	MENTAL_HEALTH_LEGAL_STATUS	☐	ISH_MHLS	ISH_MHLS	CHAR	1	0	Mental Health Legal Status
122	MENTAL_HEALTH_LEGAL_STATUSX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field
123	POST_DIS_PHYS	☐	NARNR	RI_KUNNR	CHAR	10	0	IS-H: Number of Postdischarge Physician	*
124	P115_SFA_PHYS	☐	ISH_P115B_VA	RI_KUNNR	CHAR	10	0	Personalnummer kooperierender Vertragsarzt (§115b SGB V)	*
125	P115_SFA_PHYS_LANR	☐	ISH_LANR_P115B	ISH_LANR	CHAR	9	0	Lebenslange Arztnummer eines §115b SGB V Arztes
126	P115_SFA_PHYS_2	☐	ISH_P115B_VA_2	RI_KUNNR	CHAR	10	0	Personalnummer 2. kooperierender Vertragsarzt (§115b SGB V)	*
127	P115_SFA_PHYS_2_LANR	☐	ISH_LANR_P115B	ISH_LANR	CHAR	9	0	Lebenslange Arztnummer eines §115b SGB V Arztes
128	P115_EXT_PHYS	☐	ISH_P115B_BA	RI_KUNNR	CHAR	10	0	Personalnummer Belegarzt (§115b SGB V)	*
129	P115_EXT_PHYS_LANR	☐	ISH_LANR_P115B	ISH_LANR	CHAR	9	0	Lebenslange Arztnummer eines §115b SGB V Arztes
130	P115_EXT_PHYS_2	☐	ISH_P115B_BA_2	RI_KUNNR	CHAR	10	0	Personalnummer 2. Belegarzt (§115b SGB V)	*
131	P115_EXT_PHYS_2_LANR	☐	ISH_LANR_P115B	ISH_LANR	CHAR	9	0	Lebenslange Arztnummer eines §115b SGB V Arztes
132	PIR_CONSENT	☐	ISH_CONSENT	XFELD	CHAR	1	0	PKV P301: Einwilligung zur elektronischen Datenübertragung
133	PIR_CONSENTX	☐	BAPIUPDATE	BAPIUPDATE	CHAR	1	0	Updated information in related user data field

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	BAPI2097OVIN	ACCIDENT	TN14C	UNFAR	KEY	1	CN
2	BAPI2097OVIN	ACCIDENT_EMSTYP	TN14I	RESCTY	KEY	1	CN
3	BAPI2097OVIN	ADMITT_DEPT	NORG	ORGID	REF	1	CN
4	BAPI2097OVIN	APPLSTATUS	TNC301SA	APSTATE	KEY	1	CN
5	BAPI2097OVIN	ARRIVAL_MODE	TN14K	ARRIVE	KEY	1	CN
6	BAPI2097OVIN	BED	NBAU	BAUID		1	CN
7	BAPI2097OVIN	CANTON_CONVTN	TNCH13	AGREEMENT	KEY	1	CN
8	BAPI2097OVIN	CANTON_TARIFF	TNCH12	TARCDE	KEY	1	CN
9	BAPI2097OVIN	CASEENDTYPE	TN15D	ENDTYP	KEY	1	CN
10	BAPI2097OVIN	CASE_CATEGORY	TN15C	CASETY	KEY	1	CN
11	BAPI2097OVIN	CLASS	TNP01	CLASS	REF	1	CN
12	BAPI2097OVIN	DEPARTMENT	NORG	ORGID	REF	1	CN
13	BAPI2097OVIN	DOC_TYPE	TN17D	PASSTY	REF	1	CN
14	BAPI2097OVIN	EMPLOYEE_TYPE	TN15G	EMTYP	KEY	1	CN
15	BAPI2097OVIN	EXT_VISIT_STAT	TN14E	STATUS_EX	REF	1	CN
16	BAPI2097OVIN	MOVEMNT_REAS1	TN14G	GRUND	KEY	1	CN
17	BAPI2097OVIN	MOVEMNT_REAS2	TN14G	GRUND	KEY	1	CN
18	BAPI2097OVIN	MOVEMNT_TYPE	TN14B	BWART	KEY	1	CN
19	BAPI2097OVIN	NURS_TREAT_OU	NORG	ORGID	REF	1	CN
20	BAPI2097OVIN	REC_ORDER	AUFK	AUFNR	KEY	1	CN
21	BAPI2097OVIN	REF_HOSPITAL	NGPA	GPART	KEY	1	CN
22	BAPI2097OVIN	REF_PSTTRT_TYPE	TN14H	REFSRC	KEY	1	CN
23	BAPI2097OVIN	ROOM	NBAU	BAUID	KEY	1	CN
24	BAPI2097OVIN	SPECIALTY_VISIT	TNKFA	FACHR	KEY	1	CN
25	BAPI2097OVIN	TREATMCATEGORY	TN24	BEKAT	KEY	1	CN
26	BAPI2097OVIN	TREAT_CODE	TN14M	BCODE	REF	1	CN
27	BAPI2097OVIN	WAITLIST_DELREAS	TN42B	WLRRN	REF	1	CN
28	BAPI2097OVIN	WAITLIST_HOSP	NGPA	GPART	KEY	1	CN
29	BAPI2097OVIN	WAITLIST_PRIO	TN14P	WLPRI	KEY	1	CN
30	BAPI2097OVIN	WAITLIST_STATUS	TN42C	WLSTA	REF	1	CN
31	BAPI2097OVIN	WAITLIST_TYPE	TN42A	WLTYP	REF	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in	472