SAP ABAP View N_VBEWFAL3 (LAZR: View uber NBEW, NFAL und NPAT)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NNL1 (Package) Application development Hospital System Netherlands

Basic Data

View Type	D	Database View
Database View	N_VBEWFAL3
Short Description	LAZR: View uber NBEW, NFAL und NPAT
Root table	NBEW	IS-H: Movements for Case

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	NBEW	NBEW
2	NFAL
3	NPAT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	NFAL	MANDT	JL	EQ				0	0
2	NBEW	MANDT	JR	EQ			AND	0	0
3	NFAL	EINRI	JL	EQ				0	0
4	NBEW	EINRI	JR	EQ			AND	0	0
5	NFAL	FALNR	JL	EQ				0	0
6	NBEW	FALNR	JR	EQ			AND	0	0
7	NPAT	MANDT	JL	EQ				0	0
8	NFAL	MANDT	JR	EQ			AND	0	0
9	NPAT	PATNR	JL	EQ				0	0
10	NFAL	PATNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	NBEW	MANDT		☐	MANDT	☐	Client
2	EINRI	NBEW	EINRI		☐	EINRI	☐	IS-H: Institution
3	FALNR	NBEW	FALNR		☐	FALNR	☐	IS-H: Case Number
4	LFDNR	NBEW	LFDNR		☐	LFDBEW	☐	IS-H: Sequence Number of Movement
5	BEWTY	NBEW	BEWTY		☐	BEWTY	☐	IS-H: Movement Category
6	BWART	NBEW	BWART		☐	RI_BWART	☐	IS-H: Movement Type
7	BWIDT	NBEW	BWIDT		☐	BWIDT	☐	IS-H: Date of Movement
8	BWIZT	NBEW	BWIZT		☐	BWIZT	☐	IS-H: Time of Movement
9	PLANB	NBEW	PLANB		☐	PLANB	☐	IS-H: Planned Indicator for Date of Movement
10	BWPDT	NBEW	BWPDT		☐	BWPDT	☐	IS-H: Planned Date of Movement
11	BWPZT	NBEW	BWPZT		☐	BWPZT	☐	IS-H: Planned Time of Movement
12	BWEDT	NBEW	BWEDT		☐	BWEDT	☐	IS-H: Movement End Date, Start Date of Subsequent Movement
13	BWEZT	NBEW	BWEZT		☐	BWEZT	☐	IS-H: Movement End Time, Start Time of Subsequent Movement
14	PLANE	NBEW	PLANE		☐	PLANE	☐	IS-H: Planned Indicator for End Date of Movement
15	LFDREF	NBEW	LFDREF		☐	LFDREF	☐	IS-H: Sequence Number of Subsequent Movement
16	ORGFA	NBEW	ORGFA		☐	NZUWFA	☐	IS-H: OU with Departmental Responsibility for Case
17	ORGPF	NBEW	ORGPF		☐	NZUWPF	☐	Organizational Unit Assigned to Case
18	ZIMMR	NBEW	ZIMMR		☐	ISH_ZIMMID	☐	IS-H: Building ID of Room
19	BETT	NBEW	BETT		☐	BETTID	☐	IS-H: Building ID of Bed Location
20	PATNR	NFAL	PATNR		☐	PATNR	☐	IS-H: Patient Number
21	DGNLF	NFAL	DGNLF		☐	LLFDDIA	☐	IS-H: Obsolete
22	INFKZ	NFAL	INFKZ		☐	INFKZ	☐	IS-H: Infectious Disease Indicator
23	FZIFF	NFAL	FZIFF		☐	PZIFF_FALL	☐	IS-H: Check Digit for Case
24	GSCHL	NPAT	GSCHL		☐	GSCHL	☐	IS-H: Sex Indicator - Internal
25	NNAME	NPAT	NNAME		☐	NNAME_PAT	☐	IS-H: Patient Last Name
26	VNAME	NPAT	VNAME		☐	VNAME_PAT	☐	IS-H: Patient First Name
27	NNAMS	NPAT	NNAMS		☐	NNAMES_PAT	☐	IS-H: Standardized Last Name
28	VNAMS	NPAT	VNAMS		☐	VNAMES_PAT	☐	Standardized First Name
29	GBDAT	NPAT	GBDAT		☐	RI_GBDAT	☐	IS-H: Birthdate
30	VORSW	NPAT	VORSW		☐	RI_VORSW	☐	IS-H: Name Prefix
31	TITEL	NPAT	TITEL		☐	RI_TITEL	☐	IS-H: Title
32	PZIFF	NPAT	PZIFF		☐	PZIFF_PAT	☐	IS-H: Check Digit for Patient
33	FALAR	NFAL	FALAR		☐	FALLART	☐	IS-H: Case Type
34	STORN	NBEW	STORN		☐	RI_STORN	☐	IS-H: Cancellation Indicator
35	PLANR	NBEW	PLANR		☐	ISH_PLANR	☐	IS-H: Planned Indicator for Room Assignment
36	EXTKH	NBEW	EXTKH		☐	EXTKH	☐	IS-H: Identification of an External Hospital
37	ORGAU	NBEW	ORGAU		☐	ORGAU	☐	IS-H: Org. ID of Admitting Facility
38	NOTAN	NFAL	NOTAN		☐	NOTAUF	☐	IS-H: Emergency Admission Indicator
39	KRZAN	NFAL	KRZAN		☐	KURZAUF	☐	IS-H: Quick Admission Indicator
40	DAUER	NBEW	DAUER		☐	ISH_DAUER	☐	IS-H: Estimated Length of Stay or Treatment
41	NAMZU	NPAT	NAMZU		☐	RI_NAMZU	☐	IS-H: Name Affix
42	ANRED	NPAT	ANRED		☐	RI_ANRDS	☐	IS-H: Form-of-Address Key
43	RISKF	NPAT	RISKF		☐	ISH_RISIKO	☐	IS-H: Risk Information Exists for the Patient
44	BEKAT	NBEW	BEKAT		☐	BEKAT	☐	Treatment Category
45	DSPTY	NBEW	DSPTY		☐	ISH_DSPT	☐	IS-H: Scheduling Type for Visit Scheduling
46	VISTY	NBEW	VISTY		☐	ISH_BT	☐	IS-H: Code of Visit Category for Visit Scheduling
47	TELNR	NBEW	TELNR		☐	TELF_INT	☐	IS-H: Telephone Number of Patient in Institution
48	TVKZ	NBEW	TVKZ		☐	TVKZ	☐	IS-H: TV Indicator
49	LAND	NPAT	LAND		☐	LAND_PAT	☐	IS-H: Country of patient's place of residence
50	PSTLZ	NPAT	PSTLZ		☐	PSTLZ_PAT	☐	IS-H: Patient Postal Code
51	EXTNR	NPAT	EXTNR		☐	EXT_PATNR	☐	IS-H: External Patient Identification
52	AGNUM	NPAT	AGNUM		☐	AGNUM_PAT	☐	IS-H: Patient's Employer
53	HARNR	NPAT	HARNR		☐	HARNR	☐	IS-H: Personnel Number of Family Physician
54	STATU	NBEW	STATU		☐	ISH_ABSTIN	☐	IS-H: Internal Status of Outpatient Visit

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

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