on 10-30-2023 11:20 PM
I'm currently working on SAP B1 10.0 for SAP HANA (10.00.220) SP 2308 and migrating a stored procedure from MSSQL because we used to have SAP B1 9.2. The SP is running fine, I did the syntax conversions and it's OK; the problem is that I need to invoke that SP from SAP B1 and have the user input the values for the "Initial Date" and "End Date" parameters of the SP. I have tried several ways but none have worked. Examples that didn't work:
CALL YourProcedureName('[%0]', '[%1]');
CALL YourProcedureName('@Fecha_Ini', '@Fecha_Fin');
CALL YourProcedureName(:Fecha_Ini, :Fecha_Fin);
But... If I hardcode the date values for the parameters, the SP executes perfectly, e.g.,
CALL YourProcedureName('20230101', '20230131');
Can someone please tell me what should I do or what I'm doing wrong? Is there a specific structure that I should follow? I'm new to SAP HANA.
Thanks in advance.
User | Count |
---|---|
104 | |
12 | |
11 | |
6 | |
5 | |
4 | |
3 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.