SAP ABAP View N_VKAVBEW (IS-H: Admiss./transf. made for create/borrow/transfer of MR)

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_VKAVBEW
Short Description	IS-H: Admiss./transf. made for create/borrow/transfer of MR
Root table	NKAV	ISH: Intermediate File Creation/Borrowing/Transfer of Recrds

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	NKAV	NKAV
2	NBEW
3	NFAL
4	NPAT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	NBEW	MANDT	JL	EQ				0	0
2	NKAV	MANDT	JR	EQ			AND	0	0
3	NBEW	EINRI	JL	EQ				0	0
4	NKAV	EINRI	JR	EQ			AND	0	0
5	NBEW	FALNR	JL	EQ				0	0
6	NKAV	FALNR	JR	EQ			AND	0	0
7	NBEW	LFDNR	JL	EQ				0	0
8	NKAV	LFDNR	JR	EQ			AND	0	0
9	NFAL	MANDT	JL	EQ				0	0
10	NKAV	MANDT	JR	EQ			AND	0	0
11	NFAL	EINRI	JL	EQ				0	0
12	NKAV	EINRI	JR	EQ			AND	0	0
13	NFAL	FALNR	JL	EQ				0	0
14	NKAV	FALNR	JR	EQ			AND	0	0
15	NPAT	MANDT	JL	EQ				0	0
16	NKAV	MANDT	JR	EQ			AND	0	0
17	NPAT	PATNR	JL	EQ				0	0
18	NKAV	PATNR	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	NKAV	MANDT		☐	MANDT	☐	Client
2	EINRI	NKAV	EINRI		☐	EINRI	☐	IS-H: Institution
3	PATNR	NKAV	PATNR		☐	PATNR	☐	IS-H: Patient Number
4	FALNR	NKAV	FALNR		☐	FALNR	☐	IS-H: Case Number
5	LFDNR	NKAV	LFDNR		☐	LFDBEW	☐	IS-H: Sequence Number of Movement
6	TYP	NKAV	TYP		☐	ANFOTYP	☐	IS-H: Med. Rec. Request Type: Create or Borrow Med. Record
7	DOKAR	NKAV	DOKAR		☐	DOKAR	☐	Document Type
8	DOKNR	NKAV	DOKNR		☐	DOKNR	☐	Document number
9	DOKVR	NKAV	DOKVR		☐	DOKVR	☐	Document version
10	DOKTL	NKAV	DOKTL		☐	DOKTL_D	☐	Document part
11	ERDAT	NKAV	ERDAT		☐	RI_ERDAT	☐	IS-H: Date when Record Created
12	ERTIM	NKAV	ERTIM		☐	RI_ERTIM	☐	IS-H: Time Record Created
13	USER1	NKAV	USER1		☐	ISH_KAVUSER1	☐	IS-H: User-Defined Field 1
14	BEWTY	NBEW	BEWTY		☐	BEWTY	☐	IS-H: Movement Category
15	STORN	NBEW	STORN		☐	RI_STORN	☐	IS-H: Cancellation Indicator
16	BWART	NBEW	BWART		☐	RI_BWART	☐	IS-H: Movement Type
17	BWIDT	NBEW	BWIDT		☐	BWIDT	☐	IS-H: Date of Movement
18	BWIZT	NBEW	BWIZT		☐	BWIZT	☐	IS-H: Time of Movement
19	PLANB	NBEW	PLANB		☐	PLANB	☐	IS-H: Planned Indicator for Date of Movement
20	BWEDT	NBEW	BWEDT		☐	BWEDT	☐	IS-H: Movement End Date, Start Date of Subsequent Movement
21	BWEZT	NBEW	BWEZT		☐	BWEZT	☐	IS-H: Movement End Time, Start Time of Subsequent Movement
22	LFDREF	NBEW	LFDREF		☐	LFDREF	☐	IS-H: Sequence Number of Subsequent Movement
23	ORGFA	NBEW	ORGFA		☐	NZUWFA	☐	IS-H: OU with Departmental Responsibility for Case
24	ORGPF	NBEW	ORGPF		☐	NZUWPF	☐	Organizational Unit Assigned to Case
25	FALAR	NFAL	FALAR		☐	FALLART	☐	IS-H: Case Type
26	FZIFF	NFAL	FZIFF		☐	PZIFF_FALL	☐	IS-H: Check Digit for Case
27	GSCHL	NPAT	GSCHL		☐	GSCHL	☐	IS-H: Sex Indicator - Internal
28	NNAME	NPAT	NNAME		☐	NNAME_PAT	☐	IS-H: Patient Last Name
29	VNAME	NPAT	VNAME		☐	VNAME_PAT	☐	IS-H: Patient First Name
30	NNAMS	NPAT	NNAMS		☐	NNAMES_PAT	☐	IS-H: Standardized Last Name
31	VNAMS	NPAT	VNAMS		☐	VNAMES_PAT	☐	Standardized First Name
32	TITEL	NPAT	TITEL		☐	RI_TITEL	☐	IS-H: Title
33	NAMZU	NPAT	NAMZU		☐	RI_NAMZU	☐	IS-H: Name Affix
34	VORSW	NPAT	VORSW		☐	RI_VORSW	☐	IS-H: Name Prefix
35	GBDAT	NPAT	GBDAT		☐	RI_GBDAT	☐	IS-H: Birthdate
36	PZIFF	NPAT	PZIFF		☐	PZIFF_PAT	☐	IS-H: Check Digit for Patient
37	EXTNR	NPAT	EXTNR		☐	EXT_PATNR	☐	IS-H: External Patient Identification
38	KZTXT	NBEW	KZTXT		☐	TEXT_BEW	☐	Comment on Case Movement
39	ZIMMR	NBEW	ZIMMR		☐	ISH_ZIMMID	☐	IS-H: Building ID of Room

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