Follow us on LinkedIn for your next SAP project

← Back to Search

SAP Table STMSIQREQ

TMS UIQ: Request for Import Queue Display

STMSIQREQ (TMS UIQ: Request for Import Queue Display) is a standard table in SAP R\3 ERP systems. Below you can find the technical details of the fields that make up this table. Key fields are marked in blue.

Additionally we provide an overview of foreign key relationships, if any, that link STMSIQREQ to other SAP tables.

STMSIQREQ table fields

Field

Data element

Checktable

Datatype

Length

Decimals

Possible values

DOMNAM

TMS: Transport Domain

TMSDOMNAM

CHAR

SYSNAM

TMS: System Name

TMSSYSNAM

CHAR

BUFPOS

Dictionary: Line item

DDPOSITION

NUMC

BUFLVL

Counter

COUNTER

NUMC

TRKORR

Request/Task

TRKORR

CHAR

UMODES

tp Unconditional Modes

TRTPUMODES

CHAR

IMPFLG

tp Import Flag

TRTPIMPFLG

CHAR

Value	Description
NULL	No request (control information)
1	Request waiting to be imported
2	Request already imported
3	Requests in this source system are excluded from the import
4	Only for internal use by tp
5	Requests not selected are excluded from the import
6	Selected requests are excluded from the import
7	Target client is not imported
8	Transport request is already in the system
9	Transport request belongs to another project
C	Requests of transport type C excluded from import
E	Requests of transport type E excluded from import
K	Requests of transport type K excluded from import
M	Client transports only imported as single imports
O	Requests of transport type O excluded from import
T	Requests of transport type T excluded from import
W	Requests of transport type W excluded from import
c	C request waiting for import
d	D request waiting for import
e	E request waiting for import
k	K request waiting for import
m	Client transports waiting for import
o	O request waiting for import
t	T request waiting for import
w	W request waiting for import

MAXRC

Return code

TRRETCODE

CHAR

TARCLI

Target client for the request

TRTARCLI

CHAR

PROJECT

Project in Change and Transport System

TRKORR_P

CHAR

TRFUNC

Type of request/task

TRFUNCTION

CHAR

Value	Description
K	Workbench Request
W	Customizing Request
C	Relocation of Objects Without Package Change
O	Relocation of Objects with Package Change
E	Relocation of Complete Package
T	Transport of Copies
S	Development/Correction
R	Repair
X	Unclassified Task
Q	Customizing Task
G	Piece List for CTS Project
M	Client Transport Request
P	Piece List for Upgrade
D	Piece List for Support Package
F	Piece List
L	Deletion transport

ACTFLG

tp Active Flag

TRTPACTFLG

CHAR

PREFLG

tp Predecessor Flag

TRTPPREFLG

CHAR

NODATAFLG

tp No Data Flag

TRTPNODFLG

CHAR

JOBID

TMS CI Background Job Number

CIBJOBNUM

NUMC

TPSTATID

tp Time Stamp

TRTPTSTAMP

CHAR

IMPSING

General Flag

FLAG

CHAR

Value	Description
X	Flag set. Event has occurred.
NULL	Flag is Not Set

OWNER

TMS: Owner

TMSOWNER

CHAR

ADMIN

TMS: Transport Administrator

TMSADMIN

CHAR

TEXT

Short Description of Repository Objects

AS4TEXT

CHAR

COMSYS

TMS: System Name

TMSSYSNAM

CHAR

SRCCLI

Source client of request

TRCLIENT

CHAR

TRSTEP

tp Step

TRTPSTEP

CHAR

Value	Description
#	Convert ADO Data File
(	Lock Development Environment
)	Unlock Development Environment
<	Forward to Follow-On System(s)
+	Activate Nametabs
-	Activate Nametabs with DDL
NULL	Unknown Step
1	Activation of Report Sources (inactive import)
2	Postprocessing of Language Import
3	Start R/3 Instance
4	Stop R/3 Instance
5	Activate Report Sources (MST Only)
6	Activate DDIC Runtime Descriptions (Nametabs)
7	Unknown Step
8	Reset All SAP Buffers (/$SYNC)
9	Execution of Standard XPRAS
A	Activation
B	Inactive Import
C	C Objects (Release C Source Transports)
D	ADO Import
E	Main Export
F	Export C Source Transports
G	Generation
H	ABAP Dictionary Import
I	Main Import
L	Command File Import
M	MC_ENQ Activation
N	Conversion
O	Conversion Requested from SE14
P	Test Import
Q	Results Confirmation
R	XPRAs
S	Distribution (DDIC Changes to Conversion Prog. and mvntabs)
T	Deployment (non-ABAP)
U	Read Request Metadata
V	Version Management
X	ADO Export
\	Activate Nametabs with Special Actions
a	Set Stop Mark
b	Accelerated Inactive Import
d	Delete Stop Mark
e	Preparation for Export
f	Check Whether Buffers Can Be Written to
g	Import Queue Adjustment
h	Accelerated DDIC Import
k	Accelerated Shadow Import
i	Accelerated Main Import
j	Define Buffer Length
l	Accelerated Command File Import
m	Create cofile
n	Convert Matchcode and Enqueue Objects
o	Reserve Memory Space in Data File
p	Set Active (cofile)
q	Set Inactive (cofi)
r	Set Data as Transferred (cofi)
t	R3trans Database Connection
v	Create Versions After Import
w	Create Versions Before Import
{	Lock SAP System Against User Logon
}	Unlock SAP System for User Logon
~	Delete Nametabs
y	Change in DBI Tables
>	Remove from Buffer
*	Prepare Buffer
=	Clean Up Target Systems
\|	Broadcast

IMPDAT

Field of type DATS

DATS

IMPTIM

Field of type TIMS

TIMS

IMPDAT2

Field of type DATS

DATS

IMPTIM2

Field of type TIMS

TIMS

IMPSTAT

TMS: Import Status

TMSIMPSTAT

CHAR

Value	Description
A	Request must still be approved
D	Request rejected
C	Request does not match component version
N	Request will not be imported
P	Request is after end mark
Q	Request is ready for import again
R	Request waiting to be imported
S	Import is scheduled
T	Import running
W	Import terminated
X	Request already imported
F	Request imported successfully into all systems
E	Some errors during transport
Z	Request not yet imported into all systems

QASTATUS

TMS QA: Status of QA Flag

QASTATUS

CHAR

Value	Description
A	Active
I	Inactive
V	Rejected
O	Open (Nothing Done)

QADELETED

General Flag

FLAG

CHAR

Value	Description
X	Flag set. Event has occurred.
NULL	Flag is Not Set

QADIST

General Flag

FLAG

CHAR

Value	Description
X	Flag set. Event has occurred.
NULL	Flag is Not Set

RC1

Return code

TRRETCODE

CHAR

RC2

Return code

TRRETCODE

CHAR

RC3

Return code

TRRETCODE

CHAR

RC4

Return code

TRRETCODE

CHAR

RC5

Return code

TRRETCODE

CHAR

RC6

Return code

TRRETCODE

CHAR

RC7

Return code

TRRETCODE

CHAR

RC8

Return code

TRRETCODE

CHAR

RC9

Return code

TRRETCODE

CHAR

ICONRC

CHAR

ICONAF

CHAR

ICONPF

CHAR

ICONIS

CHAR

ICONQS

CHAR

ICONQD

CHAR

ICONQED

CHAR

ICONRC1

CHAR

ICONRC2

CHAR

ICONRC3

CHAR

ICONRC4

CHAR

ICONRC5

CHAR

ICONRC6

CHAR

ICONRC7

CHAR

ICONRC8

CHAR

ICONRC9

CHAR

INFO0

CHAR

INFO1

CHAR

INFO2

CHAR

INFO3

CHAR

INFO4

CHAR

INFO5

CHAR

INFO6

CHAR

INFO7

CHAR

INFO8

CHAR

INFO9

CHAR

ALERTID

CI: alert ID

CIALERTID

CHAR

CLIENTS

CHAR

800

QASTATALL

TMS QA: Status of QA Flag

QASTATUS

CHAR

Value	Description
A	Active
I	Inactive
V	Rejected
O	Open (Nothing Done)

ICONALL

CHAR

INF10

CHAR

STEPS

CHAR

CVERSFLG

Result of Component Check

CCRESLT

CHAR

Value	Description
>	Greater Than
<	Less Than
=	Equals
-	Unknown
<>	Greater Than and Less Than
NE	Not Equal to
>=	Greater Than and Equal To
<=	Lesser Than and Equal To