SAP ABAP View N_2VDOCDRA (IS-H*MED: Database view of NDOC and DRAW)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NMED (Package) R/3MED: Medical documentation GSD

Basic Data

View Type	D	Database View
Database View	N_2VDOCDRA
Short Description	IS-H*MED: Database view of NDOC and DRAW
Root table	NDOC	IS-H: Assignment of IS-H Objects to Documents in DMS

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	NDOC	NDOC
2	DRAW

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	DRAW	MANDT	JL	EQ				0	0
2	NDOC	MANDT	JR	EQ			AND	0	0
3	DRAW	DOKAR	JL	EQ				0	0
4	NDOC	DOKAR	JR	EQ			AND	0	0
5	DRAW	DOKNR	JL	EQ				0	0
6	NDOC	DOKNR	JR	EQ			AND	0	0
7	DRAW	DOKVR	JL	EQ				0	0
8	NDOC	DOKVR	JR	EQ			AND	0	0
9	DRAW	DOKTL	JL	EQ				0	0
10	NDOC	DOKTL	JR	EQ				0	0

View Fields

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

Maintenance Status

Access

☑   read only

☐   read and change

☐   Time-dependent views: like U, validity data like ' '

☐   read, change, delete and insert

Delivery Class
Data Browser/Table View Maintenance	Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20140121
SAP Release Created in