Skip to Content
0
Oct 18, 2019 at 03:42 PM

use values from scalar functions in HANA select

254 Views

Hi,

I need to show several constant in multiple SQL selects. These constants are derived from a table that contains one record only.

How to pick up these constants from HANA procedures or functions if scalar function doesn't allow any SQL operations.

SELECT MANDT, MATNR , Costant01, constant02

FROM "SAPSR3"."MARA"

Thanks