SQL TRACE Problem with view

[Former Member]

Hi ,

I am working in SAP 4.0 environment.While running SQL trace for one of the FI SAP Standard report,I see that in the SQl trace whenever a Transparent table is fetched eg ANLB or ANEK, I find an SQL query , but when the view V_ANLaB is fetched I find no SQL statement in front of it and only FETCH V_ANLAB is listed in the trace.

This is how the trace looks:

Duration Object DB op. RJu RC SQL statement

17 V_ANLAB FETCH 1 0

43.692 ANLH OPEN 1 0 SELECT WHERE "MANDT" = '590' AND "BUKRS" = '2350' AND "ANLN1" IN ( '000001097275' , '000001097276' , '000001097277' , '000001097278' , '000001097279' , '000001097280' , '000001097281' , '000001097282' , '...

My question is whether select query are seen in the SQL trace for view or not?

Thanks & Regards

Jyotsna

[Former Member]

Hi Jyotsna

I tried SQL trace on my system, i discovered that there is no SQL query for 'Fetch' for Tables as well as Views.

But i get select queries for 'prepare' and 'open' in both the cases i.e. for both tables as well as views.

So, there is no difference in my case. I'm on WAS 6.2

So, as per my understanding, select queries are seen in the SQL trace for views also.

Regards

Ashish Jain