Process Chain Statistics 
DataSource Transactional Data: 0TCT_DS21
The DataSource Process Chain Statistics (0TCT_DS21) provides details of all the process chains that were successfully executed in the system. These process chains have a status that is either green or completed.
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 handles deltas internally. 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 the table RSPCLOGCHAIN and RSPCPROCESSLOG.
Fields in the Extract Structure | Description of the Field in the Extract Structure | Table of Origin | Field in the Table of Origin |
|---|---|---|---|
CALDAY |
Calendar Day |
Routine (STRTTIMESTMP) |
|
CHAIN_ID |
Name of the process chain |
RSPCLOGCHAIN |
CHAIN_ID |
DURATION |
Duration |
ABAP Routine |
|
INSTANCE |
Process instance |
RSPCPROCESSLOG |
INSTANCE |
LOG_ID |
Log ID of the process chain run |
RSPCLOGCHAIN |
LOG_ID |
STARTTIMESTAMP |
Start time stamp |
RSPCPROCESSLOG |
STARTTIMESTAMP |
STAUIK |
Frequency |
Constant = 1 |
|
SYSID |
BI system |
ABAP Routine |
|
TIME |
Start time |
Routine (STRTTIMESTMP) |
|
TYPE |
Type of process |
RSPCPROCESSLOG |
TYPE |
VARIANT |
Process variant |
RSPCPROCESSLOG |
VARIANTE |
Extractor Logic
All the fields, except for sysid, duration, stauik and timek, that are mentioned in the above table are extracted directly from the tables RSPCLOGCHAIN and RSPCPROCESSLOG. SYSID is derived in the function 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, except for the summary rows, where this is calculated using a different formula. TIMEK is the start time calculated using the field start time stamp (STARTTIMESTAMP). Only those Process Chains are selected that were successfully executed.