SAP ABAP Table RNPAT (IS-H: Patient Master Screen Fields)
Hierarchy
☛
BBPCRM (Software Component) BBPCRM
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ NPVS (Package) Application development patient management system
⤷ CRM (Application Component) Customer Relationship Management
⤷ CRM_APPLICATION (Package) All CRM Components Without Special Structure Packages
⤷ NPVS (Package) Application development patient management system
Basic Data
Table Category | INTTAB | Structure |
Structure | RNPAT | Table Relationship Diagram |
Short Description | IS-H: Patient Master Screen Fields |
Delivery and Maintenance
Pool/cluster | ||
Delivery Class | ||
Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
Components
Field | Key | Data Element | Domain | Data Type |
Length | Decimal Places |
Short Description | Check table |
|
---|---|---|---|---|---|---|---|---|---|
1 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
2 | EINRI | EINRI | EINRI | CHAR | 4 | 0 | IS-H: Institution | TN01 | |
3 | .INCLUDE | 0 | 0 | IS-H: Screen Fields Patient Master - Name | |||||
4 | NNAME | NNAME_PAT | TEXT30 | CHAR | 30 | 0 | IS-H: Patient Last Name | ||
5 | VNAME | VNAME_PAT | TEXT30 | CHAR | 30 | 0 | IS-H: Patient First Name | ||
6 | GBNAM | GBNAM | TEXT30 | CHAR | 30 | 0 | IS-H: Birthname | ||
7 | GBDAT | RI_GBDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Birthdate | ||
8 | GSCHL | GSCHL | GSCHL | CHAR | 1 | 0 | IS-H: Sex Indicator - Internal | ||
9 | GSCHLE | GSCHLE | GSCHLE | CHAR | 1 | 0 | IS-H: Sex Indicator - User-Specific | * | |
10 | GSCHLTXT | TEXT_GES | TEXT10 | CHAR | 10 | 0 | IS-H: Sex Specification - User-Specific | ||
11 | ANREX | ISH_AKURZ | TEXT5 | CHAR | 5 | 0 | IS-H: Form-of-Address Short Text | ||
12 | TITEL | RI_TITEL | TITEL | CHAR | 15 | 0 | IS-H: Title | * | |
13 | NAMZU | RI_NAMZU | TITEL | CHAR | 15 | 0 | IS-H: Name Affix | * | |
14 | VORSW | RI_VORSW | TITEL | CHAR | 15 | 0 | IS-H: Name Prefix | * | |
15 | NAME2 | NAME2_PAT | TEXT30 | CHAR | 30 | 0 | Pseudonym, Order Name | ||
16 | NATIO | RI_NATIO | LAND1 | CHAR | 3 | 0 | IS-H: Nationality | * | |
17 | NATXT | NATIO | TEXT15 | CHAR | 15 | 0 | Nationality | ||
18 | RESID | ISH_RESID | XFELD | CHAR | 1 | 0 | IS-H: Indicator that Patient is Non-Resident | ||
19 | UNKNOWN_GBDAT | ISH_UNKNOWN_GBDAT | ISH_UNKNOWN_GBDAT | CHAR | 1 | 0 | Geburtsdatum nicht genau bekannt | ||
20 | .INCLUDE | 0 | 0 | IS-H: Screen Fields Patient Master - Other Data | |||||
21 | SPRAS | SPRAS_PAT | SPRAS | LANG | 1 | 0 | Patient Language | * | |
22 | SPTXT | SPTXT | SPTXT16 | CHAR | 16 | 0 | Name of Language | ||
23 | GLAND | GLAND | LAND1 | CHAR | 3 | 0 | IS-H: Country of Birth | T005 | |
24 | GLANT | LANDX | TEXT15 | CHAR | 15 | 0 | Country Name | ||
25 | GBORT | ISH_GBORT | TEXT25 | CHAR | 25 | 0 | IS-H: Patient Birthplace | ||
26 | FAMST | FAMST | FAMST | CHAR | 1 | 0 | Marital Status Key | * | |
27 | SPRSL | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | * | |
28 | FATXT | RI_FATXT | FATXT | CHAR | 6 | 0 | Marital Status Designation | ||
29 | KONFE | RI_KONFE | RI_KONFE | CHAR | 2 | 0 | IS-H: Religion | ||
30 | KOTXT | KITXT | KITXT | CHAR | 4 | 0 | Religious Denomination | ||
31 | KTEXT | KNFTX | TEXT25 | CHAR | 25 | 0 | Religious Denomination Long Text | ||
32 | KZTXT | TEXT_PAT | TEXT50 | CHAR | 50 | 0 | IS-H: Comment on Patient | ||
33 | LGTXT | RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
34 | EXTNR | EXT_PATNR | EXT_PATNR | CHAR | 20 | 0 | IS-H: External Patient Identification | ||
35 | RVNUM | ISH_RVNUM | ISH_SVNUM | CHAR | 20 | 0 | IS-H: Social Insurance Number | ||
36 | PASSTY | ISH_PASSTY | ISH_PASSTY | CHAR | 2 | 0 | Type of Identification Document | TN17D | |
37 | PASSTX | ISH_PASSTX | TEXT15 | CHAR | 15 | 0 | Text for Identification Document Type | ||
38 | PASSNR | ISH_PASSNR | ISH_PASSNR | CHAR | 15 | 0 | IS-H: Identification Document Number | ||
39 | PFARR | PFARR | PFARR | CHAR | 2 | 0 | IS-H: Parish | TN13A | |
40 | PFTXT | PFTXT | TEXT20 | CHAR | 20 | 0 | IS-H: Text for Parish | ||
41 | RACE | ISH_RACE | ISH_RACE | CHAR | 2 | 0 | IS-H: Race | TN17R | |
42 | RACETXT | ISH_RACETX | TEXT15 | CHAR | 15 | 0 | IS-H: Race text | ||
43 | INSID | ISH_VERS_NR | CHAR | 10 | 0 | DE: Eindeutige Versichertennummer (EGK) | |||
44 | .INCLUDE | 0 | 0 | IS-H: Screen Fields Patient Master - Indicators | |||||
45 | SPEND | SPENKZ | XFELD | CHAR | 1 | 0 | IS-H: Organ Donor Indicator | ||
46 | SPENT | SPENTEXT | TEXT50 | CHAR | 50 | 0 | Explanation for Donor Indicator | ||
47 | SPELT | RI_LGTXT | XFELD | CHAR | 1 | 0 | Indicator that Long Text Exists | ||
48 | VIPKZ | VIPKZ | XFELD | CHAR | 1 | 0 | IS-H: VIP Indicator | ||
49 | NOTAN | NOTAUF | XFELD | CHAR | 1 | 0 | IS-H: Emergency Admission Indicator | ||
50 | KRZAN | KURZAUF | XFELD | CHAR | 1 | 0 | IS-H: Quick Admission Indicator | ||
51 | PFORT | PFORT | XFELD | CHAR | 1 | 0 | IS-H: Patient Does not Appear in Public List | ||
52 | PFAKZ | PFAKZ | XFELD | CHAR | 1 | 0 | IS-H: Religious List Indicator | ||
53 | RISKF | ISH_RISIKO | XFELD | CHAR | 1 | 0 | IS-H: Risk Information Exists for the Patient | ||
54 | TODKZ | PAT_TOD | XFELD | CHAR | 1 | 0 | IS-H: Patient Is Deceased | ||
55 | INACT | ISH_INACTIVE | XFELD | CHAR | 1 | 0 | 'Inactive' Indicator | ||
56 | .INCLUDE | 0 | 0 | IS-H: Screen Fields Patient Master - Employer | |||||
57 | AGNUM | AGNUM_PAT | RI_KUNNR | CHAR | 10 | 0 | IS-H: Patient's Employer | NGPA | |
58 | AGNAM | AGNAM | TEXT30 | CHAR | 30 | 0 | IS-H: Employer Name | ||
59 | BERUF | BERUF | TEXT25 | CHAR | 25 | 0 | IS-H: Patient Occupation | ||
60 | EMPSC | ISH_EMPDAT | RI_DATUM | DATS | 8 | 0 | IS-H: Employed Since | ||
61 | .INCLUDE | 0 | 0 | IS-H: Screen Fields Patient Master - Next of Kin | |||||
62 | .INCLUDE | 0 | 0 | IS-H: Screen Fields Patient Master - Next of Kin 1 | |||||
63 | ANNA1 | NNAME_ANG | TEXT30 | CHAR | 30 | 0 | IS-H: Last Name of Person to Be Contacted | ||
64 | ANVN1 | VNAME_ANG | TEXT30 | CHAR | 30 | 0 | IS-H: First Name of Person to Be Contacted | ||
65 | ANVV1 | VERWVH | VERWVH | CHAR | 1 | 0 | IS-H: Relationship | * | |
66 | ANTX1 | TEXT_VER | TEXT15 | CHAR | 15 | 0 | IS-H: Text for Relationship | ||
67 | VMKZ1 | VORMUND | XFELD | CHAR | 1 | 0 | IS-H: Legal Representative | ||
68 | ANEX1 | EXTNR_ANG | EXT_PATNR | CHAR | 20 | 0 | IS-H: External Identification of Next of Kin/Assoc. Party | ||
69 | .INCLUDE | 0 | 0 | IS-H: Screen Fields Patient Master - Next of Kin 2 | |||||
70 | ANNA2 | NNAME_ANG | TEXT30 | CHAR | 30 | 0 | IS-H: Last Name of Person to Be Contacted | ||
71 | ANVN2 | VNAME_ANG | TEXT30 | CHAR | 30 | 0 | IS-H: First Name of Person to Be Contacted | ||
72 | ANVV2 | VERWVH | VERWVH | CHAR | 1 | 0 | IS-H: Relationship | * | |
73 | ANTX2 | TEXT_VER | TEXT15 | CHAR | 15 | 0 | IS-H: Text for Relationship | ||
74 | VMKZ2 | VORMUND | XFELD | CHAR | 1 | 0 | IS-H: Legal Representative | ||
75 | ANEX2 | EXTNR_ANG | EXT_PATNR | CHAR | 20 | 0 | IS-H: External Identification of Next of Kin/Assoc. Party |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | RNPAT | AGNUM | NGPA | GPART | REF | 1 | CN |
2 | RNPAT | EINRI | TN01 | EINRI | KEY | 1 | CN |
3 | RNPAT | GLAND | T005 | LAND1 | REF | 1 | CN |
4 | RNPAT | MANDT | T000 | MANDT | KEY | 1 | CN |
5 | RNPAT | PASSTY | TN17D | PASSTY | REF | 1 | CN |
6 | RNPAT | PFARR | TN13A | PFARR | REF | 1 | CN |
7 | RNPAT | RACE | TN17R | RACE | REF | 1 | CN |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |