DTP Statistics 
DataSource Transactional Data: 0TCT_DS22
The DataSource DTP Statistics (0TCT_DS22) provides details about the data transfer processes that were executed both individually as stand alone processes, and as part of the process chain. The fields that are provided by the DataSource are listed in the extract structure. If the data transfer process is executed in a process chain, the fields CHAIN_ID and LOG_ID either contain data or are initial.
One important feature of the DataSource is the summary record. Two types of summary records are provided by the DataSource for every DTP for a specific instance:
Summary record for a DTP for every distinct Data Packet ID for a distinct instance
Summary record for a DTP for a distinct instance
Technical Data
Application Component | BW-BCT-TCT |
|---|---|
Available as of Release | SAP NetWeaver 2004s |
Shipment | SAP NW 2004s BI Content Add-On 2 |
Content Versions | No Content versions exist. |
RemoteCube-Capable | Yes |
Delta-Capable | Yes |
Extraction from Archives | No |
Verifiable | No |
Data Modeling
Delta Update
The DataSource has the function module extractor RSDDK_BIW_GET_DATA. This function module internally handles delta. The DB table RSDDSTATEXTRACT stores the delta pointer for each executed DataSource. With the next delta extraction, the delta pointer is extracted from this table and the corresponding delta data is extracted from different DB tables.
Fields in the Extract Structure | Description of the Field in the Extract Structure | Table of Origin | Field in the Table of Origin |
|---|---|---|---|
CALDAY |
|||
CHAIN_ID |
Name of the process chain |
RSPCLOGCHAIN |
CHAIN_ID |
CMD |
DTP command |
RSDDSTATDTP |
CMD |
DPAKID |
Data packet number |
RSDDSTATDTP |
DATAPAKID |
DTP |
Data transfer process ID |
RSBKREQUEST |
DTP |
DURATION |
Duration |
ABAP Routine |
|
INSTANCE |
Process instance (value) |
RSDDSTATDTP |
INSTANCE |
LOGSYS |
Source system |
RSDDSTATDTP |
LOGSYS |
LOG_ID |
Log ID of process chain run |
RSPCLOGCHAIN |
LOG_ID |
PROCESSMODE |
Processing mode |
RSBKREQUEST |
PROCESSMODE |
RECORDS_FINISH |
Records at the finish |
RSDDSTATDTP |
RECORDS_FINISH |
RECORDS_START |
Records at the start |
RSDDSTATDTP |
RECORDS_START |
SIZE _FINISH |
Size of the data package at the end |
RSDDSTATDTP |
SIZE _FINISH |
SIZE_START |
Size of the data package at the start |
RSDDSTATDTP |
SIZE_START |
SRC |
Source for the DTP |
RSBKREQUEST |
SRC |
SRCTLOGO |
Type of the source for a DTP |
RSBSOURCEPROP |
TLOGO |
SRCTLOGOSUB |
Sub-type of the source for a DTP |
RSBSOURCEPROP |
TLOGOSUB |
SRCTP |
DTP source type |
RSBKREQUEST |
SRCTP |
STAUIK |
Frequency |
Constant = 1 |
|
STEP |
Step |
RSDDSTATDTP |
STEP |
SUBSTEP |
Sub-step |
RSDDSTATDTP |
SUBSTEP |
TGT |
Target for the DTP |
RSBKREQUEST |
TGT |
TGTTLOGO |
Type of target for a DTP |
RSBTARGETPROP |
TLOGO |
TGTTLOGOSUB |
Sub-type of Target for a DTP |
RSBTARGETPROP |
TLOGOSUB |
TGTTP |
DTP target type |
RSBKREQUEST |
SRCTP |
TIME |
Time |
ABAP Routine |
|
TSTMP_FINISH |
End of DTP time stamp |
RSDDSTATDTP |
TSTMP_FINISH |
TSTMP_START |
Start of DTP time stamp |
RSDDSTATDTP |
TSTMP_START |
UNAME |
User name |
RSBKREQUEST |
UNAME |
Extractor Logic
All the fields except for the fields sysid, duration, stauik and timek that are mentioned in the above table are extracted directly from the tables RSDDSTATDTP, RSBKREQUEST, RSBSOURCEPROP and RSBTARGETPROP. If a DTP is executed in a process chain, the CHAIN_ID (process chain name) and LOG_ID (log ID), which are derived from table RSPCLOGCHAIN are used for the corresponding DTP. SYSID is derived in the function module using an object. DURATION is calculated using the end time stamp (ENDTIMESTMP) and start time stamp (STARTTIMESTAMP) fields. STAUIK is always set to constant 1, with the exception of the summary rows, where this is calculated using a different formula. TIMEK is start time which is calculated using the field start time stamp (STARTTIMESTAMP).