Skip to Content
0
Former Member
Jul 12, 2016 at 09:44 AM

CDS view with SQL Privileges

198 Views

Hi all,

Since SP11 it should be possible to add CDS view to SQL Privileges. I am not able add CDS objects or add the view below (V_VBAP) to SQL Privilege.

@WithStructuredPrivilegeCheck: true

view V_VBAP as select from VBAP_SYN

{

"MANDT", "VBELN"

};

I am using the first revision of SP11. I have attached the presentation given by SAP which shows how it works. Did I miss something?

Second issue: I have created structured privileges by using SQL statement for this V_VBAP view, but this privilege is not available as an object in a package. Therefor it can not be moved to other environments. See statement below. Any idea how to add this structured privilege to a package.

CREATE STRUCTURED PRIVILEGE AP_VIEW_SQL FOR SELECT ON "DD.V_VBAP" WHERE "MANDT" = '100';

I would gladly receive a solution for this.


Thanks

Attachments