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]

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