SAP ABAP Table N_VPVISIT (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	N_VPVISIT	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	EINRI	☑	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
3	FALNR	☑	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	NFAL
4	LFDNR	☑	LFDBEW	LFDBEW	NUMC	5	0	IS-H: Sequence Number of Movement
5	STORN_BW	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
6	BEWTY	☐	BEWTY	BEWTY	CHAR	1	0	IS-H: Movement Category
7	BWART	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type	TN14B
8	BWIDT	☐	BWIDT	RI_DATUM	DATS	8	0	IS-H: Date of Movement
9	BWIZT	☐	BWIZT	UHRZT	TIMS	6	0	IS-H: Time of Movement
10	PLANB	☐	PLANB	ISH_PLAN	CHAR	1	0	IS-H: Planned Indicator for Date of Movement
11	STATUS	☐	ISH_ABSTIN	ISH_ABSTIN	CHAR	2	0	IS-H: Internal Status of Outpatient Visit
12	BWPDT	☐	BWPDT	RI_DATUM	DATS	8	0	IS-H: Planned Date of Movement
13	BWPZT	☐	BWPZT	UHRZT	TIMS	6	0	IS-H: Planned Time of Movement
14	BWEDT	☐	BWEDT	RI_DATUM	DATS	8	0	IS-H: Movement End Date, Start Date of Subsequent Movement
15	BWEZT	☐	BWEZT	UHRZT	TIMS	6	0	IS-H: Movement End Time, Start Time of Subsequent Movement
16	PLANE	☐	PLANE	ISH_PLAN	CHAR	1	0	IS-H: Planned Indicator for End Date of Movement
17	VISTY	☐	ISH_BT	ISH_BT	CHAR	1	0	IS-H: Code of Visit Category for Visit Scheduling
18	DSPTY	☐	ISH_DSPT	ISH_DSPTC8	CHAR	8	0	IS-H: Scheduling Type for Visit Scheduling	TN40B
19	KZTXT	☐	TEXT_BEW	TEXT50	CHAR	50	0	Comment on Case Movement
20	LGTXT	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
21	NOTKZ	☐	RI_NOTKZ	XFELD	CHAR	1	0	IS-H: Emergency Case Indicator
22	ORGFA	☐	NZUWFA	ORGID	CHAR	8	0	IS-H: OU with Departmental Responsibility for Case	NORG
23	ORGPF	☐	NZUWPF	ORGID	CHAR	8	0	Organizational Unit Assigned to Case	NORG
24	ZIMMR	☐	ISH_ZIMMID	BAUID	CHAR	8	0	IS-H: Building ID of Room	NBAU
25	PLANR	☐	ISH_PLANR	ISH_PLAN	CHAR	1	0	IS-H: Planned Indicator for Room Assignment
26	ORGAU	☐	ORGAU	ORGID	CHAR	8	0	IS-H: Org. ID of Admitting Facility	NORG
27	FACHR	☐	FACHRTY5	ISH_FACHR	CHAR	4	0	IS-H: Physician Specialty	TNKFA
28	STOID	☐	N1BSTOID	N1STOID	CHAR	3	0	IS-H: Reason for Canceling Movement	N1STGR
29	CLASS	☐	ISH_PAYCL	ISH_PAYCL	CHAR	4	0	IS-H: Patient Class	TNP01
30	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
31	NNAME	☐	NNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient Last Name
32	VNAME	☐	VNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient First Name
33	NNAMS	☐	NNAMES_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Last Name
34	VNAMS	☐	VNAMES_PAT	CHAR30	CHAR	30	0	Standardized First Name
35	TITEL	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title
36	NAMZU	☐	RI_NAMZU	TITEL	CHAR	15	0	IS-H: Name Affix
37	VORSW	☐	RI_VORSW	TITEL	CHAR	15	0	IS-H: Name Prefix
38	GBDAT	☐	RI_GBDAT	RI_DATUM	DATS	8	0	IS-H: Birthdate
39	GBNAM	☐	GBNAM	TEXT30	CHAR	30	0	IS-H: Birthname
40	GBNAS	☐	GBNAMS_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Birthname
41	VIPKZ	☐	VIPKZ	XFELD	CHAR	1	0	IS-H: VIP Indicator
42	PZIFF	☐	PZIFF_PAT	PZIFF	CHAR	1	0	IS-H: Check Digit for Patient
43	TELF1	☐	TELF_PAT	TEXT16	CHAR	16	0	IS-H: Patient Telephone Number
44	EXTNR	☐	EXT_PATNR	EXT_PATNR	CHAR	20	0	IS-H: External Patient Identification
45	TODKZ	☐	PAT_TOD	XFELD	CHAR	1	0	IS-H: Patient Is Deceased
46	RISKF	☐	ISH_RISIKO	XFELD	CHAR	1	0	IS-H: Risk Information Exists for the Patient
47	FALAR	☐	FALLART	FALLART	CHAR	1	0	IS-H: Case Type
48	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number	NPAT
49	STATU	☐	FALLSTATUS	FALLSTATUS	CHAR	1	0	IS-H: Case Status
50	FZIFF	☐	PZIFF_FALL	PZIFF	CHAR	1	0	IS-H: Check Digit for Case
51	KV_KZ	☐	ISH_KV_KZ	XFELD	CHAR	1	0	IS-H: Relevant for Panel Physician Association Billing
52	NOTAN	☐	NOTAUF	XFELD	CHAR	1	0	IS-H: Emergency Admission Indicator
53	KRZAN	☐	KURZAUF	XFELD	CHAR	1	0	IS-H: Quick Admission Indicator
54	BEKAT	☐	BEKAT	BEHKATEG	CHAR	6	0	Treatment Category	TN24
55	BWGR1	☐	ISH_BWGR1	ISH_BGRUND	CHAR	2	0	Movement Reason - 1st and 2nd Positions	TN14G
56	BWGR2	☐	ISH_BWGR2	ISH_BGRUND	CHAR	2	0	Movement Reason - 3rd and 4th Positions	TN14G

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N_VPVISIT	BEKAT	TN24	BEKAT	REF	C	CN
2	N_VPVISIT	BWART	TN14B	BWART	REF	1	CN
3	N_VPVISIT	BWGR1	TN14G	GRUND	REF	1	CN
4	N_VPVISIT	BWGR2	TN14G	GRUND	REF	1	CN
5	N_VPVISIT	CLASS	TNP01	CLASS	REF	1	CN
6	N_VPVISIT	DSPTY	TN40B	DISPO	REF	C	CN
7	N_VPVISIT	EINRI	TN01	EINRI	KEY	1	CN
8	N_VPVISIT	FACHR	TNKFA	FACHR	REF	1	CN
9	N_VPVISIT	FALNR	NFAL	FALNR	KEY	1	N
10	N_VPVISIT	MANDT	T000	MANDT	KEY	1	CN
11	N_VPVISIT	ORGAU	NORG	ORGID	REF	1	CN
12	N_VPVISIT	ORGFA	NORG	ORGID	REF	1	CN
13	N_VPVISIT	ORGPF	NORG	ORGID	REF	1	CN
14	N_VPVISIT	PATNR	NPAT	PATNR	REF	1	CN
15	N_VPVISIT	STOID	N1STGR	STOID	REF	C	CN
16	N_VPVISIT	ZIMMR	NBAU	BAUID	REF	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in