How to Generate Select SQL From Hana Modeling in SAP Business One?

If you created some custom Analytical/Calculation View using HANA Modeling, you can now generate Select SQL from it, with effortless step by step below :

1. Open HANA Studio, expand “Content” Tab
2. Select Calculation View that you want to generate “Select SQL” statement, right click on it
3. Click on “Generate Select SQL” option.

 

Then, a new SQL Console window will be opened with generated Select SQL automatically.

Also read:

• Custom Field (UDF) As Selection Criteria in Pick & Pack Manager
• How to Create HANA Database User
• Create Approval Based on Credit Limit Condition
• Review Multiple User Authorizations