InfoPackage Statistics

DataSource Transactional Data: 0TCT_DS23

The DataSource InfoPackage Statistics (0TCT_DS23) provides detailed information about InfoPackages that were executed either independently or in a process chain.

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 deltas. 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 corresponding delta data is extracted from different DB tables.

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
`ACTION`	Transaction type	`RSDDSTATWHM`	`ACTION`
`CALDAY`	Calender day
`CHAIN_ID`	Name of the process chain	`RSPCLOGCHAIN`	`CHAIN_ID`
`DSOURCE`	DataSource	`RSDDSTATWHM`	`DSOURCE`
`ENDTIME`	TimeStamp		`ABAP Routine`
`INFOCUBE`	InfoProvider	`RSDDSTATWHM`	`INFOCUBE`
`IPAKID`	InfoPackage ID	`RSDDSTATWHM`	`IPAKID`
`ISOURCE`	InfoSource	`RSDDSTATWHM`	`ISOURCE`
`LOGSYS`	Source system	`RSDDSTATWHM`	`LOGSYS`
`LOG_ID`	Log ID of the process chain run	`RSPCLOGCHAIN`	`LOG_ID`
`MANUAL`	Automatically/Manually posted	`RSDDSTATWHM`	`MANUAL`
`OBJVERS`	Object version		`Routine = A`
`RECORDS`	Records (WHM process)	`RSDDSTATWHM`	`RECORDS`
`RSSID`	Master data ID	`RSDDSTATWHM`	`RSSID`
`SRCTLOGO`			`Routine`
`SRCTLOGOSUB`			`Routine`
`STARTTIME`	Time stamp	`RSDDSTATWHM`	`STARTTIME`
`STAUIK`	Frequency		`Constant = 1`
`SYSID`	BI System		`ABAP Routine`
`TFMETHOD`	Transfer type WHM	`RSDDSTATWHM`	`TFMETHOD`
`TGTTLOGO`			`Routine`
`TGTTLOGOSUB`			`Routine`
`TIME`	Duration	`RSDDSTATWHM`	`TIME`
`UNAME`	User name	`RSDDSTATWHM`	`UNAME`

Extractor Logic

The function module extractor extracts all the InfoPackages that are independently executed and that are executed as part of a process chain. For those InfoPackages that are executed in a process chain, the field CHAIN_ID is returned by the DataSource. RSDDSTATWHM and RSPCLOGCHAIN are joined to extract the required data.