hdbtablefunction - codbex/codbex-kronos GitHub Wiki
SQL Functions (.hdbtablefunction )
This object type represents a database function.
Reference
The information on how to develop the design-time data-persistence table function model for a Kronos application.
SAP Help
Example Artifact Code
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;
Sample
https://github.com/codbex/codbex-kronos/tree/main/samples/hdb-tablefunction-simple
Modules
- Data Structure Parser
- Processor
Unit Tests
https://github.com/codbex/codbex-kronos/tree/main/modules/engines/engine-hdb/src/test/java/com/codbex/kronos/hdb/ds/parser/hdbtablefunction https://github.com/codbex/codbex-kronos/tree/main/modules/engines/engine-hdb/src/test/java/com/codbex/kronos/hdb/ds/processors/function