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

[former_member588495]

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

[former_member588495]

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

[abo]

Move the whole case/endcase blocks right before append.

[ekekakos]

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

[ekekakos]

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.

[former_member588495]

Hi Elias,

Yes, I have put dots as the above script.

Thanks

Roger