SAP ABAP View N_FALL_BEW (IS-H: Case/patient/movement list (NBEW, NFAL, NPAT))

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_FALL_BEW
Short Description	IS-H: Case/patient/movement list (NBEW, NFAL, 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	BWEDT	NBEW	BWEDT		☐	BWEDT	☐	IS-H: Movement End Date, Start Date of Subsequent Movement
11	BWEZT	NBEW	BWEZT		☐	BWEZT	☐	IS-H: Movement End Time, Start Time of Subsequent Movement
12	PLANE	NBEW	PLANE		☐	PLANE	☐	IS-H: Planned Indicator for End Date of Movement
13	LFDREF	NBEW	LFDREF		☐	LFDREF	☐	IS-H: Sequence Number of Subsequent Movement
14	NOTKZ	NBEW	NOTKZ		☐	RI_NOTKZ	☐	IS-H: Emergency Case Indicator
15	WLPRI	NBEW	WLPRI		☐	WLPRI	☐	IS-H: Priority for Preregistration/Waiting List Management
16	AUFDS	NBEW	AUFDS		☐	AUFDT_LAST	☐	IS-H: Latest Admission Date
17	UNFKZ	NBEW	UNFKZ		☐	UNFART	☐	IS-H: Accident Type
18	ORGFA	NBEW	ORGFA		☐	NZUWFA	☐	IS-H: OU with Departmental Responsibility for Case
19	ORGPF	NBEW	ORGPF		☐	NZUWPF	☐	Organizational Unit Assigned to Case
20	ZIMMR	NBEW	ZIMMR		☐	ISH_ZIMMID	☐	IS-H: Building ID of Room
21	BETT	NBEW	BETT		☐	BETTID	☐	IS-H: Building ID of Bed Location
22	EXTKH	NBEW	EXTKH		☐	EXTKH	☐	IS-H: Identification of an External Hospital
23	EZUST	NBEW	EZUST		☐	EZUST	☐	Disposition of Patient at Time of Discharge
24	ABWGN	NBEW	ABWGN		☐	ISH_ABWGN	☐	IS-H: Indicator Whether Absence is Approved ('X')
25	TELF_INT	NBEW	TELNR		☐	TELF_INT	☐	IS-H: Telephone Number of Patient in Institution
26	KZTXT	NBEW	KZTXT		☐	TEXT_BEW	☐	Comment on Case Movement
27	LGTXT	NBEW	LGTXT		☐	RI_LGTXT	☐	Indicator that Long Text Exists
28	FALAR	NFAL	FALAR		☐	FALLART	☐	IS-H: Case Type
29	PATNR	NFAL	PATNR		☐	PATNR	☐	IS-H: Patient Number
30	FZIFF	NFAL	FZIFF		☐	PZIFF_FALL	☐	IS-H: Check Digit for Case
31	NOTANFALL	NFAL	NOTAN		☐	NOTAUF	☐	IS-H: Emergency Admission Indicator
32	KRZANFALL	NFAL	KRZAN		☐	KURZAUF	☐	IS-H: Quick Admission Indicator
33	GSCHL	NPAT	GSCHL		☐	GSCHL	☐	IS-H: Sex Indicator - Internal
34	NNAME	NPAT	NNAME		☐	NNAME_PAT	☐	IS-H: Patient Last Name
35	NNAMS	NPAT	NNAMS		☐	NNAMES_PAT	☐	IS-H: Standardized Last Name
36	VNAME	NPAT	VNAME		☐	VNAME_PAT	☐	IS-H: Patient First Name
37	VNAMS	NPAT	VNAMS		☐	VNAMES_PAT	☐	Standardized First Name
38	TITEL	NPAT	TITEL		☐	RI_TITEL	☐	IS-H: Title
39	VORSW	NPAT	VORSW		☐	RI_VORSW	☐	IS-H: Name Prefix
40	GBDAT	NPAT	GBDAT		☐	RI_GBDAT	☐	IS-H: Birthdate
41	GBNAM	NPAT	GBNAM		☐	GBNAM	☐	IS-H: Birthname
42	TODDT	NPAT	TODDT		☐	TODDV	☐	IS-H: Date of Death From
43	TODZT	NPAT	TODZT		☐	TODZV	☐	Time of Death From
44	TODDB	NPAT	TODDB		☐	TODDB	☐	Date of Death To
45	TODZB	NPAT	TODZB		☐	TODZB	☐	IS-H: Time of Death To
46	PSTLZ	NPAT	PSTLZ		☐	PSTLZ_PAT	☐	IS-H: Patient Postal Code
47	ORT	NPAT	ORT		☐	ORT01_PAT	☐	IS-H: City where Patient Resides
48	STRAS	NPAT	STRAS		☐	STRAS_PAT	☐	IS-H: Street and House Number of Patient
49	TODUR	NPAT	TODUR		☐	TODUR	☐	IS-H: Cause of Death
50	NOTANPAT	NPAT	NOTAN		☐	NOTAUF	☐	IS-H: Emergency Admission Indicator
51	KRZANPAT	NPAT	KRZAN		☐	KURZAUF	☐	IS-H: Quick Admission Indicator
52	PZIFF	NPAT	PZIFF		☐	PZIFF_PAT	☐	IS-H: Check Digit for Patient
53	LOEKZB	NBEW	STORN		☐	RI_STORN	☐	IS-H: Cancellation Indicator
54	LOEKZF	NFAL	STORN		☐	RI_STORN	☐	IS-H: Cancellation Indicator
55	LOEKZP	NPAT	STORN		☐	RI_STORN	☐	IS-H: Cancellation Indicator
56	ORGAU	NBEW	ORGAU		☐	ORGAU	☐	IS-H: Org. ID of Admitting Facility
57	VIPKZ	NPAT	VIPKZ		☐	VIPKZ	☐	IS-H: VIP Indicator
58	BEKAT	NBEW	BEKAT		☐	BEKAT	☐	Treatment Category
59	ADRNR	NPAT	ADRNR		☐	ISH_ADRNR	☐	IS-H: Address Number
60	ADROB	NPAT	ADROB		☐	ISH_ADROBJ	☐	IS-H: Address Object
61	INACT	NPAT	INACT		☐	ISH_INACTIVE	☐	'Inactive' Indicator
62	STATU	NBEW	STATU		☐	ISH_ABSTIN	☐	IS-H: Internal Status of Outpatient Visit
63	EXTNR	NPAT	EXTNR		☐	EXT_PATNR	☐	IS-H: External Patient Identification
64	ABRKZ	NFAL	ABRKZ		☐	ABRKZ_FALL	☐	IS-H: Billing Indicator for Case
65	PATGEW	NFAL	PATGEW		☐	ISH_PATGEW	☐	IS-H: Weight of Patient at Admission
66	GWEIN	NFAL	GWEIN		☐	ISH_EINGEW	☐	IS-H: Unit of Measurement for Patient Weight
67	PATGRO	NFAL	PATGRO		☐	ISH_PATGRO	☐	IS-H: Height of Patient at Admission
68	GREIN	NFAL	GREIN		☐	ISH_EINGRO	☐	IS-H: Unit of Measurement for Patient Size
69	ADRN2	NPAT	ADRN2		☐	ISH_ADRNR	☐	IS-H: Address Number
70	ADRO2	NPAT	ADRO2		☐	ISH_ADROBJ	☐	IS-H: Address Object
71	RVNUM	NPAT	RVNUM		☐	ISH_RVNUM	☐	IS-H: Social Insurance Number
72	PLSNR	NFAL	PLSNR		☐	ISH_EXTNR_PLS	☐	IS-H: PRS Number

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