topic Re: Table call statisitcs: ROWS AFFECTED ? in Application Development and Automation Discussions

Table call statisitcs: ROWS AFFECTED ?

Former Member — Thu, 27 Oct 2005 16:52:57 GMT

Hello,

the table call statistics (ST10) provides one column with the number of rows affected. This is the number of rows that have been read from the database. But the size of a row among tables are different. One row can have a size of 120Kb in one table or 5 Kb in another table.

So how is it to understand? What does it mean in KBytes if one row of a table is affected?

Thx, holger

Message was edited by: Holger Schmidt

Re: Table call statisitcs: ROWS AFFECTED ?

Former Member — Fri, 28 Oct 2005 15:02:23 GMT

Hi Holger,

Unfortunately, this list output be ST10 is not oriented towards the Size of the call. The program RSTABL11 prints this list.

One way to achieve this may be to copy the program RSTABL11 to suit your reporting requirements, such as getting the table row lengths and multiplying the rows with these lenghts.

This new program can then be called independently. Look at how the RSTABL11 is submitted in SAPMST10.

Hope this helps,

Bhanu

Hope this helps,

Bhanu

Re: Table call statisitcs: ROWS AFFECTED ?

Former Member — Thu, 03 Nov 2005 15:53:17 GMT

Hi Holger,

Were you able to do something?

Cheers,

Bhanu