Invalid SQL Function SERIES_GENERATE_INTEGER in AMDP Procedure after Update

[lkempkens]

Hi,

we used the SQL Function SERIES_GENERATE_INTEGER in an AMDP-Procedure.

This AMDP-Procedure worked fine on a Netweaver 7.50 on HANA 2.

After upgrading to S/4 HANA 2022 Initial Shipment, the following code doesn't compile anymore:

method fill_temporary_templates
by database procedure
for hdb language sqlscript.
 lt_ext_event_binder_tmp = 
   select generated_period_start as binder
   from series_generate_integer( 1, 20, 90 );
endmethod.

Error: SERIES_GENERATE_INTEGER is unkown.

Does anybody know why this function doesn't work anymore in an AMDP-Procedure?
The HANA-DB itself executes the command without any concern:

Thanks!

Lars

[Sandra_Rossi]

Be careful with <br> code formatting errors in the SAP Community forum. This is better formatted:

method fill_temporary_templates
  by database procedure
  for hdb language sqlscript.
  
 lt_ext_event_binder_tmp = 
   select generated_period_start as binder
   from series_generate_integer( 1, 20, 90 );
endmethod.

[chaouki_akir]

Hello,

do you see it there : transaction ST04 select * from "SYS"."FUNCTIONS" ?

If no, you may ask SAP support for why the function is missing aftere the upgrade

Our system is SAP 7.56 SP 1

[lkempkens]

Thank you, Chaouki. I wasn't aware, that this table exists and in that it shows the missing schema (same as Fernando explainend in his post). That helped me to understand the missing link.