SAP ABAP Table N_VBEWFAL (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	N_VBEWFAL	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	BEWTY	☐	BEWTY	BEWTY	CHAR	1	0	IS-H: Movement Category
6	BWART	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type	TN14B
7	BWIDT	☐	BWIDT	RI_DATUM	DATS	8	0	IS-H: Date of Movement
8	BWIZT	☐	BWIZT	UHRZT	TIMS	6	0	IS-H: Time of Movement
9	PLANB	☐	PLANB	ISH_PLAN	CHAR	1	0	IS-H: Planned Indicator for Date of Movement
10	BWPDT	☐	BWPDT	RI_DATUM	DATS	8	0	IS-H: Planned Date of Movement
11	BWPZT	☐	BWPZT	UHRZT	TIMS	6	0	IS-H: Planned Time of Movement
12	BWEDT	☐	BWEDT	RI_DATUM	DATS	8	0	IS-H: Movement End Date, Start Date of Subsequent Movement
13	BWEZT	☐	BWEZT	UHRZT	TIMS	6	0	IS-H: Movement End Time, Start Time of Subsequent Movement
14	PLANE	☐	PLANE	ISH_PLAN	CHAR	1	0	IS-H: Planned Indicator for End Date of Movement
15	LFDREF	☐	LFDREF	LFDBEW	NUMC	5	0	IS-H: Sequence Number of Subsequent Movement
16	ORGFA	☐	NZUWFA	ORGID	CHAR	8	0	IS-H: OU with Departmental Responsibility for Case	NORG
17	ORGPF	☐	NZUWPF	ORGID	CHAR	8	0	Organizational Unit Assigned to Case	NORG
18	ZIMMR	☐	ISH_ZIMMID	BAUID	CHAR	8	0	IS-H: Building ID of Room	NBAU
19	BETT	☐	BETTID	BAUID	CHAR	8	0	IS-H: Building ID of Bed Location	NBAU
20	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number	NPAT
21	DGNLF	☐	LLFDDIA	LFDDIA	NUMC	3	0	IS-H: Obsolete
22	INFKZ	☐	INFKZ	XFELD	CHAR	1	0	IS-H: Infectious Disease Indicator
23	FZIFF	☐	PZIFF_FALL	PZIFF	CHAR	1	0	IS-H: Check Digit for Case
24	ENDDT	☐	ENDDT_FAL	RI_DATUM	DATS	8	0	IS-H: End Date of Case
25	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
26	NNAME	☐	NNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient Last Name
27	VNAME	☐	VNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient First Name
28	NNAMS	☐	NNAMES_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Last Name
29	VNAMS	☐	VNAMES_PAT	CHAR30	CHAR	30	0	Standardized First Name
30	GBNAM	☐	GBNAM	TEXT30	CHAR	30	0	IS-H: Birthname
31	GBNAS	☐	GBNAMS_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Birthname
32	GBDAT	☐	RI_GBDAT	RI_DATUM	DATS	8	0	IS-H: Birthdate
33	VORSW	☐	RI_VORSW	TITEL	CHAR	15	0	IS-H: Name Prefix
34	TITEL	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title
35	VIPKZ	☐	VIPKZ	XFELD	CHAR	1	0	IS-H: VIP Indicator
36	PZIFF	☐	PZIFF_PAT	PZIFF	CHAR	1	0	IS-H: Check Digit for Patient
37	EXTNR	☐	EXT_PATNR	EXT_PATNR	CHAR	20	0	IS-H: External Patient Identification
38	FALAR	☐	FALLART	FALLART	CHAR	1	0	IS-H: Case Type
39	FATYP	☐	ISH_CASETYPE	ISH_CASETYPE	CHAR	2	0	Case Category	TN15C
40	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
41	PLANR	☐	ISH_PLANR	ISH_PLAN	CHAR	1	0	IS-H: Planned Indicator for Room Assignment
42	EXTKH	☐	EXTKH	RI_KUNNR	CHAR	10	0	IS-H: Identification of an External Hospital	NGPA
43	ORGAU	☐	ORGAU	ORGID	CHAR	8	0	IS-H: Org. ID of Admitting Facility	NORG
44	NOTAN	☐	NOTAUF	XFELD	CHAR	1	0	IS-H: Emergency Admission Indicator
45	KRZAN	☐	KURZAUF	XFELD	CHAR	1	0	IS-H: Quick Admission Indicator
46	DAUER	☐	ISH_DAUER	NUMC5	NUMC	5	0	IS-H: Estimated Length of Stay or Treatment
47	NAMZU	☐	RI_NAMZU	TITEL	CHAR	15	0	IS-H: Name Affix
48	ANRED	☐	RI_ANRDS	RI_ANRDS	CHAR	2	0	IS-H: Form-of-Address Key
49	RISKF	☐	ISH_RISIKO	XFELD	CHAR	1	0	IS-H: Risk Information Exists for the Patient
50	RVNUM	☐	ISH_RVNUM	ISH_SVNUM	CHAR	20	0	IS-H: Social Insurance Number
51	BEKAT	☐	BEKAT	BEHKATEG	CHAR	6	0	Treatment Category	TN24
52	CLASS	☐	ISH_PAYCL	ISH_PAYCL	CHAR	4	0	IS-H: Patient Class	TNP01
53	DSPTY	☐	ISH_DSPT	ISH_DSPTC8	CHAR	8	0	IS-H: Scheduling Type for Visit Scheduling	TN40B
54	VISTY	☐	ISH_BT	ISH_BT	CHAR	1	0	IS-H: Code of Visit Category for Visit Scheduling
55	TELNR	☐	TELF_INT	TEXT16	CHAR	16	0	IS-H: Telephone Number of Patient in Institution
56	TVKZ	☐	TVKZ	XFELD	CHAR	1	0	IS-H: TV Indicator
57	KZTXT	☐	TEXT_BEW	TEXT50	CHAR	50	0	Comment on Case Movement
58	KZLGT	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
59	FACHR5	☐	FACHRTY5	ISH_FACHR	CHAR	4	0	IS-H: Physician Specialty	TNKFA
60	FACHR7	☐	FACHRTY7	ISH_FACHR	CHAR	4	0	IS-H: Specialty for Organizational Unit	TNKFA
61	FACHS	☐	ISH_PLANCHARAC	ISH_PLANCHARAC	CHAR	8	0	IS-H: Occupancy Characteristic	TNPC1
62	BWGR1	☐	ISH_BWGR1	ISH_BGRUND	CHAR	2	0	Movement Reason - 1st and 2nd Positions	TN14G
63	BWGR2	☐	ISH_BWGR2	ISH_BGRUND	CHAR	2	0	Movement Reason - 3rd and 4th Positions	TN14G
64	STATU	☐	ISH_ABSTIN	ISH_ABSTIN	CHAR	2	0	IS-H: Internal Status of Outpatient Visit

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N_VBEWFAL	BEKAT	TN24	BEKAT	REF	C	CN
2	N_VBEWFAL	BETT	NBAU	BAUID	REF	1	CN
3	N_VBEWFAL	BWART	TN14B	BWART	REF	1	CN
4	N_VBEWFAL	BWGR1	TN14G	GRUND	REF	1	CN
5	N_VBEWFAL	BWGR2	TN14G	GRUND	REF	1	CN
6	N_VBEWFAL	CLASS	TNP01	CLASS	REF	1	CN
7	N_VBEWFAL	DSPTY	TN40B	DISPO	REF	C	CN
8	N_VBEWFAL	EINRI	TN01	EINRI	KEY	1	CN
9	N_VBEWFAL	EXTKH	NGPA	GPART	REF	1	CN
10	N_VBEWFAL	FACHR5	TNKFA	FACHR	REF	1	CN
11	N_VBEWFAL	FACHR7	TNKFA	FACHR	REF	1	CN
12	N_VBEWFAL	FACHS	TNPC1	PCHAR	KEY	1	CN
13	N_VBEWFAL	FALNR	NFAL	FALNR	KEY	1	N
14	N_VBEWFAL	FATYP	TN15C	CASETY	KEY	1	CN
15	N_VBEWFAL	MANDT	T000	MANDT	KEY	1	CN
16	N_VBEWFAL	ORGAU	NORG	ORGID	REF	1	CN
17	N_VBEWFAL	ORGFA	NORG	ORGID	REF	1	CN
18	N_VBEWFAL	ORGPF	NORG	ORGID	REF	1	CN
19	N_VBEWFAL	PATNR	NPAT	PATNR	REF	1	CN
20	N_VBEWFAL	ZIMMR	NBAU	BAUID	REF	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in