"How to use index-based cell access to manipulate table data."

"What do I need before I start?"

" This tutorial is designed for SAP HANA Cloud. Tutorials: Debugging Stored Procedures "

Use Index-Based Cell Access

Overview

You will learn

✔How to use index-based cell access to manipulate table data.

R Rich Heilman August 21, 2026

Created on February 11, 2021

Contributors

More from Rich Heilman

TUTORIAL Anonymous Blocks ⏱ 15 min. TUTORIAL Create Scalar User Defined Functions ⏱ 15 min. TUTORIAL Create SQLScript User Defined Libraries ⏱ 15 min. TUTORIAL Creating Table User Defined Functions ⏱ 15 min.

See all 20 tutorials by Rich Heilman →

Prerequisites

This tutorial is designed for SAP HANA Cloud.
Tutorials: Debugging Stored Procedures

Steps

Intro

Using index-based cell access to manipulate table data is faster than using cursors or arrays.

Step 1 Create a new procedure

—

Use what you have learned and create a new procedure called build_products in the procedure folder.
procedure editor

Use what you have learned about procedure parameters, and define an output parameters as show here.

SQLScript
out ex_products table (PRODUCTID nvarchar(10),
                       CATEGORY nvarchar(40),
                       PRICE decimal(15,2))

Step 2 Insert procedure code

Between the BEGIN and END statements, using index based cell access, insert rows into an intermediate table variable using the following code.

SQLScript

 declare lt_products table like :ex_products;

 lt_products = select PRODUCTID, CATEGORY, PRICE from "OPENSAP_MD_PRODUCTS";

 lt_products.productid[1] = 'ProductA';
 lt_products.category[1] = 'Software';
 lt_products.price[1] = '1999.99';

 lt_products.productid[2] = 'ProductB';
 lt_products.category[2] = 'Software';
 lt_products.price[2] = '2999.99';

 lt_products.productid[3] = 'ProductC';
 lt_products.category[3] = 'Software';
 lt_products.price[3] = '3999.99';

 ex_products = select * from :lt_products;

The completed code should look like the following.

SQLScript
  PROCEDURE "build_products" (
      	    out ex_products table (PRODUCTID nvarchar(10),
                               CATEGORY nvarchar(20),
                               PRICE decimal(15,2) ) )
    LANGUAGE SQLSCRIPT
    SQL SECURITY INVOKER
    READS SQL DATA AS
  BEGIN

    declare lt_products table like :ex_products;

    lt_products = select PRODUCTID, CATEGORY, PRICE from "OPENSAP_MD_PRODUCTS";

    lt_products.productid[1] = 'ProductA';
    lt_products.category[1] = 'Software';
    lt_products.price[1] = '1999.99';

    lt_products.productid[2] = 'ProductB';
    lt_products.category[2] = 'Software';
    lt_products.price[2] = '2999.99';

    lt_products.productid[3] = 'ProductC';
    lt_products.category[3] = 'Software';
    lt_products.price[3] = '3999.99';

    ex_products = select * from :lt_products;

  END

Step 3 Save, deploy and check results

Resources

Next Steps

TUTORIAL Use Table Variable Operators ⏱ 10 min. +

Discussion

Share feedback on this tutorial or join the conversation in SAP Community.

Submit detailed feedback

Discuss in Community

Use Index-Based Cell Access

Overview

You will learn

More from Rich Heilman

Prerequisites

Prerequisites

Steps

Intro

Resources

Next Steps

Related Tutorials

Discussion

Joule

AI Notice