SAP ABAP Table N_VPREREG_PROV (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	N_VPREREG_PROV	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	VKGID	☑	N1VKGID	N1VKGID	NUMC	8	0	IS-H: CORD/PREG: ID of an Order Item (Preregistration)
3	PRGNR	☐	NPRGNR	NPRGNR	CHAR	10	0	IS-H: Preregistration Number
4	PRTID	☐	NPRTID	CHAR10	CHAR	10	0	IS-H: Preregistration Type Identification	NPRT
5	VKGST	☐	ISH_WLSTATUS	CHAR2	CHAR	2	0	IS-H: Preregistration/Waiting List Status	TN42C
6	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
7	ORGFA	☐	N1VKGFA	ORGID	CHAR	8	0	IS-H: Departmental Org. Unit in Preregistration
8	ORGID	☐	N1PRGTROU	ORGID	CHAR	8	0	Treatment Unit in Preregistration	NORG
9	ETRBY	☐	NPRGETRBY	NPRGETRBY	CHAR	1	0	IS-H: Preregistration Initiated By
10	ETROE	☐	N1ETROE	ORGID	CHAR	8	0	Initiating Organizational Unit	NORG
11	ETRMA	☐	NPRGETRGP	RI_KUNNR	CHAR	10	0	IS-H: Initiating Employee/Business Partner	NGPA
12	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number	NPAT
13	EXTNR	☐	EXT_PATNR	EXT_PATNR	CHAR	20	0	IS-H: External Patient Identification
14	PAPID	☐	ISH_PAPID	ISH_PAPID	CHAR	10	0	IS-H: Provisional Patient Number	NPAP
15	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	NFAL
16	NNAME	☐	NNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient Last Name
17	NNAMS	☐	NNAMES_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Last Name
18	VNAME	☐	VNAME_PAT	TEXT30	CHAR	30	0	IS-H: Patient First Name
19	VNAMS	☐	VNAMES_PAT	CHAR30	CHAR	30	0	Standardized First Name
20	GBNAM	☐	GBNAM	TEXT30	CHAR	30	0	IS-H: Birthname
21	GBNAMS	☐	GBNAMS_PAT	CHAR30	CHAR	30	0	IS-H: Standardized Birthname
22	GBDAT	☐	RI_GBDAT	RI_DATUM	DATS	8	0	IS-H: Birthdate
23	GSCHL	☐	GSCHL	GSCHL	CHAR	1	0	IS-H: Sex Indicator - Internal
24	TITEL	☐	RI_TITEL	TITEL	CHAR	15	0	IS-H: Title	T535N
25	NAMZU	☐	RI_NAMZU	TITEL	CHAR	15	0	IS-H: Name Affix	T535N
26	VORSW	☐	RI_VORSW	TITEL	CHAR	15	0	IS-H: Name Prefix	T535N
27	ADRNR	☐	ISH_ADRNR	ISH_ADRNR	CHAR	10	0	IS-H: Address Number	NADR
28	ADROB	☐	ISH_ADROBJ	ISH_ADROBJ	CHAR	4	0	IS-H: Address Object
29	KANAM	☐	N1VKANAM	TEXT50	CHAR	50	0	IS-H: CORD/PREG: Short Anamnesis in Clinical Order
30	KALTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
31	DITXT	☐	N1VKDIA	TEXT50	CHAR	50	0	IS-H: Preregistration Diagnosis
32	DILTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
33	EARNR	☐	N1EARNR	RI_KUNNR	CHAR	10	0	IS-H: Referring Physician	NGPA
34	WUZPI	☐	N1ZPI_INT	N1ZPI_INT	CHAR	2	0	Time Interpretation - Internal Format
35	WUMNT	☐	N1WUMNT	N1MONAT	CHAR	2	0	Desired Time (Month)
36	WUJHR	☐	N1WUJHR	N1C004	CHAR	4	0	Desired Time (Year)
37	BMVKG	☐	N1BMVKG	TEXT50	CHAR	50	0	IS-H: Comment for Preregistration
38	BMLTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
39	WLPRI	☐	WLPRI	WLPRI	CHAR	2	0	IS-H: Priority for Preregistration/Waiting List Management	TN14P
40	PVPAT	☐	N1PVPAT	XFELD	CHAR	1	0	IS-H: Preregistered as Private Patient
41	WLTYP	☐	ISH_WLTYPE	CHAR6	CHAR	6	0	IS-H: Waiting List	TN42A
42	WLRDT	☐	ISH_WLRDAT	DATUM	DATS	8	0	IS-H: Date when Movement Removed From Waiting List
43	WLRRN	☐	ISH_WLRRSN	CHAR3	CHAR	3	0	IS-H: Reason for Removal from Waiting List	TN42B
44	WLHSP	☐	ISH_WLHOSP	RI_KUNNR	CHAR	10	0	IS-H: Waiting List Postdischarge Hospital
45	WLADT	☐	ISH_WLADAT	DATUM	DATS	8	0	IS-H: Date when Patient Added to Waiting List
46	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
47	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
48	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
49	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
50	FALAR	☐	FALLART	FALLART	CHAR	1	0	IS-H: Case Type
51	EXTKH	☐	N1EXTKH	RI_KUNNR	CHAR	10	0	IS-H: Referring Hospital	NGPA
52	UARNR	☐	N1UARNR	RI_KUNNR	CHAR	10	0	IS-H: Referring Physician (Outpatients)	NGPA
53	HARNR	☐	N1HARNR	RI_KUNNR	CHAR	10	0	IS-H: Family Physician	NGPA
54	BWART	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type
55	BEKAT	☐	BEKAT	BEHKATEG	CHAR	6	0	Treatment Category
56	AUFDS	☐	AUFDT_LAST	RI_DATUM	DATS	8	0	IS-H: Latest Admission Date
57	RFSRC	☐	ISH_REFSRC	ISH_REFSRC	CHAR	2	0	IS-H: Referral, Postdischarge Treatment Type	TN14H
58	USER1	☐	ISH_PREGUSER1	ISH_PREGUSER1	CHAR	20	0	IS-H: User-Defined Field 1
59	USER2	☐	ISH_PREGUSER2	ISH_PREGUSER2	CHAR	20	0	IS-H: User-Defined Field 2
60	USER3	☐	ISH_PREGUSER3	ISH_PREGUSER3	DATS	8	0	IS-H: User-Defined Field 3
61	USER4	☐	ISH_PREGUSER4	ISH_PREGUSER4	DATS	8	0	IS-H: User-Defined Field 4
62	USER5	☐	ISH_PREGUSER5	ISH_PREGUSER5	CHAR	50	0	IS-H: User-Defined Field 5
63	USER6	☐	ISH_PREGUSER6	ISH_PREGUSER6	CHAR	1	0	IS-H: User-Defined Field 6
64	USER7	☐	ISH_PREGUSER7	ISH_PREGUSER7	CHAR	1	0	IS-H: User-Defined Field 7
65	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N_VPREREG_PROV	ADRNR	NADR	ADRNR	REF	1	C
2	N_VPREREG_PROV	EARNR	NGPA	GPART	REF	C	CN
3	N_VPREREG_PROV	EINRI	TN01	EINRI	KEY	1	CN
4	N_VPREREG_PROV	ETRMA	NGPA	GPART	REF	1	CN
5	N_VPREREG_PROV	ETROE	NORG	ORGID	REF	1	CN
6	N_VPREREG_PROV	EXTKH	NGPA	GPART	KEY	1	CN
7	N_VPREREG_PROV	FALNR	NFAL	FALNR	REF	C	CN
8	N_VPREREG_PROV	HARNR	NGPA	GPART	KEY	1	CN
9	N_VPREREG_PROV	MANDT	T000	MANDT	KEY	1	CN
10	N_VPREREG_PROV	NAMZU	T535N	TITEL	REF	1	CN
11	N_VPREREG_PROV	ORGID	NORG	ORGID	KEY	1	CN
12	N_VPREREG_PROV	PAPID	NPAP	PAPID	REF	C	CN
13	N_VPREREG_PROV	PATNR	NPAT	PATNR	REF	C	CN
14	N_VPREREG_PROV	PRTID	NPRT	PRTID	KEY	1	CN
15	N_VPREREG_PROV	RFSRC	TN14H	REFSRC	KEY	C	CN
16	N_VPREREG_PROV	TITEL	T535N	TITEL	REF	1	CN
17	N_VPREREG_PROV	UARNR	NGPA	GPART	KEY	1	CN
18	N_VPREREG_PROV	VKGST	TN42C	WLSTA	REF	C	CN
19	N_VPREREG_PROV	VORSW	T535N	TITEL	REF	1	CN
20	N_VPREREG_PROV	WLPRI	TN14P	WLPRI	REF	C	CN
21	N_VPREREG_PROV	WLRRN	TN42B	WLRRN	REF	C	CN
22	N_VPREREG_PROV	WLTYP	TN42A	WLTYP	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in