SQL query does not return data

Question

I am developing a SAP program to obtain information about a reference from the material table (MARA).

First I take certain references and then using a loop I need to make other query for every iteration:

SELECT
  MARA~BISMT
FROM mara
WHERE mara~matnr = @ref
INTO @var.

I know that the problem is that the types conflict (mara~matnr is characters and ref is string), how can I convert both to the same type and see the results?

I think that you're talking about external (`ref`) and internal values (`mara~matnr`), you go from one value to the other via [conversion routines](https://help.sap.com/doc/abapdocu_753_index_htm/7.53/en-US/index.htm?file=abenconversion_exits.htm), either with function module `RS_CONV_EX_2_IN` or with statement `WRITE` (internal to external). — Sandra Rossi, May 01 '20 at 19:03

score 4 · Answer 1 · answered May 01 '20 at 15:44

4

You can also use ABAP string templates instead of conversion exits suggested by mkysoft:

DATA: ref TYPE string VALUE '2'.

ref = |{ CONV matnr( ref ) ALPHA = in  }|.

SELECT SINGLE bismt
  FROM mara
 WHERE matnr = @ref
  INTO @DATA(var).

answered May 01 '20 at 15:44

Suncatcher

10,355
10
52
90

score 0 · Accepted Answer · answered May 01 '20 at 13:40

You can use field symbol for dynamic type and CONVERSION_EXIT_ALPHA_INPUT function module for formatting value for db.

TABLES: mara.

DATA: ref TYPE string,
      var TYPE string.

FIELD-SYMBOLS: <fs_ref> TYPE any.

ref = '11'.

ASSIGN ('mara-matnr') TO <fs_ref>.
CHECK sy-subrc IS INITIAL.

<fs_ref> = ref.

CALL FUNCTION 'CONVERSION_EXIT_ALPHA_INPUT'
  EXPORTING
    input   = <fs_ref>
 IMPORTING
   output   = <fs_ref>.


SELECT SINGLE mara~bismt
  FROM mara
  INTO @var
 WHERE mara~matnr = @<fs_ref>.

TABLES statement is obsolete and throws syntax error inside classes, it shouldn't be used — Suncatcher, May 01 '20 at 16:12

SQL query does not return data

2 Answers2

Linked