SAP ABAP View N_PAP_PIX (IS-H: View on NPAP and NPAPIX (Search Name Index PreregPat.))

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_PAP_PIX
Short Description	IS-H: View on NPAP and NPAPIX (Search Name Index PreregPat.)
Root table	NPAPIX	IS-H: Preregistered Patient Name Index

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	NPAPIX	NPAPIX
2	NPAP

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field
1	NPAP	MANDT	JL	EQ				0	0
2	NPAPIX	MANDT	JR	EQ			AND	0	0
3	NPAP	PAPID	JL	EQ				0	0
4	NPAPIX	PAPID	JR	EQ				0	0

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	NPAPIX	MANDT		☐	MANDT	☐	Client
2	NNAMS	NPAPIX	NNAMS		☐	NNAMES_PAT	☐	IS-H: Standardized Last Name
3	NNAME	NPAPIX	NNAME		☐	NNAME_PAT	☐	IS-H: Patient Last Name
4	CH_NAME	NPAPIX	CH_NAME		☐	CH_NAME	☐	IS-H: Indicator for changed last name
5	VNAMS	NPAPIX	VNAMS		☐	VNAMES_PAT	☐	Standardized First Name
6	PAPID	NPAPIX	PAPID		☐	ISH_PAPID	☐	IS-H: Provisional Patient Number
7	VNAME	NPAP	VNAME		☐	VNAME_PAT	☐	IS-H: Patient First Name
8	GBNAM	NPAP	GBNAM		☐	GBNAM	☐	IS-H: Birthname
9	GBNAS	NPAP	GBNAS		☐	GBNAMS_PAT	☐	IS-H: Standardized Birthname
10	GBDAT	NPAP	GBDAT		☐	RI_GBDAT	☐	IS-H: Birthdate
11	GSCHL	NPAP	GSCHL		☐	GSCHL	☐	IS-H: Sex Indicator - Internal
12	TITEL	NPAP	TITEL		☐	RI_TITEL	☐	IS-H: Title
13	NAMZU	NPAP	NAMZU		☐	RI_NAMZU	☐	IS-H: Name Affix
14	VORSW	NPAP	VORSW		☐	RI_VORSW	☐	IS-H: Name Prefix
15	ANRED	NPAP	ANRED		☐	RI_ANRDS	☐	IS-H: Form-of-Address Key
16	EXTNR	NPAP	EXTNR		☐	EXT_PATNR	☐	IS-H: External Patient Identification
17	RVNUM	NPAP	RVNUM		☐	ISH_RVNUM	☐	IS-H: Social Insurance Number
18	PASSTY	NPAP	PASSTY		☐	ISH_PASSTY	☐	Type of Identification Document
19	PASSNR	NPAP	PASSNR		☐	ISH_PASSNR	☐	IS-H: Identification Document Number
20	ADRNR	NPAP	ADRNR		☐	ISH_ADRNR	☐	IS-H: Address Number
21	ADROB	NPAP	ADROB		☐	ISH_ADROBJ	☐	IS-H: Address Object
22	ERDAT	NPAP	ERDAT		☐	RI_ERDAT	☐	IS-H: Date when Record Created
23	ERUSR	NPAP	ERUSR		☐	RI_ERNAM	☐	IS-H: Name of Employee who Created Record
24	UPDAT	NPAP	UPDAT		☐	RI_UPDAT	☐	IS-H: Date of Last Change
25	UPUSR	NPAP	UPUSR		☐	RI_UPNAM	☐	IS-H: Name of Person who Last Changed Data
26	STORN	NPAP	STORN		☐	RI_STORN	☐	IS-H: Cancellation Indicator
27	STUSR	NPAP	STUSR		☐	STORN_USER	☐	IS-H: Name of User who Canceled Data Record
28	STDAT	NPAP	STDAT		☐	STORN_DAT	☐	Date of Cancellation
29	NNAMP	NPAPIX	NNAMP		☐	NNAME_PHON	☐	IS-H: Phonetic last name

Maintenance Status

Access

☑   read only

☐   read and change

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

☐   read, change, delete and insert

Delivery Class	A	Application Table (Master- and Transaction Data)
Data Browser/Table View Maintenance		Display/Maintenance Allowed with Restrictions

History

Last changed by/on	SAP	20060313
SAP Release Created in	471