SAP ABAP View N_PAT_PIX (IS-H: View of NPAT and NPIX (search name index))

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_PAT_PIX
Short Description	IS-H: View of NPAT and NPIX (search name index)
Root table	NPIX	IS-H: Patient name index

Table

#	Table Name	Foreign Table	Foreign Field	Foreign DIR
1	NPIX	NPIX
2	NPAT

Join Conditions

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

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	NPIX	MANDT		☐	MANDT	☐	Client
2	NNAMS	NPIX	NNAMS		☐	NNAMES_PAT	☐	IS-H: Standardized Last Name
3	PATNR	NPIX	PATNR		☐	PATNR	☐	IS-H: Patient Number
4	NNAME	NPIX	NNAME		☐	NNAME_PAT	☐	IS-H: Patient Last Name
5	CH_NAME	NPIX	CH_NAME		☐	CH_NAME	☐	IS-H: Indicator for changed last name
6	VNAMS	NPIX	VNAMS		☐	VNAMES_PAT	☐	Standardized First Name
7	PZIFF	NPAT	PZIFF		☐	PZIFF_PAT	☐	IS-H: Check Digit for Patient
8	EINRI	NPAT	EINRI		☐	EINRI	☐	IS-H: Institution
9	GSCHL	NPAT	GSCHL		☐	GSCHL	☐	IS-H: Sex Indicator - Internal
10	STANDNAM	NPAT	NNAMS		☐	NNAMES_PAT	☐	IS-H: Standardized Last Name
11	VNAME	NPAT	VNAME		☐	VNAME_PAT	☐	IS-H: Patient First Name
12	NAMZU	NPAT	NAMZU		☐	RI_NAMZU	☐	IS-H: Name Affix
13	VORSW	NPAT	VORSW		☐	RI_VORSW	☐	IS-H: Name Prefix
14	GBDAT	NPAT	GBDAT		☐	RI_GBDAT	☐	IS-H: Birthdate
15	GBNAM	NPAT	GBNAM		☐	GBNAM	☐	IS-H: Birthname
16	GBNAS	NPAT	GBNAS		☐	GBNAMS_PAT	☐	IS-H: Standardized Birthname
17	PSTLZ	NPAT	PSTLZ		☐	PSTLZ_PAT	☐	IS-H: Patient Postal Code
18	ORT	NPAT	ORT		☐	ORT01_PAT	☐	IS-H: City where Patient Resides
19	ORT2	NPAT	ORT2		☐	ORT02_PAT	☐	Patient District
20	STRAS	NPAT	STRAS		☐	STRAS_PAT	☐	IS-H: Street and House Number of Patient
21	TELF1	NPAT	TELF1		☐	TELF_PAT	☐	IS-H: Patient Telephone Number
22	STATU	NPAT	STATU		☐	PAT_STATUS	☐	Patient Status
23	NOTAN	NPAT	NOTAN		☐	NOTAUF	☐	IS-H: Emergency Admission Indicator
24	KRZAN	NPAT	KRZAN		☐	KURZAUF	☐	IS-H: Quick Admission Indicator
25	STORN	NPAT	STORN		☐	RI_STORN	☐	IS-H: Cancellation Indicator
26	TODKZ	NPAT	TODKZ		☐	PAT_TOD	☐	IS-H: Patient Is Deceased
27	LAND	NPAT	LAND		☐	LAND_PAT	☐	IS-H: Country of patient's place of residence
28	NNAMP	NPIX	NNAMP		☐	NNAME_PHON	☐	IS-H: Phonetic last name
29	EXTNR	NPAT	EXTNR		☐	EXT_PATNR	☐	IS-H: External Patient Identification
30	RVNUM	NPAT	RVNUM		☐	ISH_RVNUM	☐	IS-H: Social Insurance Number
31	RFPAT	NPAT	RFPAT		☐	RFPAT	☐	Reference to Patient Number in Merging
32	ADRNR	NPAT	ADRNR		☐	ISH_ADRNR	☐	IS-H: Address Number
33	ADROB	NPAT	ADROB		☐	ISH_ADROBJ	☐	IS-H: Address Object
34	TITEL	NPAT	TITEL		☐	RI_TITEL	☐	IS-H: Title
35	PASSTY	NPAT	PASSTY		☐	ISH_PASSTY	☐	Type of Identification Document
36	PASSNR	NPAT	PASSNR		☐	ISH_PASSNR	☐	IS-H: Identification Document Number
37	RESID	NPAT	RESID		☐	ISH_RESID	☐	IS-H: Indicator that Patient is Non-Resident
38	ADRN2	NPAT	ADRN2		☐	ISH_ADRNR	☐	IS-H: Address Number
39	ADRO2	NPAT	ADRO2		☐	ISH_ADROBJ	☐	IS-H: Address Object
40	VIPKZ	NPAT	VIPKZ		☐	VIPKZ	☐	IS-H: VIP Indicator
41	INACT	NPAT	INACT		☐	ISH_INACTIVE	☐	'Inactive' Indicator
42	NAME2	NPAT	NAME2		☐	NAME2_PAT	☐	Pseudonym, Order Name
43	TODUR	NPAT	TODUR		☐	TODUR	☐	IS-H: Cause of Death
44	INSID	NPAT	INSID		☐	ISH_VERS_NR	☐	DE: Eindeutige Versichertennummer (EGK)

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