SAP ABAP View U_17006 (Person - personal data)
Hierarchy
☛
SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR
⤷
PA-PA (Application Component) Personnel Administration
⤷
PBAS (Package) SAP HR Master Data Application Development
⤷
⤷
Basic Data
| View Type | D | Database View |
| Database View | U_17006 | |
| Short Description | Person - personal data | |
| Root table | PA0002 | HR Master Record: Infotype 0002 (Personal Data) |
| Entity Type | DM02L |
| Short text | Person - personal data |
Table
| # | Table Name | Foreign Table | Foreign Field | Foreign DIR |
|---|---|---|---|---|
| 1 | PA0002 |
Join Conditions
| # | Table Name | Field Name | Negation | Operator | Constants | Cont. line | AND/OR | Offset | F Length | Mco Field |
|---|---|---|---|---|---|---|---|---|---|---|
View Fields
| # | View field | Table | Field | Maintenance Flag | Key | Data element | Mod | Short Description |
|---|---|---|---|---|---|---|---|---|
| 1 | MANDT | MANDT | Client | |||||
| 2 | PERNR | PERSNO | Personnel number | |||||
| 3 | SUBTY | SUBTY | Subtype | |||||
| 4 | OBJPS | OBJPS | Object Identification | |||||
| 5 | SPRPS | SPRPS | Lock Indicator for HR Master Data Record | |||||
| 6 | ENDDA | ENDDA | End Date | |||||
| 7 | BEGDA | BEGDA | Start Date | |||||
| 8 | SEQNR | SEQNR | Number of Infotype Record With Same Key | |||||
| 9 | AEDTM | AEDAT | Last Changed On | |||||
| 10 | UNAME | AENAM | Name of Person Who Changed Object | |||||
| 11 | PREAS | PREAS | Reason for Changing Master Data | |||||
| 12 | INITS | INITS | Initials | |||||
| 13 | NACHN | PAD_NACHN | Last Name | |||||
| 14 | NAME2 | PAD_NAME2 | Name at Birth | |||||
| 15 | VORNA | PAD_VORNA | First Name | |||||
| 16 | TITEL | TITEL | Title | |||||
| 17 | TITL2 | TITL2 | Second Title | |||||
| 18 | NAMZU | NAMZU | Other Title | |||||
| 19 | VORSW | VORSW | Name Prefix | |||||
| 20 | VORS2 | VORS2 | Second Name Prefix | |||||
| 21 | RUFNM | PAD_RUFNM | Nickname | |||||
| 22 | KNZNM | KNZNM | Name Format Indicator for Employee in a List | |||||
| 23 | ANRED | ANRDE | Form-of-Address Key | |||||
| 24 | GESCH | GESCH | Gender Key | |||||
| 25 | GBDAT | GBDAT | Date of Birth | |||||
| 26 | GBLND | GBLND | Country of Birth | |||||
| 27 | GBDEP | GBDEP | State | |||||
| 28 | GBORT | PAD_GBORT | Birthplace | |||||
| 29 | NATIO | NATSL | Nationality | |||||
| 30 | NATI2 | NATS2 | Second Nationality | |||||
| 31 | NATI3 | NATS3 | Third Nationality | |||||
| 32 | SPRSL | PAD_SPRAS | Communication Language | |||||
| 33 | KONFE | KONFE | Religious Denomination Key | |||||
| 34 | FAMST | FAMST | Marital Status Key | |||||
| 35 | FAMDT | FAMDT | Valid From Date of Current Marital Status | |||||
| 36 | ANZKD | ANZKD | Number of Children | |||||
| 37 | NACON | NACON | Name Connection | |||||
| 38 | PERMO | PIDMO | Modifier for Personnel Identifier | |||||
| 39 | PERID | PRDNI | Personnel ID Number | |||||
| 40 | GBPAS | GBPAS | Date of Birth According to Passport | |||||
| 41 | FNAMK | P22J_PFNMK | First name (Katakana) | |||||
| 42 | LNAMK | P22J_PLNMK | Last name (Katakana) | |||||
| 43 | FNAMR | P22J_PFNMR | First Name (Romaji) | |||||
| 44 | LNAMR | P22J_PLNMR | Last Name (Romaji) | |||||
| 45 | NABIK | P22J_PNBIK | Name of Birth (Katakana) | |||||
| 46 | NABIR | P22J_PNBIR | Name of Birth (Romaji) | |||||
| 47 | NICKK | P22J_PNCKK | Koseki (Katakana) | |||||
| 48 | NICKR | P22J_PNCKR | Koseki (Romaji) | |||||
| 49 | GBJHR | GBJHR | Year of Birth | |||||
| 50 | GBMON | GBMON | Month of Birth | |||||
| 51 | GBTAG | GBTAG | Birth Date (to Month/Year) | |||||
| 52 | NCHMC | NACHNMC | Last Name (Field for Search Help) | |||||
| 53 | VNAMC | VORNAMC | First Name (Field for Search Help) | |||||
| 54 | NACH2 | PAD_NACH2 | Second Name | |||||
| 55 | CNAME | PAD_CNAME | Complete Name | |||||
| 56 | MIDNM | PAD_MIDNM | Middle Name | |||||
Maintenance Status
| read only |
| read and change |
| Time-dependent views: like U, validity data like ' ' |
| read, change, delete and insert |
| Delivery Class | ||
| Data Browser/Table View Maintenance | Display/Maintenance Allowed with Restrictions |
History
| Last changed by/on | SAP | 20110901 |
| SAP Release Created in |