Select single *

[ramco1917]

Hi

I have below function . Instead of * i want to display only Matnr , MTART , MEINS fields . Can it be done with Select Single syntax.

SELECT SINGLE * FROM MARA
INTO EX_MARA
WHERE MATNR = IM_MATNR.

Thanks

[MateuszAdamus]

Hello ramco_1917

Yes. Provide field names instead of the start. Define the structure with the fields and do the following.

SELECT SINGLE matnr, mtart, meins FROM MARA INTO EX_MARA WHERE MATNR = IM_MATNR.

Or

SELECT SINGLE matnr, mtart, meins FROM MARA INTO CORRESPONDING FIELDS OF EX_MARA WHERE MATNR = IM_MATNR.

Kind regards,

Mateusz

[Sandra_Rossi]

If a comma is used between column names, the valid syntax must use @:

SELECT SINGLE matnr, mtart, meins FROM MARA INTO @EX_MARA WHERE MATNR = @IM_MATNR.

Or

SELECT SINGLE matnr, mtart, meins FROM MARA INTO CORRESPONDING FIELDS OF @EX_MARA WHERE MATNR = @IM_MATNR.

[stefan-de-vriendt]

Hi, R S,

Using the new syntax you can do the following

SELECT SINGLE FROM MARA

FIELDS matnr, mtart, meins

INTO EX_MARA

WHERE matnr = @IM_MATNR

[stefan-de-vriendt]

If you want to declare EX_MARA inline:

into @DATA(EX_MARA)

Please note that you can have a list of available fields when pressing ctrl-space after the keyword FIELDS

[Sandra_Rossi]

Please edit your question, select your code and press the "CODE" button to make it correctly colorized/indented, so that it's easier for us to analyze it. Thank you.