NPNT SAP (Patient Master Data) Table details
Dictionary Type: Table
Description: Patient Master Data
Description: Patient Master Data
Table field list including key, data, relationships and ABAP select examples
NPNT is a standard SAP Table which is used to store Patient Master Data data and is available within R/3 SAP systems depending on the version and release level.
The NPNT table consists of various fields, each holding specific information or linking keys about Patient Master Data data available in SAP. These include PARTNER (Patient Number), INSTN (Institution), PNT_GA (IS-H: Geographical Area), STD_LN (IS-H: Standardized 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 NPNT 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 | Assigned to domain | MANDT | |||
PARTNER | Patient Number | ISH_PNT_ID | CHAR | 10 | BUT000 | ALPHA | BU_PARTNER | ||
INSTN | Institution | EINRI | CHAR | 4 | TN01 | ALPHA | EINRI | EIN | |
PNT_GA | IS-H: Geographical Area | EINZGEBIET | CHAR | 9 | EINZGEBIET | ||||
STD_LN | IS-H: Standardized Last Name | NNAMES_PAT | CHAR | 30 | CHAR30 | ||||
STD_FN | Standardized First Name | VNAMES_PAT | CHAR | 30 | CHAR30 | ||||
STD_BN | IS-H: Standardized Birthname | GBNAMS_PAT | CHAR | 30 | CHAR30 | ||||
BIRTHCTRY | IS-H: Country of Birth | GLAND | CHAR | 3 | Assigned to domain | LAND1 | |||
PNT_CD | Check Digit for Patient | PZIFF_PAT | CHAR | 1 | PZIFF | PZP | |||
DTH_IND | IS-H: Patient Is Deceased | PAT_TOD | CHAR | 1 | XFELD | ||||
DTM_FRM | Time of Death From | TODZV | TIMS | 6 | UHRZT | ||||
DDAT_TO | Date of Death To | TODDB | DATS | 8 | RI_DATUM | ||||
DTM_TO | IS-H: Time of Death To | TODZB | TIMS | 6 | UHRZT | ||||
DTH_CAU | IS-H: Cause of Death | TODUR | CHAR | 3 | TN18A | TODUR | |||
DTH_LOC | Location of Death | ISH_DTH_LOC | CHAR | 2 | Assigned to domain | ISH_LOC | |||
PAT_OCCU | IS-H: Patient Occupation | BERUF | CHAR | 25 | TEXT25 | ||||
EMPSC | IS-H: Employed Since | ISH_EMPDAT | DATS | 8 | RI_DATUM | ||||
ADDRNUMBER | Address number | AD_ADDRNUM | CHAR | 10 | Assigned to domain | ALPHA | AD_ADDRNUM | ADR | |
CN_OCCU | National Occupation Category | ISH_CN_OCCUP | CHAR | 5 | Assigned to domain | ISH_CN_OCCUP | |||
RELGN | IS-H: Religion | RI_KONFE | CHAR | 2 | RI_KONFE | ||||
RES_IND | Indicator That Patient Is Non-Resident | ISH_RESID | CHAR | 1 | XFELD | ||||
INA_IND | 'Inactive' Indicator | ISH_INACTIVE | CHAR | 1 | XFELD | ||||
ORD_IND | Organ Donor Indicator | SPENKZ | CHAR | 1 | XFELD | ||||
VIP_IND | IS-H: VIP Indicator | VIPKZ | CHAR | 1 | XFELD | ||||
EADM_IND | IS-H: Emergency Admission Indicator | NOTAUF | CHAR | 1 | XFELD | ||||
QADM_IND | IS-H: Quick Admission Indicator | KURZAUF | CHAR | 1 | XFELD | ||||
RIN_IND | IS-H: Risk Information Exists for the Patient | ISH_RISIKO | CHAR | 1 | XFELD | ||||
CRT_USR | IS-H: Name of Employee who Created Record | RI_ERNAM | CHAR | 12 | USNAM | ||||
CRT_DAT | IS-H: Date when Record Created | RI_ERDAT | DATS | 8 | RI_DATUM | ||||
CHG_USR | IS-H: Name of Person who Last Changed Data | RI_UPNAM | CHAR | 12 | USNAM | ||||
CHG_DAT | IS-H: Date of Last Change | RI_UPDAT | DATS | 8 | RI_DATUM | ||||
CCL_USR | IS-H: Name of User who Canceled Data Record | STORN_USER | CHAR | 12 | USNAM | ||||
CCL_DAT | Date of Cancellation | STORN_DAT | DATS | 8 | RI_DATUM | ||||
CCL_IND | IS-H: Cancellation Indicator | RI_STORN | CHAR | 1 | XFELD | ||||
RACE | IS-H: Race | ISH_RACE | CHAR | 2 | TN17R | ALPHA | ISH_RACE | ||
SI_NUM | IS-H: Social Insurance Number | ISH_RVNUM | CHAR | 20 | ISH_SVNUM | ||||
RFPNT | Reference to Patient Number in Merging | ISH_RFP_ID | CHAR | 10 | Assigned to domain | ALPHA | BU_PARTNER | ||
RFPNT_CD | Check Digit for Patient | PZIFF_PAT | CHAR | 1 | PZIFF | PZP | |||
DOC_TYP | Type of Identification Document | ISH_PASSTY | CHAR | 2 | TN17D | ALPHA | ISH_PASSTY | ||
DOC_NUM | IS-H: Identification Document Number | ISH_PASSNR | CHAR | 15 | NLJUS | ISH_PASSNR | |||
EO_IND | EXTAUFG | CHAR | 1 | XFELD | |||||
EO_TYPE | EXTAUFGA | CHAR | 2 | Assigned to domain | EXTAUFGA | ||||
PNT_EXTNR | IS-H: External Patient Identification | EXT_PATNR | CHAR | 20 | EXT_PATNR | ||||
DOB_UN | Birthdate Is Unknown | ISH_UNKNOWN_GBDAT | CHAR | 1 | ISH_UNKNOWN_GBDAT | ||||
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 | ||||
PATNR | IS-H: Patient Number | PATNR | CHAR | 10 | Assigned to domain | ALPHA | PATNR | PAT | |
ADR_KIND | Address Type | BU_ADRKIND | CHAR | 10 | TB009 | BU_ADRKIND | |||
INSID | ISH_VERS_NR | CHAR | 10 | ||||||
ISTAT_BPL | ISTAT Code | ISH_ISTAT | CHAR | 6 | ISH_ISTAT | ||||
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 |
Key field | Non-key field |
How do I retrieve data from SAP table NPNT using ABAP code
The following ABAP code Example will allow you to do a basic selection on NPNT to SELECT all data from the tableDATA: WA_NPNT TYPE NPNT.
SELECT SINGLE *
FROM NPNT
INTO CORRESPONDING FIELDS OF WA_NPNT
WHERE...
How to access SAP table NPNT
Within an ECC or HANA version of SAP you can also view further information about NPNT 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