SAP Table WLBIDTPRQT

BI Workload: DTP Runtime Statistics- Request ID

WLBIDTPRQT (BI Workload: DTP Runtime Statistics- Request ID) 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 WLBIDTPRQT to other SAP tables.

WLBIDTPRQT table fields

Field Data element Checktable Datatype Length Decimals
REQUID Request ID WLBWREQID CHAR 12 0
DATAPAKID Data Packet ID WLBIDPAKID CHAR 10 0
SRC Name of the Data Source for a Data Transfer Process WLBISRC CHAR 30 0
SRCSYSTEM Source System Connection WLBISRCSYS CHAR 10 0
SRCTP Type of Source Object of a Data Transfer Process WLBISRCTYP CHAR 6 0
DTASRC DataSource
CUBE InfoCube
ODSO DataStore Object
ISET InfoSet
TEST Tests
DUMMY Template
DTP DTP (Error Stack)
IOBJA InfoObject: Attributes
IOBJT InfoObject: Texts
IOBJH InfoObject: Hierarchies
TOTAL All Data Sources Totalled
TGT Name of the Data Target for a Data Transfer Process WLBITGT CHAR 30 0
TGTTP Type of Target Object for a Data Transfer Process WLBITGTTYP CHAR 6 0
CUBE InfoCube
ODSO DataStore Object
IOBJA InfoObject: Attributes
IOBJT InfoObject: Texts
IOBJH InfoObject: Hierarchies
DEST Open Hub Destination
TEST Test Data Target
DUMMY Copy from Data Target
TOTAL All Data Target Types Totalled
TIMETOTAL Total Runtime of All DTPs (s) WLBIDTPTTOT DEC 15 1
NUMPACKAGE Total Number of Data Packets WLBINUMPACK DEC 15 0
TIMETOTCUM Cumulated Total Runtime of All DTP Data Packets (s) WLBIDTPTCUM DEC 15 1
RECS_MAX Maximum Number of Processed Records in a Data Packet WLBIRCSMAX DEC 21 0
SIZE_MAX Maximum Size of Processed Records in a Data Packet [Bytes] WLBISIZMAX DEC 21 0
TIMESRC Total Runtme of DTP Extraction in Source System (s) WLBITIMSRC DEC 15 1
TIMESRCPCT Share of Total Runtime that is Runtime in Source System (%) WLBITSRCPCT DEC 5 2
RECSSRC Number of Extracted Records in Source System WLBIRCSSRC DEC 21 0
SIZESRC Size of Extracted Packets from Source System (Bytes) WLBISIZSRC DEC 21 0
TIMEERRF Total Runtime for DTP Error Handling (s) WLBITIMERF DEC 15 1
TIMEERFPCT Share of Total Runtime That Is Error Filter Runtime (%) WLBITERFPCT DEC 5 2
RECSERRF_S Total Number of Records in Error Filter at Start Time WLBIRCSERFS DEC 21 0
RECSERRF_F Total Number of Records in Error Filter at End Time WLBIRCSERFF DEC 21 0
SIZEERRF_S Size of the Packets in Error Filter at Start Time (Bytes) WLBISIZERFS DEC 21 0
SIZEERRF_F Size of Packets in Error Filter at End Time (Bytes) WLBISIZERFF DEC 21 0
TIMETRFN Total Runtime for All DTP Transformations (s) WLBITIMTRF DEC 15 1
TIMETRFPCT Share of Total Runtime That Is Transformation Time (%) WLBITTRFPCT DEC 5 2
RECSTRFN_S Total Number of Transformed Records at Start Time WLBIRCSTRFS DEC 21 0
RECSTRFN_F Total Number of Transformed Records at End Time WLBIRCSTRFF DEC 21 0
SIZETRFN_S Size of the Transformed Packets at Start Time (Bytes) WLBISIZTRFS DEC 21 0
SIZETRFN_F Size of the Transformed Packets at End Time (Bytes) WLBISIZTRFF DEC 21 0
TIMETGT Total Runtime for Storing in Target Object (s) WLBITIMTGT DEC 15 1
TIMETGTPCT Share of Total Runtime that Is Target Object Time (%) WLBITTGTPCT DEC 5 2
RECSTGT_S Number of Stored Records in Target Object at Start Time WLBIRCSTGTS DEC 21 0
RECSTGT_F Number of Stored Records in Target Object at End Time WLBIRCSTGTF DEC 21 0
SIZETGT_S Size of the Stored Packets in Target Object (Bytes) WLBISIZTGTS DEC 21 0
RECSSRCPH Throughput: Number of Records Read in Source System per Hour WLBIRCSSRCPH DEC 15 0
RECSERFPH Throughput: Number of Records in Error Filter per Hour WLBIRCSERFPH DEC 15 0
RECSTRFPH Throughput: Number of Transformed Records per Hour WLBIRCSTRFPH DEC 15 0
RECSTGTPH Throughput: Number of Records Written to Target Object / h WLBIRCSTGTPH DEC 15 0
NUMTRFN Number of DTP Transformations WLBINUMTRF INT4 10 0
TSTMP_START UTC time stamp in long form (YYYYMMDDhhmmss,mmmuuun) TZNTSTMPL DEC 21 7
REQUEST DTP Request ID WLBIDTPREQ CHAR 30 0
LOGSYS Logical Name of the Source System WLBWLOGSYS CHAR 30 0
DTP Data Transfer Process ID WLBIDTPNAM CHAR 30 0
UNAME User Name WLBWNAME CHAR 12 0
CSTATE Current DTP Status WLBICSTATE CHAR 4 0
USTATE User-Defined Processing Status for a DTP Request WLBIUSTATE CHAR 1 0
0 New
1 Executable
2 Processed successfully
3 Processed with errors
4 Deleted
5 Active
6 Processed, with Warnings
7 Further processing started
8 Processed further
9 Deletion started
A Further processing terminated
TSTATE Technical Processing Status for a DTP Request WLBITSTATE CHAR 1 0
0 New
1 Executable
2 Processed successfully
3 Processed with errors
4 Deleted
5 Active
6 Processed, with Warnings
7 Further processing started
8 Processed further
9 Deletion started
A Further processing terminated
TARGETSTATE Target Status of DTP Request WLBITGTSTT CHAR 1 0
PROCESSMODE DTP Processing Mode WLBIPMODE CHAR 1 0
0 Serially in the Background Process
1 Serial Extraction, Immediate Parallel Processing
2 Serial Extraction, Then Parallel Processing (Obsolete)
3 Parallel Extraction and Processing
4 Serially in the Dialog Process (for Debugging)
5 Processing Mode for Real-Time Data Package
6 Processing Mode for Direct Access
7 Serial Extraction and Processing of Source Package
8 Serially in Dialog Process
9 No Data Transfer; Delta Status in Source: Fetched