- Home
- Resources
- SAP Tables
- NPAP - IS-H: Provisional Patient Master Data
SAP Table NPAP
IS-H: Provisional Patient Master Data
NPAP (IS-H: Provisional Patient Master Data) 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 NPAP to other SAP tables.
Source: NPAP (IS-H: Provisional Patient Master Data)
NPAP table fields
Field |
Data element |
Checktable |
Datatype |
Length |
Decimals |
|
MANDT |
Client |
MANDT |
T000
|
CLNT |
|
3 |
0 |
|
PAPID |
IS-H: Provisional Patient Number |
ISH_PAPID |
|
CHAR |
|
10 |
0 |
|
NNAME |
Patient Last Name |
NNAME_PAT |
|
CHAR |
|
30 |
0 |
|
NNAMS |
IS-H: Standardized Last Name |
NNAMES_PAT |
|
CHAR |
|
30 |
0 |
|
VNAME |
IS-H: Patient First Name |
VNAME_PAT |
|
CHAR |
|
30 |
0 |
|
VNAMS |
Standardized First Name |
VNAMES_PAT |
|
CHAR |
|
30 |
0 |
|
GBNAM |
IS-H: Birthname |
GBNAM |
|
CHAR |
|
30 |
0 |
|
GBNAS |
IS-H: Standardized Birthname |
GBNAMS_PAT |
|
CHAR |
|
30 |
0 |
|
GBDAT |
IS-H: Birthdate |
RI_GBDAT |
|
DATS |
|
8 |
0 |
|
GSCHL |
IS-H: Sex Indicator - Internal |
GSCHL |
|
CHAR |
|
1 |
0 |
Possible values
1 |
male |
2 |
female |
3 |
unknown |
|
TITEL |
IS-H: Title |
RI_TITEL |
T535N
|
CHAR |
|
15 |
0 |
|
NAMZU |
IS-H: Name Affix |
RI_NAMZU |
T535N
|
CHAR |
|
15 |
0 |
|
VORSW |
IS-H: Name Prefix |
RI_VORSW |
T535N
|
CHAR |
|
15 |
0 |
|
ANRED |
IS-H: Form-of-Address Key |
RI_ANRDS |
|
CHAR |
|
2 |
0 |
|
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 |
|
PASSNR |
IS-H: Identification Document Number |
ISH_PASSNR |
|
CHAR |
|
15 |
0 |
|
ADRNR |
IS-H: Address Number |
ISH_ADRNR |
NADR
|
CHAR |
|
10 |
0 |
|
ADROB |
IS-H: Address Object |
ISH_ADROBJ |
|
CHAR |
|
4 |
0 |
Possible values
NPAT |
Patient |
NPAN |
Patient - Next of Kin/Associated Party |
NPAG |
Patient - Employer |
NPAP |
Provisional Patient Master Data |
NGPA |
Business Partner |
TN01 |
Institution |
N301 |
EDI Data Collection Point |
NWAN |
Bad Debt Party |
NORG |
Organizational Unit |
NBAU |
Building Unit |
NVVH |
Insurance - Main Person Insured/Alternate Invoice Recipient |
NVVG |
Insurance - Employer of Main Person Insured |
NAPP |
Provisional Appointment |
NVVN |
Guarantors |
REDO |
Renewable Document |
NPSD |
Pseudonymized Patient |
|
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 |
|
STORN |
IS-H: Cancellation Indicator |
RI_STORN |
|
CHAR |
|
1 |
0 |
Possible values
|
STUSR |
IS-H: Name of User who Canceled Data Record |
STORN_USER |
|
CHAR |
|
12 |
0 |
|
STDAT |
Date of Cancellation |
STORN_DAT |
|
DATS |
|
8 |
0 |
|
UNKNOWN_GBDAT |
Birthdate Is Unknown |
ISH_UNKNOWN_GBDAT |
|
CHAR |
|
1 |
0 |
Possible values
D |
Day Unknown |
M |
Month Unknown |
Y |
Year Unknown |
|
MIG_DONE |
Indicator Specifying Record Is Migrated to BP Table |
ISH_BPMIG_DONE |
|
CHAR |
|
1 |
0 |
Possible values
M |
Master Data Migrated |
R |
Relationships Migrated |
NULL |
Not Migrated |
E |
Errors in Migration |
|
/ISHFR/BIRTHRK |
IS-H FR: Birth Rank |
/ISHFR/ISH_BIRTH_RANK |
|
NUMC |
|
1 |
0 |
|
NPAP foreign key relationships
Table |
Field |
Foreign key table |
Foreign key field |
Check table |
Check field |
NPAP |
ADRNR |
NPAP |
MANDT |
NADR |
IS-H: Addresses (Central Address Management) |
MANDT |
NPAP |
ADRNR |
NPAP |
ADRNR |
NADR |
IS-H: Addresses (Central Address Management) |
ADRNR |
NPAP |
ADRNR |
NPAP |
ADROB |
NADR |
IS-H: Addresses (Central Address Management) |
ADROB |
NPAP |
MANDT |
NPAP |
MANDT |
T000 |
Clients |
MANDT |
NPAP |
NAMZU |
NPAP |
MANDT |
T535N |
Name affixes |
MANDT |
NPAP |
NAMZU |
'Z' |
|
T535N |
Name affixes |
ART |
NPAP |
NAMZU |
NPAP |
NAMZU |
T535N |
Name affixes |
TITEL |
NPAP |
PASSTY |
NPAP |
MANDT |
TN17D |
IS-H: Identity Document Types |
MANDT |
NPAP |
PASSTY |
NPAP |
PASSTY |
TN17D |
IS-H: Identity Document Types |
PASSTY |
NPAP |
TITEL |
NPAP |
MANDT |
T535N |
Name affixes |
MANDT |
NPAP |
TITEL |
'T' |
|
T535N |
Name affixes |
ART |
NPAP |
TITEL |
NPAP |
TITEL |
T535N |
Name affixes |
TITEL |
NPAP |
VORSW |
NPAP |
MANDT |
T535N |
Name affixes |
MANDT |
NPAP |
VORSW |
'V' |
|
T535N |
Name affixes |
ART |
NPAP |
VORSW |
NPAP |
VORSW |
T535N |
Name affixes |
TITEL |