SAP ABAP Table HRTMC_S_WORK_EXP_EXT_EXT (Work Experience (External))
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 | HRTMC_S_WORK_EXP_EXT_EXT | Table Relationship Diagram |
Short Description | Work Experience (External) |
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 | External Work Experience | |||||
2 | .INCLUDE | 0 | 0 | Key Structure for Infotype Structures PNNNN | |||||
3 | MANDT | MANDT | MANDT | CLNT | 3 | 0 | Client | T000 | |
4 | PLVAR | PLVAR | PLVAR | CHAR | 2 | 0 | Plan Version | T778P | |
5 | OTYPE | OTYPE | OTYPE | CHAR | 2 | 0 | Object Type | T778O | |
6 | OBJID | OBJEKTID | NUM08 | NUMC | 8 | 0 | Object ID | ||
7 | INFTY | INFOTYP | INFOTYP | CHAR | 4 | 0 | Infotype | T778T | |
8 | SUBTY | SUBTYP | SUBTYP | CHAR | 4 | 0 | Subtype | T778U | |
9 | ISTAT | ISTAT_D | ISTAT | CHAR | 1 | 0 | Planning Status | T778S | |
10 | PRIOX | PRIOX | CHAR2 | CHAR | 2 | 0 | Priority | ||
11 | BEGDA | BEGDATUM | DATUM | DATS | 8 | 0 | Start Date | ||
12 | ENDDA | ENDDATUM | DATUM | DATS | 8 | 0 | End Date | ||
13 | VARYF | VARYF | CHAR10 | CHAR | 10 | 0 | Variation Field for File PLOG | ||
14 | SEQNR | SEQNR | NUM03 | NUMC | 3 | 0 | Number of Infotype Record With Same Key | ||
15 | .INCLUDE | 0 | 0 | Infotype Administration Data | |||||
16 | AEDTM | AEDTM | DATUM | DATS | 8 | 0 | Changed on | ||
17 | UNAME | USRNAME | CHAR12 | CHAR | 12 | 0 | User Name | ||
18 | REASN | REASN | CHAR2 | CHAR | 2 | 0 | Reason | ||
19 | HISTO | HISTO | CHAR1 | CHAR | 1 | 0 | Historical Record Flag | ||
20 | ITXNR | ITXNR | NUM08 | NUMC | 8 | 0 | Text Module for Infotype | ||
21 | .INCLUDE | 0 | 0 | External Work Experience | |||||
22 | EMPLOYER | HRTMC_EMPLOYER | TEXT80 | CHAR | 80 | 0 | Employer | ||
23 | CITY | AD_CITY1 | TEXT40 | CHAR | 40 | 0 | City | ||
24 | REGION | REGIO | REGIO | CHAR | 3 | 0 | Region (State, Province, County) | T005S | |
25 | COUNTRY | LAND1 | LAND1 | CHAR | 3 | 0 | Country Key | T005 | |
26 | INDUSTRY | HRTMC_INDUSTRY | HRTMC_INDUSTRY | NUMC | 4 | 0 | Industry | T77TMC_INDU | |
27 | FUNCTIONAL_AREA | HRTMC_FUNCTIONAL_AREA | HRTMC_FUNCTIONAL_AREA | NUMC | 4 | 0 | Functional Area | T77TMC_FUNC | |
28 | HIERARCHY_LEVEL | HRTMC_HIERARCHY_LEVEL | HRTMC_HIERARCHY_LEVEL | NUMC | 4 | 0 | Hierarchy Level | T77TMC_HIER | |
29 | SPAN_OF_CONTROL | HRTMC_SPAN_OF_CONTROL | DEC3 | DEC | 3 | 0 | Span of Control | ||
30 | START_DATE | HRTMC_WORK_EXP_START_DATE | DATUM | DATS | 8 | 0 | Start of Earlier Work Relationship | ||
31 | END_DATE | HRTMC_WORK_EXP_END_DATE | DATUM | DATS | 8 | 0 | End of Earlier Work Relationship | ||
32 | WORKING_TIME | HRTMC_WORKING_TIME | DEC2_2 | DEC | 4 | 2 | Working Time in Hours per Week | ||
33 | CONTRACT_TYPE | HRTMC_WORK_CONTRACT_TYPE | HRTMC_WORK_CONTRACT_TYPE | NUMC | 4 | 0 | Work Contract Type | T77TMC_CONTTY | |
34 | JOB_TITEL | HRTMC_JOBTITLE | TEXT80 | CHAR | 80 | 0 | Job Title | ||
35 | COMMENT_CLASS | SDOK_CLASS | SDOK_CLASS | CHAR | 10 | 0 | Document class | * | |
36 | COMMENT_ID | SDOK_DOCID | SDOK_DOCID | CHAR | 32 | 0 | ID for documents and relations | ||
37 | .INCLUDE | 0 | 0 | ||||||
38 | TABNR | HRTABNR | HRTABNR | CHAR | 32 | 0 | Reference Number to Table Part | * | |
39 | .INCLUDE | 0 | 0 | Texts for External Work Experience | |||||
40 | COUNTRY_TXT | HRTMC_COUNTRY_TXT | TEXT50 | CHAR | 50 | 0 | Country Text (for Display Only) | ||
41 | REGION_TXT | HRTMC_REGION_TXT | TEXT20 | CHAR | 20 | 0 | Region Text (Only for Display) | ||
42 | CONTRACT_TYPE_TXT | HRTMC_CONTRACT_TYPE_TXT | TEXT30 | CHAR | 30 | 0 | Text of Work Contract Type | ||
43 | FUNCTIONAL_AREA_TXT | HRTMC_FUNCTIONAL_AREA_TXT | TEXT80 | CHAR | 80 | 0 | Text of the Functional Area | ||
44 | HIERARCHY_LEVEL_TXT | HRTMC_HIERARCHY_LEVEL_TXT | TEXT80 | CHAR | 80 | 0 | Hierarchy Level Text | ||
45 | INDUSTRY_TXT | HRTMC_INDUSTRY_TXT | TEXT80 | CHAR | 80 | 0 | Industry Text | ||
46 | DESCRIPTION_TXT | HRTMC_DESCRIPTION | STRG | 0 | 0 | Transfer Objects for Free Texts from Infotypes | |||
47 | LOCATION_TXT | HRTMC_LOCATION | TEXT80 | CHAR | 80 | 0 | Location | ||
48 | DOC_LANGU | SPRAS | SPRAS | LANG | 1 | 0 | Language Key | * | |
49 | ATTACHMENTS | HRTMC_T_ATTACHMENT | TTYP | 0 | 0 |
Foreign Keys
Source Table | Source Column | Foreign Table | Foreign Column | Dependency Factor | Cardinality left | Cardinality right | |
---|---|---|---|---|---|---|---|
1 | HRTMC_S_WORK_EXP_EXT_EXT | CONTRACT_TYPE | T77TMC_CONTTY | WORK_CONTRACT | |||
2 | HRTMC_S_WORK_EXP_EXT_EXT | COUNTRY | T005 | LAND1 | |||
3 | HRTMC_S_WORK_EXP_EXT_EXT | FUNCTIONAL_AREA | T77TMC_FUNC | FUNCTIONAL_AREA | |||
4 | HRTMC_S_WORK_EXP_EXT_EXT | HIERARCHY_LEVEL | T77TMC_HIER | HIERARCHY_LEVEL | |||
5 | HRTMC_S_WORK_EXP_EXT_EXT | INDUSTRY | T77TMC_INDU | INDUSTRY | |||
6 | HRTMC_S_WORK_EXP_EXT_EXT | INFTY | T778T | INFTY | |||
7 | HRTMC_S_WORK_EXP_EXT_EXT | ISTAT | T778S | ISTAT | |||
8 | HRTMC_S_WORK_EXP_EXT_EXT | MANDT | T000 | MANDT | |||
9 | HRTMC_S_WORK_EXP_EXT_EXT | OTYPE | T778O | OTYPE | |||
10 | HRTMC_S_WORK_EXP_EXT_EXT | PLVAR | T778P | PLVAR | |||
11 | HRTMC_S_WORK_EXP_EXT_EXT | REGION | T005S | BLAND | |||
12 | HRTMC_S_WORK_EXP_EXT_EXT | SUBTY | T778U | SUBTY |
History
Last changed by/on | SAP | 20130604 |
SAP Release Created in | 701 |