SAP TEMUS IS-U Mig.: Managmnt Table data and field list

TEMUS is a standard SAP Table which is used to store IS-U Mig.: Managmnt data in SAP systems, such as SAP R/3, S/4HANA, depending on the version and release level.

The TEMUS table consists of various fields, each holding specific information or linking keys about IS-U Mig.: Managmnt data available in SAP. These include UNAME (User Name), FIRMA (Company (Client) for Migration), JMP_FIRMA (Skip Company Selection at Start), OBJECT (Migration Object)... 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. .

TEMUS table Technical Details:

Delivery Class: C - Customising table, maintenance only by cust
Display/Maintenance via tcode SM30: Display/Maintenance Allowed but with Restrictions
SAP enhancement categories: Can be enhanced (character-type or numeric)


SAP TEMUS table fields - Full list of fields found in SAP data dictionary

Looking for S/4HANA specific information? Click here to explore the details, fields and extensibility available for this table in the SAP S/4HANA version of the TEMUS table. Also check whether the table still exists or has been transformed into a CDS view as part of the HANA simplifications.
Field Description Data Element Data Type length (Dec) Check table Conversion Routine Domain Name MemoryID SHLP
MANDTClient MANDTCLNT3Assigned to domainMANDT
UNAMEUser Name UNAMECHAR12UNAME
FIRMACompany (Client) for Migration EMG_FIRMACHAR5Assigned to domainEMG_FIRMA
JMP_FIRMASkip Company Selection at Start EMG_JMP_FIRMACHAR1EMG_CHECK
OBJECTMigration Object EMG_OBJECTCHAR10Assigned to domainEMG_OBJECTEM1
CHANGE_STATUSBlocking status change permissible EMG_CH_STATUSCHAR1EMG_CHECK
N_NAMESub-structure name for automation data EMG_SUPPTCHAR30EMG_AUTOPT
INPSTRUCTLargest possible transfer structure (SAP) EMG_STRUCTCHAR30Assigned to domainAS4TABEM2
FIELDField name for transfer structure EMG_FIELDCHAR30Assigned to domainFDNAME
VARNAMEFixed value EMG_VNAMECHAR12Assigned to domainEMG_VNAME
SERVERRemote server of migration path dialog EMG_SERVER_DIACHAR40MSNAME2
PFADPath for Migration Dialog EMG_PFAD_DIACHAR60EMG_PFAD_NAME
SERVER_BACKRemote server of migration path batch EMG_SERVER_BACKCHAR40MSNAME2
PFAD_BACKPath for Migration Batch EMG_PFAD_BACKCHAR60EMG_PFAD_NAME
CPGFSCode Page of Legacy System EMG_SCPNUMC4Assigned to domainCPCODEPAGE
CPGISCode Page of System EMG_ICPNUMC4Assigned to domainCPCODEPAGE
FILE_SUFFIXMigration file suffix EMG_SUFFIXCHAR3EMG_SUFFIX
ANZDSNumber of data records for display EMG_ANZDSINT410EMG_ANZAHL
WB_STATUSDisplay additional migration workbench status EMG_WBSTATUSCHAR1EMG_CHECK
EXCEL_PFADPath to local Excel application EMG_EXCEL_PFADCHAR60EMG_PFAD_NAME
INSERT_TOOLPerformance tools for report generation EMG_INS_TOOLCHAR1EMG_CHECK
FULL_FIELDNAMEDisplay Full Length of Field Name EMG_FULL_FIELDCHAR1EMG_CHECK
DATUMDate DATUMDATS8DATUM
UZEITTime UZEITTIMS6UZEIT
ANAMEUser Name UNAMECHAR12UNAME
STRUC_PFADDirectory for downloading structure descriptions EMG_STRUC_PFADCHAR60EMG_PFAD_NAME
PERFMON_ONActivate performance monitor in batch run EMG_PERFMON_ONCHAR1EMG_CHECK
PERFMON_NRNumber of data records per issue in performance monitoring EMG_PERFMON_NRNUMC5NUM05
MSG_TO_JOBLOGWrite Error Messages Additionally to Job Log EMG_MSG_TO_JOBLOGCHAR1EMG_CHECK
SEL_IMP_MODEMode for Data Import (Dialog, Batch...) EMG_SEL_IMP_MODECHAR1EMG_IMPMODE
MSG_OFFNo Longer Display Messages for Migration Workbench EMG_MSG_OFFCHAR1EMG_CHECK
CONVOBJECTConversion object EMG_CONVOBJECTCHAR15Assigned to domainEMG_CONVOBJECT
CHANGE_IMP_PATHMigration: Change to Migration Path of Import Screen is OK EMG_CHANGE_IMP_PATHCHAR1EMG_CHECK
ACCESSIBLEAccessible Screen Display EMG_ACCESSIBLECHAR1EMG_CHECK

Key field Non-key field



How do I retrieve data from SAP table TEMUS using ABAP code

The following ABAP code Example will allow you to do a basic selection on TEMUS to SELECT all data from the table
DATA: WA_TEMUS TYPE TEMUS.

SELECT SINGLE *
FROM TEMUS
INTO CORRESPONDING FIELDS OF WA_TEMUS
WHERE...

How to access SAP table TEMUS

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

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