Show TOC

BI Object Request Status Locate this document in the navigation structure

DataSource Transactional Data DataSource Transactional Data: 0TCT_DS11

 

The DataSource BI Object Request Status (0TCT_DS11) provides details of requests in different DataTargets and Master Data in characteristics.

The fields that are provided by the DataSource are displayed in a table that contains detailed information about the extract structure.

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

No

Extraction from Archives

No

Verifiable

No

Data Modeling

Delta Update

The DataSource has remote capability. It does not support delta handling.

Fields of Origin for the Extract Structure

Fields in the Extract Structure

Description of the Field in the Extract Structure

Table of Origin

Field in the Table of Origin

LOGSYS

Logical System

ABAP Routine

BWOBJECT

Data Source or Target for Status Manager

RSMDATASTATE_EXT

DTA

DTA_TYPE

Data Target Type

RSMDATASTATE_EXT

DTA_TYPE

LAST_REQUEST

Master data ID

RSMDATASTATE_EXT

LAST_REQUEST

TECHOK

Request SID for which all requests are technically correct

RSMDATASTATE

TECHOK

QUALOK

Request SID for which all requests checked for quality

RSMDATASTATE

QUALOK

COMPR

Request SID to which InfoCube is to be compressed

RSMDATASTATE

COMPR

ROLLUP

Request SID to which all aggregates are rolled up

RSMDATASTATE

ROLLUP

TMSTMP_ROLLUP

Time stamp for highest roll-up request

RSMDATASTATE

TMSTMP_ROLLUP

TMSTMP_QUALOK

Time stamp for largest request that is qualitatively correct

RSMDATASTATE

TMSTMP_QUALOK

TS_DATA_CHANGED

Time stamp for last change of any field

RSMDATASTATE_EXT

TS_DATA_CHANGED

TS_LAST_REQUEST

Time stamp for last loaded request

RSMDATASTATE_EXT

TS_LAST_REQUEST

TS_QUAL_CHANGED

Time stamp for last change of qualitatively correct record

RSMDATASTATE_EXT

TS_QUAL_CHANGED

TS_TECH_CHANGED

Time stamp for last change of technically correct record

RSMDATASTATE_EXT

TS_TECH_CHANGED

TS_ERROR_CHANGED

Time stamp for last change of erroneous record

RSMDATASTATE_EXT

TS_ERROR_CHANGED

TS_ACTIV_CHANGED

Time stamp for last change of activation record

RSMDATASTATE_EXT

TS_ACTIV_CHANGED

TS_COMP_CHANGED

Time stamp for last change of compressed record

RSMDATASTATE_EXT

TS_COMP_CHANGED

TS_ROLL_CHANGED

Time stamp for last change of roll up record

RSMDATASTATE_EXT

TS_ROLL_CHANGED

RECORDS_ALL

Number of data records

RSMDATASTATE_EXT

RECORDS_ALL

REQUESTS_ALL

Number of requests

RSMDATASTATE_EXT

REQUESTS_ALL

RECORDS_QUALOK

Number of records qualitatively correct

RSMDATASTATE_EXT

RECORDS_QUALOK

REQUESTS_QUALOK

Number of requests qualitatively correct

RSMDATASTATE_EXT

REQUESTS_QUALOK

RECORDS_TECHOK

Number of records technically correct

RSMDATASTATE_EXT

RECORDS_TECHOK

REQUESTS_TECHOK

Number of requests technically correct

RSMDATASTATE_EXT

REQUESTS_TECHOK

RECORDS_ERROR

Number of erroneous records

RSMDATASTATE_EXT

RECORDS_ERROR

REQUESTS_ERROR

Number of erroneous requests

RSMDATASTATE_EXT

REQUESTS_ERROR

RECORDS_ACTIV

Number of activated records

RSMDATASTATE_EXT

RECORDS_ACTIV

REQUESTS_ACTIV

Number of activated requests

RSMDATASTATE_EXT

REQUESTS_ACTIV

RECORDS_COMPR

Number of compressed records

RSMDATASTATE_EXT

RECORDS_COMPR

REQUESTS_COMPR

Number of requests compressed

RSMDATASTATE_EXT

REQUESTS_COMPR

RECORDS_ROLLUP

Last aggregated record

RSMDATASTATE_EXT

RECORDS_ROLLUP

REQUESTS_ROLLUP

Last aggregated request

RSMDATASTATE_EXT

REQUESTS_ROLLUP

Extractor Logic

The DataSource uses the function module extractor RSTC_GET_STATUS_DATA. This function module extracts data from the tables RSMDATASTATE_EXT and RSMDATASTATE. A left outer join is used to join these two tables using the condition given below:

RSMDATASTATE_EXT-DTA = RSMDATASTATE-INFOCUBE