SQLScript error in AMDP

[Former Member]

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.

[pfefferf]

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

[Former Member]

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.

[pfefferf]

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