SAP ABAP View N_VPREG_BASIC (IS-H: Basic Data for Preregistration for Prereg. View)

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_VPREG_BASIC
Short Description	IS-H: Basic Data for Preregistration for Prereg. View
Root table	N1CORDER	IS-H: Clinical Order

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	N1CORDER	N1CORDER
2	N1VKG
3	N1APCN

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	N1CORDER	MANDT	JL	EQ				0	0
2	N1VKG	MANDT	JR	EQ			AND	0	0
3	N1CORDER	CORDERID	JL	EQ				0	0
4	N1VKG	CORDERID	JR	EQ			AND	0	0
5	N1VKG	MANDT	JL	EQ				0	0
6	N1APCN	MANDT	JR	EQ			AND	0	0
7	N1VKG	APCNID	JL	EQ				0	0
8	N1APCN	APCNID	JR	EQ				0	0

View Fields

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

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	20130529
SAP Release Created in	472