SAP ABAP Table N_VKAVBEW (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	N_VKAVBEW	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	PATNR	☑	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number	NPAT
4	FALNR	☑	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	NFAL
5	LFDNR	☑	LFDBEW	LFDBEW	NUMC	5	0	IS-H: Sequence Number of Movement	NBEW
6	TYP	☑	ANFOTYP	ANFTYP	CHAR	1	0	IS-H: Med. Rec. Request Type: Create or Borrow Med. Record
7	DOKAR	☑	DOKAR	DOKAR	CHAR	3	0	Document Type	TDWA
8	DOKNR	☑	DOKNR	DOKNR	CHAR	25	0	Document number	DRAW
9	DOKVR	☑	DOKVR	DOKVR	CHAR	2	0	Document version
10	DOKTL	☑	DOKTL_D	DOKTL	CHAR	3	0	Document part
11	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
12	ERTIM	☐	RI_ERTIM	UHRZT	TIMS	6	0	IS-H: Time Record Created
13	USER1	☐	ISH_KAVUSER1	CHAR20	CHAR	20	0	IS-H: User-Defined Field 1
14	BEWTY	☐	BEWTY	BEWTY	CHAR	1	0	IS-H: Movement Category
15	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
16	BWART	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type	TN14B
17	BWIDT	☐	BWIDT	RI_DATUM	DATS	8	0	IS-H: Date of Movement
18	BWIZT	☐	BWIZT	UHRZT	TIMS	6	0	IS-H: Time of Movement
19	PLANB	☐	PLANB	ISH_PLAN	CHAR	1	0	IS-H: Planned Indicator for Date of Movement
20	BWEDT	☐	BWEDT	RI_DATUM	DATS	8	0	IS-H: Movement End Date, Start Date of Subsequent Movement
21	BWEZT	☐	BWEZT	UHRZT	TIMS	6	0	IS-H: Movement End Time, Start Time of Subsequent Movement
22	LFDREF	☐	LFDREF	LFDBEW	NUMC	5	0	IS-H: Sequence Number of Subsequent Movement
23	ORGFA	☐	NZUWFA	ORGID	CHAR	8	0	IS-H: OU with Departmental Responsibility for Case	NORG
24	ORGPF	☐	NZUWPF	ORGID	CHAR	8	0	Organizational Unit Assigned to Case	NORG
25	FALAR	☐	FALLART	FALLART	CHAR	1	0	IS-H: Case Type
26	FZIFF	☐	PZIFF_FALL	PZIFF	CHAR	1	0	IS-H: Check Digit for Case
27	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
28	NNAME	☐	NNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient Last Name
29	VNAME	☐	VNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient First Name
30	NNAMS	☐	NNAMES_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Last Name
31	VNAMS	☐	VNAMES_PAT	CHAR30	CHAR	30	0	Standardized First Name
32	TITEL	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title
33	NAMZU	☐	RI_NAMZU	TITEL	CHAR	15	0	IS-H: Name Affix
34	VORSW	☐	RI_VORSW	TITEL	CHAR	15	0	IS-H: Name Prefix
35	GBDAT	☐	RI_GBDAT	RI_DATUM	DATS	8	0	IS-H: Birthdate
36	PZIFF	☐	PZIFF_PAT	PZIFF	CHAR	1	0	IS-H: Check Digit for Patient
37	EXTNR	☐	EXT_PATNR	EXT_PATNR	CHAR	20	0	IS-H: External Patient Identification
38	KZTXT	☐	TEXT_BEW	TEXT50	CHAR	50	0	Comment on Case Movement
39	ZIMMR	☐	ISH_ZIMMID	BAUID	CHAR	8	0	IS-H: Building ID of Room	NBAU

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N_VKAVBEW	BWART	TN14B	BWART	REF	1	CN
2	N_VKAVBEW	DOKAR	TDWA	DOKAR	KEY	1	CN
3	N_VKAVBEW	DOKNR	DRAW	DOKNR	KEY	1	CN
4	N_VKAVBEW	EINRI	TN01	EINRI	KEY	1	CN
5	N_VKAVBEW	FALNR	NFAL	FALNR	KEY	1	CN
6	N_VKAVBEW	LFDNR	NBEW	LFDNR	KEY	1	1
7	N_VKAVBEW	MANDT	T000	MANDT	KEY	1	CN
8	N_VKAVBEW	ORGFA	NORG	ORGID	REF	1	CN
9	N_VKAVBEW	ORGPF	NORG	ORGID	REF	1	CN
10	N_VKAVBEW	PATNR	NPAT	PATNR	KEY	1	CN
11	N_VKAVBEW	ZIMMR	NBAU	BAUID	REF	1	CN

History

Last changed by/on	SAP	20131127
SAP Release Created in