SAP ABAP View N_RNSBEW (IS-H: View for statistics with movement >case >patient)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NBAS (Package) Appl. development Hospital System master data, catalogs

Basic Data

View Type	D	Database View
Database View	N_RNSBEW
Short Description	IS-H: View for statistics with movement >case >patient
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			AND	0	0
11	NBEW	STORN		EQ	' '		AND	0	0
12	NFAL	STORN		EQ	' '		AND	0	0
13	NPAT	STORN		EQ	' '		AND	0	0
14	NBEW	PLANB		EQ	' '		AND	0	0
15	NBEW	BEWTY		NE	'4'			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	BWEDT	NBEW	BWEDT		☐	BWEDT	☐	IS-H: Movement End Date, Start Date of Subsequent Movement
10	BWEZT	NBEW	BWEZT		☐	BWEZT	☐	IS-H: Movement End Time, Start Time of Subsequent Movement
11	PLANE	NBEW	PLANE		☐	PLANE	☐	IS-H: Planned Indicator for End Date of Movement
12	ORGFA	NBEW	ORGFA		☐	NZUWFA	☐	IS-H: OU with Departmental Responsibility for Case
13	ORGPF	NBEW	ORGPF		☐	NZUWPF	☐	Organizational Unit Assigned to Case
14	FALAR	NFAL	FALAR		☐	FALLART	☐	IS-H: Case Type
15	EINZG	NFAL	EINZG		☐	EINZGEBIET	☐	IS-H: Geographical Area
16	GSCHL	NPAT	GSCHL		☐	GSCHL	☐	IS-H: Sex Indicator - Internal
17	GBDAT	NPAT	GBDAT		☐	RI_GBDAT	☐	IS-H: Birthdate
18	LAND	NPAT	LAND		☐	LAND_PAT	☐	IS-H: Country of patient's place of residence
19	PSTLZ	NPAT	PSTLZ		☐	PSTLZ_PAT	☐	IS-H: Patient Postal Code
20	ORT	NPAT	ORT		☐	ORT01_PAT	☐	IS-H: City where Patient Resides
21	ORT2	NPAT	ORT2		☐	ORT02_PAT	☐	Patient District
22	LFDREF	NBEW	LFDREF		☐	LFDREF	☐	IS-H: Sequence Number of Subsequent Movement
23	NNAME	NPAT	NNAME		☐	NNAME_PAT	☐	IS-H: Patient Last Name
24	VNAME	NPAT	VNAME		☐	VNAME_PAT	☐	IS-H: Patient First Name
25	VORSW	NPAT	VORSW		☐	RI_VORSW	☐	IS-H: Name Prefix
26	FOREI	NFAL	FOREI		☐	ISH_FOREIG	☐	IS-H: Foreign Case
27	FPEDT	NFAL	FPEDT		☐	ISH_FPEDT	☐	IS-H: Date of Wound Healing

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