SAP ABAP Table N_FALL_BEW (Generated Table for View)

Basic Data

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

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N_FALL_BEW	ADRN2	NADR	ADRNR	REF	1	C
2	N_FALL_BEW	ADRNR	NADR	ADRNR	REF	1	C
3	N_FALL_BEW	BEKAT	TN24	BEKAT	REF	C	CN
4	N_FALL_BEW	BETT	NBAU	BAUID	REF	1	CN
5	N_FALL_BEW	BWART	TN14B	BWART	REF	1	CN
6	N_FALL_BEW	EINRI	TN01	EINRI	KEY	1	CN
7	N_FALL_BEW	EXTKH	NGPA	GPART	REF	1	CN
8	N_FALL_BEW	EZUST	TN14D	ENTZU	REF	1	CN
9	N_FALL_BEW	FALNR	NFAL	FALNR	KEY	1	N
10	N_FALL_BEW	GREIN	T006	MSEHI	REF	1	CN
11	N_FALL_BEW	GWEIN	T006	MSEHI	REF	1	CN
12	N_FALL_BEW	MANDT	T000	MANDT	KEY	1	CN
13	N_FALL_BEW	ORGAU	NORG	ORGID	REF	1	CN
14	N_FALL_BEW	ORGFA	NORG	ORGID	REF	1	CN
15	N_FALL_BEW	ORGPF	NORG	ORGID	REF	1	CN
16	N_FALL_BEW	PATNR	NPAT	PATNR	REF	1	CN
17	N_FALL_BEW	TODUR	TN18A	TODUR	REF	1	CN
18	N_FALL_BEW	UNFKZ	TN14C	UNFAR	REF	1	CN
19	N_FALL_BEW	WLPRI	TN14P	WLPRI	REF	1	CN
20	N_FALL_BEW	ZIMMR	NBAU	BAUID	REF	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in