topic Syntax Error.. in Application Development and Automation Discussions

Syntax Error..

Former Member — Tue, 19 Dec 2006 05:59:30 GMT

Hi Friends, Good morning to Everyone...

Actually am BW Consultant... I dont even Knew alphabets in ABAP..

Am having an syntax error like this

Error : Comma without preceding colon (after SELECT ?).

Re: Syntax Error..

Former Member — Tue, 19 Dec 2006 06:01:19 GMT

Hi,

just before this error statement,there is a yellow button click on that it will be corrected.

regards,

pankaj singh

Re: Syntax Error..

Former Member — Tue, 19 Dec 2006 06:01:48 GMT

Can you send me the code so that i can able to say......

Re: Syntax Error..

Former Member — Tue, 19 Dec 2006 06:02:08 GMT

when use Into , this kind of errors u will get .

check this sample sytax.

DATA:  carrid   TYPE scarr-carrid, 
       carrname TYPE scarr-carrname. 
       CARRNAME LIKE SCARR-CARRNAME, 
SELECT carrid carrname 
       INTO (carrid, carrname) -->No SPACE
       FROM scarr. 
  WRITE: / carrid, carrname. 
ENDSELECT.

Re: Syntax Error..

Former Member — Tue, 19 Dec 2006 06:03:34 GMT

U can find yellow button with tool tip text 'Correct Errors', if u press that, ur error will get rectified.

Re: Syntax Error..

Former Member — Tue, 19 Dec 2006 06:03:43 GMT

pls send the select query

regards

shiba dutta

Re: Syntax Error..

former_member404244 — Tue, 19 Dec 2006 06:04:40 GMT

Hi Aluri,

what might have happened is that there is some problem in select query...

may be while passing values to the variables.Please check the code....is it like this

select matnr werks from marc into ( v_matnr, v_werks )

endselect.

so just give some space in the variables as above and check....

regards,

nagaraj

Re: Syntax Error..

Former Member — Tue, 19 Dec 2006 06:05:53 GMT

tables: pa0001.

data begin of itab occurs 0.

include structure pa0001.

data end of itab.

Start-of-selection.

select * from pa0001 into table itab.

This is the sample program to use the Select statement..if u want more precise answer then give me ur code and wht u want to do..

reward points

Re: Syntax Error..

Former Member — Tue, 19 Dec 2006 06:06:00 GMT

hi use like this

DATA: carrid TYPE scarr-carrid,

carrname TYPE scarr-carrname.

* CARRNAME LIKE SCARR-CARRNAME,

SELECT carrid carrname

INTO (carrid, carrname) "No SPACE

FROM scarr.

WRITE: / carrid, carrname.

ENDSELECT.

uncommend * the (CARRNAME LIKE SCARR-CARRNAME).

regards

Usman

Message was edited by:

Usman Sheriff

Re: Syntax Error..

Former Member — Tue, 19 Dec 2006 06:07:53 GMT

u would have used query like this

select field1 field2 from table into (itab1,itab2)

this error may be due to no space between the open bracket or space in the open bracket .

check tht.

if not copy the code & send it.

Re: Syntax Error..

Former Member — Tue, 19 Dec 2006 06:12:10 GMT

Hi. Thx for Replying!!!

In Our Bw.. We will write routines.. We will have predefine Program which will by

Default like this...

DEFAULT PROGRAM:-

PROGRAM UPDATE_ROUTINE.

$$ begin of global - insert your declaration only below this line -

TABLES: /BIC/MZ2CNEWMAT.

DATA: DIV(2),CUS(10),DIVCUS(12).

$$ end of global - insert your declaration only before this line -

FORM compute_key_field

TABLES MONITOR STRUCTURE RSMONITOR "user defined monitoring

USING COMM_STRUCTURE LIKE /BIC/CS8Z2SDOPI

RECORD_NO LIKE SY-TABIX

RECORD_ALL LIKE SY-TABIX

SOURCE_SYSTEM LIKE RSUPDSIMULH-LOGSYS

CHANGING RESULT LIKE /BIC/VZ2SDBPRIMT-BILL_DATE

RETURNCODE LIKE SY-SUBRC

ABORT LIKE SY-SUBRC. "set ABORT <> 0 to cancel update

$$ begin of routine - insert your code only below this line -

fill the internal table "MONITOR", to make monitor entries

result value of the routine

RESULT = .

if the returncode is not equal zero, the result will not be updated

RETURNCODE = 0.

if abort is not equal zero, the update process will be canceled

ABORT = 0.

$$ end of routine - insert your code only before this line -

ENDFORM.

So, I have written Code like this.... in ROutine...

WRITEN PROGRAM:

PROGRAM UPDATE_ROUTINE.

$$ begin of global - insert your declaration only below this line -

TABLES: /BIC/MZ2CNEWMAT.

DATA: DIV(2),CUS(10),DIVCUS(12).

$$ end of global - insert your declaration only before this line -

FORM compute_key_field

TABLES MONITOR STRUCTURE RSMONITOR "user defined monitoring

USING COMM_STRUCTURE LIKE /BIC/CS8Z2SDOPI

RECORD_NO LIKE SY-TABIX

RECORD_ALL LIKE SY-TABIX

SOURCE_SYSTEM LIKE RSUPDSIMULH-LOGSYS

CHANGING RESULT LIKE /BIC/VZ2SDBPRIMT-/BIC/Z2CDIVCUS

RETURNCODE LIKE SY-SUBRC

ABORT LIKE SY-SUBRC. "set ABORT <> 0 to cancel update

$$ begin of routine - insert your code only below this line -

fill the internal table "MONITOR", to make monitor entries

SELECT SINGLE O~DIVISION N~SID_0CUSTOMER FROM /BIC/MZ2CNEWMAT AS O INNER JOIN /BIC/DZ2SDBPRIM3 AS N

ON O~/BIC/Z2CNEWMAT = N~SID_Z2CNEWMAT

INTO ( DIV, CUS ).

CONCATENATE TEMP CUS INTO DIVCUS.

result value of the routine

RESULT = DIVCUS.* if the returncode is not equal zero, the result will not be updated

RETURNCODE = 0.

if abort is not equal zero, the update process will be canceled

ABORT = 0.

$$ end of routine - insert your code only before this line -

ENDFORM.

KIndly help me.. Answering getz appreciated.. Itz Urgent..

Cheerz,

ALURI

Re: Syntax Error..

former_member404244 — Tue, 19 Dec 2006 06:15:45 GMT

Hi,

the problem is in select query don't give space..

SELECT SINGLE O_{DIVISION N}SID_0CUSTOMER FROM /BIC/MZ2CNEWMAT AS O INNER JOIN /BIC/DZ2SDBPRIM3 AS N

ON O_{/BIC/Z2CNEWMAT = N}SID_Z2CNEWMAT

INTO ( DIV, CUS ).WRITE LIKE THIS (DIV, CUS).

REGARDS,

NAGARAJ

Re: Syntax Error..

Former Member — Tue, 19 Dec 2006 06:16:10 GMT

try to remove the space

SELECT SINGLE O_{DIVISION N}SID_0CUSTOMER FROM /BIC/MZ2CNEWMAT AS O INNER JOIN /BIC/DZ2SDBPRIM3 AS N

ON O_{/BIC/Z2CNEWMAT = N}SID_Z2CNEWMAT

INTO (DIV, CUS).

regards

shiba dutta

Message was edited by:

SHIBA DUTTA

Re: Syntax Error..

Former Member — Tue, 19 Dec 2006 06:18:10 GMT

Hi Alluri,

SELECT SINGLE O_{DIVISION N}SID_0CUSTOMER FROM /BIC/MZ2CNEWMAT AS O INNER JOIN /BIC/DZ2SDBPRIM3 AS N

ON O_{/BIC/Z2CNEWMAT = N}SID_Z2CNEWMAT

INTO ( DIV, CUS ).

Take out the space after into statement. INTO (DIV,CUS)

Reward Points if it is helpful.

Regards,

Kiran I

Re: Syntax Error..

Former Member — Tue, 19 Dec 2006 06:18:30 GMT

SELECT SINGLE O_{DIVISION N}SID_0CUSTOMER INTO (DIV, CUS)FROM /BIC/MZ2CNEWMAT AS O INNER JOIN /BIC/DZ2SDBPRIM3 AS N

ON O_{/BIC/Z2CNEWMAT = N}SID_Z2CNEWMAT.