3782982 - cannot restrict access to a specific cds query in query browser; 'restricted' option disabled for catalog SAP_BW_BC_AQB_PC– SAP S/4HANA Cloud Public Edition

• Access to the query C_SalesVolumeAnalyticsQry is required for a specific user in the Query Browser.
• A custom business role was created and assigned the business catalog SAP_BW_BC_AQB_PC.
• When attempting to maintain a restriction for C_SalesVolumeAnalyticsQry, the Restricted option is disabled for Read, Write, and Value Help.
• Confirmation is needed on whether restricting a specific CDS query within the Query Browser using role restrictions is technically possible.

SAP S/4HANA Cloud Public Edition

1. Create a custom business role (for example, ZS_QUERY_BROWSER).
2. Assign the business catalog SAP_BW_BC_AQB_PC to the role.
3. Attempt to maintain a restriction for the query C_SalesVolumeAnalyticsQry.
4. Observe that the Restricted option is disabled for Read, Write, and Value Help.

• The business catalog SAP_BW_BC_AQB_PC has no restriction type; therefore, the access category cannot be set to Restricted in the role.
• Restricting access at the level of an individual CDS query within the Query Browser using role restrictions is not supported.

1. Acknowledge that catalog SAP_BW_BC_AQB_PC does not provide a restriction type; the Restricted option is disabled by design.
2. It is not technically possible to restrict access to a specific CDS query (such as C_SalesVolumeAnalyticsQry) within the Query Browser using role restrictions. Communicate this product limitation.

query browser, C_SalesVolumeAnalyticsQry, cds query restriction, SAP_BW_BC_AQB_PC, restricted option disabled, read write value help, role restrictions, catalog without restriction type, CA-GTF-VDM-QB, analytics queries, access control, authorization, query-level restriction, s/4hana cloud, business role , KBA , CA-GTF-VDM-QB , Query Browser , Problem