topic Re: Simple SELECT statement in Application Development and Automation Discussions

Simple SELECT statement

Former Member — Fri, 15 Jun 2007 07:13:11 GMT

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.

Re: Simple SELECT statement

Former Member — Fri, 15 Jun 2007 07:16:51 GMT

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

Re: Simple SELECT statement

Peter_Inotai — Fri, 15 Jun 2007 07:17:12 GMT

Hi,

The comma is missing there:

INTO (itab-bldat itab-cpudt)

this should be

INTO (itab-bldat, itab-cpudt)

best regards,

Peter

Re: Simple SELECT statement

Former Member — Fri, 15 Jun 2007 07:18:08 GMT

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

Re: Simple SELECT statement

Former Member — Fri, 15 Jun 2007 07:18:16 GMT

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.

Re: Simple SELECT statement

Former Member — Fri, 15 Jun 2007 07:18:18 GMT

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