N_VPREG_BASIC SAP (Generated Table for View) Table View details
Dictionary Type: Table View
Description: Generated Table for View
Description: Generated Table for View
ABAP Code to SELECT data from N_VPREG_BASIC
Related tables to N_VPREG_BASIC
Access table N_VPREG_BASIC
Related tables to N_VPREG_BASIC
Access table N_VPREG_BASIC
Table View field list including key, data, relationships and ABAP select examples
N_VPREG_BASIC is a standard SAP Table View which is used to store Generated Table for View data and is available within R/3 SAP systems depending on the version and release level.
The N_VPREG_BASIC table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include CORDERID (IS-H: CORD/PREG: Identification of a Clinical Order), POSNR (Clinical Order Item Number), VKGID (IS-H: CORD/PREG: ID of an Order Item (Preregistration)), EINRI (Institution).. 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:Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Not classified
SAP N_VPREG_BASIC table view 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 | MANDT | ||||
CORDERID | IS-H: CORD/PREG: Identification of a Clinical Order | N1CORDID | CHAR | 32 | SYSUUID_C | ||||
POSNR | Clinical Order Item Number | N1CORDPOSNR | NUMC | 3 | N1POSNR | ||||
VKGID | IS-H: CORD/PREG: ID of an Order Item (Preregistration) | N1VKGID | NUMC | 8 | N1VKGID | ||||
EINRI | Institution | EINRI | CHAR | 4 | ALPHA | EINRI | EIN | ||
PATNR | IS-H: Patient Number | PATNR | CHAR | 10 | ALPHA | PATNR | PAT | ||
PAPID | IS-H: Provisional Patient Number | ISH_PAPID | CHAR | 10 | ALPHA | ISH_PAPID | |||
PVPAT | IS-H: Preregistered as Private Patient | N1PVPAT | CHAR | 1 | XFELD | ||||
ETRBY | IS-H: CORD/PREG: Clinical Order Initiated By | N1CORDETRBY | CHAR | 1 | N1CORDETRBY | ||||
ETROE | Initiating Organizational Unit | N1CORDETROE | CHAR | 8 | ALPHA | ORGID | |||
ETRMA | Initiating Employee/Business Partner | N1CORDETRGP | CHAR | 10 | ALPHA | RI_KUNNR | |||
CORDTITLE | IS-H: CORD/PREG: Title of Clinical Order | N1CORDTITLE | CHAR | 30 | N1CORDTITLE | ||||
PRGNR | Order Number | N1CORDNR | CHAR | 10 | ALPHA | N1CORDNR | |||
RCKRUF | Clinical Order - Callback Number | N1CORDRCKRUF | CHAR | 30 | N1CORDRCKRUF | ||||
KANAM | IS-H: CORD/PREG: Short Anamnesis for Clinical Order | N1CORDANAM | CHAR | 50 | TEXT50 | ||||
KALTX | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
FRAGE | IS-H: CORD/PREG: Questions | N1CORDFRAGE | CHAR | 50 | TEXT50 | ||||
FRLTX | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
BMVKG | Comment for Clinical Order | N1CORDBMKG | CHAR | 50 | TEXT50 | ||||
BMLTX | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
WLPRI | IS-H: Priority for Preregistration/Waiting List Management | WLPRI | CHAR | 2 | ALPHA | WLPRI | |||
WLTYP | IS-H: Waiting List | ISH_WLTYPE | CHAR | 6 | CHAR6 | ||||
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 | CHAR3 | ||||
VKGST | IS-H: Preregistration/Waiting List Status | ISH_WLSTATUS | CHAR | 2 | CHAR2 | ||||
WLHSP | IS-H: Waiting List Postdischarge Hospital | ISH_WLHOSP | CHAR | 10 | ALPHA | RI_KUNNR | |||
WLADT | IS-H: Date when Patient Added to Waiting List | ISH_WLADAT | DATS | 8 | DATUM | ||||
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 | ||||
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 | ||||
STTIME | Time of Cancellation | ISH_STORN_TIM | TIMS | 6 | UHRZT | ||||
STOID | IS-H: Cancellation Reason for Preregistration | N1STOID_PRG | CHAR | 3 | N1STOID | ||||
FALNR | IS-H: Case Number | FALNR | CHAR | 10 | ALPHA | FALNR | FAL | ||
FALAR | IS-H: Case Type | FALLART | CHAR | 1 | FALLART | ||||
BEWTY | Movement Category | BEWTY | CHAR | 1 | BEWTY | ||||
ORGFA | IS-H: Departmental Org. Unit in Preregistration | N1VKGFA | CHAR | 8 | ALPHA | ORGID | |||
BWART | IS-H: Movement Type | RI_BWART | CHAR | 2 | RI_BWART | ||||
BEKAT | Treatment Category | BEKAT | CHAR | 6 | ALPHA | BEHKATEG | |||
APCNID | IS-H: Identification of an Appointment Template | N1APCNID | CHAR | 32 | SYSUUID_C | ||||
TRTGP | Filler (Business Partner) | N1CORDTRTGP | CHAR | 10 | ALPHA | RI_KUNNR | |||
CORDTYPID | IS-H: CORD/PREG: Identification of the Clinical Order Type | N1COTID | CHAR | 32 | SYSUUID_C | ||||
PREREG | IS-H: CORD/PREG: Clinical Order Preregistered | N1CORDPREREG | CHAR | 1 | ISH_ON_OFF | ||||
EXTKH | IS-H: Referring Hospital | N1EXTKH | CHAR | 10 | NGPA | ALPHA | RI_KUNNR | ||
EARNR | IS-H: Referring Physician | N1EARNR | CHAR | 10 | NGPA | ALPHA | RI_KUNNR | ||
UARNR | IS-H: Referring Physician (Outpatients) | N1UARNR | CHAR | 10 | NGPA | ALPHA | RI_KUNNR | ||
RFSRC | IS-H: Referral, Postdischarge Treatment Type | ISH_REFSRC | CHAR | 2 | ALPHA | ISH_REFSRC | |||
HARNR | IS-H: Family Physician | N1HARNR | CHAR | 10 | NGPA | ALPHA | RI_KUNNR | ||
AUFDS | IS-H: Latest Admission Date | N1APCNAUFDS | DATS | 8 | |||||
WUZPI | IS-H: Desired Time Interpretation, Internal Format | N1APCNWUZPI | CHAR | 2 | N1APCNWUZPI | ||||
WUMNT | Desired Time (Month) | N1APCNWUMNT | CHAR | 2 | N1APCNWUMNT | ||||
WUJHR | Desired Time (Year) | N1APCNWUJHR | CHAR | 4 | N1APCNWUJHR | ||||
TRTOE | IS-H: Appointment Template: OU in which Appointment Occurs | N1APCNTRTOE | CHAR | 8 | ALPHA | ORGID | |||
TRDRN | IS-H: Default Duration for a Treatment Appointment | ISH_APTIME_PDF | NUMC | 4 | ISH_DZEIT | ||||
TROOM | IS-H: Default Room for a Treatment Appointment | ISH_TR_ROOM_PDF | CHAR | 8 | ALPHA | BAUID | |||
TPERNR | IS-H: Attending Person | N1APCNPERNR | CHAR | 10 | ALPHA | RI_KUNNR | |||
WDATE | Desired Date | N1APCNWDATE | DATS | 8 | |||||
WTIME | Desired Time | N1APCNWTIME | TIMS | 6 | |||||
WDISP | IS-H: Outpatient Scheduling Type | N1APCNWDISP | CHAR | 8 | ISH_DSPTC8 | ||||
WPTINP | IS-H: Inpatient Scheduling Type | N1APCNWPTINP | CHAR | 8 | ISH_DSPTC8 | ||||
ORDPRI | Prioritization for Request/Movement (Internal) | N1APRI_D | NUMC | 3 | N1APRI |
Key field | Non-key field |
How do I retrieve data from SAP table N_VPREG_BASIC using ABAP code
The following ABAP code Example will allow you to do a basic selection on N_VPREG_BASIC to SELECT all data from the tableDATA: WA_N_VPREG_BASIC TYPE N_VPREG_BASIC.
SELECT SINGLE *
FROM N_VPREG_BASIC
INTO CORRESPONDING FIELDS OF WA_N_VPREG_BASIC
WHERE...
How to access SAP table N_VPREG_BASIC
Within an ECC or HANA version of SAP you can also view further information about N_VPREG_BASIC 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