topic Re: Select single * in Application Development and Automation Discussions

Select single *

ramco1917 — Fri, 14 May 2021 10:39:49 GMT

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

Re: Select single *

MateuszAdamus — Fri, 14 May 2021 10:42:39 GMT

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.

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

Kind regards,

Mateusz

Re: Select single *

stefan-de-vriendt — Fri, 14 May 2021 12:31:58 GMT

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

Re: Select single *

stefan-de-vriendt — Fri, 14 May 2021 15:04:23 GMT

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

Re: Select single *

Sandra_Rossi — Fri, 14 May 2021 17:52:11 GMT

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.

Re: Select single *

Sandra_Rossi — Fri, 14 May 2021 17:56:50 GMT

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.

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