Use AMDP Function in SELECT column possible

[Former Member]

Hi,

we like to centralize some cleanup logic in an AMDP class but did not get it to work to use it directly in the select statements. Instead we developed now a HANA native scalar function with is used in the AMDP expert routines which runs fine. But for an better management I like to ask if it is possible to create a scalar function in AMDP as well which can be called in the SELECT (not like a table function in FROM <...> ).

We like to use it in the SELECT part of the procedure like SELECT REGEX_CLEAN( VBELN ) , ..... FROM ....

Regards,

Nils

[DoanManhQuynh]

I belive you talking about SQL expression which is build-in functions and as far as i know you cant defined one for yourself...also in open sql, we cant put a subquery (here is your AMDP) in select list. There are alot of new technical nowadays like AMDP,ADBC, CDS View...so you may find a workaround for your requirement.