topic Re: Parameter cannot be converted to anumber in Application Development and Automation Discussions

Parameter cannot be converted to anumber

8it8 — Tue, 28 Nov 2023 14:26:33 GMT

Hey,

I've created in include SEL this sum parameter:

PARAMETERS: p_sum type i.

In the CLI include I WROTE THIS select:

CLASS lcl_main_sfp IMPLEMENTATION.

  METHOD select_data.

    SELECT mara~matnr, mara~mtart, makt~maktx, mara~ersda
      UP TO p_sum ROWS
      FROM mara
      INNER JOIN makt
      ON makt~matnr = mara~matnr
    INTO CORRESPONDING FIELDS OF TABLE @mt_table.

  ENDMETHOD.

and I get the following error:

What can be the problem? is't this from the same type?

Re: Parameter cannot be converted to anumber

Eduardo-CE — Tue, 28 Nov 2023 16:28:29 GMT

Hi,

Try like this:

  SELECT
    *
    UP TO @p_num ROWS
    INTO TABLE @DATA(it_tmp)
    FROM mara INNER JOIN makt
    on mara~matnr = makt~matnr.

Re: Parameter cannot be converted to anumber

RaymondGiuseppi — Tue, 28 Nov 2023 16:54:57 GMT

You activated the strict mode for ABAP SQL statement as soon as you used the @ in the resulting internal table. So use also @p_sum for the host variable.

Re: Parameter cannot be converted to anumber

thilakan_t — Tue, 28 Nov 2023 17:08:32 GMT

It works in S/4HANA 1909(ABAP Platform 1909). what is the version of your system?

Re: Parameter cannot be converted to anumber

8it8 — Wed, 29 Nov 2023 06:59:51 GMT

so how to deal with this?

Re: Parameter cannot be converted to anumber

8it8 — Wed, 29 Nov 2023 07:58:41 GMT

Thanks.

I really had to get rid of the @ from the table and actually there was another issue (very simple...)

the SEL INCLUDE was below the the CLI include.....

Re: Parameter cannot be converted to anumber

Sandra_Rossi — Wed, 29 Nov 2023 08:22:29 GMT

8it8

To answer your quote "how to deal with this", did you realize what Raymond and Eduardo have said before you ask? (@p_sum instead of p_sum)

Re: Parameter cannot be converted to anumber

Dominik_Tylczynski — Wed, 29 Nov 2023 08:22:59 GMT

Hello 8it8

Your SELECT statement would be syntactically correct if:

P_NUM is indeed of I type,
P_NUM is escaped with @ as you have already escaped MT_TABLE with @ thus using the new Open SQL syntax.

You have declared P_NUM as a parameter with I type, still you get the error about P_NUM not being a number. That is strange and I suspect that you have also defined P_NUM as a parameter of the SELECT_DATA method.

Would you be able to share the declaration of the method?

Best regards

Dominik Tylczynski