SAP ABAP Table N_2VDOCDRA (Generated Table for View)

Basic Data

Table Category	VIEW	General view structure
General view structure	N_2VDOCDRA	Table Relationship Diagram
Short Description	Generated Table for View

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	MANDT	☑	MANDT	MANDT	CLNT	3	0	Client	T000
2	DOKAR	☑	DOKAR	DOKAR	CHAR	3	0	Document Type	TDWA
3	DOKNR	☑	DOKNR	DOKNR	CHAR	25	0	Document number	DRAW
4	DOKVR	☑	DOKVR	DOKVR	CHAR	2	0	Document version
5	DOKTL	☑	DOKTL_D	DOKTL	CHAR	3	0	Document part
6	LFDDOK	☑	LFDDOK	INT4_NOS	INT4	10	0	Sequence Number of Document
7	DWNAM	☐	DWNAM	DWNAM	CHAR	12	0	Name of person responsible
8	DOKST	☐	DOKST	DOKST	CHAR	2	0	Document Status	TDWS
9	LABOR	☐	LABOR	LABOR	CHAR	3	0	Laboratory/design office	T024L
10	LOEDK	☐	LOEDK	XFELD	CHAR	1	0	Deletion indicator
11	BEGRU	☐	BEGRU	BEGRU	CHAR	4	0	Authorization Group
12	FILEP	☐	FILEP	TEXT255	CHAR	255	0	Original of document
13	DAPPL	☐	DAPPL	DAPPL	CHAR	3	0	Application	TDWP
14	FILEP1	☐	FILEP	TEXT255	CHAR	255	0	Original of document
15	DAPPL1	☐	DAPPL	DAPPL	CHAR	3	0	Application	TDWP
16	VPRIOR	☐	VPRIOR	NUMC01	NUMC	1	0	Processing priority
17	RES1	☐	RESDRAW	CHAR14	CHAR	14	0	Reserve field DRAW
18	RES2	☐	RESDRAW	CHAR14	CHAR	14	0	Reserve field DRAW
19	RES3	☐	RESDRAW	CHAR14	CHAR	14	0	Reserve field DRAW
20	RES4	☐	RESDRAW	CHAR14	CHAR	14	0	Reserve field DRAW
21	ORGFORM	☐	ORGFORM	ORGFORM	CHAR	1	0	IS-H: Organization Form for Medical Record Management
22	EINRI	☐	EINRI	EINRI	CHAR	4	0	IS-H: Institution	TN01
23	PATNR	☐	PATNR	PATNR	CHAR	10	0	IS-H: Patient Number	NPAT
24	FALNR	☐	FALNR	FALNR	CHAR	10	0	IS-H: Case Number	NFAL
25	FALAR	☐	FALLART	FALLART	CHAR	1	0	IS-H: Case Type
26	ORGFA	☐	NZUWFA	ORGID	CHAR	8	0	IS-H: OU with Departmental Responsibility for Case	NORG
27	ORGPF	☐	NZUWPF	ORGID	CHAR	8	0	Organizational Unit Assigned to Case	NORG
28	ORGLE	☐	ERBOE	ORGID	CHAR	8	0	IS-H: Organizational Unit that Performs the Service	NORG
29	ORGLA	☐	ANPOE	ORGID	CHAR	8	0	IS-H: Nursing Org. Unit Requesting Service	NORG
30	ORGDO	☐	ORGDO	ORGID	CHAR	8	0	Documenting Organizational Unit	NORG
31	LEIST	☐	TARLS	TARLS	CHAR	10	0	IS-H: Service in Service Catalog	NLEI
32	LNRLS	☐	LNRLS	LNRLS	CHAR	10	0	IS-H: Service Sequence Number
33	ANFID	☐	ANFID	ANFID	NUMC	8	0	Identification of a Request (Number)	N1ANF
34	LFDBEW	☐	LFDBEW	LFDBEW	NUMC	5	0	IS-H: Sequence Number of Movement	NBEW
35	MITARB	☐	N1MITARB	RI_KUNNR	CHAR	10	0	Employee Responsible	NGPA
36	DTID	☐	N2_DTID	N2_DTID	CHAR	10	0	Document Category ID	N2DT
37	DTVERS	☐	N2_VERS	N2_VERS	NUMC	3	0	Version Number
38	BERST	☐	N2_BERST	NUMC01	NUMC	1	0	Authorization level
39	BEZEB	☐	BEZEB	BEZEB	CHAR	1	0	Reference Level of a Document
40	MEDOK	☐	MEDOK	XFELD	CHAR	1	0	Indicator for a Medical Document
41	PCODE	☐	N2_PCODE	CHAR4	CHAR	4	0	Special Indicator (Presentation Code)	TN2FLAG
42	DODAT	☐	N2_DODAT	RI_DATUM	DATS	8	0	Document Date
43	DOTIM	☐	N2_DOTIM	UHRZT	TIMS	6	0	Document Time
44	ERUSR	☐	RI_ERNAM	USNAM	CHAR	12	0	IS-H: Name of Employee who Created Record
45	ERDAT	☐	RI_ERDAT	RI_DATUM	DATS	8	0	IS-H: Date when Record Created
46	ERTIM	☐	RI_ERTIM	UHRZT	TIMS	6	0	IS-H: Time Record Created
47	LOEKZ	☐	RI_LOEKZ	XFELD	CHAR	1	0	Deletion Flag/Indicator
48	LOUSR	☐	RI_LOUSR	USNAM	CHAR	12	0	IS-H: User who Deleted Record
49	LODAT	☐	RI_LODAT	RI_DATUM	DATS	8	0	IS-H: Date of Deletion
50	LOTIM	☐	RI_LOTIM	UHRZT	TIMS	6	0	Deletion Time
51	UPUSR	☐	RI_UPNAM	USNAM	CHAR	12	0	IS-H: Name of Person who Last Changed Data
52	UPDAT	☐	RI_UPDAT	RI_DATUM	DATS	8	0	IS-H: Date of Last Change
53	UPTIM	☐	RI_UPTIM	UHRZT	TIMS	6	0	IS-H: Time of Last Change
54	STORELOC	☐	N2_STORELOC	N2_STORELOC	CHAR	1	0	Storage Location / Archive
55	ROLLNO	☐	ISH_ROLLNO	CHAR10	CHAR	10	0	IS-H: Roll Number of a Micro Film
56	MICROF	☐	ISH_MICROF	XFELD	CHAR	1	0	IS-H: Patient's medical record is microfilmed
57	EXTNR	☐	ISH_DOCEXT	CHAR15	CHAR	15	0	IS-H: External Medical Record/Document ID
58	ALBUM	☐	ISH_ALBUM	CHAR10	CHAR	10	0	IS-H: Album Id for microfilm
59	STORELOC2	☐	N2_STORELOC2	N2_STORELOC2	CHAR	1	0	Storage Location (Only Used Internally)

Foreign Keys

	Source Table	Source Column	Foreign Table	Foreign Column	Dependency Factor	Cardinality left	Cardinality right
1	N_2VDOCDRA	ANFID	N1ANF	ANFID	KEY	1	CN
2	N_2VDOCDRA	DAPPL	TDWP	DAPPL	KEY	1	CN
3	N_2VDOCDRA	DAPPL1	TDWP	DAPPL	KEY	1	CN
4	N_2VDOCDRA	DOKAR	TDWA	DOKAR	KEY	1	CN
5	N_2VDOCDRA	DOKNR	DRAW	DOKNR	KEY	1	CN
6	N_2VDOCDRA	DOKST	TDWS	DOKST	KEY	1	CN
7	N_2VDOCDRA	DTID	N2DT	DTID
8	N_2VDOCDRA	EINRI	TN01	EINRI	KEY	1	CN
9	N_2VDOCDRA	FALNR	NFAL	FALNR	KEY	1	CN
10	N_2VDOCDRA	LABOR	T024L	LABOR	KEY	1	CN
11	N_2VDOCDRA	LEIST	NLEI	LEIST	KEY	1	CN
12	N_2VDOCDRA	LFDBEW	NBEW	LFDNR
13	N_2VDOCDRA	MANDT	T000	MANDT	KEY	1	CN
14	N_2VDOCDRA	MITARB	NGPA	GPART
15	N_2VDOCDRA	ORGDO	NORG	ORGID	KEY	1	CN
16	N_2VDOCDRA	ORGFA	NORG	ORGID
17	N_2VDOCDRA	ORGLA	NORG	ORGID	KEY	1	CN
18	N_2VDOCDRA	ORGLE	NORG	ORGID	KEY	1	CN
19	N_2VDOCDRA	ORGPF	NORG	ORGID	KEY	1	CN
20	N_2VDOCDRA	PATNR	NPAT	PATNR	KEY	1	CN
21	N_2VDOCDRA	PCODE	TN2FLAG	FLAGID

History

Last changed by/on	SAP	20140121
SAP Release Created in