topic Re: SQLScript error in AMDP in Application Development and Automation Discussions

SQLScript error in AMDP

Former Member — Sun, 05 Apr 2015 16:06:18 GMT

Hello,

please guide me with below error,

METHOD TEST_CEFUNC BY DATABASE PROCEDURE

FOR HDB

LANGUAGE SQLSCRIPT

options READ-ONLY

USING VBAK VBAP.

LT_VBAK = CE_COLUMN_TABLE("VBAK");

LT_VBAP = CE_COLUMN_TABLE("VBAP");

ET__DATA = CE_JOIN (:LT_VBAK,:LT_VBAP,["VBELN"],["VBELN","AUGRU","NETWR","BSTNK","KUNNR","POSNR","MATNR","KWMENG"]);

ENDMETHOD.

SQLSCRIPT message: Parameter must be a valid column table name: ZCL_TEST_1=>VBAK#covw

Why am i getting above SQLScript error? I am using HANA database system and VBAK/VBAP are column based tables.

Re: SQLScript error in AMDP

pfefferf — Mon, 06 Apr 2015 17:47:46 GMT

Hi,

as far as I know CE_COLUMN_TABLE is not supported in AMDPs. Replace the CE_COLUMN_TABLE functions by a Select statement (e.g. LT_VBAK = SELECT * FROM VBAK).

By the way. Think about the further usage of CE functions, cause they will not be enhanced/improved anymore so far ().

Best Regards,

Florian

Re: SQLScript error in AMDP

Former Member — Mon, 06 Apr 2015 21:00:09 GMT

Hi Florian,

The work around worked but i think its not much of a use now that i have to fetch all the data.

Thanks for bringing to my attention the blog on CE Functions...i was under the impression they are preferred over SQL and as AMDP eventually creates a DB procedure in the backend i thought of exploring if we can directly use CE Functions....looks like SQL itself is optimized.

Re: SQLScript error in AMDP

pfefferf — Tue, 07 Apr 2015 04:20:29 GMT

Hi,

what hinders you to implement a restriction to the selection regarding your needs? Or to replace the CE_JOIN by a Select statement with join to get the same result?

Best regards,

Florian