Tips
How to write SAP HANA Dynamic SQL Query Examples
How to write SAP HANA Dynamic SQL Query Examples Examples: CREATE PROCEDURE DYNAMIC_QUERY1(IN TABLE_NAME VARCHAR(20)) AS BEGIN DECLARE QUERY VARCHAR(200); QUERY:='SELECT * FROM ' || :TABLE_N…
Tips
SAP HANA IF Statement Using AND and OR Example
SAP HANA IF Statement Using AND and OR example TEMP_TABLE DATA ----------------------- ID NAME AGE --- --------- --- 1 PETER 23 2 DANIEL 45 3 ROSEMARY 22 4 …
Tips
SAP HANA Insert or Update Data Based on condition SQL Queries Example
SAP HANA Insert or Update Data Based on condition SQL Queries Example Here is a way to decide whether to insert or update data on the condition of a variable content. Example CREATE PROCEDURE…
SQL Query and Other
Exporting query results to a CSV or Microsoft Excel spreadsheet file
Exporting query results to a CSV or Microsoft Excel spreadsheet file : Procedure 1. Type your query in the SQL Statements pane of Interactive SQL. 2. At the end of the query, choose on…
Tips
SAP HANA SQL Query to display all month names from current year until date
following is the SAP HANA SQL Query to display all month names from current year until date: do begin declare i int := 0; tMo = select '' mo from dummy; while i < 12 do tMo = sel…
Tips
List of Keyboard shortcuts in SAP HANA
There are some keyboard shortcuts to improve productivity with this tool. What I found: F8 :execute Query F9 :execute Query where Cursor is (Query means SQL Statements separated by semicolon ) Ctr…
SAP HANA
Reserved Keyword In SAP HANA Database
In this article ii will show you how to get a list of reserved words in SAP HANA database. I will show you how , you need to make a query for the “RESERVED_KEYWORD” system view. The query like SELE…
Tips
How to comments SQL Statements and Identifiers Concept in SAP HANA
COMMENT If you want to add comment in your HANA SQL statement to improve the readability and maintainability, so comments are delimited in SQL statements as follows: Double hyphens "--". …
SAP HANA
SAP Business One Transaction Notification in SAP HANA Database Various cases Query Examples
Following are the query example for SAP Business One Transaction Notification in SAP HANA Database, hope it will help you. ------BLOCK RETURN WITH GREATER THAN ZERO COST ----------- ---------…
SAP HANA
SAP Hana Connection String for Application Connection Example Syntax
Following are the HANA Connection String used for Making connection with Hana Catalog(Database) HANA CONNECTION STRING for 32Bit System for Install Driver B1CRHPROXY32 DRIVER={B1CRHPROXY32};UID…
![ABAP New Syntax Explained: 20 Game-Changing Features Every Developer Must Know [2025 Guide]](https://blogger.googleusercontent.com/img/b/R29vZ2xl/AVvXsEhXnFcBTH0agv8KIVAfRIaEnsMGGbKCIQ81UKWAm2u5l_qOQJg_LphMPk4uN3X4Nf1fj86MuElU6SD0OZVkdPlXhQF5FtYEv0LTdRgTSYHxwvVyY6wYpnbbc8bMmxt1mkrPcUb9P89eeARCnCoFSEn6rXTJ-GM9nQt_RoypoforLedduTwrDlsrSTqdOxc/w100/ChatGPT%20Image%20Jul%2013,%202025,%2010_18_02%20PM.png)
Social Plugin