N_VPREG_BASIC SAP (Generated Table for View) Table View details

Dictionary Type: Table 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




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
MANDTClient MANDTCLNT3MANDT
CORDERIDIS-H: CORD/PREG: Identification of a Clinical Order N1CORDIDCHAR32SYSUUID_C
POSNRClinical Order Item Number N1CORDPOSNRNUMC3N1POSNR
VKGIDIS-H: CORD/PREG: ID of an Order Item (Preregistration) N1VKGIDNUMC8N1VKGID
EINRIInstitution EINRICHAR4ALPHAEINRIEIN
PATNRIS-H: Patient Number PATNRCHAR10ALPHAPATNRPAT
PAPIDIS-H: Provisional Patient Number ISH_PAPIDCHAR10ALPHAISH_PAPID
PVPATIS-H: Preregistered as Private Patient N1PVPATCHAR1XFELD
ETRBYIS-H: CORD/PREG: Clinical Order Initiated By N1CORDETRBYCHAR1N1CORDETRBY
ETROEInitiating Organizational Unit N1CORDETROECHAR8ALPHAORGID
ETRMAInitiating Employee/Business Partner N1CORDETRGPCHAR10ALPHARI_KUNNR
CORDTITLEIS-H: CORD/PREG: Title of Clinical Order N1CORDTITLECHAR30N1CORDTITLE
PRGNROrder Number N1CORDNRCHAR10ALPHAN1CORDNR
RCKRUFClinical Order - Callback Number N1CORDRCKRUFCHAR30N1CORDRCKRUF
KANAMIS-H: CORD/PREG: Short Anamnesis for Clinical Order N1CORDANAMCHAR50TEXT50
KALTXIndicator that Long Text Exists RI_LGTXTCHAR1XFELD
FRAGEIS-H: CORD/PREG: Questions N1CORDFRAGECHAR50TEXT50
FRLTXIndicator that Long Text Exists RI_LGTXTCHAR1XFELD
BMVKGComment for Clinical Order N1CORDBMKGCHAR50TEXT50
BMLTXIndicator that Long Text Exists RI_LGTXTCHAR1XFELD
WLPRIIS-H: Priority for Preregistration/Waiting List Management WLPRICHAR2ALPHAWLPRI
WLTYPIS-H: Waiting List ISH_WLTYPECHAR6CHAR6
WLRDTIS-H: Date when Movement Removed From Waiting List ISH_WLRDATDATS8DATUM
WLRRNIS-H: Reason for Removal from Waiting List ISH_WLRRSNCHAR3CHAR3
VKGSTIS-H: Preregistration/Waiting List Status ISH_WLSTATUSCHAR2CHAR2
WLHSPIS-H: Waiting List Postdischarge Hospital ISH_WLHOSPCHAR10ALPHARI_KUNNR
WLADTIS-H: Date when Patient Added to Waiting List ISH_WLADATDATS8DATUM
USER1IS-H: User-Defined Field 1 ISH_PREGUSER1CHAR20ISH_PREGUSER1
USER2IS-H: User-Defined Field 2 ISH_PREGUSER2CHAR20ISH_PREGUSER2
USER3IS-H: User-Defined Field 3 ISH_PREGUSER3DATS8ISH_PREGUSER3
USER4IS-H: User-Defined Field 4 ISH_PREGUSER4DATS8ISH_PREGUSER4
USER5IS-H: User-Defined Field 5 ISH_PREGUSER5CHAR50ISH_PREGUSER5
USER6IS-H: User-Defined Field 6 ISH_PREGUSER6CHAR1ISH_PREGUSER6
USER7IS-H: User-Defined Field 7 ISH_PREGUSER7CHAR1ISH_PREGUSER7
ERDATIS-H: Date when Record Created RI_ERDATDATS8RI_DATUM
ERUSRIS-H: Name of Employee who Created Record RI_ERNAMCHAR12USNAM
UPDATIS-H: Date of Last Change RI_UPDATDATS8RI_DATUM
UPUSRIS-H: Name of Person who Last Changed Data RI_UPNAMCHAR12USNAM
STORNIS-H: Cancellation Indicator RI_STORNCHAR1XFELD
STUSRIS-H: Name of User who Canceled Data Record STORN_USERCHAR12USNAM
STDATDate of Cancellation STORN_DATDATS8RI_DATUM
STTIMETime of Cancellation ISH_STORN_TIMTIMS6UHRZT
STOIDIS-H: Cancellation Reason for Preregistration N1STOID_PRGCHAR3N1STOID
FALNRIS-H: Case Number FALNRCHAR10ALPHAFALNRFAL
FALARIS-H: Case Type FALLARTCHAR1FALLART
BEWTYMovement Category BEWTYCHAR1BEWTY
ORGFAIS-H: Departmental Org. Unit in Preregistration N1VKGFACHAR8ALPHAORGID
BWARTIS-H: Movement Type RI_BWARTCHAR2RI_BWART
BEKATTreatment Category BEKATCHAR6ALPHABEHKATEG
APCNIDIS-H: Identification of an Appointment Template N1APCNIDCHAR32SYSUUID_C
TRTGPFiller (Business Partner) N1CORDTRTGPCHAR10ALPHARI_KUNNR
CORDTYPIDIS-H: CORD/PREG: Identification of the Clinical Order Type N1COTIDCHAR32SYSUUID_C
PREREGIS-H: CORD/PREG: Clinical Order Preregistered N1CORDPREREGCHAR1ISH_ON_OFF
EXTKHIS-H: Referring Hospital N1EXTKHCHAR10NGPAALPHARI_KUNNR
EARNRIS-H: Referring Physician N1EARNRCHAR10NGPAALPHARI_KUNNR
UARNRIS-H: Referring Physician (Outpatients) N1UARNRCHAR10NGPAALPHARI_KUNNR
RFSRCIS-H: Referral, Postdischarge Treatment Type ISH_REFSRCCHAR2ALPHAISH_REFSRC
HARNRIS-H: Family Physician N1HARNRCHAR10NGPAALPHARI_KUNNR
AUFDSIS-H: Latest Admission Date N1APCNAUFDSDATS8
WUZPIIS-H: Desired Time Interpretation, Internal Format N1APCNWUZPICHAR2N1APCNWUZPI
WUMNTDesired Time (Month) N1APCNWUMNTCHAR2N1APCNWUMNT
WUJHRDesired Time (Year) N1APCNWUJHRCHAR4N1APCNWUJHR
TRTOEIS-H: Appointment Template: OU in which Appointment Occurs N1APCNTRTOECHAR8ALPHAORGID
TRDRNIS-H: Default Duration for a Treatment Appointment ISH_APTIME_PDFNUMC4ISH_DZEIT
TROOMIS-H: Default Room for a Treatment Appointment ISH_TR_ROOM_PDFCHAR8ALPHABAUID
TPERNRIS-H: Attending Person N1APCNPERNRCHAR10ALPHARI_KUNNR
WDATEDesired Date N1APCNWDATEDATS8
WTIMEDesired Time N1APCNWTIMETIMS6
WDISPIS-H: Outpatient Scheduling Type N1APCNWDISPCHAR8ISH_DSPTC8
WPTINPIS-H: Inpatient Scheduling Type N1APCNWPTINPCHAR8ISH_DSPTC8
ORDPRIPrioritization for Request/Movement (Internal) N1APRI_DNUMC3N1APRI

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 table
DATA: 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 as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!