SAP ABAP Table BAPIHR0002 (HR: HR Master Record Infotype 0002 (Personal Data))
Hierarchy
☛
SAP_HRRXX (Software Component) Sub component SAP_HRRXX of SAP_HR
⤷ PA-OS (Application Component) Organizational Structure
⤷ PP0A (Package) HR-CA: ALE/IDOC Functionality
⤷ PA-OS (Application Component) Organizational Structure
⤷ PP0A (Package) HR-CA: ALE/IDOC Functionality
Basic Data
Table Category | INTTAB | Structure |
Structure | BAPIHR0002 | Table Relationship Diagram |
Short Description | HR: HR Master Record Infotype 0002 (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 | .INCLUDE | 0 | 0 | Keys for HR Master Data (BAPI) | |||||
2 | OBJ_ID | PERNR_D | PERNR | NUMC | 8 | 0 | Personnel Number | ||
3 | INFOTYPE | INFTY | INFOTYP | CHAR | 4 | 0 | Infotype | T582A | |
4 | SUBTYPE | SUBTY | SUBTY | CHAR | 4 | 0 | Subtype | ||
5 | OBJECT_IDENTIFICATION | OBJPS | OBJPS | CHAR | 2 | 0 | Object Identification | ||
6 | LOCKINDIC | SPRPS | SPRPS | CHAR | 1 | 0 | Lock Indicator for HR Master Data Record | ||
7 | TO_DATE | ENDDA | DATUM | DATS | 8 | 0 | End Date | ||
8 | FROM_DATE | BEGDA | DATUM | DATS | 8 | 0 | Start Date | ||
9 | IT_REC_NO | SEQNR | NUM03 | NUMC | 3 | 0 | Number of Infotype Record With Same Key | ||
10 | .INCLUDE | 0 | 0 | HR Master Data Administration Fields (BAPI) | |||||
11 | CHANGED_ON | AEDAT | DATUM | DATS | 8 | 0 | Last Changed On | ||
12 | CHANGED_BY | AENAM | USNAM | CHAR | 12 | 0 | Name of Person Who Changed Object | ||
13 | HIST_FLAG | HISTO | CHAR1 | CHAR | 1 | 0 | Historical Record Flag | ||
14 | INFOTYPE_TEXT_EXISTS | ITXEX | XFELD | CHAR | 1 | 0 | Text Exists for Infotype | ||
15 | REFERENCE_FILEDS_EXIST | PRFEX | XFELD | CHAR | 1 | 0 | Reference Fields Exist (Primary/Secondary Costs) | ||
16 | CONFIRMATION_FIELDS_EXIST | ORDEX | XFELD | CHAR | 1 | 0 | Confirmation Fields Exist | ||
17 | INFOTYPE_SCREEN_CONTROL | ITBLD | CHAR2 | CHAR | 2 | 0 | Infotype Screen Control | ||
18 | REASON_TO_CHANGE_MASTER_DATA | PREAS | PREAS | CHAR | 2 | 0 | Reason for Changing Master Data | T530E | |
19 | FLAG_1 | NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
20 | FLAG_2 | NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
21 | FLAG_3 | NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
22 | FLAG_4 | NUSED | NUSED | CHAR | 1 | 0 | Reserved Field/Unused Field | ||
23 | RESERVED_FIELD_1 | NUSED2 | NUSED2 | CHAR | 2 | 0 | Reserved Field/Unused Field of Length 2 | ||
24 | RESERVED_FIELD_2 | NUSED2 | NUSED2 | CHAR | 2 | 0 | Reserved Field/Unused Field of Length 2 | ||
25 | EMPLOYEE_INITIALS | INITS | TEXT10 | CHAR | 10 | 0 | Initials | ||
26 | LAST_NAME | PAD_NACHN | PAD_NACHN | CHAR | 40 | 0 | Last Name | ||
27 | NAME_AT_BIRTH | PAD_NAME2 | PAD_NACHN | CHAR | 40 | 0 | Name at Birth | ||
28 | SECOND_NAME | PAD_NACH2 | PAD_NACHN | CHAR | 40 | 0 | Second Name | ||
29 | FIRST_NAME | PAD_VORNA | PAD_VORNM | CHAR | 40 | 0 | First Name | ||
30 | FULL_EMPLOYEE_NAME | PAD_CNAME | TEXT80 | CHAR | 80 | 0 | Complete Name | ||
31 | TITLE | TITEL | TITEL | CHAR | 15 | 0 | Title | T535N | |
32 | SECOND_TITLE | TITL2 | TITEL | CHAR | 15 | 0 | Second Title | T535N | |
33 | ARISTOCRATIC_TITLE | NAMZU | TITEL | CHAR | 15 | 0 | Other Title | T535N | |
34 | NAME_AFFIX | VORSW | TITEL | CHAR | 15 | 0 | Name Prefix | T535N | |
35 | SECOND_NAME_PREFIX | VORS2 | TITEL | CHAR | 15 | 0 | Second Name Prefix | T535N | |
36 | KNOWN_AS | PAD_RUFNM | PAD_VORNM | CHAR | 40 | 0 | Nickname | ||
37 | MIDDLE_NAME | PAD_MIDNM | PAD_VORNM | CHAR | 40 | 0 | Middle Name | ||
38 | NAME_FORMAT_INDICATOR | KNZNM | KNZN2 | NUMC | 2 | 0 | Name Format Indicator for Employee in a List | ||
39 | FORM_OF_ADDRESS_KEY | ANRDE | ANRDE | CHAR | 1 | 0 | Form-of-Address Key | T522G | |
40 | GENDER_KEY | GESCH | GESCH | CHAR | 1 | 0 | Gender Key | ||
41 | DATE_BIRTH | GBDAT | GBDAT | DATS | 8 | 0 | Date of Birth | ||
42 | COUNTRY_OF_BIRTH | GBLND | LAND1 | CHAR | 3 | 0 | Country of Birth | T005 | |
43 | COUNTRY_OF_BIRTH_ISO | INTCA | INTCA | CHAR | 2 | 0 | Country ISO code | ||
44 | STATE | GBDEP | REGIO | CHAR | 3 | 0 | State | T005S | |
45 | BIRTHPLACE | PAD_GBORT | PAD_ORT01 | CHAR | 40 | 0 | Birthplace | ||
46 | NATIONALITY | NATSL | LAND1 | CHAR | 3 | 0 | Nationality | T005 | |
47 | NATIONALITY_ISO | INTCA | INTCA | CHAR | 2 | 0 | Country ISO code | ||
48 | SECOND_NATIONALITY | NATS2 | LAND1 | CHAR | 3 | 0 | Second Nationality | T005 | |
49 | SECOND_NATIONALITY_ISO | INTCA | INTCA | CHAR | 2 | 0 | Country ISO code | ||
50 | THIRD_NATIONALITY | NATS3 | LAND1 | CHAR | 3 | 0 | Third Nationality | T005 | |
51 | THIRD_NATIONALITY_ISO | INTCA | INTCA | CHAR | 2 | 0 | Country ISO code | ||
52 | LANGU | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | T002 | |
53 | LANGU_ISO | LAISO | LAISO | CHAR | 2 | 0 | 2-Character SAP Language Code | ||
54 | RELIGIOUS_DENOMINATION | KONFE | KONFE | CHAR | 2 | 0 | Religious Denomination Key | T516T | |
55 | MARITAL_STATUS | FAMST | FAMST | CHAR | 1 | 0 | Marital Status Key | T502T | |
56 | START_DATE_OF_MARITAL_STATUS | FAMDT | DATUM | DATS | 8 | 0 | Valid From Date of Current Marital Status | ||
57 | NUMBER_OF_CHILDREN | ANZKD | DEC03 | DEC | 3 | 0 | Number of Children | ||
58 | NAME_CONNECTION | NACON | CHAR1 | CHAR | 1 | 0 | Name Connection | ||
59 | MODIFIER_FOR_PERSONNEL_ID | PIDMO | CHAR2 | CHAR | 2 | 0 | Modifier for Personnel Identifier | ||
60 | PERSIDNO | PRDNI | CHAR20 | CHAR | 20 | 0 | Personnel ID Number | ||
61 | PASSPORT_DATE_OF_BIRTH | GBPAS | DATUM | DATS | 8 | 0 | Date of Birth According to Passport | ||
62 | FIRST_NAME_KATAKANA | P22J_PFNMK | P22J_PNAME | CHAR | 40 | 0 | First name (Katakana) | ||
63 | LAST_NAME_KATAKANA | P22J_PLNMK | P22J_PNAME | CHAR | 40 | 0 | Last name (Katakana) | ||
64 | FIRST_NAME_ROMAJI | P22J_PFNMR | P22J_PNAME | CHAR | 40 | 0 | First Name (Romaji) | ||
65 | LAST_NAME_ROMAJI | P22J_PLNMR | P22J_PNAME | CHAR | 40 | 0 | Last Name (Romaji) | ||
66 | NAME_OF_BIRTH_KATAKANA | P22J_PNBIK | P22J_PNAME | CHAR | 40 | 0 | Name of Birth (Katakana) | ||
67 | NAME_OF_BIRTH_ROMAJI | P22J_PNBIR | P22J_PNAME | CHAR | 40 | 0 | Name of Birth (Romaji) | ||
68 | NICKNAME_KATAKANA | P22J_PNCKK | P22J_PNAME | CHAR | 40 | 0 | Koseki (Katakana) | ||
69 | NICKNAME_ROMAJI | P22J_PNCKR | P22J_PNAME | CHAR | 40 | 0 | Koseki (Romaji) | ||
70 | YEAR_OF_BIRTH | GBJHR | GJAHR | NUMC | 4 | 0 | Year of Birth | ||
71 | MONTH_OF_BIRTH | GBMON | NUM2 | NUMC | 2 | 0 | Month of Birth | ||
72 | DAY_OF_BIRTH | GBTAG | NUM2 | NUMC | 2 | 0 | Birth Date (to Month/Year) | ||
73 | LAST_NAME_MATCHCODE | NACHNMC | CHAR25 | CHAR | 25 | 0 | Last Name (Field for Search Help) | ||
74 | FIRST_NAME_MATCHCODE | VORNAMC | CHAR25 | CHAR | 25 | 0 | First Name (Field for Search Help) |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | BAPIHR0002 | ARISTOCRATIC_TITLE | T535N | TITEL | |||
2 | BAPIHR0002 | COUNTRY_OF_BIRTH | T005 | LAND1 | |||
3 | BAPIHR0002 | FORM_OF_ADDRESS_KEY | T522G | ANRED | |||
4 | BAPIHR0002 | INFOTYPE | T582A | INFTY | |||
5 | BAPIHR0002 | LANGU | T002 | SPRAS | |||
6 | BAPIHR0002 | MARITAL_STATUS | T502T | FAMST | |||
7 | BAPIHR0002 | NAME_AFFIX | T535N | TITEL | |||
8 | BAPIHR0002 | NATIONALITY | T005 | LAND1 | |||
9 | BAPIHR0002 | REASON_TO_CHANGE_MASTER_DATA | T530E | PREAS | |||
10 | BAPIHR0002 | RELIGIOUS_DENOMINATION | T516T | KONFE | |||
11 | BAPIHR0002 | SECOND_NAME_PREFIX | T535N | TITEL | |||
12 | BAPIHR0002 | SECOND_NATIONALITY | T005 | LAND1 | |||
13 | BAPIHR0002 | SECOND_TITLE | T535N | TITEL | |||
14 | BAPIHR0002 | STATE | T005S | BLAND | 1 | CN | |
15 | BAPIHR0002 | THIRD_NATIONALITY | T005 | LAND1 | |||
16 | BAPIHR0002 | TITLE | T535N | TITEL |
History
Last changed by/on | SAP | 20140121 |
SAP Release Created in |