SAP ABAP Table N_VPREG_BASIC (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	N_VPREG_BASIC	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
2	CORDERID	☑	N1CORDID	SYSUUID_C	CHAR	32	0	IS-H: CORD/PREG: Identification of a Clinical Order
3	POSNR	☑	N1CORDPOSNR	N1POSNR	NUMC	3	0	Clinical Order Item Number
4	VKGID	☑	N1VKGID	N1VKGID	NUMC	8	0	IS-H: CORD/PREG: ID of an Order Item (Preregistration)
5	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution
6	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number
7	PAPID	☐	ISH_PAPID	ISH_PAPID	CHAR	10	0	IS-H: Provisional Patient Number
8	PVPAT	☐	N1PVPAT	XFELD	CHAR	1	0	IS-H: Preregistered as Private Patient
9	ETRBY	☐	N1CORDETRBY	N1CORDETRBY	CHAR	1	0	IS-H: CORD/PREG: Clinical Order Initiated By
10	ETROE	☐	N1CORDETROE	ORGID	CHAR	8	0	Initiating Organizational Unit
11	ETRMA	☐	N1CORDETRGP	RI_KUNNR	CHAR	10	0	Initiating Employee/Business Partner
12	CORDTITLE	☐	N1CORDTITLE	N1CORDTITLE	CHAR	30	0	IS-H: CORD/PREG: Title of Clinical Order
13	PRGNR	☐	N1CORDNR	N1CORDNR	CHAR	10	0	Order Number
14	RCKRUF	☐	N1CORDRCKRUF	N1CORDRCKRUF	CHAR	30	0	Clinical Order - Callback Number
15	KANAM	☐	N1CORDANAM	TEXT50	CHAR	50	0	IS-H: CORD/PREG: Short Anamnesis for Clinical Order
16	KALTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
17	FRAGE	☐	N1CORDFRAGE	TEXT50	CHAR	50	0	IS-H: CORD/PREG: Questions
18	FRLTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
19	BMVKG	☐	N1CORDBMKG	TEXT50	CHAR	50	0	Comment for Clinical Order
20	BMLTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
21	WLPRI	☐	WLPRI	WLPRI	CHAR	2	0	IS-H: Priority for Preregistration/Waiting List Management
22	WLTYP	☐	ISH_WLTYPE	CHAR6	CHAR	6	0	IS-H: Waiting List
23	WLRDT	☐	ISH_WLRDAT	DATUM	DATS	8	0	IS-H: Date when Movement Removed From Waiting List
24	WLRRN	☐	ISH_WLRRSN	CHAR3	CHAR	3	0	IS-H: Reason for Removal from Waiting List
25	VKGST	☐	ISH_WLSTATUS	CHAR2	CHAR	2	0	IS-H: Preregistration/Waiting List Status
26	WLHSP	☐	ISH_WLHOSP	RI_KUNNR	CHAR	10	0	IS-H: Waiting List Postdischarge Hospital
27	WLADT	☐	ISH_WLADAT	DATUM	DATS	8	0	IS-H: Date when Patient Added to Waiting List
28	USER1	☐	ISH_PREGUSER1	ISH_PREGUSER1	CHAR	20	0	IS-H: User-Defined Field 1
29	USER2	☐	ISH_PREGUSER2	ISH_PREGUSER2	CHAR	20	0	IS-H: User-Defined Field 2
30	USER3	☐	ISH_PREGUSER3	ISH_PREGUSER3	DATS	8	0	IS-H: User-Defined Field 3
31	USER4	☐	ISH_PREGUSER4	ISH_PREGUSER4	DATS	8	0	IS-H: User-Defined Field 4
32	USER5	☐	ISH_PREGUSER5	ISH_PREGUSER5	CHAR	50	0	IS-H: User-Defined Field 5
33	USER6	☐	ISH_PREGUSER6	ISH_PREGUSER6	CHAR	1	0	IS-H: User-Defined Field 6
34	USER7	☐	ISH_PREGUSER7	ISH_PREGUSER7	CHAR	1	0	IS-H: User-Defined Field 7
35	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
36	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
37	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
38	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
39	STORN	☐	RI_STORN	XFELD	CHAR	1	0	IS-H: Cancellation Indicator
40	STUSR	☐	STORN_USER	USNAM	CHAR	12	0	IS-H: Name of User who Canceled Data Record
41	STDAT	☐	STORN_DAT	RI_DATUM	DATS	8	0	Date of Cancellation
42	STTIME	☐	ISH_STORN_TIM	UHRZT	TIMS	6	0	Time of Cancellation
43	STOID	☐	N1STOID_PRG	N1STOID	CHAR	3	0	IS-H: Cancellation Reason for Preregistration
44	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number
45	FALAR	☐	FALLART	FALLART	CHAR	1	0	IS-H: Case Type
46	BEWTY	☐	BEWTY	BEWTY	CHAR	1	0	IS-H: Movement Category
47	ORGFA	☐	N1VKGFA	ORGID	CHAR	8	0	IS-H: Departmental Org. Unit in Preregistration
48	BWART	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type
49	BEKAT	☐	BEKAT	BEHKATEG	CHAR	6	0	Treatment Category
50	APCNID	☐	N1APCNID	SYSUUID_C	CHAR	32	0	IS-H: Identification of an Appointment Template
51	TRTGP	☐	N1CORDTRTGP	RI_KUNNR	CHAR	10	0	Filler (Business Partner)
52	CORDTYPID	☐	N1COTID	SYSUUID_C	CHAR	32	0	IS-H: CORD/PREG: Identification of the Clinical Order Type
53	PREREG	☐	N1CORDPREREG	ISH_ON_OFF	CHAR	1	0	IS-H: CORD/PREG: Clinical Order Preregistered
54	EXTKH	☐	N1EXTKH	RI_KUNNR	CHAR	10	0	IS-H: Referring Hospital	NGPA
55	EARNR	☐	N1EARNR	RI_KUNNR	CHAR	10	0	IS-H: Referring Physician	NGPA
56	UARNR	☐	N1UARNR	RI_KUNNR	CHAR	10	0	IS-H: Referring Physician (Outpatients)	NGPA
57	RFSRC	☐	ISH_REFSRC	ISH_REFSRC	CHAR	2	0	IS-H: Referral, Postdischarge Treatment Type
58	HARNR	☐	N1HARNR	RI_KUNNR	CHAR	10	0	IS-H: Family Physician	NGPA
59	AUFDS	☐	N1APCNAUFDS		DATS	8	0	IS-H: Latest Admission Date
60	WUZPI	☐	N1APCNWUZPI	N1APCNWUZPI	CHAR	2	0	IS-H: Desired Time Interpretation, Internal Format
61	WUMNT	☐	N1APCNWUMNT	N1APCNWUMNT	CHAR	2	0	Desired Time (Month)
62	WUJHR	☐	N1APCNWUJHR	N1APCNWUJHR	CHAR	4	0	Desired Time (Year)
63	TRTOE	☐	N1APCNTRTOE	ORGID	CHAR	8	0	IS-H: Appointment Template: OU in which Appointment Occurs
64	TRDRN	☐	ISH_APTIME_PDF	ISH_DZEIT	NUMC	4	0	IS-H: Default Duration for a Treatment Appointment
65	TROOM	☐	ISH_TR_ROOM_PDF	BAUID	CHAR	8	0	IS-H: Default Room for a Treatment Appointment
66	TPERNR	☐	N1APCNPERNR	RI_KUNNR	CHAR	10	0	IS-H: Attending Person
67	WDATE	☐	N1APCNWDATE		DATS	8	0	Desired Date
68	WTIME	☐	N1APCNWTIME		TIMS	6	0	Desired Time
69	WDISP	☐	N1APCNWDISP	ISH_DSPTC8	CHAR	8	0	IS-H: Outpatient Scheduling Type
70	WPTINP	☐	N1APCNWPTINP	ISH_DSPTC8	CHAR	8	0	IS-H: Inpatient Scheduling Type
71	ORDPRI	☐	N1APRI_D	N1APRI	NUMC	3	0	Prioritization for Request/Movement (Internal)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N_VPREG_BASIC	EARNR	NGPA	GPART	REF	C	CN
2	N_VPREG_BASIC	EXTKH	NGPA	GPART	KEY	1	CN
3	N_VPREG_BASIC	HARNR	NGPA	GPART	KEY	1	CN
4	N_VPREG_BASIC	UARNR	NGPA	GPART	KEY	1	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in