Simple SELECT statement

[Former Member]

Hi. Could You explain to me where does an error come from?

DATA: 
  BEGIN OF itab OCCURS 0,
    bldat LIKE zrfakh-bldat,
    cpudt LIKE zrfakh-cpudt,
  END OF itab.
    
  SELECT zrfakh~bldat zrfakh~cpudt
  INTO   (itab-bldat itab-cpudt)
  FROM   zrfakh.

<i>ERROR: The list "(ITAB-BLDAT" after "INTO" is not of the form (f1, ...,fn), or contains an undefined field. excludes specification of a field list.</i>

When I make it like that:

  SELECT zrfakh~bldat zrfakh~cpudt
  INTO CORRESPONDING FIELDS OF itab
  FROM   zrfakh.
    APPEND itab.        
  ENDSELECT.

an error disappears.

Greetings. P.

[Former Member]

Hi,

When you give multiple fields...you should separate them with comma

SELECT zrfakh~bldat zrfakh~cpudt
  INTO   (itab-bldat,itab-cpudt)
  FROM   zrfakh.

Thanks

Naren

[Peter_Inotai]

Hi,

The comma is missing there:

INTO (itab-bldat itab-cpudt)

this should be

INTO (itab-bldat, itab-cpudt)

best regards,

Peter

[Former Member]

Hi,

DATA: 
  BEGIN OF itab OCCURS 0,
    bldat LIKE zrfakh-bldat,
    cpudt LIKE zrfakh-cpudt,
  END OF itab.
    
  SELECT zrfakh~bldat zrfakh~cpudt
  INTO   ( itab-bldat,itab-cpudt )  " --> Space after the ( and before the )
  FROM   zrfakh.

Regards

Sudheer

[Former Member]

DATA:

BEGIN OF itab OCCURS 0,

bldat LIKE zrfakh-bldat,

cpudt LIKE zrfakh-cpudt,

END OF itab.

SELECT zrfakh_{bldat zrfakh}cpudt

INTO (itab-bldat itab-cpudt)

FROM zrfakh

endselect.

[Former Member]

Hi

Just put a comma between the fields itab-bldat itab-cpudt

SELECT zrfakh_{bldat zrfakh}cpudt

INTO (itab-bldat, itab-cpudt)

FROM zrfakh.

Reward points for useful Answers

Regards

Anji