HRTMC_S_WORK_EXP_EXT SAP (Work Experience (External)) Structure details

Dictionary Type: Structure
Description: Work Experience (External)




ABAP Code to SELECT data from HRTMC_S_WORK_EXP_EXT
Related tables to HRTMC_S_WORK_EXP_EXT
Access table HRTMC_S_WORK_EXP_EXT




Structure field list including key, data, relationships and ABAP select examples

HRTMC_S_WORK_EXP_EXT is a standard SAP Structure so does not store data like a database table does. It can be used to define the fields of other actual tables or to process "Work Experience (External)" Information within sap ABAP programs.

This is done by declaring abap internal tables, work areas or database tables based on this Structure. These can then be used to store and process the required data appropriately.

i.e. DATA: wa_HRTMC_S_WORK_EXP_EXT TYPE HRTMC_S_WORK_EXP_EXT.

The HRTMC_S_WORK_EXP_EXT table consists of various fields, each holding specific information or linking keys about Work Experience (External) data available in SAP. These include MANDT (Client), PLVAR (Plan Version), OTYPE (Object Type), OBJID (Object ID).. See below for full list along with technical details, documentation, text table, check tables, foreign key relationships, conversion routines, relevant tcodes and example ABAP select code etc. .

Delivery Class:
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can Be Enhanced (Deep)


SAP HRTMC_S_WORK_EXP_EXT structure fields - Full list of fields found in SAP data dictionary

Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3T000MANDT
PLVARPlan Version PLVARCHAR2T778PPLVARPOP
OTYPEObject Type OTYPECHAR2T778OOTYPEPOT
OBJIDObject ID OBJEKTIDNUMC8NUM08PON
INFTYInfotype INFOTYPCHAR4T778TINFOTYPHRBAS00INFTY
SUBTYSubtype SUBTYPCHAR4T778USUBTYP
ISTATPlanning Status ISTAT_DCHAR1T778SISTATPST
PRIOXPriority PRIOXCHAR2CHAR2
BEGDAStart Date BEGDATUMDATS8DATUMBEG
ENDDAEnd Date ENDDATUMDATS8DATUMEND
VARYFVariation Field for File PLOG VARYFCHAR10CHAR10
SEQNRNumber of Infotype Record with Same Key SEQNRNUMC3NUM03
AEDTMChanged on AEDTMDATS8DATUM
UNAMEUser Name USRNAMECHAR12CHAR12
REASNReason REASNCHAR2CHAR2
HISTOHistorical Record Flag HISTOCHAR1CHAR1
ITXNRText Module for Infotype ITXNRNUMC8NUM08
EMPLOYEREmployer HRTMC_EMPLOYERCHAR80TEXT80
CITYCity AD_CITY1CHAR40TEXT40CLCITYNAME
REGIONSTATE (State, Province, County) REGIOCHAR3T005SREGIO
COUNTRYCountry Key LAND1CHAR3T005LAND1LND
INDUSTRYIndustry HRTMC_INDUSTRYNUMC4T77TMC_INDUHRTMC_INDUSTRY
FUNCTIONAL_AREAFunctional Area HRTMC_FUNCTIONAL_AREANUMC4T77TMC_FUNCHRTMC_FUNCTIONAL_AREA
HIERARCHY_LEVELHierarchy Level HRTMC_HIERARCHY_LEVELNUMC4T77TMC_HIERHRTMC_HIERARCHY_LEVEL
SPAN_OF_CONTROLSpan of Control HRTMC_SPAN_OF_CONTROLDEC3DEC3
START_DATEStart of Earlier Work Relationship HRTMC_WORK_EXP_START_DATEDATS8DATUM
END_DATEEnd of Earlier Work Relationship HRTMC_WORK_EXP_END_DATEDATS8DATUM
WORKING_TIMEWorking Time in Hours per Week HRTMC_WORKING_TIMEDEC4(2) DEC2_2
CONTRACT_TYPEWork Contract Type HRTMC_WORK_CONTRACT_TYPENUMC4T77TMC_CONTTYHRTMC_WORK_CONTRACT_TYPE
JOB_TITELJob Title HRTMC_JOBTITLECHAR80TEXT80
COMMENT_CLASSDocument class SDOK_CLASSCHAR10Assigned to domainSDOK_CLASS
COMMENT_IDID for documents and relations SDOK_DOCIDCHAR32SDOK_DOCID
TABNRReference Number to Table Part HRTABNRCHAR32Assigned to domainHRTABNR
COUNTRY_TXTCountry Text (for Display Only) HRTMC_COUNTRY_TXTCHAR50TEXT50
REGION_TXTRegion Text (Only for Display) HRTMC_REGION_TXTCHAR20TEXT20
CONTRACT_TYPE_TXTText of Work Contract Type HRTMC_CONTRACT_TYPE_TXTCHAR30TEXT30
FUNCTIONAL_AREA_TXTText of the Functional Area HRTMC_FUNCTIONAL_AREA_TXTCHAR80TEXT80
HIERARCHY_LEVEL_TXTHierarchy Level Text HRTMC_HIERARCHY_LEVEL_TXTCHAR80TEXT80
INDUSTRY_TXTIndustry Text HRTMC_INDUSTRY_TXTCHAR80TEXT80
DESCRIPTION_TXTTransfer Objects for Free Texts from Infotypes HRTMC_DESCRIPTIONSTRG0
LOCATION_TXTLocation HRTMC_LOCATIONCHAR80TEXT80
DOC_LANGULanguage Key SPRASLANG1Assigned to domainISOLASPRASSPRH_T002

Key field Non-key field



How do I retrieve data from SAP structure HRTMC_S_WORK_EXP_EXT using ABAP code?

As HRTMC_S_WORK_EXP_EXT is a database structure and not a table it does not store any data in the SAP data dictionary. The ABAP SELECT statement is therefore not appropriate and can not be performed on HRTMC_S_WORK_EXP_EXT as there is no data to select.

How to access SAP table HRTMC_S_WORK_EXP_EXT

Within an ECC or HANA version of SAP you can also view further information about HRTMC_S_WORK_EXP_EXT and the data within it using relevant transactions such as

SE11 (ABAP Dictionary Maintenance)
SM30 (Maintain Table Data)
SE80 (Object Navigator)
SE16 (Data Browser).


Search for further information about these or an SAP related objects



Comments on this SAP object

What made you want to lookup this SAP object? Please tell us what you were looking for and anything you would like to be included on this page!