sap-hana-sqlscript

name	sap-hana-sqlscript
description	SAP HANA SQLScript — stored procedures, table functions, AMDP, calculation views, declarative vs imperative logic, CE functions, performance profiling, HDI containers. Use when writing HANA SQLScript, creating AMDP classes, or optimizing database logic.
trigger	{"keywords":["SQLScript","AMDP","hdbprocedure","hdbtablefunction","calculation view","HANA stored procedure","HANA table function","CE function","plan visualizer"],"intent":"Write and optimize SAP HANA SQLScript procedures, table functions, AMDP classes, and calculation views.","file_patterns":["*.hdbprocedure","*.hdbtablefunction","*.hdbview","*amdp*"]}

SAP HANA SQLScript

Prerequisites

• SAP HANA 2.0 SPS05+ (or HANA Cloud) with SQLScript enabled
• HANA Database Explorer or HANA Studio for debugging/profiling
• HDI container access (for CAP/HDI deployments) or direct schema access
• ABAP 7.4 SP05+ on HANA for AMDP (requires IF_AMDP_MARKER_HDB interface)
• ADT (ABAP Development Tools) for AMDP class editing

Stored Procedure

• Host variables use colon prefix (:iv_matnr) inside SQL statements
• SELECT assigns to variables via expression (lv_count = SELECT COUNT(*)...) — no INTO clause
• SESSION_CONTEXT('CLIENT') retrieves session variables

CREATE PROCEDURE ZSP_MATERIAL_STOCK (
  IN  iv_plant  NVARCHAR(4),
  OUT et_result (MATNR NVARCHAR(), MAKTX NVARCHAR(), LABST (,))
)
 SQLSCRIPT
 SECURITY INVOKER


  et_result  
    m.MATNR, m.MAKTX, (s.LABST, )  LABST
   "MARA"  m
    "MARD"  s  m.MATNR  s.MATNR  s.WERKS  :iv_plant
   m.LVORM  ;
;