ABAP CDS Hierarchy Definition - Not able to Preview

[muthuhana]

Hello Team,

I was unable to preview the data for the Hierarchy Definition CDS view. It says there was some authorization checks failure. I want to apply Hierarchy aggregate functions on this CDS view but it fails to return the data.

Please note that this issue is occurring in both trail and productive versions. Please let me know how to resolve this error.

Edit: When I took Authorization traces, it clearly says Authorization S_TABU_NAM Read & Write is getting failed. But How do I resolve this authorization issue ?

Thanks a lot.

Best Regards,

Muthu

[WRoeckelein]

Data Preview for Hierarchy works for me in S/4HANA 2023 FPS01. Perhaps some auth issue in the underlying view?

[muthuhana]

Actually I am using BTP ABAP Environment, I was unable to get the data by consuming it in the Open SQL

[muthuhana]

Yes authorization issue are there for S_TABU_NAM but not sure how to resolve in the BTP ABAP Envrionment

[WRoeckelein]

I tried also in my ABAP environment. I did not get an authorization error, but I have currently no values in the table

[MKreitlein]

I'm sorry, I'm no BTP expert... but I would assume the solution is similar to an ABAP system.

In PFCG you need to create or enhance a role with which you can read the table.

I guess as of now, you cannot read it in SE16, either, right?

[muthuhana]

No I cannot use any GUI based screens. But just wanted to understand why does it requires authorization it is just as cds view like other cds view definition. I am wondering, why this view has special kind of authorization

[muthuhana]

Please ignore this answer

[MKreitlein]

Hello @muthuhana 

Have you checked SU53 directly after executing the preview?

Might be there is another CDS view in the underlying views, from which yours is selecting data?

BR, Martin

[muthuhana]

Hello Martin, I am facing authorization issue on the object S_TABU_NAM for READ & WRITE. Lower CDS view don't have DCL