SAP ABAP Table RN1VKG_DAT (IS-H*MED: N1VKG structure extended by the planning date)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NORD (Package) R/3MED: Services processing EDV-G

Basic Data

Table Category	INTTAB	Structure
Structure	RN1VKG_DAT	Table Relationship Diagram
Short Description	IS-H*MED: N1VKG structure extended by the planning date

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	.INCLUDE	☐				0	0	IS-H: Item of Clinical Order (Preregistration)
2	MANDT	☐	MANDT	MANDT	CLNT	3	0	Client	T000
3	VKGID	☐	N1VKGID	N1VKGID	NUMC	8	0	IS-H: CORD/PREG: ID of an Order Item (Preregistration)
4	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
5	ORGID	☐	N1PRGTROU	ORGID	CHAR	8	0	Treatment Unit in Preregistration	NORG
6	ANFTY	☐	ANFTY	ANFTY	CHAR	6	0	Request Type	N1ANFTYP
7	ETRBY	☐	NPRGETRBY	NPRGETRBY	CHAR	1	0	IS-H: Preregistration Initiated By
8	ETROE	☐	N1ETROE	ORGID	CHAR	8	0	Initiating Organizational Unit	NORG
9	ETRGP	☐	NPRGETRGP	RI_KUNNR	CHAR	10	0	IS-H: Initiating Employee/Business Partner	NGPA
10	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number	NPAT
11	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	NFAL
12	KANAM	☐	N1VKANAM	TEXT50	CHAR	50	0	IS-H: CORD/PREG: Short Anamnesis in Clinical Order
13	KALTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
14	DITXT	☐	N1VKDIA	TEXT50	CHAR	50	0	IS-H: Preregistration Diagnosis
15	DILTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
16	EARNR	☐	N1EARNR	RI_KUNNR	CHAR	10	0	IS-H: Referring Physician	NGPA
17	WUZPI	☐	N1ZPI_INT	N1ZPI_INT	CHAR	2	0	Time Interpretation - Internal Format
18	WUMNT	☐	N1WUMNT	N1MONAT	CHAR	2	0	Desired Time (Month)
19	WUJHR	☐	N1WUJHR	N1C004	CHAR	4	0	Desired Time (Year)
20	PBGDT	☐	N1VKPDT	DATS	DATS	8	0	IS-H: Planned Date of Preregistration
21	PBZT	☐	N1VKPZT	UHRZT	TIMS	6	0	IS-H: Planned Time of Preregistration
22	BMVKG	☐	N1BMVKG	TEXT50	CHAR	50	0	IS-H: Comment for Preregistration
23	BMLTX	☐	RI_LGTXT	XFELD	CHAR	1	0	Indicator that Long Text Exists
24	AFNDT	☐	N1AFNDT	RI_DATUM	DATS	8	0	Expected Admission Date
25	AFNOE	☐	N1AFNOE	ORGID	CHAR	8	0	Organizational Unit to which Patient Is Admitted	NORG
26	WLPRI	☐	WLPRI	WLPRI	CHAR	2	0	IS-H: Priority for Preregistration/Waiting List Management	TN14P
27	PVPAT	☐	N1PVPAT	XFELD	CHAR	1	0	IS-H: Preregistered as Private Patient
28	WLTYP	☐	ISH_WLTYPE	CHAR6	CHAR	6	0	IS-H: Waiting List	TN42A
29	WLREM	☐	ISH_WLSTREMO	XFELD	CHAR	1	0	IS-H: Preregistration Status "Inactive" Indicator
30	WLRDT	☐	ISH_WLRDAT	DATUM	DATS	8	0	IS-H: Date when Movement Removed From Waiting List
31	WLRRN	☐	ISH_WLRRSN	CHAR3	CHAR	3	0	IS-H: Reason for Removal from Waiting List	TN42B
32	WLSTA	☐	ISH_WLSTATUS	CHAR2	CHAR	2	0	IS-H: Preregistration/Waiting List Status	TN42C
33	WLHSP	☐	ISH_WLHOSP	RI_KUNNR	CHAR	10	0	IS-H: Waiting List Postdischarge Hospital	*
34	WLADT	☐	ISH_WLADAT	DATUM	DATS	8	0	IS-H: Date when Patient Added to Waiting List
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	STOID	☐	N1STOID_PRG	N1STOID	CHAR	3	0	IS-H: Cancellation Reason for Preregistration	N1STGR
43	FALAR	☐	FALLART	FALLART	CHAR	1	0	IS-H: Case Type
44	PAPID	☐	ISH_PAPID	ISH_PAPID	CHAR	10	0	IS-H: Provisional Patient Number	NPAP
45	EXTKH	☐	N1EXTKH	RI_KUNNR	CHAR	10	0	IS-H: Referring Hospital	NGPA
46	UARNR	☐	N1UARNR	RI_KUNNR	CHAR	10	0	IS-H: Referring Physician (Outpatients)	NGPA
47	HARNR	☐	N1HARNR	RI_KUNNR	CHAR	10	0	IS-H: Family Physician	NGPA
48	ORGFA	☐	N1VKGFA	ORGID	CHAR	8	0	IS-H: Departmental Org. Unit in Preregistration	*
49	BEWAR	☐	RI_BWART	RI_BWART	CHAR	2	0	IS-H: Movement Type	*
50	BEKAT	☐	BEKAT	BEHKATEG	CHAR	6	0	Treatment Category	*
51	AUFDS	☐	AUFDT_LAST	RI_DATUM	DATS	8	0	IS-H: Latest Admission Date
52	RFSRC	☐	ISH_REFSRC	ISH_REFSRC	CHAR	2	0	IS-H: Referral, Postdischarge Treatment Type	TN14H
53	AUSPR	☐	N1PRGAUSPR	N1PRGAUSPR	CHAR	8	0	IS-H: CORD/PREG: Specification of the Clinical Order
54	PRTID	☐	NPRTID	CHAR10	CHAR	10	0	IS-H: Preregistration Type Identification	NPRT
55	PRGNR	☐	NPRGNR	NPRGNR	CHAR	10	0	IS-H: Preregistration Number
56	ICPMK	☐	ICPM_ID	TARID	CHAR	2	0	IS-H: Identification of Surgical Procedure Coding Catalog	*
57	ICPML	☐	ICPM_LS	TARLS	CHAR	10	0	IS-H: Surgical Procedure Code (Service)	*
58	TRDRN	☐	ISH_APTIME_PDF	ISH_DZEIT	NUMC	4	0	IS-H: Default Duration for a Treatment Appointment
59	TRDRNX	☐	ISH_APTIME_MAN	XFELD	CHAR	1	0	IS-H: Duration of Treatment Appt Changed Manually
60	TROOM	☐	ISH_TR_ROOM_PDF	BAUID	CHAR	8	0	IS-H: Default Room for a Treatment Appointment	NBAU
61	TROOMX	☐	ISH_TR_ROOM_MAN	XFELD	CHAR	1	0	IS-H: Room for Treatment Appointment Changed Manually
62	USER1	☐	ISH_PREGUSER1	ISH_PREGUSER1	CHAR	20	0	IS-H: User-Defined Field 1
63	USER2	☐	ISH_PREGUSER2	ISH_PREGUSER2	CHAR	20	0	IS-H: User-Defined Field 2
64	USER3	☐	ISH_PREGUSER3	ISH_PREGUSER3	DATS	8	0	IS-H: User-Defined Field 3
65	USER4	☐	ISH_PREGUSER4	ISH_PREGUSER4	DATS	8	0	IS-H: User-Defined Field 4
66	USER5	☐	ISH_PREGUSER5	ISH_PREGUSER5	CHAR	50	0	IS-H: User-Defined Field 5
67	USER6	☐	ISH_PREGUSER6	ISH_PREGUSER6	CHAR	1	0	IS-H: User-Defined Field 6
68	USER7	☐	ISH_PREGUSER7	ISH_PREGUSER7	CHAR	1	0	IS-H: User-Defined Field 7
69	CORDERID	☐	N1CORDID	SYSUUID_C	CHAR	32	0	IS-H: CORD/PREG: Identification of a Clinical Order
70	POSNR	☐	N1CORDPOSNR	N1POSNR	NUMC	3	0	Clinical Order Item Number
71	APCNID	☐	N1APCNID	SYSUUID_C	CHAR	32	0	IS-H: Identification of an Appointment Template
72	CORDTYPID	☐	N1COTID	SYSUUID_C	CHAR	32	0	IS-H: CORD/PREG: Identification of the Clinical Order Type
73	OBJNR	☐	J_OBJNR	J_OBJNR	CHAR	22	0	Object number	*
74	PREREG	☐	N1CORDPREREG	ISH_ON_OFF	CHAR	1	0	IS-H: CORD/PREG: Clinical Order Preregistered
75	TRTBY	☐	N1CORDTRTBY	N1CORDTRTBY	CHAR	1	0	IS-H: CORD/PREG: Clinical Order Filled By
76	TRTOE	☐	N1CORDTRTOE	ORGID	CHAR	8	0	IS-H: CORD/PREG: Order Filler (Org. Unit)	*
77	TRTGP	☐	N1CORDTRTGP	RI_KUNNR	CHAR	10	0	Filler (Business Partner)	*
78	BEKATX	☐	N1CORDBEKAT_MAN	XFELD	CHAR	1	0	IS-H: Treatment Category Changed Manually
79	TPAE	☐	N1TPAE	N1TPAE	CHAR	2	0	Transport Type	*
80	ERTIM	☐	ISH_ERTIM	UHRZT	TIMS	6	0	IS-H: Time when Data Record Created
81	UPTIM	☐	ISH_UPTIM	UHRZT	TIMS	6	0	IS-H: Time Data Record was Last Changed
82	STTIM	☐	ISH_STORN_TIM	UHRZT	TIMS	6	0	Time of Cancellation
83	REQCOMPID	☐	N1REQCOMPID	N1REQCOMPID	NUMC	8	0	IS-H: CORD/PREG: Identification of a Request in CORD
84	REQCOMPNR	☐	N1REQCOMPNR	N1REQCOMPNR	CHAR	8	0	IS-H: CORD/PREG: Request Number in Clinical Order
85	BEWTY	☐	BEWTY	BEWTY	CHAR	1	0	IS-H: Movement Category
86	FATYP	☐	ISH_CASETYPE	ISH_CASETYPE	CHAR	2	0	Case Category	TN15C
87	CORDPTYPID	☐	N1COTID_PROF	SYSUUID_C	CHAR	32	0	Identification of a Profile Type
88	NOCORDPTYP	☐	NOCORDPTYP		NUMC	2	0	Item Number of Profile Type
89	PLANDT	☐	N1VKPDT	DATS	DATS	8	0	IS-H: Planned Date of Preregistration

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	RN1VKG_DAT	AFNOE	NORG	ORGID	REF	C	CN
2	RN1VKG_DAT	ANFTY	N1ANFTYP	ANFTY	KEY	1	CN
3	RN1VKG_DAT	EARNR	NGPA	GPART	REF	C	CN
4	RN1VKG_DAT	EINRI	TN01	EINRI	KEY	1	CN
5	RN1VKG_DAT	ETRGP	NGPA	GPART	REF	1	CN
6	RN1VKG_DAT	ETROE	NORG	ORGID	REF	1	CN
7	RN1VKG_DAT	EXTKH	NGPA	GPART	KEY	1	CN
8	RN1VKG_DAT	FALNR	NFAL	FALNR	REF	C	CN
9	RN1VKG_DAT	FATYP	TN15C	CASETY	KEY	1	CN
10	RN1VKG_DAT	HARNR	NGPA	GPART	KEY	1	CN
11	RN1VKG_DAT	MANDT	T000	MANDT	KEY	1	CN
12	RN1VKG_DAT	ORGID	NORG	ORGID	KEY	1	CN
13	RN1VKG_DAT	PAPID	NPAP	PAPID	REF	C	CN
14	RN1VKG_DAT	PATNR	NPAT	PATNR	REF	C	CN
15	RN1VKG_DAT	PRTID	NPRT	PRTID	KEY	1	CN
16	RN1VKG_DAT	RFSRC	TN14H	REFSRC	KEY	C	CN
17	RN1VKG_DAT	STOID	N1STGR	STOID	REF	1	CN
18	RN1VKG_DAT	TROOM	NBAU	BAUID	REF	1	CN
19	RN1VKG_DAT	UARNR	NGPA	GPART	KEY	1	CN
20	RN1VKG_DAT	WLPRI	TN14P	WLPRI	REF	C	CN
21	RN1VKG_DAT	WLRRN	TN42B	WLRRN	REF	C	CN
22	RN1VKG_DAT	WLSTA	TN42C	WLSTA	REF	C	CN
23	RN1VKG_DAT	WLTYP	TN42A	WLTYP	REF	C	CN

History

Last changed by/on	SAP	20130529
SAP Release Created in