SQL trace missing tables while doing trace

[Former Member]

Hi,

I did a runtime analysis(SE30) for my report and i can see huge time has been taken while fetching from table RBKP around 50% of total time.

But at the same time when i see SQL trace(ST05) for the same run, I am not able to see table RBKP in the trace at all. It is just showing some other tables used in the report.How it is possible I am sure the report is using RBKP table at the begining itself but it is not showing in the SQL trace. When i see summary statement it shows summary with different tables other than RBKP.Like wise I am sure the trace is missing few other tables also.RBKP also has setting buffering not allowed.

How this is possible, my report involves millions of records. Is it possible trace is not able to generate for all the records.In ST05 I am selecting the option more than 5000 records for display.

Regards,

Karthik.k

[Former Member]

Some times it happens ,so try to trace again and this will show all the tables now.

Thanks

Seshu

[daniel_carvalho]

Hi Karthik,

I could get a customized report from mySAP ECC 6.0 version and, by using ST05 transaction, it could trace the RBKP select statement.

Question: what is the selection condition you are using to get the desired records?

Daniel.

[Former Member]

Ok,But What i am seeing in trace is, it is happening for each and every record,It shows the document number of every record with the corresponding SQL statement and time.If our selection is huge over millions of record , is the trace is going to show all the records fetched on all the tables in the report.In my case I am not even able to see the table in summary statement also.

But in SE30 result I can see Fetch on RBKP table has taken more time as below

Gross Net

Runtime analysis 1,968,837,631 0

Program ZFAPR2950_VENDOR 1,968,835,234 46

Screen entry 1,968,539,963 70

PAI screen SAPMSSY0 1,968,539,807 23

Event LDB-Processing 1,968,539,784 23

PERFORM EXTRACT_DATA 1,968,539,729 20,378

PERFORM GET_POSTED_DATA 1,889,897,362 2,513

Fetch RBKP 1,475,942,699 1,475,942,699

Fetch BKPF 423,975,477 423,975,477

regards,

Karthik.k

[Former Member]

SQL Trace -

It works as like selection-screen ,if the selection meets the requirement to get from table then it will trace otherwise it will not trace.

Give all selection-fields and see the results.

Thanks

Seshu

[Former Member]

Hi Karthik, If the query is executed it should be displayed in SQL Trace. As per you post I assume that for the selection criteria you had mentioned the query is getting executed. However as you said its retrieving some huge data just try to retrieve more no. of records ( i.e. more than 5000 which is by default).

let me know if that works out.

Regards,

Swaroop

[Former Member]

RBKP is among the initial tables in the report. I can see it accessing RBKP thrugh SM50.With out RBKP table the report will not show output at all but I am also getting proper output.

[Former Member]

Hi swaroop,

You are exactly correct . I am using dispay 5000 records(ST05) and I am not able to see the records where the table RBKP is accessed(all I can see is BSIK table alone). I again tried to execute with more than 5000 records but still I am able to see only records of two tables(BSIK and VBSEGK) this time. I couldn't able to see other tables.

All I want to know is this the limitation of ST05 if the records are more it is not able to display all those.So How will i get the complete trace of my report.Even in summary display the tables doesn't turns up.But I can see RBKP is used at the same time in SE30.

Regards,

Karthik.k

[Former Member]

I don't think it would be useful to see a report that show millions of accesses to the same table. Why don't you just limit the selection to a few records and run that through the trace?

Rob

[Former Member]

Hi Karthik, As far as i know that when ever u switch the trace on it would record all the data queries I am not very sure why this is happening.

Any ways just try executing in this way..

1. put a break point at u r RBKP select query.

2. Execute u r report with out a trace ( Dont turn on ST05).

3. At the break point turn on the trace (ST05, Activate Trace)

4.immediatly turn it off after the select query

5.and then display trace....Ideally speaking this time u r trace should only contain RBKP queries...

Let me know if u need some more clarifications...

Regards,

Swaroop

[Former Member]

Karthik,

if trace is not working for that table ,then use get run time command within program in case you have access.

data: a type i,

b type i,

c type i.

get runtime field a.

ur select query RBKP

get run time field b.

c = b - a.

Thanks

Seshu