SAP ABAP Table P7404 (Education/Training)
Hierarchy
☛
SAP_BS_FND (Software Component) SAP Business Suite Foundation
⤷ CA-EPT-TM (Application Component) Talent Management
⤷ HCM_TMC (Package) HCM: Talent Management Core
⤷ CA-EPT-TM (Application Component) Talent Management
⤷ HCM_TMC (Package) HCM: Talent Management Core
Basic Data
Table Category | INTTAB | Structure |
Structure | P7404 | Table Relationship Diagram |
Short Description | Education/Training |
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 | Key Structure for Infotype Structures PNNNN | |||||
2 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
3 | PLVAR | PLVAR | PLVAR | CHAR | 2 | 0 | Plan Version | T778P | |
4 | OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | T778O | |
5 | OBJID | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
6 | INFTY | INFOTYP | INFOTYP | CHAR | 4 | 0 | Infotype | T778T | |
7 | SUBTY | SUBTYP | SUBTYP | CHAR | 4 | 0 | Subtype | T778U | |
8 | ISTAT | ISTAT_D | ISTAT | CHAR | 1 | 0 | Planning Status | T778S | |
9 | PRIOX | PRIOX | CHAR2 | CHAR | 2 | 0 | Priority | ||
10 | BEGDA | BEGDATUM | DATUM | DATS | 8 | 0 | Start Date | ||
11 | ENDDA | ENDDATUM | DATUM | DATS | 8 | 0 | End Date | ||
12 | VARYF | VARYF | CHAR10 | CHAR | 10 | 0 | Variation Field for File PLOG | ||
13 | SEQNR | SEQNR | NUM03 | NUMC | 3 | 0 | Number of Infotype Record With Same Key | ||
14 | .INCLUDE | 0 | 0 | Infotype Administration Data | |||||
15 | AEDTM | AEDTM | DATUM | DATS | 8 | 0 | Changed on | ||
16 | UNAME | USRNAME | CHAR12 | CHAR | 12 | 0 | User Name | ||
17 | REASN | REASN | CHAR2 | CHAR | 2 | 0 | Reason | ||
18 | HISTO | HISTO | CHAR1 | CHAR | 1 | 0 | Historical Record Flag | ||
19 | ITXNR | ITXNR | NUM08 | NUMC | 8 | 0 | Text Module for Infotype | ||
20 | .INCLUDE | 0 | 0 | Education/Training | |||||
21 | EDUCATION_TYPE | HRTMC_EDUCATION_TYPE | HRTMC_EDUCATION_TYPE | NUMC | 4 | 0 | Education Type | T77TMC_EDUTYP | |
22 | EDUCATION_FIELD | HRTMC_EDUCATION_FIELD | HRTMC_EDUCATION_FIELD | NUMC | 4 | 0 | Education Field | T77TMC_EDUFLD | |
23 | INSTITUTE | HRTMC_EDUCATION_INSTITUTE | TEXT80 | CHAR | 80 | 0 | Educational Institute | ||
24 | CITY | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
25 | REGION | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
26 | COUNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
27 | FIELD_OF_STUDY1 | HRTMC_FIELD_OF_STUDY | TEXT80 | CHAR | 80 | 0 | Field of Study | ||
28 | FIELD_OF_STUDY2 | HRTMC_FIELD_OF_STUDY | TEXT80 | CHAR | 80 | 0 | Field of Study | ||
29 | FIELD_OF_STUDY3 | HRTMC_FIELD_OF_STUDY | TEXT80 | CHAR | 80 | 0 | Field of Study | ||
30 | DEGREE | HRTMC_DEGREE | TEXT80 | CHAR | 80 | 0 | Degree | ||
31 | GRADE | HRTMC_GRADE | CHAR04 | CHAR | 4 | 0 | Grade | ||
32 | START_DATE | HRTMC_EDUCATION_START_DATE | DATUM | DATS | 8 | 0 | Start of Education | ||
33 | END_DATE | HRTMC_EDUCATION_END_DATE | DATUM | DATS | 8 | 0 | End of Education | ||
34 | HIGHEST_DEGREE | HRTMC_HIGHEST_DEGREE | HRTMC_HIGHEST_DEGREE | CHAR | 1 | 0 | Highest Degree | ||
35 | DEGREE_LEVEL | HRTMC_DEGREE_LEVEL | HRTMC_DEGREE_LEVEL | NUMC | 2 | 0 | Degree Level | T77TMC_DEGREE | |
36 | COMMENT_CLASS | SDOK_CLASS | SDOK_CLASS | CHAR | 10 | 0 | Document class | * | |
37 | COMMENT_ID | SDOK_DOCID | SDOK_DOCID | CHAR | 32 | 0 | ID for documents and relations | ||
38 | .INCLUDE | 0 | 0 | ||||||
39 | TABNR | HRTABNR | HRTABNR | CHAR | 32 | 0 | Reference Number to Table Part | * |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | P7404 | COUNTRY | T005 | LAND1 | |||
2 | P7404 | DEGREE_LEVEL | T77TMC_DEGREE | DEGREE_LEVEL | |||
3 | P7404 | EDUCATION_FIELD | T77TMC_EDUFLD | EDU_FIELD | |||
4 | P7404 | EDUCATION_TYPE | T77TMC_EDUTYP | EDU_TYPE | |||
5 | P7404 | INFTY | T778T | INFTY | |||
6 | P7404 | ISTAT | T778S | ISTAT | |||
7 | P7404 | MANDT | T000 | MANDT | |||
8 | P7404 | OTYPE | T778O | OTYPE | |||
9 | P7404 | PLVAR | T778P | PLVAR | |||
10 | P7404 | REGION | T005S | BLAND | |||
11 | P7404 | SUBTY | T778U | SUBTY |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 701 |