SAP NPNT Table in S/4 HANA - Patient Master Data
NPNT is a standard SAP Table which is used to store Patient Master Data data and is available within SAP S/4 HANA systems and previous ECC R/3 systems. Below is the technical details and the field list relevant for an SAP S/4 HANA system, see here for details and fields available within the SAP R/3 version of the NPNT table(ECC)
Delivery Class: A - Application table (master and transaction data)
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can be enhanced (character-type or numeric)
Dictionary Type: Transparent table
Database Table: NPNT
NPNT table structure field list
Below is the full NPNT field list that makes up the SAP database table structure, including key fields, description, data type and other technical details of each field
Field | Description | Data Element | Data Type | length (Dec) | Check table | Conversion Routine | Domain Name | MemoryID | SHLP | SHLP Field |
MANDT | Client | MANDT | CLNT | 3(0) | MANDT | |||||
PARTNER | Business Partner Number for Patient | ISH_PNT_ID | CHAR | 10(0) | BUT000 | ALPHA | BU_PARTNER | |||
INSTN | Institution | EINRI | CHAR | 4(0) | TN01 | ALPHA | EINRI | EIN | ||
PNT_GA | Geographical Area | EINZGEBIET | CHAR | 9(0) | EINZGEBIET | |||||
STD_LN | Standardized Last Name | NNAMES_PAT | CHAR | 80(0) | CHAR80 | |||||
STD_FN | Standardized First Name | VNAMES_PAT | CHAR | 80(0) | CHAR80 | |||||
STD_BN | Standardized Birth Name | GBNAMS_PAT | CHAR | 80(0) | CHAR80 | |||||
BIRTHCTRY | Country of Birth | GLAND | CHAR | 3(0) | Assigned to domain | LAND1 | ||||
PNT_CD | Check Digit for Patient | PZIFF_PAT | CHAR | 1(0) | PZIFF | |||||
DTH_IND | Patient Is Deceased | PAT_TOD | CHAR | 1(0) | XFELD | |||||
DTM_FRM | Time of Death From | TODZV | TIMS | 6(0) | UHRZT | |||||
DDAT_TO | Date of Death To | TODDB | DATS | 8(0) | RI_DATUM | |||||
DTM_TO | Time of Death To | TODZB | TIMS | 6(0) | UHRZT | |||||
DTH_CAU | Cause of Death | TODUR | CHAR | 3(0) | TN18A | TODUR | ||||
DTH_LOC | Location of Death | ISH_DTH_LOC | CHAR | 2(0) | Assigned to domain | ISH_LOC | ||||
RELGN | Religion | RI_KONFE | CHAR | 2(0) | RI_KONFE | |||||
RES_IND | Indicator That Patient Is Non-Resident | ISH_RESID | CHAR | 1(0) | XFELD | |||||
INA_IND | 'Inactive' Indicator | ISH_INACTIVE | CHAR | 1(0) | XFELD | |||||
ORD_IND | Organ Donor Indicator | SPENKZ | CHAR | 1(0) | XFELD | |||||
VIP_IND | VIP Indicator | VIPKZ | CHAR | 1(0) | XFELD | |||||
EADM_IND | Emergency Admission Indicator | NOTAUF | CHAR | 1(0) | XFELD | |||||
QADM_IND | Quick Admission Indicator | KURZAUF | CHAR | 1(0) | XFELD | |||||
CRT_USR | Name of Employee who Created Record | RI_ERNAM | CHAR | 12(0) | USNAM | |||||
CRT_DAT | Date when Record Created | RI_ERDAT | DATS | 8(0) | RI_DATUM | |||||
CHG_USR | Name of Person Who Last Changed Data | RI_UPNAM | CHAR | 12(0) | USNAM | |||||
CHG_DAT | Date of Last Change | RI_UPDAT | DATS | 8(0) | RI_DATUM | |||||
CCL_USR | Name of User who Canceled Data Record | STORN_USER | CHAR | 12(0) | USNAM | |||||
CCL_DAT | Date of Cancellation | STORN_DAT | DATS | 8(0) | RI_DATUM | |||||
CCL_IND | Cancellation Indicator | RI_STORN | CHAR | 1(0) | XFELD | |||||
RACE | Race | ISH_RACE | CHAR | 2(0) | TN17R | ALPHA | ISH_RACE | |||
SI_NUM | Social Insurance Number | ISH_RVNUM | CHAR | 20(0) | ISH_SVNUM | |||||
RFPNT | Reference to Patient Number in Merging | ISH_RFP_ID | CHAR | 10(0) | Assigned to domain | ALPHA | BU_PARTNER | |||
RFPNT_CD | Check Digit for Patient | PZIFF_PAT | CHAR | 1(0) | PZIFF | |||||
DOC_TYP | Type of Identification Document | ISH_PASSTY | CHAR | 2(0) | TN17D | ALPHA | ISH_PASSTY | |||
DOC_NUM | Identification Document Number | ISH_PASSNR | CHAR | 15(0) | ISH_PASSNR | |||||
PNT_EXTNR | External Patient Identification | EXT_PATNR | CHAR | 40(0) | EXT_PATNR | |||||
DOB_UN | Birthdate Is Unknown | ISH_UNKNOWN_GBDAT | CHAR | 1(0) | ISH_UNKNOWN_GBDAT | |||||
USER1 | User-Defined Field 1 | ISH_PATUSER1 | CHAR | 20(0) | ISH_PATUSER1 | |||||
USER2 | User-Defined Field 2 | ISH_PATUSER2 | CHAR | 20(0) | ISH_PATUSER2 | |||||
USER3 | User-Defined Field 3 | ISH_PATUSER3 | DATS | 8(0) | ISH_PATUSER3 | |||||
USER4 | User-Defined Field 4 | ISH_PATUSER4 | DATS | 8(0) | ISH_PATUSER4 | |||||
USER5 | User-Defined Field 5 | ISH_PATUSER5 | CHAR | 50(0) | ISH_PATUSER5 | |||||
USER6 | User-Defined Field 6 | ISH_PATUSER6 | CHAR | 1(0) | ISH_PATUSER6 | |||||
PATNR | Patient Number | PATNR | CHAR | 10(0) | ALPHA | PATNR | ||||
ADR_KIND | Address Type | BU_ADRKIND | CHAR | 10(0) | TB009 | BU_ADRKIND | ||||
INSID | Unique Insurance Number (EHC) | ISH_VERS_NR | CHAR | 10(0) | ||||||
LAST_NAME_LONG | Patient Last Name | ISH_NNAME_PAT_LONG | CHAR | 70(0) | TEXT70 | |||||
FIRST_NAME_LONG | Patient First Name | ISH_VNAME_PAT_LONG | CHAR | 70(0) | TEXT70 | |||||
BIRTH_NAME_LONG | Birth Name | ISH_GBNAM_LONG | CHAR | 70(0) | TEXT70 | |||||
SEX_SPECIAL | Additional Attribute for Sex | ISH_SEX_SPECIALIZATION | CHAR | 1(0) | ISH_SEX_SPECIALIZATION |
Search for further information about these or an SAP related objects