Follow us on LinkedIn for your next SAP project

SAP Table NPAT

IS-H: Patient Master Data (General)

NPAT (IS-H: Patient Master Data (General)) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link NPAT to other SAP tables.

NPAT table fields

Field Data element Checktable Datatype Length Decimals Possible values
MANDT
Client
MANDT T000
CLNT
3 0
PATNR
IS-H: Patient Number
PATNR
CHAR
10 0
EINRI
Institution
EINRI TN01
CHAR
4 0
GSCHL
IS-H: Sex Indicator - Internal
GSCHL
CHAR
1 0
NNAME
Patient Last Name
NNAME_PAT
CHAR
30 0
NNAMS
IS-H: Standardized Last Name
NNAMES_PAT
CHAR
30 0
VNAME
IS-H: Patient First Name
VNAME_PAT
CHAR
30 0
VNAMS
Standardized First Name
VNAMES_PAT
CHAR
30 0
TITEL
IS-H: Title
RI_TITEL
CHAR
15 0
NAMZU
IS-H: Name Affix
RI_NAMZU
CHAR
15 0
VORSW
IS-H: Name Prefix
RI_VORSW
CHAR
15 0
NAME2
Pseudonym, Order Name
NAME2_PAT
CHAR
30 0
GBDAT
IS-H: Birthdate
RI_GBDAT
DATS
8 0
GBNAM
IS-H: Birthname
GBNAM
CHAR
30 0
GBNAS
IS-H: Standardized Birthname
GBNAMS_PAT
CHAR
30 0
GLAND
IS-H: Country of Birth
GLAND T005
CHAR
3 0
TODKZ
IS-H: Patient Is Deceased
PAT_TOD
CHAR
1 0
TODDT
IS-H: Date of Death From
TODDV
DATS
8 0
TODZT
Time of Death From
TODZV
TIMS
6 0
TODDB
Date of Death To
TODDB
DATS
8 0
TODZB
IS-H: Time of Death To
TODZB
TIMS
6 0
TODUR
IS-H: Cause of Death
TODUR TN18A
CHAR
3 0
ANRED
IS-H: Form-of-Address Key
RI_ANRDS
CHAR
2 0
FAMST
IS-H: Marital Status
RI_FAMST
CHAR
1 0
KONFE
IS-H: Religion
RI_KONFE
CHAR
2 0
NATIO
IS-H: Nationality
RI_NATIO T005
CHAR
3 0
SPRAS
Patient Language
SPRAS_PAT T002
LANG
1 0
LAND
IS-H: Country of patient's place of residence
LAND_PAT T005
CHAR
3 0
PSTLZ
IS-H: Patient Postal Code
PSTLZ_PAT
CHAR
10 0
ORT
IS-H: City where Patient Resides
ORT01_PAT
CHAR
25 0
ORT2
Patient District
ORT02_PAT
CHAR
25 0
STRAS
IS-H: Street and House Number of Patient
STRAS_PAT
CHAR
30 0
BLAND
IS-H: Region (Federal State, Province, County)
ISH_REGION T005S
CHAR
3 0
GEBIE
IS-H: Geographical Area
EINZGEBIET
CHAR
9 0
TELF1
IS-H: Patient Telephone Number
TELF_PAT
CHAR
16 0
SPEND
Organ Donor Indicator
SPENKZ
CHAR
1 0
SPENT
Explanation for Donor Indicator
SPENTEXT
CHAR
50 0
SPELT
Indicator that Long Text Exists
RI_LGTXT
CHAR
1 0
VIPKZ
IS-H: VIP Indicator
VIPKZ
CHAR
1 0
ARCHV
IS-H: Archived Data Indicator
ARCHIV
CHAR
1 0
STATU
Patient Status
PAT_STATUS
CHAR
1 0
EXTNR
IS-H: External Patient Identification
EXT_PATNR
CHAR
20 0
NOTAN
IS-H: Emergency Admission Indicator
NOTAUF
CHAR
1 0
KRZAN
IS-H: Quick Admission Indicator
KURZAUF
CHAR
1 0
RFPAT
Reference to Patient Number in Merging
RFPAT
CHAR
10 0
RFZIF
Check Digit for Patient
PZIFF_PAT
CHAR
1 0
BERUF
IS-H: Patient Occupation
BERUF
CHAR
25 0
AGNUM
IS-H: Patient's Employer
AGNUM_PAT NGPA
CHAR
10 0
AGNAM
IS-H: Employer Name
AGNAM
CHAR
30 0
AGLAN
IS-H: Employer Country
AGLAN T005
CHAR
3 0
AGPLZ
IS-H: Employer Postal Code
AGPLZ
CHAR
10 0
AGORT
IS-H: Employer City
AGORT
CHAR
25 0
AGSTR
IS-H: Employer Street
AGSTR
CHAR
30 0
AGTEL
IS-H: Employer Telephone Number
AGTEL
CHAR
16 0
RVNUM
IS-H: Social Insurance Number
ISH_RVNUM
CHAR
20 0
ANNA1
IS-H: Last Name of Person to Be Contacted
NNAME_ANG
CHAR
30 0
ANVN1
IS-H: First Name of Person to Be Contacted
VNAME_ANG
CHAR
30 0
ANLA1
Country of the Person to Be Contacted
LAND_ANG T005
CHAR
3 0
ANPL1
IS-H: Postal Code
PSTLZ_ANG
CHAR
10 0
ANOR1
IS-H: City where Person to Be Contacted Resides
ORT01_ANG
CHAR
25 0
ANST1
IS-H: Street and House Number of Person to Be Contacted
STRAS_ANG
CHAR
30 0
ANTE1
IS-H: Telephone Number of Person to Be Contacted
TELF_ANG
CHAR
16 0
ANVV1
IS-H: Relationship
VERWVH TN17B
CHAR
1 0
VMKZ1
IS-H: Legal Representative
VORMUND
CHAR
1 0
ANNA2
IS-H: Last Name of Person to Be Contacted
NNAME_ANG
CHAR
30 0
ANVN2
IS-H: First Name of Person to Be Contacted
VNAME_ANG
CHAR
30 0
ANLA2
Country of the Person to Be Contacted
LAND_ANG T005
CHAR
3 0
ANPL2
IS-H: Postal Code
PSTLZ_ANG
CHAR
10 0
ANOR2
IS-H: City where Person to Be Contacted Resides
ORT01_ANG
CHAR
25 0
ANST2
IS-H: Street and House Number of Person to Be Contacted
STRAS_ANG
CHAR
30 0
ANTE2
IS-H: Telephone Number of Person to Be Contacted
TELF_ANG
CHAR
16 0
ANVV2
IS-H: Relationship
VERWVH TN17B
CHAR
1 0
VMKZ2
IS-H: Legal Representative
VORMUND
CHAR
1 0
KZTXT
IS-H: Comment on Patient
TEXT_PAT
CHAR
50 0
LGTXT
Indicator that Long Text Exists
RI_LGTXT
CHAR
1 0
BEGDT
IS-H: Valid-From Date of Record
RI_BEGDT
DATS
8 0
ENDDT
IS-H: Valid-To Date of Record
RI_ENDDT
DATS
8 0
HISTK
Indicator that History Records Are Available
RI_HISTK
CHAR
1 0
RISKF
IS-H: Risk Information Exists for the Patient
ISH_RISIKO
CHAR
1 0
TESTP
Test Patient Status
TESTP
CHAR
1 0
PZIFF
Check Digit for Patient
PZIFF_PAT
CHAR
1 0
ERDAT
IS-H: Date when Record Created
RI_ERDAT
DATS
8 0
ERUSR
IS-H: Name of Employee who Created Record
RI_ERNAM
CHAR
12 0
UPDAT
IS-H: Date of Last Change
RI_UPDAT
DATS
8 0
UPUSR
IS-H: Name of Person who Last Changed Data
RI_UPNAM
CHAR
12 0
STORN
IS-H: Cancellation Indicator
RI_STORN
CHAR
1 0
STUSR
IS-H: Name of User who Canceled Data Record
STORN_USER
CHAR
12 0
STDAT
Date of Cancellation
STORN_DAT
DATS
8 0
GBORT
IS-H: Patient Birthplace
ISH_GBORT
CHAR
25 0
HARNR
IS-H: Personnel Number of Family Physician
HARNR NGPA
CHAR
10 0
EARNR
IS-H: Personnel Number of Referring Physician
EARNR NGPA
CHAR
10 0
UARNR
IS-H: Personnel Number of Referring Physician
UARNR NGPA
CHAR
10 0
RACE
IS-H: Race
ISH_RACE TN17R
CHAR
2 0
RESID
Indicator That Patient Is Non-Resident
ISH_RESID
CHAR
1 0
PASSTY
Type of Identification Document
ISH_PASSTY TN17D
CHAR
2 0
PASSNR
IS-H: Identification Document Number
ISH_PASSNR
CHAR
15 0
ADRNR
IS-H: Address Number
ISH_ADRNR NADR
CHAR
10 0
ADROB
IS-H: Address Object
ISH_ADROBJ
CHAR
4 0
ADNAG
IS-H: Address Number
ISH_ADRNR NADR
CHAR
10 0
ADOAG
IS-H: Address Object
ISH_ADROBJ
CHAR
4 0
ADNN1
IS-H: Address Number
ISH_ADRNR NADR
CHAR
10 0
ADON1
IS-H: Address Object
ISH_ADROBJ
CHAR
4 0
ADNN2
IS-H: Address Number
ISH_ADRNR NADR
CHAR
10 0
ADON2
IS-H: Address Object
ISH_ADROBJ
CHAR
4 0
ANEX1
External Identification of Next of Kin
EXTNR_ANG
CHAR
20 0
ANEX2
External Identification of Next of Kin
EXTNR_ANG
CHAR
20 0
ADRN2
IS-H: Address Number
ISH_ADRNR NADR
CHAR
10 0
ADRO2
IS-H: Address Object
ISH_ADROBJ
CHAR
4 0
INACT
'Inactive' Indicator
ISH_INACTIVE
CHAR
1 0
USER1
IS-H: User-Defined Field 1
ISH_PATUSER1
CHAR
20 0
USER2
IS-H: User-Defined Field 2
ISH_PATUSER2
CHAR
20 0
USER3
IS-H: User-Defined Field 3
ISH_PATUSER3
DATS
8 0
USER4
IS-H: User-Defined Field 4
ISH_PATUSER4
DATS
8 0
USER5
IS-H: User-Defined Field 5
ISH_PATUSER5
CHAR
50 0
USER6
IS-H: User-Defined Field 6
ISH_PATUSER6
CHAR
1 0
EXTAUFG
EXTAUFG
CHAR
1 0
EXTAUFGA
EXTAUFGA TNWCHEA16
CHAR
2 0
EMPSC
IS-H: Employed Since
ISH_EMPDAT
DATS
8 0
UNKNOWN_GBDAT
Birthdate Is Unknown
ISH_UNKNOWN_GBDAT
CHAR
1 0
MIG_DONE
Indicator Specifying Record Is Migrated to BP Table
ISH_BPMIG_DONE
CHAR
1 0
INSID
ISH_VERS_NR
CHAR
10 0
ISTAT_BPL
ISTAT Code
ISH_ISTAT
CHAR
6 0
TAXNUM
Tax Number of Person
ISH_IT_TAXNUM
CHAR
20 0
TAXNUM_IND
Tax Number Indicator
ISH_TAXNUM_IND
CHAR
1 0
STP
STP Code
ISH_STP
CHAR
16 0
STP_ENDDT
End of Validity of STP Code
ISH_STPEND
DATS
8 0
CONS_PERSDATA
Consent for Processing of Personal Data
ISH_CONS_PERSDATA
CHAR
1 0
/ISHFR/BIRTHRK
IS-H FR: Birth Rank
/ISHFR/ISH_BIRTH_RANK
NUMC
1 0
DTH_LOC
Location of Death
ISH_DTH_LOC TN18L
CHAR
2 0
OCCUP
National Occupation Category
ISH_CN_OCCUP TN17C
CHAR
5 0
NARNR_S
Postdischarge Physician for Inpatient Stays
ISH_POSTDIS_PHYS_INP
CHAR
10 0
NARNR_A
Postdischarge Physician for Outpatient Stays
ISH_POSTDIS_PHYS_OUTP
CHAR
10 0

NPAT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
NPAT ADNAG NPAT MANDT NADR
IS-H: Addresses (Central Address Management)
MANDT
NPAT ADNAG NPAT ADNAG NADR
IS-H: Addresses (Central Address Management)
ADRNR
NPAT ADNAG NPAT ADOAG NADR
IS-H: Addresses (Central Address Management)
ADROB
NPAT ADNN1 NPAT MANDT NADR
IS-H: Addresses (Central Address Management)
MANDT
NPAT ADNN1 NPAT ADNN1 NADR
IS-H: Addresses (Central Address Management)
ADRNR
NPAT ADNN1 NPAT ADON1 NADR
IS-H: Addresses (Central Address Management)
ADROB
NPAT ADNN2 NPAT MANDT NADR
IS-H: Addresses (Central Address Management)
MANDT
NPAT ADNN2 NPAT ADNN2 NADR
IS-H: Addresses (Central Address Management)
ADRNR
NPAT ADNN2 NPAT ADON2 NADR
IS-H: Addresses (Central Address Management)
ADROB
NPAT ADRN2 NPAT ADRO2 NADR
IS-H: Addresses (Central Address Management)
ADROB
NPAT ADRN2 NPAT MANDT NADR
IS-H: Addresses (Central Address Management)
MANDT
NPAT ADRN2 NPAT ADRN2 NADR
IS-H: Addresses (Central Address Management)
ADRNR
NPAT ADRNR NPAT MANDT NADR
IS-H: Addresses (Central Address Management)
MANDT
NPAT ADRNR NPAT ADRNR NADR
IS-H: Addresses (Central Address Management)
ADRNR
NPAT ADRNR NPAT ADROB NADR
IS-H: Addresses (Central Address Management)
ADROB
NPAT AGLAN NPAT MANDT T005
Countries
MANDT
NPAT AGLAN NPAT AGLAN T005
Countries
LAND1
NPAT AGNUM NPAT AGNUM NGPA
IS-H: Business Partners
GPART
NPAT AGNUM NPAT MANDT NGPA
IS-H: Business Partners
MANDT
NPAT ANLA1 NPAT MANDT T005
Countries
MANDT
NPAT ANLA1 NPAT ANLA1 T005
Countries
LAND1
NPAT ANLA2 NPAT MANDT T005
Countries
MANDT
NPAT ANLA2 NPAT ANLA2 T005
Countries
LAND1
NPAT ANVV1 NPAT ANVV1 TN17B
IS-H: Relationship Types
VERVA
NPAT ANVV1 NPAT MANDT TN17B
IS-H: Relationship Types
MANDT
NPAT ANVV2 NPAT MANDT TN17B
IS-H: Relationship Types
MANDT
NPAT ANVV2 NPAT ANVV2 TN17B
IS-H: Relationship Types
VERVA
NPAT BLAND NPAT LAND T005S
Taxes: Region (Province) Key
LAND1
NPAT BLAND NPAT BLAND T005S
Taxes: Region (Province) Key
BLAND
NPAT BLAND NPAT MANDT T005S
Taxes: Region (Province) Key
MANDT
NPAT DTH_LOC NPAT MANDT TN18L
Location
MANDT
NPAT DTH_LOC NPAT DTH_LOC TN18L
Location
LOCAT
NPAT EARNR NPAT MANDT NGPA
IS-H: Business Partners
MANDT
NPAT EARNR NPAT EARNR NGPA
IS-H: Business Partners
GPART
NPAT EINRI NPAT MANDT TN01
IS-H: Institutions
MANDT
NPAT EINRI NPAT EINRI TN01
IS-H: Institutions
EINRI
NPAT EXTAUFGA NPAT MANDT TNWCHEA16
MANDT
NPAT EXTAUFGA NPAT EINRI TNWCHEA16
EINRI
NPAT EXTAUFGA NPAT EXTAUFGA TNWCHEA16
EXTAUFGA
NPAT GLAND NPAT GLAND T005
Countries
LAND1
NPAT GLAND NPAT MANDT T005
Countries
MANDT
NPAT HARNR NPAT MANDT NGPA
IS-H: Business Partners
MANDT
NPAT HARNR NPAT HARNR NGPA
IS-H: Business Partners
GPART
NPAT LAND NPAT MANDT T005
Countries
MANDT
NPAT LAND NPAT LAND T005
Countries
LAND1
NPAT MANDT NPAT MANDT T000
Clients
MANDT
NPAT NATIO NPAT MANDT T005
Countries
MANDT
NPAT NATIO NPAT NATIO T005
Countries
LAND1
NPAT OCCUP NPAT MANDT TN17C
IS-H: Occupation Category and Code
MANDT
NPAT OCCUP NPAT OCCUP TN17C
IS-H: Occupation Category and Code
OCCUP
NPAT PASSTY NPAT MANDT TN17D
IS-H: Identity Document Types
MANDT
NPAT PASSTY NPAT PASSTY TN17D
IS-H: Identity Document Types
PASSTY
NPAT RACE NPAT MANDT TN17R
IS-H: Race
MANDT
NPAT RACE NPAT RACE TN17R
IS-H: Race
RACE
NPAT SPRAS NPAT SPRAS T002
Language Keys (Component BC-I18)
SPRAS
NPAT TODUR NPAT MANDT TN18A
IS-H: Causes of Death
MANDT
NPAT TODUR NPAT TODUR TN18A
IS-H: Causes of Death
TODUR
NPAT UARNR NPAT UARNR NGPA
IS-H: Business Partners
GPART
NPAT UARNR NPAT MANDT NGPA
IS-H: Business Partners
MANDT