SAP ABAP Table N_VBEWFAL3 (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	N_VBEWFAL3	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	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
25	NNAME	☐	NNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient Last Name
26	VNAME	☐	VNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient First Name
27	NNAMS	☐	NNAMES_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Last Name
28	VNAMS	☐	VNAMES_PAT	CHAR30	CHAR	30	0	Standardized First Name
29	GBDAT	☐	RI_GBDAT	RI_DATUM	DATS	8	0	IS-H: Birthdate
30	VORSW	☐	RI_VORSW	TITEL	CHAR	15	0	IS-H: Name Prefix
31	TITEL	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title
32	PZIFF	☐	PZIFF_PAT	PZIFF	CHAR	1	0	IS-H: Check Digit for Patient
33	FALAR	☐	FALLART	FALLART	CHAR	1	0	IS-H: Case Type
34	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
35	PLANR	☐	ISH_PLANR	ISH_PLAN	CHAR	1	0	IS-H: Planned Indicator for Room Assignment
36	EXTKH	☐	EXTKH	RI_KUNNR	CHAR	10	0	IS-H: Identification of an External Hospital	NGPA
37	ORGAU	☐	ORGAU	ORGID	CHAR	8	0	IS-H: Org. ID of Admitting Facility	NORG
38	NOTAN	☐	NOTAUF	XFELD	CHAR	1	0	IS-H: Emergency Admission Indicator
39	KRZAN	☐	KURZAUF	XFELD	CHAR	1	0	IS-H: Quick Admission Indicator
40	DAUER	☐	ISH_DAUER	NUMC5	NUMC	5	0	IS-H: Estimated Length of Stay or Treatment
41	NAMZU	☐	RI_NAMZU	TITEL	CHAR	15	0	IS-H: Name Affix
42	ANRED	☐	RI_ANRDS	RI_ANRDS	CHAR	2	0	IS-H: Form-of-Address Key
43	RISKF	☐	ISH_RISIKO	XFELD	CHAR	1	0	IS-H: Risk Information Exists for the Patient
44	BEKAT	☐	BEKAT	BEHKATEG	CHAR	6	0	Treatment Category	TN24
45	DSPTY	☐	ISH_DSPT	ISH_DSPTC8	CHAR	8	0	IS-H: Scheduling Type for Visit Scheduling	TN40B
46	VISTY	☐	ISH_BT	ISH_BT	CHAR	1	0	IS-H: Code of Visit Category for Visit Scheduling
47	TELNR	☐	TELF_INT	TEXT16	CHAR	16	0	IS-H: Telephone Number of Patient in Institution
48	TVKZ	☐	TVKZ	XFELD	CHAR	1	0	IS-H: TV Indicator
49	LAND	☐	LAND_PAT	LAND1	CHAR	3	0	IS-H: Country of patient's place of residence	T005
50	PSTLZ	☐	PSTLZ_PAT	PSTLZ	CHAR	10	0	IS-H: Patient Postal Code
51	EXTNR	☐	EXT_PATNR	EXT_PATNR	CHAR	20	0	IS-H: External Patient Identification
52	AGNUM	☐	AGNUM_PAT	RI_KUNNR	CHAR	10	0	IS-H: Patient's Employer	NGPA
53	HARNR	☐	HARNR	RI_KUNNR	CHAR	10	0	IS-H: Personnel Number of Family Physician	NGPA
54	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_VBEWFAL3	AGNUM	NGPA	GPART	REF	1	CN
2	N_VBEWFAL3	BEKAT	TN24	BEKAT	REF	C	CN
3	N_VBEWFAL3	BETT	NBAU	BAUID	REF	1	CN
4	N_VBEWFAL3	BWART	TN14B	BWART	REF	1	CN
5	N_VBEWFAL3	DSPTY	TN40B	DISPO	REF	C	CN
6	N_VBEWFAL3	EINRI	TN01	EINRI	KEY	1	CN
7	N_VBEWFAL3	EXTKH	NGPA	GPART	REF	1	CN
8	N_VBEWFAL3	FALNR	NFAL	FALNR	KEY	1	N
9	N_VBEWFAL3	HARNR	NGPA	GPART	REF	1	CN
10	N_VBEWFAL3	LAND	T005	LAND1	REF	1	CN
11	N_VBEWFAL3	MANDT	T000	MANDT	KEY	1	CN
12	N_VBEWFAL3	ORGAU	NORG	ORGID	REF	1	CN
13	N_VBEWFAL3	ORGFA	NORG	ORGID	REF	1	CN
14	N_VBEWFAL3	ORGPF	NORG	ORGID	REF	1	CN
15	N_VBEWFAL3	PATNR	NPAT	PATNR	REF	1	CN
16	N_VBEWFAL3	ZIMMR	NBAU	BAUID	REF	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in