Using View Tables in SQ01 and SQ02, getting 'Not Authorized to Read Table'

[Former Member]

We are trying to use a SAP Standard View Table (CAUFV) in an SQ01 and SQ02 transaction. Even though there is no Authorization Group assigned to the View we still get "You have no authorization to read table caufv' when running the linked transaction. We tried assigning the CA and KA authorization groups to the role and got the same results. (The tables used to create the View are AFKO and AUKF and thier Authorization groups are CA and KA.) We tried other views and received the same results. Does anyone have any experience with this?

[rwarri1]

Hi,

Immediately after you get the error, run transaction SU53. This will show you the missing authorization.

Cheers !

[Former Member]

Hi Chuck,

when you create the query, did you select the data source as a logical database? and POH as the logical database itself. If i select it as mentioned, looks like it is working fine

good luck

[Former Member]

Hello Chuck,

There are 2 ways to restrict this

1: The user should be a part of at least one user group to run the corresponding ABAP query. This automatically restricts the access of the user to specific functional areas, and thus the corresponding underlying logical databases.

2: The authorization object S_QUERY should be used to give proper authorizations to the user for a query. This authorization object has a field named ACTVT, which can take values 02 for Change, 23 for Maintain and 67 for Translate.

This value determines whether the user can create and modify the query. The possible authorizations in the object are as follows:

S_QUERY_ALL Change, maintain and translate query

S_QUERY_UPD Change and Translate