Error in accessing cds view data using select query in Developer Extensibility in Cloud

[Shadab_Hussain67]

Hi Experts,

I am trying to access customer additional group data using sap released cds view I_CustomerSalesArea. I have written a select query to fetch the data from cds view. When I try to execute the badi via the business process its giving short dump.

Code:

SELECT SINGLE additionalcustomergroup1

FROM i_customersalesarea

WHERE customer = @item_attributes-soldtoparty

AND salesorganization = @item_attributes-salesorganization

AND distributionchannel = @item_attributes-distributionchannel

AND division = @item_attributes-division

INTO @DATA(lv_cust_group).

Also, in ADT there is a warning - Executing "Unprivileged SQL" from "CHANGE_CONDITION_AMOUNT" violates transactional contract "FUNCTIONAL".

Error in short dump - Execution takes place in a transactional context: A "CALL <functional>" call is active with "ZCL_PRCG_DOC_ITEM_CONDITION_AM". The current statement "AUTHORITY-CHECK(DCL)" is therefore forbidden.

Can someone guide in getting this resolved?

Appreciate your help !

Thanks!

[PrasanthPadmanabhan · Accepted solution]

Hi Shadab,

Could you add the keyword 'WITH PRIVILEGED ACCESS' and try this? You can find more details here

Best Regards,

Prasanth

[Shadab_Hussain67 · Accepted solution]

Thanks Prasanth, this has solved the issue. Will you mind adding the link to your comment for other members to refer.

Sincerely, Shadab

[rammel_sapdev · Accepted solution]

Hi prasanth, can you help to update the link? We are looking for an official SAP documentation regarding this.