SAP ABAP View BW_HC_NBEW_NFAL (IS-H: View on Movements and Cases for BW)

Hierarchy

☛ IS-H (Software Component) SAP Healthcare
   ⤷ IS-H-IS (Application Component) Information System
     ⤷ NBWD (Package) IS-H: Data Sources for Business Information Warehouse

Basic Data

View Type	D	Database View
Database View	BW_HC_NBEW_NFAL
Short Description	IS-H: View on Movements and Cases for BW
Root table	NFAL	IS-H: Cases

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	NFAL	NFAL
2	NBEW
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			AND	0	0
11	NFAL	STORN		EQ	' '		AND	0	0
12	NBEW	STORN		EQ	' '		AND	0	0
13	NPAT	STORN		EQ	' '			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	NFAL	MANDT		☐	MANDT	☐	Client
2	EINRI	NFAL	EINRI		☐	EINRI	☐	IS-H: Institution
3	FALNR	NFAL	FALNR		☐	FALNR	☐	IS-H: Case Number
4	FALAR	NFAL	FALAR		☐	FALLART	☐	IS-H: Case Type
5	PATNR	NFAL	PATNR		☐	PATNR	☐	IS-H: Patient Number
6	ABRKZ	NFAL	ABRKZ		☐	ABRKZ_FALL	☐	IS-H: Billing Indicator for Case
7	SICHV	NFAL	SICHV		☐	SICHV	☐	IS-H: Indicator for Restricted Patient
8	EINZG	NFAL	EINZG		☐	EINZGEBIET	☐	IS-H: Geographical Area
9	KZTXT	NFAL	KZTXT		☐	TEXT_NFAL	☐	IS-H: Comment on Case
10	KUALF	NFAL	KUALF		☐	LLFDKUA	☐	IS-H: Last IV Request Number Assigned
11	BEWLF	NFAL	BEWLF		☐	LLFDBEW	☐	IS-H: Last Movement Number Assigned
12	DGNLF	NFAL	DGNLF		☐	LLFDDIA	☐	IS-H: Obsolete
13	PGRLF	NFAL	PGRLF		☐	LLFDPGF	☐	IS-H: Last Sequence Number for Patient Group (NPGF)
14	INFKZ	NFAL	INFKZ		☐	INFKZ	☐	IS-H: Infectious Disease Indicator
15	STATU	NFAL	STATU		☐	FALLSTATUS	☐	IS-H: Case Status
16	FZIFF	NFAL	FZIFF		☐	PZIFF_FALL	☐	IS-H: Check Digit for Case
17	NOTAN	NFAL	NOTAN		☐	NOTAUF	☐	IS-H: Emergency Admission Indicator
18	KRZAN	NFAL	KRZAN		☐	KURZAUF	☐	IS-H: Quick Admission Indicator
19	ENDAT	NFAL	ENDAT		☐	ENTDAT	☐	IS-H: Date of Delivery
20	ENTIM	NFAL	ENTIM		☐	ENTZEIT	☐	IS-H: Time of Delivery
21	FGTYP	NFAL	FGTYP		☐	GEBTYP	☐	Delivery Category
22	KZKOM	NFAL	KZKOM		☐	ISH_KZKOM	☐	IS-H: Indicator that Complications Arose
23	KOMTX	NFAL	KOMTX		☐	TEXT_ENTB	☐	IS-H: Comment on Delivery
24	KOLTX	NFAL	KOLTX		☐	RI_LGTXT	☐	Indicator that Long Text Exists
25	ARBUN	NFAL	ARBUN		☐	ARBUN	☐	IS-H: Work Incapacity To-Date
26	ENDDT	NFAL	ENDDT		☐	ENDDT_FAL	☐	IS-H: End Date of Case
27	FSPER	NFAL	FSPER		☐	FSPER	☐	IS-H: Billing Block for Case
28	ERDAT	NFAL	ERDAT		☐	RI_ERDAT	☐	IS-H: Date when Record Created
29	ERUSR	NFAL	ERUSR		☐	RI_ERNAM	☐	IS-H: Name of Employee who Created Record
30	UPDAT	NFAL	UPDAT		☐	RI_UPDAT	☐	IS-H: Date of Last Change
31	UPUSR	NFAL	UPUSR		☐	RI_UPNAM	☐	IS-H: Name of Person who Last Changed Data
32	STORN	NFAL	STORN		☐	RI_STORN	☐	IS-H: Cancellation Indicator
33	STUSR	NFAL	STUSR		☐	STORN_USER	☐	IS-H: Name of User who Canceled Data Record
34	STDAT	NFAL	STDAT		☐	STORN_DAT	☐	Date of Cancellation
35	VORPT	NFAL	VORPT		☐	ISH_VORPT	☐	IS-H: Number of Days of Previous Treatmt in Calendar Year
36	BEGDT	NFAL	BEGDT		☐	BEGDT_FAL	☐	IS-H: Start Date of Case
37	STASP	NFAL	STASP		☐	ISH_STASP	☐	IS-H: Indicator for Admission Type "Statistics Block"
38	KV_KZ	NFAL	KV_KZ		☐	ISH_KV_KZ	☐	IS-H: Relevant for Panel Physician Association Billing
39	EAUFN	NFAL	EAUFN		☐	ISH_EAUFN	☐	IS-HCO: Receiver (Order)
40	KVUEB	NFAL	KVUEB		☐	ISH_KVUEB	☐	IS-H: Status of PPA Billing Case
41	VORGR	NFAL	VORGR		☐	VOR_GRVER	☐	IS-H: Previous Days to Be Deducted from Max. Length of Stay
42	OBJNR	NFAL	OBJNR		☐	J_OBJNR	☐	Object number
43	RESID	NFAL	RESID		☐	ISH_RESID	☐	IS-H: Indicator that Patient is Non-Resident
44	CHILD	NFAL	CHILD		☐	ISH_CHILD	☐	IS-H: Number of Children
45	FOREI	NFAL	FOREI		☐	ISH_FOREIG	☐	IS-H: Foreign Case
46	FATYP	NFAL	FATYP		☐	ISH_CASETYPE	☐	Case Category
47	EMTYP	NFAL	EMTYP		☐	ISH_EMTYPE	☐	IS-H: Employee Type
48	KTTAR	NFAL	KTTAR		☐	NCH_TARCDE	☐	IS-H CH: Canton Tariff
49	KTABK	NFAL	KTABK		☐	NCH_AGREEMENT	☐	IS-H CH: Convention (Hospital <-> Canton)
50	GSTA1	NFAL	GSTA1		☐	NCH_GESTA1	☐	IS-H CH: Gestational Age 1
51	GSTA2	NFAL	GSTA2		☐	NCH_GESTA2	☐	IS-H CH: Gestational Age 2
52	ANZSC	NFAL	ANZSC		☐	NCH_ANZSCH	☐	IS-H CH: Number of Previous Pregnancies
53	ANZTD	NFAL	ANZTD		☐	NCH_ANZTOT	☐	IS-H CH: Number of Previous Miscarriages or Stillbirths
54	ANZAB	NFAL	ANZAB		☐	NCH_ANZABB	☐	IS-H CH: Number of Previous Terminations of Pregnancy
55	LGBIS	NFAL	LGBIS		☐	NWCH_GENBIS	☐	IS-H CH: Service Generation Date to
56	FPEDT	NFAL	FPEDT		☐	ISH_FPEDT	☐	IS-H: Date of Wound Healing
57	APSTATE	NFAL	APSTATE		☐	ISH_APSTATE	☐	IS-H: Application Status
58	FACHR	NFAL	FACHR		☐	FACHRTY7	☐	IS-H: Specialty for Organizational Unit
59	ENDTYP	NFAL	ENDTYP		☐	ISH_CASEEND	☐	IS-H: Type of Case End
60	DOCTY	NFAL	DOCTY		☐	ISH_LPASSTY	☐	IS-H: Subvention Document Type (Long)
61	DOCNR	NFAL	DOCNR		☐	ISH_LPASSNR	☐	IS-H: Subvention Document Number (Long)
62	WKAT	NFAL	WKAT		☐	ISH_WKAT	☐	IS-H: Choice of Ward Class
63	DOCW	NFAL	DOCW		☐	ISH_DOCWKZ	☐	IS-H: Named Referral Indicator
64	PATW	NFAL	PATW		☐	ISH_PATWKZ	☐	IS-H: Patient Requested Referral Indicator
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	RESPI	NFAL	RESPI		☐	ISH_RESPIRATION	☐	IS-H: Duration of Mechanical Ventilation in Hours
70	FEXNR	NFAL	FEXNR		☐	ISH_EXTNR_FAL	☐	IS-H: External Case Identification
71	TIMESTAMP	NFAL	TIMESTAMP		☐	ISH_TIMESTAMP	☐	IS-H: Time Stamp in Short Form (YYYYMMDDhhmmss)
72	LFDNR	NBEW	LFDNR		☐	LFDBEW	☐	IS-H: Sequence Number of Movement
73	BEWTY	NBEW	BEWTY		☐	BEWTY	☐	IS-H: Movement Category
74	BWART	NBEW	BWART		☐	RI_BWART	☐	IS-H: Movement Type
75	BWIDT	NBEW	BWIDT		☐	BWIDT	☐	IS-H: Date of Movement
76	ORGFA	NBEW	ORGFA		☐	NZUWFA	☐	IS-H: OU with Departmental Responsibility for Case
77	ORGPF	NBEW	ORGPF		☐	NZUWPF	☐	Organizational Unit Assigned to Case
78	BEKAT	NBEW	BEKAT		☐	BEKAT	☐	Treatment Category
79	GSCHL	NPAT	GSCHL		☐	GSCHL	☐	IS-H: Sex Indicator - Internal
80	GBDAT	NPAT	GBDAT		☐	RI_GBDAT	☐	IS-H: Birthdate
81	NATIO	NPAT	NATIO		☐	RI_NATIO	☐	IS-H: Nationality

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	N	Display/Maintenance Not Allowed

History

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