SAP ABAP Table HRI1702 (Personal Data)
Hierarchy
☛
IS-PS-CA (Software Component) IS-PUBLIC SECTOR CONTRACT ACCOUNTING
⤷ IS-HER-CM-AD (Application Component) Administration
⤷ PMIQ (Package) Campus Management
⤷ IS-HER-CM-AD (Application Component) Administration
⤷ PMIQ (Package) Campus Management
Basic Data
Table Category | INTTAB | Structure |
Structure | HRI1702 | Table Relationship Diagram |
Short Description | Personal Data |
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 | NACHN | PAD_NACHN | PAD_NACHN | CHAR | 40 | 0 | Last Name | ||
2 | VORNA | PAD_VORNA | PAD_VORNM | CHAR | 40 | 0 | First Name | ||
3 | MIDNM | PAD_MIDNM | PAD_VORNM | CHAR | 40 | 0 | Middle Name | ||
4 | INITS | INITS | TEXT10 | CHAR | 10 | 0 | Initials | ||
5 | BIRTHNAME | PAD_NAME2 | PAD_NACHN | CHAR | 40 | 0 | Name at Birth | ||
6 | TITEL | TITEL | TITEL | CHAR | 15 | 0 | Title | T535N | |
7 | VORSW | VORSW | TITEL | CHAR | 15 | 0 | Name Prefix | T535N | |
8 | NAMZU | NAMZU | TITEL | CHAR | 15 | 0 | Other Title | T535N | |
9 | RUFNM | PIQ_RUFNM | PAD_VORNM | CHAR | 40 | 0 | Known As | ||
10 | GBDAT | PIQ_GBDAT | GBDAT | DATS | 8 | 0 | Date of Birth | ||
11 | GBLND | GBLND | LAND1 | CHAR | 3 | 0 | Country of Birth | T005 | |
12 | GBDEP | PIQ_GBDEP | REGIO | CHAR | 3 | 0 | Region of Birth (State, Province, County) | T005S | |
13 | GBORT | PAD_GBORT | PAD_ORT01 | CHAR | 40 | 0 | Birthplace | ||
14 | GBNAT | PIQ_GBNAT | LAND1 | CHAR | 3 | 0 | Nationality (Citizenship) at Birth | T005 | |
15 | NATIO | PIQNATSL | LAND1 | CHAR | 3 | 0 | Nationality (Citizenship) | T005 | |
16 | NATI2 | PIQNATS2 | LAND1 | CHAR | 3 | 0 | Second Nationality (Citizenship) | T005 | |
17 | NATI3 | PIQNATS3 | LAND1 | CHAR | 3 | 0 | Third Nationality (Citizenship) | T005 | |
18 | LANGU | PIQ_SPRAS | SPRAS | LANG | 1 | 0 | Language of Communication | T002 | |
19 | ANRED | ANRDE | ANRDE | CHAR | 1 | 0 | Form-of-Address Key | T522G | |
20 | GESCH | GESCH | GESCH | CHAR | 1 | 0 | Gender Key | ||
21 | FAMST | FAMST | FAMST | CHAR | 1 | 0 | Marital Status Key | T502T | |
22 | PRDNI | PIQ_PRDNI | CHAR20 | CHAR | 20 | 0 | Identification Number | ||
23 | NACHN_MC | PIQ_NACHN_MC | CHAR40 | CHAR | 40 | 0 | Last Name (Field for Search Help) | ||
24 | VORNA_MC | PIQ_VORNA_MC | CHAR40 | CHAR | 40 | 0 | First Name (Search Help Field) | ||
25 | DEATHDATE | PIQ_DEATHDATE | DATE | DATS | 8 | 0 | Date of Death | ||
26 | DREGDATE | PIQ_REGDEATHDATE | DATE | DATS | 8 | 0 | Date On Which Death Was Recorded | ||
27 | BIRTHNAME_MC | PIQ_BIRTHNAME_MC | CHAR40 | CHAR | 40 | 0 | Name at Birth (Field for Search Help) | ||
28 | MIDNM_MC | PIQ_MIDNM_MC | CHAR40 | CHAR | 40 | 0 | Middle Name (Field for Search Help) | ||
29 | PREV_SURNAME | PIQ_GB_PREV_SURNAME | PIQ_GB_PREV_SURNAME | CHAR | 30 | 0 | UCAS: Previous Name | ||
30 | .INCLUDE | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | HRI1702 | ANRED | T522G | ANRED | KEY | 1 | CN |
2 | HRI1702 | FAMST | T502T | FAMST | |||
3 | HRI1702 | GBDEP | T005S | BLAND | |||
4 | HRI1702 | GBLND | T005 | LAND1 | 1 | CN | |
5 | HRI1702 | GBNAT | T005 | LAND1 | |||
6 | HRI1702 | LANGU | T002 | SPRAS | KEY | 1 | CN |
7 | HRI1702 | NAMZU | T535N | TITEL | |||
8 | HRI1702 | NATI2 | T005 | LAND1 | |||
9 | HRI1702 | NATI3 | T005 | LAND1 | |||
10 | HRI1702 | NATIO | T005 | LAND1 | KEY | 1 | CN |
11 | HRI1702 | TITEL | T535N | TITEL | |||
12 | HRI1702 | VORSW | T535N | TITEL |
History
Last changed by/on | SAP | 20130529 |
SAP Release Created in |