SAP ABAP View ENT7611 (Patient)

Hierarchy

☛ IS-H (Software Component) SAP Healthcare
   ⤷ IS-H (Application Component) SAP Healthcare - Industry-Specific Components for Hospitals
     ⤷ NUH1 (Package) IS-H: Hospital Basic Data (Data Model)

Basic Data

View Type	D	Database View
Database View	ENT7611
Short Description	Patient
Root table	NPAT	IS-H: Patient Master Data (General)

Table

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

Join Conditions

#	Table Name	Field Name	Negation	Operator	Constants	Cont. line	AND/OR	Offset	F Length	Mco Field

View Fields

#	View field	Table	Field	Maintenance Flag	Key	Data element	Mod	Short Description
1	MANDT	NPAT	MANDT		☐	MANDT	☐	Client
2	PATNR	NPAT	PATNR		☐	PATNR	☐	IS-H: Patient Number
3	EINRI	NPAT	EINRI		☐	EINRI	☐	IS-H: Institution
4	GSCHL	NPAT	GSCHL		☐	GSCHL	☐	IS-H: Sex Indicator - Internal
5	NNAME	NPAT	NNAME		☐	NNAME_PAT	☐	IS-H: Patient Last Name
6	NNAMS	NPAT	NNAMS		☐	NNAMES_PAT	☐	IS-H: Standardized Last Name
7	VNAME	NPAT	VNAME		☐	VNAME_PAT	☐	IS-H: Patient First Name
8	VNAMS	NPAT	VNAMS		☐	VNAMES_PAT	☐	Standardized First Name
9	TITEL	NPAT	TITEL		☐	RI_TITEL	☐	IS-H: Title
10	NAMZU	NPAT	NAMZU		☐	RI_NAMZU	☐	IS-H: Name Affix
11	VORSW	NPAT	VORSW		☐	RI_VORSW	☐	IS-H: Name Prefix
12	NAME2	NPAT	NAME2		☐	NAME2_PAT	☐	Pseudonym, Order Name
13	GBDAT	NPAT	GBDAT		☐	RI_GBDAT	☐	IS-H: Birthdate
14	GBNAM	NPAT	GBNAM		☐	GBNAM	☐	IS-H: Birthname
15	GBNAS	NPAT	GBNAS		☐	GBNAMS_PAT	☐	IS-H: Standardized Birthname
16	GLAND	NPAT	GLAND		☐	GLAND	☐	IS-H: Country of Birth
17	TODKZ	NPAT	TODKZ		☐	PAT_TOD	☐	IS-H: Patient Is Deceased
18	TODDT	NPAT	TODDT		☐	TODDV	☐	IS-H: Date of Death From
19	TODZT	NPAT	TODZT		☐	TODZV	☐	Time of Death From
20	TODDB	NPAT	TODDB		☐	TODDB	☐	Date of Death To
21	TODZB	NPAT	TODZB		☐	TODZB	☐	IS-H: Time of Death To
22	TODUR	NPAT	TODUR		☐	TODUR	☐	IS-H: Cause of Death
23	ANRED	NPAT	ANRED		☐	RI_ANRDS	☐	IS-H: Form-of-Address Key
24	FAMST	NPAT	FAMST		☐	RI_FAMST	☐	IS-H: Marital Status
25	KONFE	NPAT	KONFE		☐	RI_KONFE	☐	IS-H: Religion
26	NATIO	NPAT	NATIO		☐	RI_NATIO	☐	IS-H: Nationality
27	SPRAS	NPAT	SPRAS		☐	SPRAS_PAT	☐	Patient Language
28	LAND	NPAT	LAND		☐	LAND_PAT	☐	IS-H: Country of patient's place of residence
29	PSTLZ	NPAT	PSTLZ		☐	PSTLZ_PAT	☐	IS-H: Patient Postal Code
30	ORT	NPAT	ORT		☐	ORT01_PAT	☐	IS-H: City where Patient Resides
31	ORT2	NPAT	ORT2		☐	ORT02_PAT	☐	Patient District
32	STRAS	NPAT	STRAS		☐	STRAS_PAT	☐	IS-H: Street and House Number of Patient
33	BLAND	NPAT	BLAND		☐	ISH_REGION	☐	IS-H: Region (Federal State, Province, County)
34	GEBIE	NPAT	GEBIE		☐	EINZGEBIET	☐	IS-H: Geographical Area
35	TELF1	NPAT	TELF1		☐	TELF_PAT	☐	IS-H: Patient Telephone Number
36	SPEND	NPAT	SPEND		☐	SPENKZ	☐	IS-H: Organ Donor Indicator
37	SPENT	NPAT	SPENT		☐	SPENTEXT	☐	Explanation for Donor Indicator
38	SPELT	NPAT	SPELT		☐	RI_LGTXT	☐	Indicator that Long Text Exists
39	VIPKZ	NPAT	VIPKZ		☐	VIPKZ	☐	IS-H: VIP Indicator
40	ARCHV	NPAT	ARCHV		☐	ARCHIV	☐	IS-H: Archived Data Indicator
41	STATU	NPAT	STATU		☐	PAT_STATUS	☐	Patient Status
42	EXTNR	NPAT	EXTNR		☐	EXT_PATNR	☐	IS-H: External Patient Identification
43	NOTAN	NPAT	NOTAN		☐	NOTAUF	☐	IS-H: Emergency Admission Indicator
44	KRZAN	NPAT	KRZAN		☐	KURZAUF	☐	IS-H: Quick Admission Indicator
45	RFZIF	NPAT	RFZIF		☐	PZIFF_PAT	☐	IS-H: Check Digit for Patient
46	BERUF	NPAT	BERUF		☐	BERUF	☐	IS-H: Patient Occupation
47	AGNUM	NPAT	AGNUM		☐	AGNUM_PAT	☐	IS-H: Patient's Employer
48	AGNAM	NPAT	AGNAM		☐	AGNAM	☐	IS-H: Employer Name
49	AGLAN	NPAT	AGLAN		☐	AGLAN	☐	IS-H: Employer Country
50	AGPLZ	NPAT	AGPLZ		☐	AGPLZ	☐	IS-H: Employer Postal Code
51	AGORT	NPAT	AGORT		☐	AGORT	☐	IS-H: Employer City
52	AGSTR	NPAT	AGSTR		☐	AGSTR	☐	IS-H: Employer Street
53	AGTEL	NPAT	AGTEL		☐	AGTEL	☐	IS-H: Employer Telephone Number
54	RVNUM	NPAT	RVNUM		☐	ISH_RVNUM	☐	IS-H: Social Insurance Number
55	ANNA1	NPAT	ANNA1		☐	NNAME_ANG	☐	IS-H: Last Name of Person to Be Contacted
56	ANVN1	NPAT	ANVN1		☐	VNAME_ANG	☐	IS-H: First Name of Person to Be Contacted
57	ANLA1	NPAT	ANLA1		☐	LAND_ANG	☐	Country of the Person to Be Contacted
58	ANPL1	NPAT	ANPL1		☐	PSTLZ_ANG	☐	IS-H: Postal Code
59	ANOR1	NPAT	ANOR1		☐	ORT01_ANG	☐	IS-H: City where Person to Be Contacted Resides
60	ANST1	NPAT	ANST1		☐	STRAS_ANG	☐	IS-H: Street and House Number of Person to Be Contacted
61	ANTE1	NPAT	ANTE1		☐	TELF_ANG	☐	IS-H: Telephone Number of Person to Be Contacted
62	ANVV1	NPAT	ANVV1		☐	VERWVH	☐	IS-H: Relationship
63	VMKZ1	NPAT	VMKZ1		☐	VORMUND	☐	IS-H: Legal Representative
64	ANNA2	NPAT	ANNA2		☐	NNAME_ANG	☐	IS-H: Last Name of Person to Be Contacted
65	ANVN2	NPAT	ANVN2		☐	VNAME_ANG	☐	IS-H: First Name of Person to Be Contacted
66	ANLA2	NPAT	ANLA2		☐	LAND_ANG	☐	Country of the Person to Be Contacted
67	ANPL2	NPAT	ANPL2		☐	PSTLZ_ANG	☐	IS-H: Postal Code
68	ANOR2	NPAT	ANOR2		☐	ORT01_ANG	☐	IS-H: City where Person to Be Contacted Resides
69	ANST2	NPAT	ANST2		☐	STRAS_ANG	☐	IS-H: Street and House Number of Person to Be Contacted
70	ANTE2	NPAT	ANTE2		☐	TELF_ANG	☐	IS-H: Telephone Number of Person to Be Contacted
71	ANVV2	NPAT	ANVV2		☐	VERWVH	☐	IS-H: Relationship
72	VMKZ2	NPAT	VMKZ2		☐	VORMUND	☐	IS-H: Legal Representative
73	KZTXT	NPAT	KZTXT		☐	TEXT_PAT	☐	IS-H: Comment on Patient
74	LGTXT	NPAT	LGTXT		☐	RI_LGTXT	☐	Indicator that Long Text Exists
75	BEGDT	NPAT	BEGDT		☐	RI_BEGDT	☐	IS-H: Valid-From Date of Record
76	ENDDT	NPAT	ENDDT		☐	RI_ENDDT	☐	IS-H: Valid-To Date of Record
77	HISTK	NPAT	HISTK		☐	RI_HISTK	☐	Indicator that History Records Are Available
78	RISKF	NPAT	RISKF		☐	ISH_RISIKO	☐	IS-H: Risk Information Exists for the Patient
79	TESTP	NPAT	TESTP		☐	TESTP	☐	Test Patient Status
80	PZIFF	NPAT	PZIFF		☐	PZIFF_PAT	☐	IS-H: Check Digit for Patient
81	ERDAT	NPAT	ERDAT		☐	RI_ERDAT	☐	IS-H: Date when Record Created
82	ERUSR	NPAT	ERUSR		☐	RI_ERNAM	☐	IS-H: Name of Employee who Created Record
83	UPDAT	NPAT	UPDAT		☐	RI_UPDAT	☐	IS-H: Date of Last Change
84	UPUSR	NPAT	UPUSR		☐	RI_UPNAM	☐	IS-H: Name of Person who Last Changed Data
85	STORN	NPAT	STORN		☐	RI_STORN	☐	IS-H: Cancellation Indicator
86	STUSR	NPAT	STUSR		☐	STORN_USER	☐	IS-H: Name of User who Canceled Data Record
87	STDAT	NPAT	STDAT		☐	STORN_DAT	☐	Date of Cancellation

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	X	Display/Maintenance Allowed

History

Last changed by/on	SAP	20130529
SAP Release Created in