SAP NFHIR_NPAT_IM Table in S/4 HANA - Patient Data









NFHIR_NPAT_IM is a standard SAP Table which is used to store Patient Data data and is available within S/4 HANA SAP systems depending on the version and release level. Below is the technical details and the list of fields specifically relevant for an SAP S/4 HANA system

Even using an S/4 Hana system you can still view further information about the SAP NFHIR_NPAT_IM table and the data within it using standard SAP GUI transactions such as SE11, SE80 or SE16. Or you can use the ADT (ABAP development tools within eclipse).

Delivery Class:
Display/Maintenance via SM30: Display/Maintenance Allowed but with Restrictions
Enhancement category: Can Be Enhanced (Deep)
Dictionary Type: Structure
Database Table: NFHIR_NPAT_IM


NFHIR_NPAT_IM table structure field list

Below is the full NFHIR_NPAT_IM 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
NNAMEPatient Last NameNNAME_PATCHAR30(0) TEXT30
VNAMEPatient First NameVNAME_PATCHAR30(0) TEXT30
GBNAMBirthnameGBNAMCHAR30(0) TEXT30
GBDATBirthdateRI_GBDATDATS8(0) RI_DATUM
GLANDCountry of BirthGLANDCHAR3(0) LAND1
GBORTPatient BirthplaceISH_GBORTCHAR25(0) TEXT25
GSCHLPatient GenderNPA_GENDERCHAR1(0) AD_SEX
GSCHLESex Indicator - User-SpecificGSCHLECHAR1(0) GSCHLE
ANREXForm-of-Address KeyAD_TITLECHAR4(0) AD_TITLE
TITELForm-of-Address KeyAD_TITLECHAR4(0) AD_TITLE
NAMZUName supplement, e.g. noble title (key)AD_TITLESCHAR4(0) AD_TITLES
VORSWName Prefix (Key)AD_PREFIXCHAR4(0) AD_PREFIX
NAME2Pseudonym, Order NameNAME2_PATCHAR30(0) TEXT30
ADDRESSSTRU0(0)
PSTLZPostal Code of CityISH_PSTLZOCHAR10(0) PSTLZ
LANDCountryISH_LANDCHAR3(0) LAND1
REGIORegion (Federal State, Province, County)ISH_REGIONCHAR3(0) REGIO
ORTCityISH_CITY1CHAR40(0) TEXT40
ORT2DistrictISH_CITY2CHAR40(0) TEXT40
STRASStreetISH_STRASSCHAR40(0) TEXT40
STRAZOther Designation Qualifying the AddressISH_STRASZCHAR40(0) TEXT40
EINZGGeographical AreaEINZGEBIETCHAR9(0) EINZGEBIET
PSTLPPostal Code of P.O. BoxISH_PSTLZPCHAR10(0) PSTLZ
PFACHPost Office BoxISH_POBOXCHAR10(0) ISH_PFACH
LANPFCountry of Post Office BoxISH_LANDPBCHAR3(0) LAND1
ORTPFPO Box CityISH_CITYPBCHAR40(0) TEXT40
PSTLFPostal Code of Company (for Major Accounts)ISH_PSTLZFCHAR10(0) PSTLZ
TELNOTTYP0(0)
FAXNRFax NumberISH_FAXNRCHAR30(0) CHAR30
FAXXTFax Number - ExtensionISH_FAXEXTCHAR10(0) CHAR10
TEXNRTelex NumberISH_TELETXCHAR30(0) TEXT30
BUILDBlock/HouseISH_BUILDCHAR10(0) TEXT10
FLOORBlock/House LevelISH_FLOORCHAR10(0) TEXT10
ROOMUnit NumberISH_ROOMCHAR10(0) TEXT10
EMAILInternet Mail (SMTP) AddressISH_SMTPADRCHAR241(0) SXIDNAD_SMTPADR
HSNM1House NumberAD_HSNM1CHAR10(0) TEXT10
STRAS_LONGStreetAD_STREETCHAR60(0) TEXT60CLSTRTNAMESTREET
STR_SUPPLSupplement 2ISH_LCTNCHAR40(0) TEXT40
NAME_COc/o NameISH_NAME_COCHAR40(0) TEXT40
DEFLT_COMMStandard Communication Type if ISH_BP_OM ActiveISH_DFLTCMMCHAR3(0) AD_COMTYPE
MOB_NMBRCell Phone if ISH_BP_OM ActiveISH_MOBNRCHAR30(0) CHAR30
MOBTTYP0(0)
ADDRESS2STRU0(0)
PSTLZPostal Code of CityISH_PSTLZOCHAR10(0) PSTLZ
LANDCountryISH_LANDCHAR3(0) LAND1
REGIORegion (Federal State, Province, County)ISH_REGIONCHAR3(0) REGIO
ORTCityISH_CITY1CHAR40(0) TEXT40
ORT2DistrictISH_CITY2CHAR40(0) TEXT40
STRASStreetISH_STRASSCHAR40(0) TEXT40
STRAZOther Designation Qualifying the AddressISH_STRASZCHAR40(0) TEXT40
EINZGGeographical AreaEINZGEBIETCHAR9(0) EINZGEBIET
PSTLPPostal Code of P.O. BoxISH_PSTLZPCHAR10(0) PSTLZ
PFACHPost Office BoxISH_POBOXCHAR10(0) ISH_PFACH
LANPFCountry of Post Office BoxISH_LANDPBCHAR3(0) LAND1
ORTPFPO Box CityISH_CITYPBCHAR40(0) TEXT40
PSTLFPostal Code of Company (for Major Accounts)ISH_PSTLZFCHAR10(0) PSTLZ
TELNOTTYP0(0)
FAXNRFax NumberISH_FAXNRCHAR30(0) CHAR30
FAXXTFax Number - ExtensionISH_FAXEXTCHAR10(0) CHAR10
TEXNRTelex NumberISH_TELETXCHAR30(0) TEXT30
BUILDBlock/HouseISH_BUILDCHAR10(0) TEXT10
FLOORBlock/House LevelISH_FLOORCHAR10(0) TEXT10
ROOMUnit NumberISH_ROOMCHAR10(0) TEXT10
EMAILInternet Mail (SMTP) AddressISH_SMTPADRCHAR241(0) SXIDNAD_SMTPADR
HSNM1House NumberAD_HSNM1CHAR10(0) TEXT10
STRAS_LONGStreetAD_STREETCHAR60(0) TEXT60CLSTRTNAMESTREET
STR_SUPPLSupplement 2ISH_LCTNCHAR40(0) TEXT40
NAME_COc/o NameISH_NAME_COCHAR40(0) TEXT40
DEFLT_COMMStandard Communication Type if ISH_BP_OM ActiveISH_DFLTCMMCHAR3(0) AD_COMTYPE
MOB_NMBRCell Phone if ISH_BP_OM ActiveISH_MOBNRCHAR30(0) CHAR30
MOBTTYP0(0)
FATXTShort nameBU_BEZ20CHAR20(0) TEXT20
KOTXTReligious DenominationKITXTCHAR4(0) KITXT
NATIONationalityRI_NATIOCHAR3(0) LAND1
SPRASPatient LanguageSPRAS_PATLANG1(0) ISOLASPRAS
SPTXTName of LanguageSPTXTCHAR16(0) SPTXT16DSB
PATXTTTYP0(0)
SPENDOrgan Donor IndicatorSPENKZCHAR1(0) XFELD
SPENTXTTTYP0(0)
VIPKZVIP IndicatorVIPKZCHAR1(0) XFELD
TODKZPatient Is DeceasedPAT_TODCHAR1(0) XFELD
TODDTDate of Death FromTODDVDATS8(0) RI_DATUM
TODZTTime of Death FromTODZVTIMS6(0) UHRZT
TODDBDate of Death ToTODDBDATS8(0) RI_DATUM
TODZBTime of Death ToTODZBTIMS6(0) UHRZT
TODURCause of DeathTODURCHAR3(0) TODUR
NOTANEmergency Admission IndicatorNOTAUFCHAR1(0) XFELD
KRZANQuick Admission IndicatorKURZAUFCHAR1(0) XFELD
RESIDIndicator That Patient Is Non-ResidentISH_RESIDCHAR1(0) XFELD
INACT'Inactive' IndicatorISH_INACTIVECHAR1(0) XFELD
PFORTPatient Does not Appear in Public ListPFORTCHAR1(0) XFELD
PFAKZReligious List IndicatorPFAKZCHAR1(0) XFELD
PFARRParishPFARRCHAR2(0) PFARR
RACERaceISH_RACECHAR2(0) ALPHAISH_RACE
EXTNRExternal Patient IdentificationEXT_PATNRCHAR40(0) EXT_PATNR
RVNUMSocial Insurance NumberISH_RVNUMCHAR20(0) ISH_SVNUM
INSIDUnique Insurance Number (EHC)ISH_VERS_NRCHAR10(0)
PASSTYType of Identification DocumentISH_PASSTYCHAR2(0) ALPHAISH_PASSTY
PASSNRIdentification Document NumberISH_PASSNRCHAR15(0) ISH_PASSNR
AGADDRESSSTRU0(0)
PSTLZPostal Code of CityISH_PSTLZOCHAR10(0) PSTLZ
LANDCountryISH_LANDCHAR3(0) LAND1
REGIORegion (Federal State, Province, County)ISH_REGIONCHAR3(0) REGIO
ORTCityISH_CITY1CHAR40(0) TEXT40
ORT2DistrictISH_CITY2CHAR40(0) TEXT40
STRASStreetISH_STRASSCHAR40(0) TEXT40
STRAZOther Designation Qualifying the AddressISH_STRASZCHAR40(0) TEXT40
EINZGGeographical AreaEINZGEBIETCHAR9(0) EINZGEBIET
PSTLPPostal Code of P.O. BoxISH_PSTLZPCHAR10(0) PSTLZ
PFACHPost Office BoxISH_POBOXCHAR10(0) ISH_PFACH
LANPFCountry of Post Office BoxISH_LANDPBCHAR3(0) LAND1
ORTPFPO Box CityISH_CITYPBCHAR40(0) TEXT40
PSTLFPostal Code of Company (for Major Accounts)ISH_PSTLZFCHAR10(0) PSTLZ
TELNOTTYP0(0)
FAXNRFax NumberISH_FAXNRCHAR30(0) CHAR30
FAXXTFax Number - ExtensionISH_FAXEXTCHAR10(0) CHAR10
TEXNRTelex NumberISH_TELETXCHAR30(0) TEXT30
BUILDBlock/HouseISH_BUILDCHAR10(0) TEXT10
FLOORBlock/House LevelISH_FLOORCHAR10(0) TEXT10
ROOMUnit NumberISH_ROOMCHAR10(0) TEXT10
EMAILInternet Mail (SMTP) AddressISH_SMTPADRCHAR241(0) SXIDNAD_SMTPADR
HSNM1House NumberAD_HSNM1CHAR10(0) TEXT10
STRAS_LONGStreetAD_STREETCHAR60(0) TEXT60CLSTRTNAMESTREET
STR_SUPPLSupplement 2ISH_LCTNCHAR40(0) TEXT40
NAME_COc/o NameISH_NAME_COCHAR40(0) TEXT40
DEFLT_COMMStandard Communication Type if ISH_BP_OM ActiveISH_DFLTCMMCHAR3(0) AD_COMTYPE
MOB_NMBRCell Phone if ISH_BP_OM ActiveISH_MOBNRCHAR30(0) CHAR30
MOBTTYP0(0)
ANNA1Last Name of Person to Be ContactedNNAME_ANGCHAR30(0) TEXT30
ANVN1First Name of Person to Be ContactedVNAME_ANGCHAR30(0) TEXT30
ANVV1RelationshipVERWVHCHAR1(0) VERWVH
VMKZ1Legal RepresentativeVORMUNDCHAR1(0) XFELD
ANEX1External Identification of Next of KinEXTNR_ANGCHAR40(0) EXT_PATNR
A1ADDRESSSTRU0(0)
PSTLZPostal Code of CityISH_PSTLZOCHAR10(0) PSTLZ
LANDCountryISH_LANDCHAR3(0) LAND1
REGIORegion (Federal State, Province, County)ISH_REGIONCHAR3(0) REGIO
ORTCityISH_CITY1CHAR40(0) TEXT40
ORT2DistrictISH_CITY2CHAR40(0) TEXT40
STRASStreetISH_STRASSCHAR40(0) TEXT40
STRAZOther Designation Qualifying the AddressISH_STRASZCHAR40(0) TEXT40
EINZGGeographical AreaEINZGEBIETCHAR9(0) EINZGEBIET
PSTLPPostal Code of P.O. BoxISH_PSTLZPCHAR10(0) PSTLZ
PFACHPost Office BoxISH_POBOXCHAR10(0) ISH_PFACH
LANPFCountry of Post Office BoxISH_LANDPBCHAR3(0) LAND1
ORTPFPO Box CityISH_CITYPBCHAR40(0) TEXT40
PSTLFPostal Code of Company (for Major Accounts)ISH_PSTLZFCHAR10(0) PSTLZ
TELNOTTYP0(0)
FAXNRFax NumberISH_FAXNRCHAR30(0) CHAR30
FAXXTFax Number - ExtensionISH_FAXEXTCHAR10(0) CHAR10
TEXNRTelex NumberISH_TELETXCHAR30(0) TEXT30
BUILDBlock/HouseISH_BUILDCHAR10(0) TEXT10
FLOORBlock/House LevelISH_FLOORCHAR10(0) TEXT10
ROOMUnit NumberISH_ROOMCHAR10(0) TEXT10
EMAILInternet Mail (SMTP) AddressISH_SMTPADRCHAR241(0) SXIDNAD_SMTPADR
HSNM1House NumberAD_HSNM1CHAR10(0) TEXT10
STRAS_LONGStreetAD_STREETCHAR60(0) TEXT60CLSTRTNAMESTREET
STR_SUPPLSupplement 2ISH_LCTNCHAR40(0) TEXT40
NAME_COc/o NameISH_NAME_COCHAR40(0) TEXT40
DEFLT_COMMStandard Communication Type if ISH_BP_OM ActiveISH_DFLTCMMCHAR3(0) AD_COMTYPE
MOB_NMBRCell Phone if ISH_BP_OM ActiveISH_MOBNRCHAR30(0) CHAR30
MOBTTYP0(0)
ANNA2Last Name of Person to Be ContactedNNAME_ANGCHAR30(0) TEXT30
ANVN2First Name of Person to Be ContactedVNAME_ANGCHAR30(0) TEXT30
ANVV2RelationshipVERWVHCHAR1(0) VERWVH
VMKZ2Legal RepresentativeVORMUNDCHAR1(0) XFELD
ANEX2External Identification of Next of KinEXTNR_ANGCHAR40(0) EXT_PATNR
A2ADDRESSSTRU0(0)
PSTLZPostal Code of CityISH_PSTLZOCHAR10(0) PSTLZ
LANDCountryISH_LANDCHAR3(0) LAND1
REGIORegion (Federal State, Province, County)ISH_REGIONCHAR3(0) REGIO
ORTCityISH_CITY1CHAR40(0) TEXT40
ORT2DistrictISH_CITY2CHAR40(0) TEXT40
STRASStreetISH_STRASSCHAR40(0) TEXT40
STRAZOther Designation Qualifying the AddressISH_STRASZCHAR40(0) TEXT40
EINZGGeographical AreaEINZGEBIETCHAR9(0) EINZGEBIET
PSTLPPostal Code of P.O. BoxISH_PSTLZPCHAR10(0) PSTLZ
PFACHPost Office BoxISH_POBOXCHAR10(0) ISH_PFACH
LANPFCountry of Post Office BoxISH_LANDPBCHAR3(0) LAND1
ORTPFPO Box CityISH_CITYPBCHAR40(0) TEXT40
PSTLFPostal Code of Company (for Major Accounts)ISH_PSTLZFCHAR10(0) PSTLZ
TELNOTTYP0(0)
FAXNRFax NumberISH_FAXNRCHAR30(0) CHAR30
FAXXTFax Number - ExtensionISH_FAXEXTCHAR10(0) CHAR10
TEXNRTelex NumberISH_TELETXCHAR30(0) TEXT30
BUILDBlock/HouseISH_BUILDCHAR10(0) TEXT10
FLOORBlock/House LevelISH_FLOORCHAR10(0) TEXT10
ROOMUnit NumberISH_ROOMCHAR10(0) TEXT10
EMAILInternet Mail (SMTP) AddressISH_SMTPADRCHAR241(0) SXIDNAD_SMTPADR
HSNM1House NumberAD_HSNM1CHAR10(0) TEXT10
STRAS_LONGStreetAD_STREETCHAR60(0) TEXT60CLSTRTNAMESTREET
STR_SUPPLSupplement 2ISH_LCTNCHAR40(0) TEXT40
NAME_COc/o NameISH_NAME_COCHAR40(0) TEXT40
DEFLT_COMMStandard Communication Type if ISH_BP_OM ActiveISH_DFLTCMMCHAR3(0) AD_COMTYPE
MOB_NMBRCell Phone if ISH_BP_OM ActiveISH_MOBNRCHAR30(0) CHAR30
MOBTTYP0(0)
HARNRPersonnel Number of Family PhysicianHARNRCHAR10(0) ALPHARI_KUNNR
EARNRPersonnel Number of Referring PhysicianEARNRCHAR10(0) ALPHARI_KUNNR
UARNRPersonnel Number of Referring PhysicianUARNRCHAR10(0) ALPHARI_KUNNR
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
ERDATDate when Record CreatedRI_ERDATDATS8(0) RI_DATUM
ERUSRName of Employee who Created RecordRI_ERNAMCHAR12(0) USNAM
UPDATDate of Last ChangeRI_UPDATDATS8(0) RI_DATUM
UPUSRName of Person Who Last Changed DataRI_UPNAMCHAR12(0) USNAM
STORNCancellation IndicatorRI_STORNCHAR1(0) XFELD
STUSRName of User who Canceled Data RecordSTORN_USERCHAR12(0) USNAM
STDATDate of CancellationSTORN_DATDATS8(0) RI_DATUM
UNKNOWN_GBDATBirthdate Is UnknownISH_UNKNOWN_GBDATCHAR1(0) ISH_UNKNOWN_GBDAT
VNAME_LONGPatient First NameISH_VNAME_PAT_LONGCHAR70(0) TEXT70
NNAME_LONGPatient Last NameISH_NNAME_PAT_LONGCHAR70(0) TEXT70
GBNAM_LONGBirth NameISH_GBNAM_LONGCHAR70(0) TEXT70
TITLE_ACA2Second academic title (key)AD_TITLE2CHAR4(0) AD_TITLE1
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!