SAP Table NPER
IS-H: Persons
NPER (IS-H: Persons) 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 NPER to other SAP tables.
NPER table fields
| Field | Data element | Checktable | Datatype | Length | Decimals | |||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| MANDT | Client | MANDT | T000 | CLNT | 3 | 0 | ||||||||||||||
| PERNR | IS-H: Person Number | RI_PERNR | NGPA | CHAR | 10 | 0 | ||||||||||||||
| GBDAT | IS-H: Birthdate | RI_GBDAT | DATS | 8 | 0 | |||||||||||||||
| RUFAN | IS-H: Extension Number | RUFANLAGE | CHAR | 16 | 0 | |||||||||||||||
| MAKZ | Is-H: Person is Employee | MAKZ_D | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| RPPKZ | IS-H: Personal Data Originates in HR System | RPPKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| EXPNR | IS-H: External Personnel Number | ISH_PERNR | CHAR | 10 | 0 | |||||||||||||||
| ARZT | IS-H: Indicator that Person Is Physician | ARZT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| ARZTN | IS-H: Identifier for a Physician | ARZTNR | CHAR | 12 | 0 | |||||||||||||||
| PFLEG | IS-H: Indicator that Person is Nurse | PFLEG | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| BARZT | IS-H: Indicator that Person is External Physician | BARZT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| KVZUL | IS-H: Physician Has External Accreditation | KV_ZULASS | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| LIQBE | IS-H: Indicator that physician has internal accreditation | LIQ_BERECH | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| KZTXT | IS-H: Comment on Person | TEXT_PER | CHAR | 50 | 0 | |||||||||||||||
| LGTXT | Indicator that Long Text Exists | RI_LGTXT | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| BEGDT | IS-H: Valid-From Date of Record | RI_BEGDT | DATS | 8 | 0 | |||||||||||||||
| ENDDT | IS-H: Valid-To Date of Record | RI_ENDDT | DATS | 8 | 0 | |||||||||||||||
| LOEKZ | Deletion Flag/Indicator | RI_LOEKZ | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| LOUSR | User Who Deleted Record | RI_LOUSR | CHAR | 12 | 0 | |||||||||||||||
| LODAT | Date of Deletion | RI_LODAT | DATS | 8 | 0 | |||||||||||||||
| ERDAT | IS-H: Date when Record Created | RI_ERDAT | DATS | 8 | 0 | |||||||||||||||
| ERUSR | IS-H: Name of Employee who Created Record | RI_ERNAM | CHAR | 12 | 0 | |||||||||||||||
| UPDAT | IS-H: Date of Last Change | RI_UPDAT | DATS | 8 | 0 | |||||||||||||||
| UPUSR | IS-H: Name of Person who Last Changed Data | RI_UPNAM | CHAR | 12 | 0 | |||||||||||||||
| FACHR | Specialty | ISH_FACHR | TNKFA | CHAR | 4 | 0 | ||||||||||||||
| SPTYP | IS-H: Specialist Type | ISH_SPTYP | CHAR | 2 | 0 |
Possible values
|
||||||||||||||
| RANK | IS-H: Rank | ISH_RANK | TN12R | CHAR | 3 | 0 | ||||||||||||||
| RKDAT | Start of Validity for Rank of a Person | ISH_RKDAT | DATS | 8 | 0 | |||||||||||||||
| RANKO | IS-H: Prior Rank | ISH_RANK_OLD | TN12R | CHAR | 3 | 0 | ||||||||||||||
| NIFNR | IS-H CH: NIF number | ISH_NIFNR | CHAR | 12 | 0 | |||||||||||||||
| MIG_DONE | Indicator Specifying Record Is Migrated to BP Table | ISH_BPMIG_DONE | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
| /ISHFR/CHARGZ | IS-H FR: Charge Zone | /ISHFR/CHARGZ | /ISHFR/TNWFR04 | CHAR | 2 | 0 | ||||||||||||||
| /ISHFR/CHARGZROL | IS-H FR: Charge Zone Function | /ISHFR/CHARGZROL | /ISHFR/TNWFR04 | CHAR | 1 | 0 | ||||||||||||||
| FIXLANR | ISH_LANR_FIX | CHAR | 7 | 0 | ||||||||||||||||
| VOLU | Indicates That Person Is Volunteer | ISH_VOLU | CHAR | 1 | 0 |
Possible values
|
||||||||||||||
NPER foreign key relationships
| Table | Field | Foreign key table | Foreign key field | Check table | Check field | |
|---|---|---|---|---|---|---|
| NPER | /ISHFR/CHARGZ | SYST | MANDT | /ISHFR/TNWFR04 | IS-H FR: Charge Zones for Persons | MANDT |
| NPER | /ISHFR/CHARGZ | NPER | /ISHFR/CHARGZ | /ISHFR/TNWFR04 | IS-H FR: Charge Zones for Persons | CHARGZ |
| NPER | /ISHFR/CHARGZ | NPER | /ISHFR/CHARGZROL | /ISHFR/TNWFR04 | IS-H FR: Charge Zones for Persons | CHARGZROL |
| NPER | /ISHFR/CHARGZROL | NPER | /ISHFR/CHARGZ | /ISHFR/TNWFR04 | IS-H FR: Charge Zones for Persons | CHARGZ |
| NPER | /ISHFR/CHARGZROL | NPER | /ISHFR/CHARGZROL | /ISHFR/TNWFR04 | IS-H FR: Charge Zones for Persons | CHARGZROL |
| NPER | /ISHFR/CHARGZROL | SYST | MANDT | /ISHFR/TNWFR04 | IS-H FR: Charge Zones for Persons | MANDT |
| NPER | FACHR | NPER | FACHR | TNKFA | IS-H: Code Specialties | FACHR |
| NPER | FACHR | NPER | MANDT | TNKFA | IS-H: Code Specialties | MANDT |
| NPER | FACHR | '5' | TNKFA | IS-H: Code Specialties | FATYP | |
| NPER | MANDT | NPER | MANDT | T000 | Clients | MANDT |
| NPER | PERNR | NPER | MANDT | NGPA | IS-H: Business Partners | MANDT |
| NPER | PERNR | NPER | PERNR | NGPA | IS-H: Business Partners | GPART |
| NPER | RANK | NPER | RANK | TN12R | IS-H: Physician Ranks | RANK |
| NPER | RANK | NPER | MANDT | TN12R | IS-H: Physician Ranks | MANDT |
| NPER | RANKO | NPER | MANDT | TN12R | IS-H: Physician Ranks | MANDT |
| NPER | RANKO | NPER | RANKO | TN12R | IS-H: Physician Ranks | RANK |
