SAP ABAP View N_VBEWFAL (IS-H: View of NBEW, NFAL, NPAT for room and bed listing)

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

View Type	D	Database View
Database View	N_VBEWFAL
Short Description	IS-H: View of NBEW, NFAL, NPAT for room and bed listing
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	ENDDT	NFAL	ENDDT		☐	ENDDT_FAL	☐	IS-H: End Date of Case
25	GSCHL	NPAT	GSCHL		☐	GSCHL	☐	IS-H: Sex Indicator - Internal
26	NNAME	NPAT	NNAME		☐	NNAME_PAT	☐	IS-H: Patient Last Name
27	VNAME	NPAT	VNAME		☐	VNAME_PAT	☐	IS-H: Patient First Name
28	NNAMS	NPAT	NNAMS		☐	NNAMES_PAT	☐	IS-H: Standardized Last Name
29	VNAMS	NPAT	VNAMS		☐	VNAMES_PAT	☐	Standardized First Name
30	GBNAM	NPAT	GBNAM		☐	GBNAM	☐	IS-H: Birthname
31	GBNAS	NPAT	GBNAS		☐	GBNAMS_PAT	☐	IS-H: Standardized Birthname
32	GBDAT	NPAT	GBDAT		☐	RI_GBDAT	☐	IS-H: Birthdate
33	VORSW	NPAT	VORSW		☐	RI_VORSW	☐	IS-H: Name Prefix
34	TITEL	NPAT	TITEL		☐	RI_TITEL	☐	IS-H: Title
35	VIPKZ	NPAT	VIPKZ		☐	VIPKZ	☐	IS-H: VIP Indicator
36	PZIFF	NPAT	PZIFF		☐	PZIFF_PAT	☐	IS-H: Check Digit for Patient
37	EXTNR	NPAT	EXTNR		☐	EXT_PATNR	☐	IS-H: External Patient Identification
38	FALAR	NFAL	FALAR		☐	FALLART	☐	IS-H: Case Type
39	FATYP	NFAL	FATYP		☐	ISH_CASETYPE	☐	Case Category
40	STORN	NBEW	STORN		☐	RI_STORN	☐	IS-H: Cancellation Indicator
41	PLANR	NBEW	PLANR		☐	ISH_PLANR	☐	IS-H: Planned Indicator for Room Assignment
42	EXTKH	NBEW	EXTKH		☐	EXTKH	☐	IS-H: Identification of an External Hospital
43	ORGAU	NBEW	ORGAU		☐	ORGAU	☐	IS-H: Org. ID of Admitting Facility
44	NOTAN	NFAL	NOTAN		☐	NOTAUF	☐	IS-H: Emergency Admission Indicator
45	KRZAN	NFAL	KRZAN		☐	KURZAUF	☐	IS-H: Quick Admission Indicator
46	DAUER	NBEW	DAUER		☐	ISH_DAUER	☐	IS-H: Estimated Length of Stay or Treatment
47	NAMZU	NPAT	NAMZU		☐	RI_NAMZU	☐	IS-H: Name Affix
48	ANRED	NPAT	ANRED		☐	RI_ANRDS	☐	IS-H: Form-of-Address Key
49	RISKF	NPAT	RISKF		☐	ISH_RISIKO	☐	IS-H: Risk Information Exists for the Patient
50	RVNUM	NPAT	RVNUM		☐	ISH_RVNUM	☐	IS-H: Social Insurance Number
51	BEKAT	NBEW	BEKAT		☐	BEKAT	☐	Treatment Category
52	CLASS	NBEW	CLASS		☐	ISH_PAYCL	☐	IS-H: Patient Class
53	DSPTY	NBEW	DSPTY		☐	ISH_DSPT	☐	IS-H: Scheduling Type for Visit Scheduling
54	VISTY	NBEW	VISTY		☐	ISH_BT	☐	IS-H: Code of Visit Category for Visit Scheduling
55	TELNR	NBEW	TELNR		☐	TELF_INT	☐	IS-H: Telephone Number of Patient in Institution
56	TVKZ	NBEW	TVKZ		☐	TVKZ	☐	IS-H: TV Indicator
57	KZTXT	NBEW	KZTXT		☐	TEXT_BEW	☐	Comment on Case Movement
58	KZLGT	NBEW	LGTXT		☐	RI_LGTXT	☐	Indicator that Long Text Exists
59	FACHR5	NBEW	FACHR		☐	FACHRTY5	☐	IS-H: Physician Specialty
60	FACHR7	NFAL	FACHR		☐	FACHRTY7	☐	IS-H: Specialty for Organizational Unit
61	FACHS	NBEW	FACHS		☐	ISH_PLANCHARAC	☐	IS-H: Occupancy Characteristic
62	BWGR1	NBEW	BWGR1		☐	ISH_BWGR1	☐	Movement Reason - 1st and 2nd Positions
63	BWGR2	NBEW	BWGR2		☐	ISH_BWGR2	☐	Movement Reason - 3rd and 4th Positions
64	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