HDBTableFunction

Overview

---

The information on this page will help you learn how to develop the design-time data-persistence model for an XSK application using the HDBTableFunction syntax.

Reference

---

SAP Help Portal

For more information, see Create a Table User-Defined Function

Sample

---

FUNCTION "MYSCHEMA"."hdb_view::OrderTableFunction" ()
    RETURNS TABLE (
        "Id" NVARCHAR(32),
        "CustomerName" NVARCHAR(500)
    )
    LANGUAGE SQLSCRIPT
    SQL SECURITY INVOKER AS
BEGIN

RETURN  SELECT "Id", "CustomerName" FROM "hdb_view::Item";

END;

Caution

Reserved keywords, used as table or column names, must be escaped.