SAP ABAP View N_VDEADOK (IS-H: View for evaluations of borrowing)

Hierarchy

☛ BBPCRM (Software Component) BBPCRM
   ⤷ CRM (Application Component) Customer Relationship Management
     ⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
       ⤷ NPVS (Package) Application development patient management system

Basic Data

View Type	D	Database View
Database View	N_VDEADOK
Short Description	IS-H: View for evaluations of borrowing
Root table	NDAE	IS-H: Requesting/borrowing medical records

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	NDAE	NDAE
2	DRAW
3	NDOC
4	NPAT

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	NDAE	MANDT	JR	EQ			AND	0	0
3	DRAW	DOKAR	JL	EQ				0	0
4	NDAE	DOKAR	JR	EQ			AND	0	0
5	DRAW	DOKNR	JL	EQ				0	0
6	NDAE	DOKNR	JR	EQ			AND	0	0
7	DRAW	DOKVR	JL	EQ				0	0
8	NDAE	DOKVR	JR	EQ			AND	0	0
9	DRAW	DOKTL	JL	EQ				0	0
10	NDAE	DOKTL	JR	EQ			AND	0	0
11	DRAW	MANDT	JL	EQ				0	0
12	NDOC	MANDT	JR	EQ			AND	0	0
13	DRAW	DOKAR	JL	EQ				0	0
14	NDOC	DOKAR	JR	EQ			AND	0	0
15	DRAW	DOKNR	JL	EQ				0	0
16	NDOC	DOKNR	JR	EQ			AND	0	0
17	DRAW	DOKVR	JL	EQ				0	0
18	NDOC	DOKVR	JR	EQ			AND	0	0
19	DRAW	DOKTL	JL	EQ				0	0
20	NDOC	DOKTL	JR	EQ			AND	0	0
21	NPAT	MANDT	JL	EQ				0	0
22	NDOC	MANDT	JR	EQ			AND	0	0
23	NPAT	PATNR	JL	EQ				0	0
24	NDOC	PATNR	JR	EQ			AND	0	0
25	NDOC	LFDDOK		EQ	0000000000			0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	NDAE	MANDT		☐	MANDT	☐	Client
2	DOKAR	NDAE	DOKAR		☐	DOKAR	☐	Document Type
3	DOKNR	NDAE	DOKNR		☐	DOKNR	☐	Document number
4	DOKVR	NDAE	DOKVR		☐	DOKVR	☐	Document version
5	DOKTL	NDAE	DOKTL		☐	DOKTL_D	☐	Document part
6	ENTLEIHER	NDAE	ENTLEIHER		☐	ENTLEIHNR	☐	Borrower for Document Management
7	ENTLTYP	NDAE	ENTLTYP		☐	ENTLEIHTYP	☐	IS-H: Borrower Category
8	LEIHDAT	NDAE	LEIHDAT		☐	ISH_LEIDAT	☐	IS-H: Date at which a Medical Record Is Borrowed/Requested
9	LEIZEIT	NDAE	LEIZEIT		☐	ISH_LEIZEI	☐	IS-H: Borrowing time
10	LFDDOK	NDOC	LFDDOK		☐	LFDDOK	☐	Sequence Number of Document
11	ORGKR	NDAE	ORGKR		☐	ORGKREIS	☐	IS-H: Organizational group for borrowing authorizations
12	ENTZW	NDAE	ENTZW		☐	ISH_ENTLZW	☐	IS-H: Reason for Borrowing Medical Record/Document
13	RUEKDAT	NDAE	RUEKDAT		☐	ISH_RUEKDT	☐	IS-H: Date Medical Record Returned
14	STATUS	NDAE	STATUS		☐	ISH_LEISTA	☐	IS-H: Borrowing Status
15	ANZMAH	NDAE	ANZMAH		☐	ISH_ANZMAH	☐	IS-H: Number of Reminders for Medical Records
16	ERMAHN	NDAE	ERMAHN		☐	ISH_AKM1DT	☐	IS-H: Date of 1st Reminder for Medical Record
17	LEMAHN	NDAE	LEMAHN		☐	ISH_AKM2DT	☐	IS-H: Date of Last Reminder
18	ENTTEXT	NDAE	ENTTEXT		☐	TEXTENT	☐	IS-H: Comment on Borrowing Episode
19	ENTLEND	NDAE	ENTLEND		☐	ISH_ENTLEN	☐	IS-H: Scheduled Borrowed-To Date
20	VERANTW	NDAE	VERANTW		☐	VERANTWORT	☐	IS-H: Person Responsible for Medical Records/Documents
21	RES1	DRAW	RES1		☐	RESDRAW	☐	Reserve field DRAW
22	RES3	DRAW	RES3		☐	RESDRAW	☐	Reserve field DRAW
23	ORGFORM	NDOC	ORGFORM		☐	ORGFORM	☐	IS-H: Organization Form for Medical Record Management
24	PATNR	NDOC	PATNR		☐	PATNR	☐	IS-H: Patient Number
25	FALNR	NDOC	FALNR		☐	FALNR	☐	IS-H: Case Number
26	FALAR	NDOC	FALAR		☐	FALLART	☐	IS-H: Case Type
27	ORGFA	NDOC	ORGFA		☐	NZUWFA	☐	IS-H: OU with Departmental Responsibility for Case
28	ORGPF	NDOC	ORGPF		☐	NZUWPF	☐	Organizational Unit Assigned to Case
29	ORGDO	NDOC	ORGDO		☐	ORGDO	☐	Documenting Organizational Unit
30	NNAME	NPAT	NNAME		☐	NNAME_PAT	☐	IS-H: Patient Last Name
31	VNAME	NPAT	VNAME		☐	VNAME_PAT	☐	IS-H: Patient First Name
32	TITEL	NPAT	TITEL		☐	RI_TITEL	☐	IS-H: Title
33	NAMZU	NPAT	NAMZU		☐	RI_NAMZU	☐	IS-H: Name Affix
34	VORSW	NPAT	VORSW		☐	RI_VORSW	☐	IS-H: Name Prefix
35	GBDAT	NPAT	GBDAT		☐	RI_GBDAT	☐	IS-H: Birthdate

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