N1VKG SAP (IS-H: Item of Clinical Order (Preregistration)) Table details
Dictionary Type: Table
Description: IS-H: Item of Clinical Order (Preregistration)
Description: IS-H: Item of Clinical Order (Preregistration)
Table field list including key, data, relationships and ABAP select examples
N1VKG is a standard SAP Table which is used to store IS-H: Item of Clinical Order (Preregistration) data and is available within R/3 SAP systems depending on the version and release level.
The N1VKG table consists of various fields, each holding specific information or linking keys about IS-H: Item of Clinical Order (Preregistration) data available in SAP. These include VKGID (IS-H: CORD/PREG: ID of an Order Item (Preregistration)), EINRI (Institution), ORGID (Treatment Unit in Preregistration), ANFTY (Request Type).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP N1VKG table fields - Full list of fields found in SAP data dictionary
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
VKGID | IS-H: CORD/PREG: ID of an Order Item (Preregistration) | N1VKGID | NUMC | 8 | N1VKGID | ||||
EINRI | Institution | EINRI | CHAR | 4 | TN01 | ALPHA | EINRI | EIN | |
ORGID | Treatment Unit in Preregistration | N1PRGTROU | CHAR | 8 | NORG | ALPHA | ORGID | ||
ANFTY | Request Type | ANFTY | CHAR | 6 | N1ANFTYP | ANFTY | |||
ETRBY | IS-H: Preregistration Initiated By | NPRGETRBY | CHAR | 1 | NPRGETRBY | ||||
ETROE | Initiating Organizational Unit | N1ETROE | CHAR | 8 | NORG | ALPHA | ORGID | ||
ETRGP | IS-H: Initiating Employee/Business Partner | NPRGETRGP | CHAR | 10 | NGPA | ALPHA | RI_KUNNR | ||
PATNR | IS-H: Patient Number | PATNR | CHAR | 10 | NPAT | ALPHA | PATNR | PAT | |
FALNR | IS-H: Case Number | FALNR | CHAR | 10 | NFAL | ALPHA | FALNR | FAL | |
KANAM | IS-H: CORD/PREG: Short Anamnesis in Clinical Order | N1VKANAM | CHAR | 50 | TEXT50 | ||||
KALTX | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
DITXT | IS-H: Preregistration Diagnosis | N1VKDIA | CHAR | 50 | TEXT50 | ||||
DILTX | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
EARNR | IS-H: Referring Physician | N1EARNR | CHAR | 10 | NGPA | ALPHA | RI_KUNNR | ||
WUZPI | Time Interpretation - Internal Format | N1ZPI_INT | CHAR | 2 | N1ZPI_INT | ||||
WUMNT | Desired Time (Month) | N1WUMNT | CHAR | 2 | ALPHA | N1MONAT | |||
WUJHR | Desired Time (Year) | N1WUJHR | CHAR | 4 | N1C004 | ||||
PBGDT | IS-H: Planned Date of Preregistration | N1VKPDT | DATS | 8 | DATS | ||||
PBZT | IS-H: Planned Time of Preregistration | N1VKPZT | TIMS | 6 | UHRZT | ||||
BMVKG | IS-H: Comment for Preregistration | N1BMVKG | CHAR | 50 | TEXT50 | ||||
BMLTX | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
AFNDT | Expected Admission Date | N1AFNDT | DATS | 8 | RI_DATUM | ||||
AFNOE | Organizational Unit to which Patient Is Admitted | N1AFNOE | CHAR | 8 | NORG | ALPHA | ORGID | ||
WLPRI | IS-H: Priority for Preregistration/Waiting List Management | WLPRI | CHAR | 2 | TN14P | ALPHA | WLPRI | ||
PVPAT | IS-H: Preregistered as Private Patient | N1PVPAT | CHAR | 1 | XFELD | ||||
WLTYP | IS-H: Waiting List | ISH_WLTYPE | CHAR | 6 | TN42A | CHAR6 | |||
WLREM | IS-H: Preregistration Status 'Inactive' Indicator | ISH_WLSTREMO | CHAR | 1 | XFELD | ||||
WLRDT | IS-H: Date when Movement Removed From Waiting List | ISH_WLRDAT | DATS | 8 | DATUM | ||||
WLRRN | IS-H: Reason for Removal from Waiting List | ISH_WLRRSN | CHAR | 3 | TN42B | CHAR3 | |||
WLSTA | IS-H: Preregistration/Waiting List Status | ISH_WLSTATUS | CHAR | 2 | TN42C | CHAR2 | |||
WLHSP | IS-H: Waiting List Postdischarge Hospital | ISH_WLHOSP | CHAR | 10 | Assigned to domain | ALPHA | RI_KUNNR | ||
WLADT | IS-H: Date when Patient Added to Waiting List | ISH_WLADAT | DATS | 8 | DATUM | ||||
ERDAT | IS-H: Date when Record Created | RI_ERDAT | DATS | 8 | RI_DATUM | ||||
ERUSR | IS-H: Name of Employee who Created Record | RI_ERNAM | CHAR | 12 | USNAM | ||||
UPDAT | IS-H: Date of Last Change | RI_UPDAT | DATS | 8 | RI_DATUM | ||||
UPUSR | IS-H: Name of Person who Last Changed Data | RI_UPNAM | CHAR | 12 | USNAM | ||||
STORN | IS-H: Cancellation Indicator | RI_STORN | CHAR | 1 | XFELD | ||||
STUSR | IS-H: Name of User who Canceled Data Record | STORN_USER | CHAR | 12 | USNAM | ||||
STDAT | Date of Cancellation | STORN_DAT | DATS | 8 | RI_DATUM | ||||
STOID | IS-H: Cancellation Reason for Preregistration | N1STOID_PRG | CHAR | 3 | N1STGR | N1STOID | |||
FALAR | IS-H: Case Type | FALLART | CHAR | 1 | FALLART | ||||
PAPID | IS-H: Provisional Patient Number | ISH_PAPID | CHAR | 10 | NPAP | ALPHA | ISH_PAPID | ||
EXTKH | IS-H: Referring Hospital | N1EXTKH | CHAR | 10 | NGPA | ALPHA | RI_KUNNR | ||
UARNR | IS-H: Referring Physician (Outpatients) | N1UARNR | CHAR | 10 | NGPA | ALPHA | RI_KUNNR | ||
HARNR | IS-H: Family Physician | N1HARNR | CHAR | 10 | NGPA | ALPHA | RI_KUNNR | ||
ORGFA | IS-H: Departmental Org. Unit in Preregistration | N1VKGFA | CHAR | 8 | Assigned to domain | ALPHA | ORGID | ||
BEWAR | IS-H: Movement Type | RI_BWART | CHAR | 2 | Assigned to domain | RI_BWART | |||
BEKAT | Treatment Category | BEKAT | CHAR | 6 | Assigned to domain | ALPHA | BEHKATEG | ||
AUFDS | IS-H: Latest Admission Date | AUFDT_LAST | DATS | 8 | RI_DATUM | ||||
RFSRC | IS-H: Referral, Postdischarge Treatment Type | ISH_REFSRC | CHAR | 2 | TN14H | ALPHA | ISH_REFSRC | ||
AUSPR | IS-H: CORD/PREG: Specification of the Clinical Order | N1PRGAUSPR | CHAR | 8 | N1PRGAUSPR | ||||
PRTID | IS-H: Preregistration Type Identification | NPRTID | CHAR | 10 | NPRT | CHAR10 | |||
PRGNR | IS-H: Preregistration Number | NPRGNR | CHAR | 10 | ALPHA | NPRGNR | |||
ICPMK | IS-H: Identification of Surgical Procedure Coding Catalog | ICPM_ID | CHAR | 2 | Assigned to domain | ALPHA | TARID | ||
ICPML | IS-H: Surgical Procedure Code (Service) | ICPM_LS | CHAR | 10 | Assigned to domain | ALPHA | TARLS | ||
TRDRN | IS-H: Default Duration for a Treatment Appointment | ISH_APTIME_PDF | NUMC | 4 | ISH_DZEIT | ||||
TRDRNX | IS-H: Duration of Treatment Appt Changed Manually | ISH_APTIME_MAN | CHAR | 1 | XFELD | ||||
TROOM | IS-H: Default Room for a Treatment Appointment | ISH_TR_ROOM_PDF | CHAR | 8 | NBAU | ALPHA | BAUID | ||
TROOMX | IS-H: Room for Treatment Appointment Changed Manually | ISH_TR_ROOM_MAN | CHAR | 1 | XFELD | ||||
USER1 | IS-H: User-Defined Field 1 | ISH_PREGUSER1 | CHAR | 20 | ISH_PREGUSER1 | ||||
USER2 | IS-H: User-Defined Field 2 | ISH_PREGUSER2 | CHAR | 20 | ISH_PREGUSER2 | ||||
USER3 | IS-H: User-Defined Field 3 | ISH_PREGUSER3 | DATS | 8 | ISH_PREGUSER3 | ||||
USER4 | IS-H: User-Defined Field 4 | ISH_PREGUSER4 | DATS | 8 | ISH_PREGUSER4 | ||||
USER5 | IS-H: User-Defined Field 5 | ISH_PREGUSER5 | CHAR | 50 | ISH_PREGUSER5 | ||||
USER6 | IS-H: User-Defined Field 6 | ISH_PREGUSER6 | CHAR | 1 | ISH_PREGUSER6 | ||||
USER7 | IS-H: User-Defined Field 7 | ISH_PREGUSER7 | CHAR | 1 | ISH_PREGUSER7 | ||||
CORDERID | IS-H: CORD/PREG: Identification of a Clinical Order | N1CORDID | CHAR | 32 | SYSUUID_C | ||||
POSNR | Clinical Order Item Number | N1CORDPOSNR | NUMC | 3 | N1POSNR | ||||
APCNID | IS-H: Identification of an Appointment Template | N1APCNID | CHAR | 32 | SYSUUID_C | ||||
CORDTYPID | IS-H: CORD/PREG: Identification of the Clinical Order Type | N1COTID | CHAR | 32 | SYSUUID_C | ||||
OBJNR | Object number | J_OBJNR | CHAR | 22 | Assigned to domain | J_OBJNR | ONR | ||
PREREG | IS-H: CORD/PREG: Clinical Order Preregistered | N1CORDPREREG | CHAR | 1 | ISH_ON_OFF | ||||
TRTBY | IS-H: CORD/PREG: Clinical Order Filled By | N1CORDTRTBY | CHAR | 1 | N1CORDTRTBY | ||||
TRTOE | IS-H: CORD/PREG: Order Filler (Org. Unit) | N1CORDTRTOE | CHAR | 8 | Assigned to domain | ALPHA | ORGID | ||
TRTGP | Filler (Business Partner) | N1CORDTRTGP | CHAR | 10 | Assigned to domain | ALPHA | RI_KUNNR | ||
BEKATX | IS-H: Treatment Category Changed Manually | N1CORDBEKAT_MAN | CHAR | 1 | XFELD | ||||
TPAE | Transport Type | N1TPAE | CHAR | 2 | Assigned to domain | N1TPAE | |||
ERTIM | IS-H: Time when Data Record Created | ISH_ERTIM | TIMS | 6 | UHRZT | ||||
UPTIM | IS-H: Time Data Record was Last Changed | ISH_UPTIM | TIMS | 6 | UHRZT | ||||
STTIM | Time of Cancellation | ISH_STORN_TIM | TIMS | 6 | UHRZT | ||||
REQCOMPID | IS-H: CORD/PREG: Identification of a Request in CORD | N1REQCOMPID | NUMC | 8 | N1REQCOMPID | ||||
REQCOMPNR | IS-H: CORD/PREG: Request Number in Clinical Order | N1REQCOMPNR | CHAR | 8 | N1REQCOMPNR | ||||
BEWTY | Movement Category | BEWTY | CHAR | 1 | BEWTY | ||||
FATYP | Case Category | ISH_CASETYPE | CHAR | 2 | TN15C | ISH_CASETYPE | |||
CORDPTYPID | Identification of a Profile Type | N1COTID_PROF | CHAR | 32 | SYSUUID_C | ||||
NOCORDPTYP | Position Number of Profile Type | NOCORDPTYP | NUMC | 2 | |||||
ISTAT | CORD: Internal Item Status | N1CORDPOSISTAT | NUMC | 3 | N1CORDPOSISTAT |
Key field | Non-key field |
How do I retrieve data from SAP table N1VKG using ABAP code
The following ABAP code Example will allow you to do a basic selection on N1VKG to SELECT all data from the tableDATA: WA_N1VKG TYPE N1VKG.
SELECT SINGLE *
FROM N1VKG
INTO CORRESPONDING FIELDS OF WA_N1VKG
WHERE...
How to access SAP table N1VKG
Within an ECC or HANA version of SAP you can also view further information about N1VKG and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects