Use AMDP Function in SELECT column possible

[former_member436579]

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.

[former_member436579]

Hi,

actually we find not a workaround for creating a scalar function in HANA itself and transport it there. But the core functionallity is availlable but everybody have to take core of the special HANA function out of the ABAP managed world.

Thanks a lot,

Nils