How do one can access/query SAP S/4HANA table data through E.g. select * from kn01 where client=100
:
- SAP HANA STUDIO
- OBDC driver
- Oracle SQL developer
Secondly I have a system access through HANA studio , but I can't see any application tables over there. It seems I'm just querying data from metadata database. What exactly info I need to get connected to SAP application data like purchase orders, GL data, sales orders , invoices, customer, etc.
regards Anwer
SAP HANA STUDIO -> Open Sql console