SAP ABAP View N_VNDAE (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_VNDAE
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	NDOC
3	NPAT

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	NDOC	MANDT	JL	EQ				0	0
2	NDAE	MANDT	JR	EQ			AND	0	0
3	NDOC	DOKAR	JL	EQ				0	0
4	NDAE	DOKAR	JR	EQ			AND	0	0
5	NDOC	DOKNR	JL	EQ				0	0
6	NDAE	DOKNR	JR	EQ			AND	0	0
7	NDOC	DOKVR	JL	EQ				0	0
8	NDAE	DOKVR	JR	EQ			AND	0	0
9	NDOC	DOKTL	JL	EQ				0	0
10	NDAE	DOKTL	JR	EQ			AND	0	0
11	NPAT	MANDT	JL	EQ				0	0
12	NDOC	MANDT	JR	EQ			AND	0	0
13	NPAT	PATNR	JL	EQ				0	0
14	NDOC	PATNR	JR	EQ			AND	0	0
15	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	ORGFORM	NDOC	ORGFORM		☐	ORGFORM	☐	IS-H: Organization Form for Medical Record Management
22	EXTNR	NDOC	EXTNR		☐	ISH_DOCEXT	☐	IS-H: External Medical Record/Document ID
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	ORGDO	NDOC	ORGDO		☐	ORGDO	☐	Documenting Organizational Unit
29	STORN	NDOC	STORN		☐	RI_STORN	☐	IS-H: Cancellation Indicator
30	MEDOK	NDOC	MEDOK		☐	MEDOK	☐	Indicator for a Medical Document
31	ARCHIV	NDOC	ARCHIV		☐	ARCHIV_ID	☐	IS-H: Organizational ID of the medical record archive
32	STANDORT	NDOC	STANDORT		☐	ISH_ARCHST	☐	IS-H: Building ID of building unit in the 'archive' OU
33	ROLLNO	NDOC	ROLLNO		☐	ISH_ROLLNO	☐	IS-H: Roll Number of a Micro Film
34	MICROF	NDOC	MICROF		☐	ISH_MICROF	☐	IS-H: Patient's medical record is microfilmed
35	INFOMR	NDOC	INFOMR		☐	ISH_INFOMR	☐	IS-H: Informational Text for Medical Record
36	TEMPMR	NDOC	TEMPMR		☐	ISH_TEMPMR	☐	IS-H: Flags a Medical Record as Temporary Medical Record
37	ALBUM	NDOC	ALBUM		☐	ISH_ALBUM	☐	IS-H: Album Id for microfilm
38	MFYEAR	NDOC	MFYEAR		☐	ISH_MFYEAR	☐	IS-H: Year Until when Data Archived on Microfilm
39	GSCHL	NPAT	GSCHL		☐	GSCHL	☐	IS-H: Sex Indicator - Internal
40	NNAME	NPAT	NNAME		☐	NNAME_PAT	☐	IS-H: Patient Last Name
41	VNAME	NPAT	VNAME		☐	VNAME_PAT	☐	IS-H: Patient First Name
42	NNAMS	NPAT	NNAMS		☐	NNAMES_PAT	☐	IS-H: Standardized Last Name
43	VNAMS	NPAT	VNAMS		☐	VNAMES_PAT	☐	Standardized First Name
44	TITEL	NPAT	TITEL		☐	RI_TITEL	☐	IS-H: Title
45	NAMZU	NPAT	NAMZU		☐	RI_NAMZU	☐	IS-H: Name Affix
46	VORSW	NPAT	VORSW		☐	RI_VORSW	☐	IS-H: Name Prefix
47	GBDAT	NPAT	GBDAT		☐	RI_GBDAT	☐	IS-H: Birthdate
48	PATEX	NPAT	EXTNR		☐	EXT_PATNR	☐	IS-H: External Patient Identification
49	REDO_KZ	NDOC	REDO_KZ		☐	ISH_REDO_KZ	☐	IS-H: Indicator for Renewable Document Management

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	20130529
SAP Release Created in