Explore the data of SAP Business ByDesign using SQL

[VVancalbergh]

Is there a way to explore the data (read-only if needed) in the SAP Business ByDesign HANA Database using SQL Statements? Maybe connect to the database using SAP HANA Studio with a limited account?

Right now I am trying to find a CustomerInvoiceRequest that actually has a ItemAccountingCodingBlockDistribution node and I have to do this using trial and error in the Repository Explorer or write an ABSL script to loop all objects.

This issue returns for every single time we want to understand how SAP ByDesign works inside.

[william_xing · Accepted solution]

Hi Vincent,

I do not think it is a possible way to use SQL Statement in SAP Cloud Applications Studio.

To do a conditional select you may able to use query function.

Thanks,

William

[VVancalbergh · Accepted solution]

It's the sad truth that this is accepted among the community. How old is SAP ByDesign? 10 years? Please, someone give us HANA SQL access and we'll write a better Data Explorer!

Thank you for your reply.