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

[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