Error ORDER BY

[Former Member]

Hi, I have a problem with a select, the error is: Comma without preceding colon (after SELECT ?).

IF NOT COMM_STRUCTURE-/bic/zkilat IS INITIAL .

SELECT FECHA, KILAT, VALOR FROM ZBW_T0004

WHERE KILAT EQ COMM_STRUCTURE-/bic/zkilat

ORDER BY FECHA ASCENDING.

IF SY-SUBRC EQ 0.

RESULT = ZBW_T0004-VALOR.

ENDIF.

ENDIF.

thanks

Mike

[naimesh_patel]

Remove commas from the fields of the select query.

Like

SELECT FECHA KILAT VALOR 
FROM ZBW_T0004
WHERE KILAT EQ COMM_STRUCTURE-/bic/zkilat
ORDER BY FECHA ASCENDING.

Regards,

Naimesh Patel

[Former Member]

You will need an INTO as well.

Rob

[Former Member]

To place this

SELECT FECHA KILAT VALOR

INTO CORRESPONDING FIELDS OF COMM_STRUCTURE-/bic/zkilat

FROM ZBW_T0004

WHERE KILAT EQ COMM_STRUCTURE-/bic/zkilat

ORDER BY FECHA ASCENDING.

Says to me, The work area (or internal table) "COMM_STRUCTURE-/BIC/ZKILAT" is not structured

[naimesh_patel]

Try like:

DATA: LA_WORK TYPE ZBW_T0004.

SELECT FECHA KILAT VALOR
INTO CORRESPONDING FIELDS OF ZBW_T0004  " <<
FROM ZBW_T0004
WHERE KILAT EQ COMM_STRUCTURE-/bic/zkilat
ORDER BY FECHA ASCENDING.

Regards,

Naimesh Patel

[Former Member]

To place this

ENDSELECT

Thanks you very much to All