1. Home
  2. Resources
  3. SAP Tables
  4. NPAT - IS-H: Patient Master Data (General)

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
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
1 male
2 female
3 unknown
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
X Yes
NULL No
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
X Yes
NULL No
SPENT Explanation for Donor Indicator SPENTEXT CHAR 50 0
SPELT Indicator that Long Text Exists RI_LGTXT CHAR 1 0
X Yes
NULL No
VIPKZ IS-H: VIP Indicator VIPKZ CHAR 1 0
X Yes
NULL No
ARCHV IS-H: Archived Data Indicator ARCHIV CHAR 1 0
X Yes
NULL No
STATU Patient Status PAT_STATUS CHAR 1 0
V Patient Deceased
EXTNR IS-H: External Patient Identification EXT_PATNR CHAR 20 0
NOTAN IS-H: Emergency Admission Indicator NOTAUF CHAR 1 0
X Yes
NULL No
KRZAN IS-H: Quick Admission Indicator KURZAUF CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
KZTXT IS-H: Comment on Patient TEXT_PAT CHAR 50 0
LGTXT Indicator that Long Text Exists RI_LGTXT CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
RISKF IS-H: Risk Information Exists for the Patient ISH_RISIKO CHAR 1 0
X Yes
NULL No
TESTP Test Patient Status TESTP CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
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
X Yes
NULL No
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
NPAT Patient
NPAN Patient - Next of Kin/Associated Party
NPAG Patient - Employer
NPAP Provisional Patient Master Data
NGPA Business Partner
TN01 Institution
N301 EDI Data Collection Point
NWAN Bad Debt Party
NORG Organizational Unit
NBAU Building Unit
NVVH Insurance - Main Person Insured/Alternate Invoice Recipient
NVVG Insurance - Employer of Main Person Insured
NAPP Provisional Appointment
NVVN Guarantors
REDO Renewable Document
NPSD Pseudonymized Patient
ADNAG IS-H: Address Number ISH_ADRNR NADR CHAR 10 0
ADOAG IS-H: Address Object ISH_ADROBJ CHAR 4 0
NPAT Patient
NPAN Patient - Next of Kin/Associated Party
NPAG Patient - Employer
NPAP Provisional Patient Master Data
NGPA Business Partner
TN01 Institution
N301 EDI Data Collection Point
NWAN Bad Debt Party
NORG Organizational Unit
NBAU Building Unit
NVVH Insurance - Main Person Insured/Alternate Invoice Recipient
NVVG Insurance - Employer of Main Person Insured
NAPP Provisional Appointment
NVVN Guarantors
REDO Renewable Document
NPSD Pseudonymized Patient
ADNN1 IS-H: Address Number ISH_ADRNR NADR CHAR 10 0
ADON1 IS-H: Address Object ISH_ADROBJ CHAR 4 0
NPAT Patient
NPAN Patient - Next of Kin/Associated Party
NPAG Patient - Employer
NPAP Provisional Patient Master Data
NGPA Business Partner
TN01 Institution
N301 EDI Data Collection Point
NWAN Bad Debt Party
NORG Organizational Unit
NBAU Building Unit
NVVH Insurance - Main Person Insured/Alternate Invoice Recipient
NVVG Insurance - Employer of Main Person Insured
NAPP Provisional Appointment
NVVN Guarantors
REDO Renewable Document
NPSD Pseudonymized Patient
ADNN2 IS-H: Address Number ISH_ADRNR NADR CHAR 10 0
ADON2 IS-H: Address Object ISH_ADROBJ CHAR 4 0
NPAT Patient
NPAN Patient - Next of Kin/Associated Party
NPAG Patient - Employer
NPAP Provisional Patient Master Data
NGPA Business Partner
TN01 Institution
N301 EDI Data Collection Point
NWAN Bad Debt Party
NORG Organizational Unit
NBAU Building Unit
NVVH Insurance - Main Person Insured/Alternate Invoice Recipient
NVVG Insurance - Employer of Main Person Insured
NAPP Provisional Appointment
NVVN Guarantors
REDO Renewable Document
NPSD Pseudonymized Patient
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
NPAT Patient
NPAN Patient - Next of Kin/Associated Party
NPAG Patient - Employer
NPAP Provisional Patient Master Data
NGPA Business Partner
TN01 Institution
N301 EDI Data Collection Point
NWAN Bad Debt Party
NORG Organizational Unit
NBAU Building Unit
NVVH Insurance - Main Person Insured/Alternate Invoice Recipient
NVVG Insurance - Employer of Main Person Insured
NAPP Provisional Appointment
NVVN Guarantors
REDO Renewable Document
NPSD Pseudonymized Patient
INACT 'Inactive' Indicator ISH_INACTIVE CHAR 1 0
X Yes
NULL No
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
X Yes
NULL No
EXTAUFG EXTAUFG CHAR 1 0
X Yes
NULL No
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
D Day Unknown
M Month Unknown
Y Year Unknown
MIG_DONE Indicator Specifying Record Is Migrated to BP Table ISH_BPMIG_DONE CHAR 1 0
M Master Data Migrated
R Relationships Migrated
NULL Not Migrated
E Errors in Migration
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
X Yes
NULL No
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
X Yes
NULL No
/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