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
⤷ 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 | 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 | PA0002 | MANDT | MANDT | Client | |||
2 | PERNR | PA0002 | PERNR | PERSNO | Personnel number | |||
3 | SUBTY | PA0002 | SUBTY | SUBTY | Subtype | |||
4 | OBJPS | PA0002 | OBJPS | OBJPS | Object Identification | |||
5 | SPRPS | PA0002 | SPRPS | SPRPS | Lock Indicator for HR Master Data Record | |||
6 | ENDDA | PA0002 | ENDDA | ENDDA | End Date | |||
7 | BEGDA | PA0002 | BEGDA | BEGDA | Start Date | |||
8 | SEQNR | PA0002 | SEQNR | SEQNR | Number of Infotype Record With Same Key | |||
9 | AEDTM | PA0002 | AEDTM | AEDAT | Last Changed On | |||
10 | UNAME | PA0002 | UNAME | AENAM | Name of Person Who Changed Object | |||
11 | PREAS | PA0002 | PREAS | PREAS | Reason for Changing Master Data | |||
12 | INITS | PA0002 | INITS | INITS | Initials | |||
13 | NACHN | PA0002 | NACHN | PAD_NACHN | Last Name | |||
14 | NAME2 | PA0002 | NAME2 | PAD_NAME2 | Name at Birth | |||
15 | VORNA | PA0002 | VORNA | PAD_VORNA | First Name | |||
16 | TITEL | PA0002 | TITEL | TITEL | Title | |||
17 | TITL2 | PA0002 | TITL2 | TITL2 | Second Title | |||
18 | NAMZU | PA0002 | NAMZU | NAMZU | Other Title | |||
19 | VORSW | PA0002 | VORSW | VORSW | Name Prefix | |||
20 | VORS2 | PA0002 | VORS2 | VORS2 | Second Name Prefix | |||
21 | RUFNM | PA0002 | RUFNM | PAD_RUFNM | Nickname | |||
22 | KNZNM | PA0002 | KNZNM | KNZNM | Name Format Indicator for Employee in a List | |||
23 | ANRED | PA0002 | ANRED | ANRDE | Form-of-Address Key | |||
24 | GESCH | PA0002 | GESCH | GESCH | Gender Key | |||
25 | GBDAT | PA0002 | GBDAT | GBDAT | Date of Birth | |||
26 | GBLND | PA0002 | GBLND | GBLND | Country of Birth | |||
27 | GBDEP | PA0002 | GBDEP | GBDEP | State | |||
28 | GBORT | PA0002 | GBORT | PAD_GBORT | Birthplace | |||
29 | NATIO | PA0002 | NATIO | NATSL | Nationality | |||
30 | NATI2 | PA0002 | NATI2 | NATS2 | Second Nationality | |||
31 | NATI3 | PA0002 | NATI3 | NATS3 | Third Nationality | |||
32 | SPRSL | PA0002 | SPRSL | PAD_SPRAS | Communication Language | |||
33 | KONFE | PA0002 | KONFE | KONFE | Religious Denomination Key | |||
34 | FAMST | PA0002 | FAMST | FAMST | Marital Status Key | |||
35 | FAMDT | PA0002 | FAMDT | FAMDT | Valid From Date of Current Marital Status | |||
36 | ANZKD | PA0002 | ANZKD | ANZKD | Number of Children | |||
37 | NACON | PA0002 | NACON | NACON | Name Connection | |||
38 | PERMO | PA0002 | PERMO | PIDMO | Modifier for Personnel Identifier | |||
39 | PERID | PA0002 | PERID | PRDNI | Personnel ID Number | |||
40 | GBPAS | PA0002 | GBPAS | GBPAS | Date of Birth According to Passport | |||
41 | FNAMK | PA0002 | FNAMK | P22J_PFNMK | First name (Katakana) | |||
42 | LNAMK | PA0002 | LNAMK | P22J_PLNMK | Last name (Katakana) | |||
43 | FNAMR | PA0002 | FNAMR | P22J_PFNMR | First Name (Romaji) | |||
44 | LNAMR | PA0002 | LNAMR | P22J_PLNMR | Last Name (Romaji) | |||
45 | NABIK | PA0002 | NABIK | P22J_PNBIK | Name of Birth (Katakana) | |||
46 | NABIR | PA0002 | NABIR | P22J_PNBIR | Name of Birth (Romaji) | |||
47 | NICKK | PA0002 | NICKK | P22J_PNCKK | Koseki (Katakana) | |||
48 | NICKR | PA0002 | NICKR | P22J_PNCKR | Koseki (Romaji) | |||
49 | GBJHR | PA0002 | GBJHR | GBJHR | Year of Birth | |||
50 | GBMON | PA0002 | GBMON | GBMON | Month of Birth | |||
51 | GBTAG | PA0002 | GBTAG | GBTAG | Birth Date (to Month/Year) | |||
52 | NCHMC | PA0002 | NCHMC | NACHNMC | Last Name (Field for Search Help) | |||
53 | VNAMC | PA0002 | VNAMC | VORNAMC | First Name (Field for Search Help) | |||
54 | NACH2 | PA0002 | NACH2 | PAD_NACH2 | Second Name | |||
55 | CNAME | PA0002 | CNAME | PAD_CNAME | Complete Name | |||
56 | MIDNM | PA0002 | 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 |