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
MANDTClientMANDTCLNT3(0) MANDT
PARTNERBusiness Partner Number for PatientISH_PNT_IDCHAR10(0) BUT000ALPHABU_PARTNER
INSTNInstitutionEINRICHAR4(0) TN01ALPHAEINRIEIN
PNT_GAGeographical AreaEINZGEBIETCHAR9(0) EINZGEBIET
STD_LNStandardized Last NameNNAMES_PATCHAR80(0) CHAR80
STD_FNStandardized First NameVNAMES_PATCHAR80(0) CHAR80
STD_BNStandardized Birth NameGBNAMS_PATCHAR80(0) CHAR80
BIRTHCTRYCountry of BirthGLANDCHAR3(0) Assigned to domainLAND1
PNT_CDCheck Digit for PatientPZIFF_PATCHAR1(0) PZIFF
DTH_INDPatient Is DeceasedPAT_TODCHAR1(0) XFELD
DTM_FRMTime of Death FromTODZVTIMS6(0) UHRZT
DDAT_TODate of Death ToTODDBDATS8(0) RI_DATUM
DTM_TOTime of Death ToTODZBTIMS6(0) UHRZT
DTH_CAUCause of DeathTODURCHAR3(0) TN18ATODUR
DTH_LOCLocation of DeathISH_DTH_LOCCHAR2(0) Assigned to domainISH_LOC
RELGNReligionRI_KONFECHAR2(0) RI_KONFE
RES_INDIndicator That Patient Is Non-ResidentISH_RESIDCHAR1(0) XFELD
INA_IND'Inactive' IndicatorISH_INACTIVECHAR1(0) XFELD
ORD_INDOrgan Donor IndicatorSPENKZCHAR1(0) XFELD
VIP_INDVIP IndicatorVIPKZCHAR1(0) XFELD
EADM_INDEmergency Admission IndicatorNOTAUFCHAR1(0) XFELD
QADM_INDQuick Admission IndicatorKURZAUFCHAR1(0) XFELD
CRT_USRName of Employee who Created RecordRI_ERNAMCHAR12(0) USNAM
CRT_DATDate when Record CreatedRI_ERDATDATS8(0) RI_DATUM
CHG_USRName of Person Who Last Changed DataRI_UPNAMCHAR12(0) USNAM
CHG_DATDate of Last ChangeRI_UPDATDATS8(0) RI_DATUM
CCL_USRName of User who Canceled Data RecordSTORN_USERCHAR12(0) USNAM
CCL_DATDate of CancellationSTORN_DATDATS8(0) RI_DATUM
CCL_INDCancellation IndicatorRI_STORNCHAR1(0) XFELD
RACERaceISH_RACECHAR2(0) TN17RALPHAISH_RACE
SI_NUMSocial Insurance NumberISH_RVNUMCHAR20(0) ISH_SVNUM
RFPNTReference to Patient Number in MergingISH_RFP_IDCHAR10(0) Assigned to domainALPHABU_PARTNER
RFPNT_CDCheck Digit for PatientPZIFF_PATCHAR1(0) PZIFF
DOC_TYPType of Identification DocumentISH_PASSTYCHAR2(0) TN17DALPHAISH_PASSTY
DOC_NUMIdentification Document NumberISH_PASSNRCHAR15(0) ISH_PASSNR
PNT_EXTNRExternal Patient IdentificationEXT_PATNRCHAR40(0) EXT_PATNR
DOB_UNBirthdate Is UnknownISH_UNKNOWN_GBDATCHAR1(0) ISH_UNKNOWN_GBDAT
USER1User-Defined Field 1ISH_PATUSER1CHAR20(0) ISH_PATUSER1
USER2User-Defined Field 2ISH_PATUSER2CHAR20(0) ISH_PATUSER2
USER3User-Defined Field 3ISH_PATUSER3DATS8(0) ISH_PATUSER3
USER4User-Defined Field 4ISH_PATUSER4DATS8(0) ISH_PATUSER4
USER5User-Defined Field 5ISH_PATUSER5CHAR50(0) ISH_PATUSER5
USER6User-Defined Field 6ISH_PATUSER6CHAR1(0) ISH_PATUSER6
PATNRPatient NumberPATNRCHAR10(0) ALPHAPATNR
ADR_KINDAddress TypeBU_ADRKINDCHAR10(0) TB009BU_ADRKIND
INSIDUnique Insurance Number (EHC)ISH_VERS_NRCHAR10(0)
LAST_NAME_LONGPatient Last NameISH_NNAME_PAT_LONGCHAR70(0) TEXT70
FIRST_NAME_LONGPatient First NameISH_VNAME_PAT_LONGCHAR70(0) TEXT70
BIRTH_NAME_LONGBirth NameISH_GBNAM_LONGCHAR70(0) TEXT70
SEX_SPECIALAdditional Attribute for SexISH_SEX_SPECIALIZATIONCHAR1(0) ISH_SEX_SPECIALIZATION




Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!