1. Home
  2. Resources
  3. SAP Tables
  4. RNPAT - IS-H: Patient Master Screen Fields

SAP Table RNPAT

IS-H: Patient Master Screen Fields

RNPAT (IS-H: Patient Master Screen Fields) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link RNPAT to other SAP tables.

RNPAT table fields

Field Data element Checktable Datatype Length Decimals
MANDT Client MANDT T000 CLNT 3 0
EINRI Institution EINRI TN01 CHAR 4 0
NNAME Patient Last Name NNAME_PAT CHAR 30 0
VNAME IS-H: Patient First Name VNAME_PAT CHAR 30 0
GBNAM IS-H: Birthname GBNAM CHAR 30 0
GBDAT IS-H: Birthdate RI_GBDAT DATS 8 0
GSCHL IS-H: Sex Indicator - Internal GSCHL CHAR 1 0
1 male
2 female
3 unknown
GSCHLE IS-H: Sex Indicator - User-Specific GSCHLE CHAR 1 0
GSCHLTXT IS-H: Sex Specification - User-Specific TEXT_GES CHAR 10 0
ANREX IS-H: Form-of-Address Short Text ISH_AKURZ CHAR 5 0
TITEL IS-H: Title RI_TITEL CHAR 15 0
NAMZU IS-H: Name Affix RI_NAMZU CHAR 15 0
VORSW IS-H: Name Prefix RI_VORSW CHAR 15 0
NAME2 Pseudonym, Order Name NAME2_PAT CHAR 30 0
NATIO IS-H: Nationality RI_NATIO CHAR 3 0
NATXT Nationality NATIO CHAR 15 0
RESID Indicator That Patient Is Non-Resident ISH_RESID CHAR 1 0
X Yes
NULL No
UNKNOWN_GBDAT Birthdate Is Unknown ISH_UNKNOWN_GBDAT CHAR 1 0
D Day Unknown
M Month Unknown
Y Year Unknown
SPRAS Patient Language SPRAS_PAT LANG 1 0
SPTXT Name of Language SPTXT CHAR 16 0
GLAND IS-H: Country of Birth GLAND T005 CHAR 3 0
GLANT Country Name LANDX CHAR 15 0
GBORT IS-H: Patient Birthplace ISH_GBORT CHAR 25 0
FAMST Marital Status Key FAMST CHAR 1 0
SPRSL Language Key SPRAS LANG 1 0
FATXT Marital Status Designation RI_FATXT CHAR 6 0
KONFE IS-H: Religion RI_KONFE CHAR 2 0
KOTXT Religious Denomination KITXT CHAR 4 0
KTEXT Religious Denomination Long Text KNFTX CHAR 25 0
KZTXT IS-H: Comment on Patient TEXT_PAT CHAR 50 0
LGTXT Indicator that Long Text Exists RI_LGTXT CHAR 1 0
X Yes
NULL No
EXTNR IS-H: External Patient Identification EXT_PATNR CHAR 20 0
RVNUM IS-H: Social Insurance Number ISH_RVNUM CHAR 20 0
PASSTY Type of Identification Document ISH_PASSTY TN17D CHAR 2 0
PASSTX Text for Identification Document Type ISH_PASSTX CHAR 15 0
PASSNR IS-H: Identification Document Number ISH_PASSNR CHAR 15 0
PFARR IS-H: Parish PFARR TN13A CHAR 2 0
PFTXT IS-H: Text for Parish PFTXT CHAR 20 0
RACE IS-H: Race ISH_RACE TN17R CHAR 2 0
RACETXT IS-H: Race text ISH_RACETX CHAR 15 0
INSID ISH_VERS_NR CHAR 10 0
ISTAT_BPL ISTAT Code Birthplace ISH_ISTAT_BP CHAR 6 0
ISTAT_BPLTXT Text for ISTAT Code ISH_ISTATTXT CHAR 40 0
TAXNUM Tax Number of Person ISH_IT_TAXNUM CHAR 20 0
TAXNUM_IND Tax Number Indicator ISH_TAXNUM_IND CHAR 1 0
X Yes
NULL No
STP STP Code ISH_STP CHAR 16 0
STP_ENDDT End of Validity of STP Code ISH_STPEND DATS 8 0
SPEND Organ Donor Indicator SPENKZ CHAR 1 0
X Yes
NULL No
SPENT Explanation for Donor Indicator SPENTEXT CHAR 50 0
SPELT Indicator that Long Text Exists RI_LGTXT CHAR 1 0
X Yes
NULL No
VIPKZ IS-H: VIP Indicator VIPKZ CHAR 1 0
X Yes
NULL No
NOTAN IS-H: Emergency Admission Indicator NOTAUF CHAR 1 0
X Yes
NULL No
KRZAN IS-H: Quick Admission Indicator KURZAUF CHAR 1 0
X Yes
NULL No
PFORT IS-H: Patient Does not Appear in Public List PFORT CHAR 1 0
X Yes
NULL No
PFAKZ IS-H: Religious List Indicator PFAKZ CHAR 1 0
X Yes
NULL No
RISKF IS-H: Risk Information Exists for the Patient ISH_RISIKO CHAR 1 0
X Yes
NULL No
TODKZ IS-H: Patient Is Deceased PAT_TOD CHAR 1 0
X Yes
NULL No
INACT 'Inactive' Indicator ISH_INACTIVE CHAR 1 0
X Yes
NULL No
CONS_PERSDATA Consent for Processing of Personal Data ISH_CONS_PERSDATA CHAR 1 0
X Yes
NULL No
AGNUM IS-H: Patient's Employer AGNUM_PAT NGPA CHAR 10 0
AGNAM IS-H: Employer Name AGNAM CHAR 30 0
BERUF IS-H: Patient Occupation BERUF CHAR 25 0
EMPSC IS-H: Employed Since ISH_EMPDAT DATS 8 0
ANNA1 IS-H: Last Name of Person to Be Contacted NNAME_ANG CHAR 30 0
ANVN1 IS-H: First Name of Person to Be Contacted VNAME_ANG CHAR 30 0
ANVV1 IS-H: Relationship VERWVH CHAR 1 0
ANTX1 IS-H: Text for Relationship TEXT_VER CHAR 15 0
VMKZ1 IS-H: Legal Representative VORMUND CHAR 1 0
X Yes
NULL No
ANEX1 External Identification of Next of Kin EXTNR_ANG CHAR 20 0
ANNA2 IS-H: Last Name of Person to Be Contacted NNAME_ANG CHAR 30 0
ANVN2 IS-H: First Name of Person to Be Contacted VNAME_ANG CHAR 30 0
ANVV2 IS-H: Relationship VERWVH CHAR 1 0
ANTX2 IS-H: Text for Relationship TEXT_VER CHAR 15 0
VMKZ2 IS-H: Legal Representative VORMUND CHAR 1 0
X Yes
NULL No
ANEX2 External Identification of Next of Kin EXTNR_ANG CHAR 20 0
/ISHFR/BIRTHRK IS-H FR: Birth Rank /ISHFR/ISH_BIRTH_RANK NUMC 1 0

RNPAT foreign key relationships

Table Field Foreign key table Foreign key field Check table Check field
RNPAT AGNUM RNPAT MANDT NGPA IS-H: Business Partners MANDT
RNPAT AGNUM RNPAT AGNUM NGPA IS-H: Business Partners GPART
RNPAT EINRI RNPAT MANDT TN01 IS-H: Institutions MANDT
RNPAT EINRI RNPAT EINRI TN01 IS-H: Institutions EINRI
RNPAT GLAND RNPAT MANDT T005 Countries MANDT
RNPAT GLAND RNPAT GLAND T005 Countries LAND1
RNPAT MANDT RNPAT MANDT T000 Clients MANDT
RNPAT PASSTY RNPAT MANDT TN17D IS-H: Identity Document Types MANDT
RNPAT PASSTY RNPAT PASSTY TN17D IS-H: Identity Document Types PASSTY
RNPAT PFARR RNPAT EINRI TN13A IS-H: Parishes EINRI
RNPAT PFARR RNPAT PFARR TN13A IS-H: Parishes PFARR
RNPAT PFARR RNPAT MANDT TN13A IS-H: Parishes MANDT
RNPAT RACE RNPAT MANDT TN17R IS-H: Race MANDT
RNPAT RACE RNPAT RACE TN17R IS-H: Race RACE