topic Re: Query Error - Comma without preceding colon (after SELECT ?). in Application Development and Automation Discussions

Query Error - Comma without preceding colon (after SELECT ?).

former_member588495 — Wed, 17 Feb 2021 09:33:43 GMT

Greeting,

I just wrote down script to get data in query as below:

====================================================================
SELECT t3~salesamt t3~reamt t3~saleqty t3~reqty,

CASE t3~salesamt.
WHEN t3~vvs10 > 0 .
WRITE t3~vvq10.
WHEN t3~vvs10 < 0.
WRITE 0.
ENDCASE.
CASE t3~reamt.
WHEN t3~vvs10 < 0.
WRITE t3~vvq10.
WHEN t3~vvs10 > 0 .
WRITE 0.
ENDCASE.
CASE t3~saleqty.
WHEN t3~vvs10 > 0 .
WRITE t3~vvq10.
WHEN t3~vvs10 < 0.
WRITE 0.
ENDCASE.
CASE t3~reqty .
WHEN t3~vvs10 < 0.
WRITE t3~vvq10.
WHEN tt3~vvs10 > 0 .
WRITE 0.
ENDCASE.
from ce110tw t3
into corresponding fields of zsd_sales_rpt_emp
where t3~fadat in s_fadat.
APPEND zsd_sales_rpt_emp TO it_data.
ENDSELECT.

====================================================================

However, I got an error message: Comma without preceding colon (after SELECT ?).

Is there any ABAP experts who can teach me how to solve this error?

Thanks in advance.

Roger

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

abo — Wed, 17 Feb 2021 09:41:35 GMT

Move the whole case/endcase blocks right before append.

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

ekekakos — Wed, 17 Feb 2021 09:44:11 GMT

Hello, have you put dots(.) in your select?

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

ekekakos — Wed, 17 Feb 2021 09:46:56 GMT

check this:

SELECT vbeln, vbtyp,
 CASE
   WHEN auart = 'ZAMA' THEN @lc_name1
   WHEN auart = 'ZACR' THEN @lc_name2
  ELSE @lc_name3
END AS ernam
FROM vbak
WHERE vbeln = @ld_vbeln
 INTO CORRESPONDING FIELDS of @ls_vbak.
ENDSELECT.

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

former_member588495 — Thu, 18 Feb 2021 08:12:59 GMT

Hi Elias,

Yes, I have put dots as the above script.

Thanks

Roger