SAP ABAP Table NPAT (IS-H: Patient Master Data (General))
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
Table Category TRANSP    Transparent table 
Transparent table NPAT   Table Relationship Diagram
Short Description IS-H: Patient Master Data (General)    
Delivery and Maintenance
Pool/cluster      
Delivery Class A   Application Table (Master- and Transaction Data) 
Data Browser/Table View Maintenance     Display/Maintenance Allowed with Restrictions 
Components
     
Field Key Data Element Domain Data
Type		 Length Decimal
Places		 Short Description Check
table
1 MANDT MANDT MANDT CLNT 3   0   Client T000
2 PATNR PATNR PATNR CHAR 10   0   IS-H: Patient Number  
3 EINRI EINRI EINRI CHAR 4   0   IS-H: Institution TN01
4 GSCHL GSCHL GSCHL CHAR 1   0   IS-H: Sex Indicator - Internal  
5 NNAME NNAME_PAT TEXT30 CHAR 30   0   IS-H: Patient Last Name  
6 NNAMS NNAMES_PAT CHAR30 CHAR 30   0   IS-H: Standardized Last Name  
7 VNAME VNAME_PAT TEXT30 CHAR 30   0   IS-H: Patient First Name  
8 VNAMS VNAMES_PAT CHAR30 CHAR 30   0   Standardized First Name  
9 TITEL RI_TITEL TITEL CHAR 15   0   IS-H: Title *
10 NAMZU RI_NAMZU TITEL CHAR 15   0   IS-H: Name Affix *
11 VORSW RI_VORSW TITEL CHAR 15   0   IS-H: Name Prefix *
12 NAME2 NAME2_PAT TEXT30 CHAR 30   0   Pseudonym, Order Name  
13 GBDAT RI_GBDAT RI_DATUM DATS 8   0   IS-H: Birthdate  
14 GBNAM GBNAM TEXT30 CHAR 30   0   IS-H: Birthname  
15 GBNAS GBNAMS_PAT CHAR30 CHAR 30   0   IS-H: Standardized Birthname  
16 GLAND GLAND LAND1 CHAR 3   0   IS-H: Country of Birth T005
17 TODKZ PAT_TOD XFELD CHAR 1   0   IS-H: Patient Is Deceased  
18 TODDT TODDV RI_DATUM DATS 8   0   IS-H: Date of Death From  
19 TODZT TODZV UHRZT TIMS 6   0   Time of Death From  
20 TODDB TODDB RI_DATUM DATS 8   0   Date of Death To  
21 TODZB TODZB UHRZT TIMS 6   0   IS-H: Time of Death To  
22 TODUR TODUR TODUR CHAR 3   0   IS-H: Cause of Death TN18A
23 ANRED RI_ANRDS RI_ANRDS CHAR 2   0   IS-H: Form-of-Address Key *
24 FAMST RI_FAMST RI_FAMST CHAR 1   0   IS-H: Marital Status  
25 KONFE RI_KONFE RI_KONFE CHAR 2   0   IS-H: Religion  
26 NATIO RI_NATIO LAND1 CHAR 3   0   IS-H: Nationality T005
27 SPRAS SPRAS_PAT SPRAS LANG 1   0   Patient Language T002
28 LAND LAND_PAT LAND1 CHAR 3   0   IS-H: Country of patient's place of residence T005
29 PSTLZ PSTLZ_PAT PSTLZ CHAR 10   0   IS-H: Patient Postal Code  
30 ORT ORT01_PAT TEXT25 CHAR 25   0   IS-H: City where Patient Resides  
31 ORT2 ORT02_PAT TEXT25 CHAR 25   0   Patient District  
32 STRAS STRAS_PAT STRAS CHAR 30   0   IS-H: Street and House Number of Patient  
33 BLAND ISH_REGION REGIO CHAR 3   0   IS-H: Region (Federal State, Province, County) T005S
34 GEBIE EINZGEBIET EINZGEBIET CHAR 9   0   IS-H: Geographical Area  
35 TELF1 TELF_PAT TEXT16 CHAR 16   0   IS-H: Patient Telephone Number  
36 SPEND SPENKZ XFELD CHAR 1   0   IS-H: Organ Donor Indicator  
37 SPENT SPENTEXT TEXT50 CHAR 50   0   Explanation for Donor Indicator  
38 SPELT RI_LGTXT XFELD CHAR 1   0   Indicator that Long Text Exists  
39 VIPKZ VIPKZ XFELD CHAR 1   0   IS-H: VIP Indicator  
40 ARCHV ARCHIV XFELD CHAR 1   0   IS-H: Archived Data Indicator  
41 STATU PAT_STATUS PAT_STATUS CHAR 1   0   Patient Status  
42 EXTNR EXT_PATNR EXT_PATNR CHAR 20   0   IS-H: External Patient Identification  
43 NOTAN NOTAUF XFELD CHAR 1   0   IS-H: Emergency Admission Indicator  
44 KRZAN KURZAUF XFELD CHAR 1   0   IS-H: Quick Admission Indicator  
45 RFPAT RFPAT PATNR CHAR 10   0   Reference to Patient Number in Merging  
46 RFZIF PZIFF_PAT PZIFF CHAR 1   0   IS-H: Check Digit for Patient  
47 BERUF BERUF TEXT25 CHAR 25   0   IS-H: Patient Occupation  
48 AGNUM AGNUM_PAT RI_KUNNR CHAR 10   0   IS-H: Patient's Employer NGPA
49 AGNAM AGNAM TEXT30 CHAR 30   0   IS-H: Employer Name  
50 AGLAN AGLAN LAND1 CHAR 3   0   IS-H: Employer Country T005
51 AGPLZ AGPLZ PSTLZ CHAR 10   0   IS-H: Employer Postal Code  
52 AGORT AGORT TEXT25 CHAR 25   0   IS-H: Employer City  
53 AGSTR AGSTR STRAS CHAR 30   0   IS-H: Employer Street  
54 AGTEL AGTEL TEXT16 CHAR 16   0   IS-H: Employer Telephone Number  
55 RVNUM ISH_RVNUM ISH_SVNUM CHAR 20   0   IS-H: Social Insurance Number  
56 ANNA1 NNAME_ANG TEXT30 CHAR 30   0   IS-H: Last Name of Person to Be Contacted  
57 ANVN1 VNAME_ANG TEXT30 CHAR 30   0   IS-H: First Name of Person to Be Contacted  
58 ANLA1 LAND_ANG LAND1 CHAR 3   0   Country of the Person to Be Contacted T005
59 ANPL1 PSTLZ_ANG PSTLZ CHAR 10   0   IS-H: Postal Code  
60 ANOR1 ORT01_ANG TEXT25 CHAR 25   0   IS-H: City where Person to Be Contacted Resides  
61 ANST1 STRAS_ANG STRAS CHAR 30   0   IS-H: Street and House Number of Person to Be Contacted  
62 ANTE1 TELF_ANG TEXT16 CHAR 16   0   IS-H: Telephone Number of Person to Be Contacted  
63 ANVV1 VERWVH VERWVH CHAR 1   0   IS-H: Relationship TN17B
64 VMKZ1 VORMUND XFELD CHAR 1   0   IS-H: Legal Representative  
65 ANNA2 NNAME_ANG TEXT30 CHAR 30   0   IS-H: Last Name of Person to Be Contacted  
66 ANVN2 VNAME_ANG TEXT30 CHAR 30   0   IS-H: First Name of Person to Be Contacted  
67 ANLA2 LAND_ANG LAND1 CHAR 3   0   Country of the Person to Be Contacted T005
68 ANPL2 PSTLZ_ANG PSTLZ CHAR 10   0   IS-H: Postal Code  
69 ANOR2 ORT01_ANG TEXT25 CHAR 25   0   IS-H: City where Person to Be Contacted Resides  
70 ANST2 STRAS_ANG STRAS CHAR 30   0   IS-H: Street and House Number of Person to Be Contacted  
71 ANTE2 TELF_ANG TEXT16 CHAR 16   0   IS-H: Telephone Number of Person to Be Contacted  
72 ANVV2 VERWVH VERWVH CHAR 1   0   IS-H: Relationship TN17B
73 VMKZ2 VORMUND XFELD CHAR 1   0   IS-H: Legal Representative  
74 KZTXT TEXT_PAT TEXT50 CHAR 50   0   IS-H: Comment on Patient  
75 LGTXT RI_LGTXT XFELD CHAR 1   0   Indicator that Long Text Exists  
76 BEGDT RI_BEGDT RI_DATUM DATS 8   0   IS-H: Valid-From Date of Record  
77 ENDDT RI_ENDDT RI_DATUM DATS 8   0   IS-H: Valid-To Date of Record  
78 HISTK RI_HISTK XFELD CHAR 1   0   Indicator that History Records Are Available  
79 RISKF ISH_RISIKO XFELD CHAR 1   0   IS-H: Risk Information Exists for the Patient  
80 TESTP TESTP XFELD CHAR 1   0   Test Patient Status  
81 PZIFF PZIFF_PAT PZIFF CHAR 1   0   IS-H: Check Digit for Patient  
82 ERDAT RI_ERDAT RI_DATUM DATS 8   0   IS-H: Date when Record Created  
83 ERUSR RI_ERNAM USNAM CHAR 12   0   IS-H: Name of Employee who Created Record  
84 UPDAT RI_UPDAT RI_DATUM DATS 8   0   IS-H: Date of Last Change  
85 UPUSR RI_UPNAM USNAM CHAR 12   0   IS-H: Name of Person who Last Changed Data  
86 STORN RI_STORN XFELD CHAR 1   0   IS-H: Cancellation Indicator  
87 STUSR STORN_USER USNAM CHAR 12   0   IS-H: Name of User who Canceled Data Record  
88 STDAT STORN_DAT RI_DATUM DATS 8   0   Date of Cancellation  
89 GBORT ISH_GBORT TEXT25 CHAR 25   0   IS-H: Patient Birthplace  
90 HARNR HARNR RI_KUNNR CHAR 10   0   IS-H: Personnel Number of Family Physician NGPA
91 EARNR EARNR RI_KUNNR CHAR 10   0   IS-H: Personnel Number of Referring Physician NGPA
92 UARNR UARNR RI_KUNNR CHAR 10   0   IS-H: Personnel Number of Referring Physician NGPA
93 RACE ISH_RACE ISH_RACE CHAR 2   0   IS-H: Race TN17R
94 RESID ISH_RESID XFELD CHAR 1   0   IS-H: Indicator that Patient is Non-Resident  
95 PASSTY ISH_PASSTY ISH_PASSTY CHAR 2   0   Type of Identification Document TN17D
96 PASSNR ISH_PASSNR ISH_PASSNR CHAR 15   0   IS-H: Identification Document Number  
97 ADRNR ISH_ADRNR ISH_ADRNR CHAR 10   0   IS-H: Address Number NADR
98 ADROB ISH_ADROBJ ISH_ADROBJ CHAR 4   0   IS-H: Address Object  
99 ADNAG ISH_ADRNR ISH_ADRNR CHAR 10   0   IS-H: Address Number NADR
100 ADOAG ISH_ADROBJ ISH_ADROBJ CHAR 4   0   IS-H: Address Object  
101 ADNN1 ISH_ADRNR ISH_ADRNR CHAR 10   0   IS-H: Address Number NADR
102 ADON1 ISH_ADROBJ ISH_ADROBJ CHAR 4   0   IS-H: Address Object  
103 ADNN2 ISH_ADRNR ISH_ADRNR CHAR 10   0   IS-H: Address Number NADR
104 ADON2 ISH_ADROBJ ISH_ADROBJ CHAR 4   0   IS-H: Address Object  
105 ANEX1 EXTNR_ANG EXT_PATNR CHAR 20   0   IS-H: External Identification of Next of Kin/Assoc. Party  
106 ANEX2 EXTNR_ANG EXT_PATNR CHAR 20   0   IS-H: External Identification of Next of Kin/Assoc. Party  
107 ADRN2 ISH_ADRNR ISH_ADRNR CHAR 10   0   IS-H: Address Number NADR
108 ADRO2 ISH_ADROBJ ISH_ADROBJ CHAR 4   0   IS-H: Address Object  
109 INACT ISH_INACTIVE XFELD CHAR 1   0   'Inactive' Indicator  
110 USER1 ISH_PATUSER1 ISH_PATUSER1 CHAR 20   0   IS-H: User-Defined Field 1  
111 USER2 ISH_PATUSER2 ISH_PATUSER2 CHAR 20   0   IS-H: User-Defined Field 2  
112 USER3 ISH_PATUSER3 ISH_PATUSER3 DATS 8   0   IS-H: User-Defined Field 3  
113 USER4 ISH_PATUSER4 ISH_PATUSER4 DATS 8   0   IS-H: User-Defined Field 4  
114 USER5 ISH_PATUSER5 ISH_PATUSER5 CHAR 50   0   IS-H: User-Defined Field 5  
115 USER6 ISH_PATUSER6 ISH_PATUSER6 CHAR 1   0   IS-H: User-Defined Field 6  
116 EXTAUFG EXTAUFG XFELD CHAR 1   0   IS-H: Kennzeichen externer Auftraggeber  
117 EXTAUFGA EXTAUFGA EXTAUFGA CHAR 2   0   IS-H: EA Externe Auftraggeberart TNWCHEA16
118 EMPSC ISH_EMPDAT RI_DATUM DATS 8   0   IS-H: Employed Since  
119 UNKNOWN_GBDAT ISH_UNKNOWN_GBDAT ISH_UNKNOWN_GBDAT CHAR 1   0   Geburtsdatum nicht genau bekannt  
120 INSID ISH_VERS_NR   CHAR 10   0   DE: Eindeutige Versichertennummer (EGK)  
Foreign Keys
Source Table Source Column Foreign Table Foreign Column Dependency Factor Cardinality left Cardinality right
1 NPAT ADNAG NADR ADRNR REF 1 C
2 NPAT ADNN1 NADR ADRNR REF 1 C
3 NPAT ADNN2 NADR ADRNR REF 1 C
4 NPAT ADRN2 NADR ADRNR REF 1 C
5 NPAT ADRNR NADR ADRNR REF 1 C
6 NPAT AGLAN T005 LAND1 REF 1 CN
7 NPAT AGNUM NGPA GPART REF 1 CN
8 NPAT ANLA1 T005 LAND1 REF 1 CN
9 NPAT ANLA2 T005 LAND1 REF 1 CN
10 NPAT ANVV1 TN17B VERVA REF 1 CN
11 NPAT ANVV2 TN17B VERVA REF 1 CN
12 NPAT BLAND T005S BLAND REF 1 CN
13 NPAT EARNR NGPA GPART REF 1 CN
14 NPAT EINRI TN01 EINRI REF 1 CN
15 NPAT EXTAUFGA TNWCHEA16 EXTAUFGA KEY 1 CN
16 NPAT GLAND T005 LAND1 REF 1 CN
17 NPAT HARNR NGPA GPART REF 1 CN
18 NPAT LAND T005 LAND1 REF 1 CN
19 NPAT MANDT T000 MANDT KEY 1 CN
20 NPAT NATIO T005 LAND1 REF 1 CN
21 NPAT PASSTY TN17D PASSTY REF 1 CN
22 NPAT RACE TN17R RACE REF 1 CN
23 NPAT SPRAS T002 SPRAS REF 1 CN
24 NPAT TODUR TN18A TODUR REF 1 CN
25 NPAT UARNR NGPA GPART REF 1 CN
History
Last changed by/on SAP  20130529 
SAP Release Created in