N_2VDOCDRA SAP (Generated Table for View) Table View details

Dictionary Type: Table View
Description: Generated Table for View




ABAP Code to SELECT data from N_2VDOCDRA
Related tables to N_2VDOCDRA
Access table N_2VDOCDRA




Table View field list including key, data, relationships and ABAP select examples

N_2VDOCDRA 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_2VDOCDRA table consists of various fields, each holding specific information or linking keys about Generated Table for View data available in SAP. These include DOKAR (Document Type), DOKNR (Document number), DOKVR (Document Version), DOKTL (Document Part).. 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_2VDOCDRA 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 MANDTCLNT3T000MANDT
DOKARDocument Type DOKARCHAR3TDWADOKARCV2
DOKNRDocument number DOKNRCHAR25DRAWALPHADOKNRCV1
DOKVRDocument Version DOKVRCHAR2DOKVRCV3
DOKTLDocument Part DOKTL_DCHAR3DOKTLCV4
LFDDOKSequence Number of Document LFDDOKINT410INT4_NOS
DWNAMName of person responsible DWNAMCHAR12DWNAM
DOKSTDocument Status DOKSTCHAR2TDWSDOKST
LABORLaboratory/design office LABORCHAR3T024LLABOR
LOEDKDeletion indicator LOEDKCHAR1XFELD
BEGRUAuthorization Group BEGRUCHAR4BEGRU
FILEPOriginal of document FILEPCHAR255TEXT255
DAPPLApplication DAPPLCHAR3TDWPDAPPL
FILEP1Original of document FILEPCHAR255TEXT255
DAPPL1Application DAPPLCHAR3TDWPDAPPL
VPRIORProcessing priority VPRIORNUMC1NUMC01
RES1Reserve field DRAW RESDRAWCHAR14CHAR14
RES2Reserve field DRAW RESDRAWCHAR14CHAR14
RES3Reserve field DRAW RESDRAWCHAR14CHAR14
RES4Reserve field DRAW RESDRAWCHAR14CHAR14
ORGFORMIS-H: Organization Form for Medical Record Management ORGFORMCHAR1ORGFORM
EINRIInstitution EINRICHAR4TN01ALPHAEINRIEIN
PATNRIS-H: Patient Number PATNRCHAR10NPATALPHAPATNRPAT
FALNRIS-H: Case Number FALNRCHAR10NFALALPHAFALNRFAL
FALARIS-H: Case Type FALLARTCHAR1FALLART
ORGFAIS-H: OU with Departmental Responsibility for Case NZUWFACHAR8NORGALPHAORGID
ORGPFOrganizational Unit Assigned to Case NZUWPFCHAR8NORGALPHAORGID
ORGLEIS-H: Organizational Unit that Performs the Service ERBOECHAR8NORGALPHAORGID
ORGLAIS-H: Nursing Organizational Unit Requesting the Service ANPOECHAR8NORGALPHAORGID
ORGDODocumenting Organizational Unit ORGDOCHAR8NORGALPHAORGIDOED
LEISTService in Service Catalog TARLSCHAR10NLEIALPHATARLSTAL
LNRLSIS-H: Service Sequence Number LNRLSCHAR10ALPHALNRLS
ANFIDIdentification of a Request (Number) ANFIDNUMC8N1ANFANFID
LFDBEWIS-H: Sequence Number of Movement LFDBEWNUMC5NBEWLFDBEW
MITARBEmployee Responsible N1MITARBCHAR10NGPAALPHARI_KUNNRVMA
DTIDDocument Category ID N2_DTIDCHAR10N2DTN2_DTIDDTYN2_DTID
DTVERSVersion Number N2_VERSNUMC3N2_VERS
BERSTObsolete: Authorization Level N2_BERSTNUMC1NUMC01
BEZEBReference Level of a Document BEZEBCHAR1BEZEB
MEDOKIndicator for a Medical Document MEDOKCHAR1XFELD
PCODESpecial Indicator (Presentation Code) N2_PCODECHAR4TN2FLAGCHAR4
DODATDocument Date N2_DODATDATS8RI_DATUM
DOTIMDocument Time N2_DOTIMTIMS6UHRZT
ERUSRIS-H: Name of Employee who Created Record RI_ERNAMCHAR12USNAM
ERDATIS-H: Date when Record Created RI_ERDATDATS8RI_DATUM
ERTIMIS-H: Time Record Created RI_ERTIMTIMS6UHRZT
LOEKZDeletion Flag/Indicator RI_LOEKZCHAR1XFELD
LOUSRUser Who Deleted Record RI_LOUSRCHAR12USNAM
LODATDate of Deletion RI_LODATDATS8RI_DATUM
LOTIMDeletion Time RI_LOTIMTIMS6UHRZT
UPUSRIS-H: Name of Person who Last Changed Data RI_UPNAMCHAR12USNAM
UPDATIS-H: Date of Last Change RI_UPDATDATS8RI_DATUM
UPTIMIS-H: Time of Last Change RI_UPTIMTIMS6UHRZT
STORELOCStorage Location / Archive N2_STORELOCCHAR1N2_STORELOC
ROLLNOIS-H: Roll Number of a Micro Film ISH_ROLLNOCHAR10CHAR10
MICROFIS-H: Patient's medical record is microfilmed ISH_MICROFCHAR1XFELD
EXTNRIS-H: External Medical Record/Document ID ISH_DOCEXTCHAR15CHAR15
ALBUMIS-H: Album Id for microfilm ISH_ALBUMCHAR10CHAR10
STORELOC2Storage Location (Only Used Internally) N2_STORELOC2CHAR1N2_STORELOC2

Key field Non-key field



How do I retrieve data from SAP table N_2VDOCDRA using ABAP code

The following ABAP code Example will allow you to do a basic selection on N_2VDOCDRA to SELECT all data from the table
DATA: WA_N_2VDOCDRA TYPE N_2VDOCDRA.

SELECT SINGLE *
FROM N_2VDOCDRA
INTO CORRESPONDING FIELDS OF WA_N_2VDOCDRA
WHERE...

How to access SAP table N_2VDOCDRA

Within an ECC or HANA version of SAP you can also view further information about N_2VDOCDRA 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!