NPAT SAP (IS-H: Patient Master Data (General)) Table details
Dictionary Type: Table
Description: IS-H: Patient Master Data (General)
Description: IS-H: Patient Master Data (General)
Table field list including key, data, relationships and ABAP select examples
NPAT is a standard SAP Table which is used to store IS-H: Patient Master Data (General) data and is available within R/3 SAP systems depending on the version and release level.
The NPAT table consists of various fields, each holding specific information or linking keys about IS-H: Patient Master Data (General) data available in SAP. These include PATNR (IS-H: Patient Number), EINRI (Institution), GSCHL (IS-H: Sex Indicator - Internal), NNAME (Patient Last Name).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .
Delivery Class: A - Application table (master and transaction data)Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)
SAP NPAT table fields - Full list of fields found in SAP data dictionary
| Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP |
| MANDT | Client | MANDT | CLNT | 3 | T000 | MANDT | |||
| PATNR | IS-H: Patient Number | PATNR | CHAR | 10 | ALPHA | PATNR | PAT | ||
| EINRI | Institution | EINRI | CHAR | 4 | TN01 | ALPHA | EINRI | EIN | |
| GSCHL | IS-H: Sex Indicator - Internal | GSCHL | CHAR | 1 | GSCHL | ||||
| NNAME | Patient Last Name | NNAME_PAT | CHAR | 30 | TEXT30 | ||||
| NNAMS | IS-H: Standardized Last Name | NNAMES_PAT | CHAR | 30 | CHAR30 | ||||
| VNAME | IS-H: Patient First Name | VNAME_PAT | CHAR | 30 | TEXT30 | ||||
| VNAMS | Standardized First Name | VNAMES_PAT | CHAR | 30 | CHAR30 | ||||
| TITEL | IS-H: Title | RI_TITEL | CHAR | 15 | Assigned to domain | TITEL | |||
| NAMZU | IS-H: Name Affix | RI_NAMZU | CHAR | 15 | Assigned to domain | TITEL | |||
| VORSW | IS-H: Name Prefix | RI_VORSW | CHAR | 15 | Assigned to domain | TITEL | |||
| NAME2 | Pseudonym, Order Name | NAME2_PAT | CHAR | 30 | TEXT30 | ||||
| GBDAT | IS-H: Birthdate | RI_GBDAT | DATS | 8 | RI_DATUM | ||||
| GBNAM | IS-H: Birthname | GBNAM | CHAR | 30 | TEXT30 | ||||
| GBNAS | IS-H: Standardized Birthname | GBNAMS_PAT | CHAR | 30 | CHAR30 | ||||
| GLAND | IS-H: Country of Birth | GLAND | CHAR | 3 | T005 | LAND1 | |||
| TODKZ | IS-H: Patient Is Deceased | PAT_TOD | CHAR | 1 | XFELD | ||||
| TODDT | IS-H: Date of Death From | TODDV | DATS | 8 | RI_DATUM | ||||
| TODZT | Time of Death From | TODZV | TIMS | 6 | UHRZT | ||||
| TODDB | Date of Death To | TODDB | DATS | 8 | RI_DATUM | ||||
| TODZB | IS-H: Time of Death To | TODZB | TIMS | 6 | UHRZT | ||||
| TODUR | IS-H: Cause of Death | TODUR | CHAR | 3 | TN18A | TODUR | |||
| ANRED | IS-H: Form-of-Address Key | RI_ANRDS | CHAR | 2 | Assigned to domain | RI_ANRDS | |||
| FAMST | IS-H: Marital Status | RI_FAMST | CHAR | 1 | RI_FAMST | ||||
| KONFE | IS-H: Religion | RI_KONFE | CHAR | 2 | RI_KONFE | ||||
| NATIO | IS-H: Nationality | RI_NATIO | CHAR | 3 | T005 | LAND1 | |||
| SPRAS | Patient Language | SPRAS_PAT | LANG | 1 | T002 | ISOLA | SPRAS | ||
| LAND | IS-H: Country of patient's place of residence | LAND_PAT | CHAR | 3 | T005 | LAND1 | |||
| PSTLZ | IS-H: Patient Postal Code | PSTLZ_PAT | CHAR | 10 | PSTLZ | ||||
| ORT | IS-H: City where Patient Resides | ORT01_PAT | CHAR | 25 | TEXT25 | ||||
| ORT2 | Patient District | ORT02_PAT | CHAR | 25 | TEXT25 | ||||
| STRAS | IS-H: Street and House Number of Patient | STRAS_PAT | CHAR | 30 | STRAS | ||||
| BLAND | IS-H: Region (Federal State, Province, County) | ISH_REGION | CHAR | 3 | T005S | REGIO | |||
| GEBIE | IS-H: Geographical Area | EINZGEBIET | CHAR | 9 | EINZGEBIET | ||||
| TELF1 | IS-H: Patient Telephone Number | TELF_PAT | CHAR | 16 | TEXT16 | ||||
| SPEND | Organ Donor Indicator | SPENKZ | CHAR | 1 | XFELD | ||||
| SPENT | Explanation for Donor Indicator | SPENTEXT | CHAR | 50 | TEXT50 | ||||
| SPELT | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
| VIPKZ | IS-H: VIP Indicator | VIPKZ | CHAR | 1 | XFELD | ||||
| ARCHV | IS-H: Archived Data Indicator | ARCHIV | CHAR | 1 | XFELD | ||||
| STATU | Patient Status | PAT_STATUS | CHAR | 1 | PAT_STATUS | ||||
| EXTNR | IS-H: External Patient Identification | EXT_PATNR | CHAR | 20 | EXT_PATNR | ||||
| NOTAN | IS-H: Emergency Admission Indicator | NOTAUF | CHAR | 1 | XFELD | ||||
| KRZAN | IS-H: Quick Admission Indicator | KURZAUF | CHAR | 1 | XFELD | ||||
| RFPAT | Reference to Patient Number in Merging | RFPAT | CHAR | 10 | Assigned to domain | ALPHA | PATNR | ||
| RFZIF | Check Digit for Patient | PZIFF_PAT | CHAR | 1 | PZIFF | PZP | |||
| BERUF | IS-H: Patient Occupation | BERUF | CHAR | 25 | TEXT25 | ||||
| AGNUM | IS-H: Patient's Employer | AGNUM_PAT | CHAR | 10 | NGPA | ALPHA | RI_KUNNR | ||
| AGNAM | IS-H: Employer Name | AGNAM | CHAR | 30 | TEXT30 | ||||
| AGLAN | IS-H: Employer Country | AGLAN | CHAR | 3 | T005 | LAND1 | |||
| AGPLZ | IS-H: Employer Postal Code | AGPLZ | CHAR | 10 | PSTLZ | ||||
| AGORT | IS-H: Employer City | AGORT | CHAR | 25 | TEXT25 | ||||
| AGSTR | IS-H: Employer Street | AGSTR | CHAR | 30 | STRAS | ||||
| AGTEL | IS-H: Employer Telephone Number | AGTEL | CHAR | 16 | TEXT16 | ||||
| RVNUM | IS-H: Social Insurance Number | ISH_RVNUM | CHAR | 20 | ISH_SVNUM | ||||
| ANNA1 | IS-H: Last Name of Person to Be Contacted | NNAME_ANG | CHAR | 30 | TEXT30 | ||||
| ANVN1 | IS-H: First Name of Person to Be Contacted | VNAME_ANG | CHAR | 30 | TEXT30 | ||||
| ANLA1 | Country of the Person to Be Contacted | LAND_ANG | CHAR | 3 | T005 | LAND1 | |||
| ANPL1 | IS-H: Postal Code | PSTLZ_ANG | CHAR | 10 | PSTLZ | ||||
| ANOR1 | IS-H: City where Person to Be Contacted Resides | ORT01_ANG | CHAR | 25 | TEXT25 | ||||
| ANST1 | IS-H: Street and House Number of Person to Be Contacted | STRAS_ANG | CHAR | 30 | STRAS | ||||
| ANTE1 | IS-H: Telephone Number of Person to Be Contacted | TELF_ANG | CHAR | 16 | TEXT16 | ||||
| ANVV1 | IS-H: Relationship | VERWVH | CHAR | 1 | TN17B | VERWVH | |||
| VMKZ1 | IS-H: Legal Representative | VORMUND | CHAR | 1 | XFELD | ||||
| ANNA2 | IS-H: Last Name of Person to Be Contacted | NNAME_ANG | CHAR | 30 | TEXT30 | ||||
| ANVN2 | IS-H: First Name of Person to Be Contacted | VNAME_ANG | CHAR | 30 | TEXT30 | ||||
| ANLA2 | Country of the Person to Be Contacted | LAND_ANG | CHAR | 3 | T005 | LAND1 | |||
| ANPL2 | IS-H: Postal Code | PSTLZ_ANG | CHAR | 10 | PSTLZ | ||||
| ANOR2 | IS-H: City where Person to Be Contacted Resides | ORT01_ANG | CHAR | 25 | TEXT25 | ||||
| ANST2 | IS-H: Street and House Number of Person to Be Contacted | STRAS_ANG | CHAR | 30 | STRAS | ||||
| ANTE2 | IS-H: Telephone Number of Person to Be Contacted | TELF_ANG | CHAR | 16 | TEXT16 | ||||
| ANVV2 | IS-H: Relationship | VERWVH | CHAR | 1 | TN17B | VERWVH | |||
| VMKZ2 | IS-H: Legal Representative | VORMUND | CHAR | 1 | XFELD | ||||
| KZTXT | IS-H: Comment on Patient | TEXT_PAT | CHAR | 50 | TEXT50 | ||||
| LGTXT | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | XFELD | ||||
| BEGDT | IS-H: Valid-From Date of Record | RI_BEGDT | DATS | 8 | RI_DATUM | ||||
| ENDDT | IS-H: Valid-To Date of Record | RI_ENDDT | DATS | 8 | RI_DATUM | ||||
| HISTK | Indicator that History Records Are Available | RI_HISTK | CHAR | 1 | XFELD | ||||
| RISKF | IS-H: Risk Information Exists for the Patient | ISH_RISIKO | CHAR | 1 | XFELD | ||||
| TESTP | Test Patient Status | TESTP | CHAR | 1 | XFELD | ||||
| PZIFF | Check Digit for Patient | PZIFF_PAT | CHAR | 1 | PZIFF | PZP | |||
| ERDAT | IS-H: Date when Record Created | RI_ERDAT | DATS | 8 | RI_DATUM | ||||
| ERUSR | IS-H: Name of Employee who Created Record | RI_ERNAM | CHAR | 12 | USNAM | ||||
| UPDAT | IS-H: Date of Last Change | RI_UPDAT | DATS | 8 | RI_DATUM | ||||
| UPUSR | IS-H: Name of Person who Last Changed Data | RI_UPNAM | CHAR | 12 | USNAM | ||||
| STORN | IS-H: Cancellation Indicator | RI_STORN | CHAR | 1 | XFELD | ||||
| STUSR | IS-H: Name of User who Canceled Data Record | STORN_USER | CHAR | 12 | USNAM | ||||
| STDAT | Date of Cancellation | STORN_DAT | DATS | 8 | RI_DATUM | ||||
| GBORT | IS-H: Patient Birthplace | ISH_GBORT | CHAR | 25 | TEXT25 | ||||
| HARNR | IS-H: Personnel Number of Family Physician | HARNR | CHAR | 10 | NGPA | ALPHA | RI_KUNNR | ||
| EARNR | IS-H: Personnel Number of Referring Physician | EARNR | CHAR | 10 | NGPA | ALPHA | RI_KUNNR | ||
| UARNR | IS-H: Personnel Number of Referring Physician | UARNR | CHAR | 10 | NGPA | ALPHA | RI_KUNNR | ||
| RACE | IS-H: Race | ISH_RACE | CHAR | 2 | TN17R | ALPHA | ISH_RACE | ||
| RESID | Indicator That Patient Is Non-Resident | ISH_RESID | CHAR | 1 | XFELD | ||||
| PASSTY | Type of Identification Document | ISH_PASSTY | CHAR | 2 | TN17D | ALPHA | ISH_PASSTY | ||
| PASSNR | IS-H: Identification Document Number | ISH_PASSNR | CHAR | 15 | NLJUS | ISH_PASSNR | |||
| ADRNR | IS-H: Address Number | ISH_ADRNR | CHAR | 10 | NADR | ALPHA | ISH_ADRNR | ||
| ADROB | IS-H: Address Object | ISH_ADROBJ | CHAR | 4 | ISH_ADROBJ | ||||
| ADNAG | IS-H: Address Number | ISH_ADRNR | CHAR | 10 | NADR | ALPHA | ISH_ADRNR | ||
| ADOAG | IS-H: Address Object | ISH_ADROBJ | CHAR | 4 | ISH_ADROBJ | ||||
| ADNN1 | IS-H: Address Number | ISH_ADRNR | CHAR | 10 | NADR | ALPHA | ISH_ADRNR | ||
| ADON1 | IS-H: Address Object | ISH_ADROBJ | CHAR | 4 | ISH_ADROBJ | ||||
| ADNN2 | IS-H: Address Number | ISH_ADRNR | CHAR | 10 | NADR | ALPHA | ISH_ADRNR | ||
| ADON2 | IS-H: Address Object | ISH_ADROBJ | CHAR | 4 | ISH_ADROBJ | ||||
| ANEX1 | External Identification of Next of Kin | EXTNR_ANG | CHAR | 20 | EXT_PATNR | ||||
| ANEX2 | External Identification of Next of Kin | EXTNR_ANG | CHAR | 20 | EXT_PATNR | ||||
| ADRN2 | IS-H: Address Number | ISH_ADRNR | CHAR | 10 | NADR | ALPHA | ISH_ADRNR | ||
| ADRO2 | IS-H: Address Object | ISH_ADROBJ | CHAR | 4 | ISH_ADROBJ | ||||
| INACT | 'Inactive' Indicator | ISH_INACTIVE | CHAR | 1 | XFELD | ||||
| USER1 | IS-H: User-Defined Field 1 | ISH_PATUSER1 | CHAR | 20 | ISH_PATUSER1 | ||||
| USER2 | IS-H: User-Defined Field 2 | ISH_PATUSER2 | CHAR | 20 | ISH_PATUSER2 | ||||
| USER3 | IS-H: User-Defined Field 3 | ISH_PATUSER3 | DATS | 8 | ISH_PATUSER3 | ||||
| USER4 | IS-H: User-Defined Field 4 | ISH_PATUSER4 | DATS | 8 | ISH_PATUSER4 | ||||
| USER5 | IS-H: User-Defined Field 5 | ISH_PATUSER5 | CHAR | 50 | ISH_PATUSER5 | ||||
| USER6 | IS-H: User-Defined Field 6 | ISH_PATUSER6 | CHAR | 1 | ISH_PATUSER6 | ||||
| EXTAUFG | EXTAUFG | CHAR | 1 | XFELD | |||||
| EXTAUFGA | EXTAUFGA | CHAR | 2 | TNWCHEA16 | EXTAUFGA | ||||
| EMPSC | IS-H: Employed Since | ISH_EMPDAT | DATS | 8 | RI_DATUM | ||||
| UNKNOWN_GBDAT | Birthdate Is Unknown | ISH_UNKNOWN_GBDAT | CHAR | 1 | ISH_UNKNOWN_GBDAT | ||||
| MIG_DONE | Indicator Specifying Record Is Migrated to BP Table | ISH_BPMIG_DONE | CHAR | 1 | ISH_BPMIG_DONE | ||||
| INSID | ISH_VERS_NR | CHAR | 10 | ||||||
| ISTAT_BPL | ISTAT Code | ISH_ISTAT | CHAR | 6 | ISH_ISTAT | ||||
| TAXNUM | Tax Number of Person | ISH_IT_TAXNUM | CHAR | 20 | BPTAXNUM | ||||
| TAXNUM_IND | Tax Number Indicator | ISH_TAXNUM_IND | CHAR | 1 | XFELD | ||||
| STP | STP Code | ISH_STP | CHAR | 16 | ISH_STP | ||||
| STP_ENDDT | End of Validity of STP Code | ISH_STPEND | DATS | 8 | RI_DATUM | ||||
| CONS_PERSDATA | Consent for Processing of Personal Data | ISH_CONS_PERSDATA | CHAR | 1 | XFELD | ||||
| /ISHFR/BIRTHRK | IS-H FR: Birth Rank | /ISHFR/ISH_BIRTH_RANK | NUMC | 1 | /ISHFR/ISH_BIRTH_RANK | ||||
| DTH_LOC | Location of Death | ISH_DTH_LOC | CHAR | 2 | TN18L | ISH_LOC | |||
| OCCUP | National Occupation Category | ISH_CN_OCCUP | CHAR | 5 | TN17C | ISH_CN_OCCUP | |||
| NARNR_S | Postdischarge Physician for Inpatient Stays | ISH_POSTDIS_PHYS_INP | CHAR | 10 | Assigned to domain | ALPHA | RI_KUNNR | ||
| NARNR_A | Postdischarge Physician for Outpatient Stays | ISH_POSTDIS_PHYS_OUTP | CHAR | 10 | Assigned to domain | ALPHA | RI_KUNNR |
| Key field | Non-key field |
How do I retrieve data from SAP table NPAT using ABAP code
The following ABAP code Example will allow you to do a basic selection on NPAT to SELECT all data from the tableDATA: WA_NPAT TYPE NPAT.
SELECT SINGLE *
FROM NPAT
INTO CORRESPONDING FIELDS OF WA_NPAT
WHERE...
How to access SAP table NPAT
Within an ECC or HANA version of SAP you can also view further information about NPAT and the data within it using relevant transactions such asSE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).
Search for further information about these or an SAP related objects