topic Re: Error ORDER BY in Application Development and Automation Discussions

Error ORDER BY

Former Member — Thu, 14 Aug 2008 16:20:31 GMT

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.

thanks

Mike

Re: Error ORDER BY

naimesh_patel — Thu, 14 Aug 2008 16:21:56 GMT

Remove commas from the fields of the select query.


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

Regards,

Naimesh Patel

Re: Error ORDER BY

Former Member — Thu, 14 Aug 2008 16:24:09 GMT

You will need an INTO as well.

Rob

Re: Error ORDER BY

Former Member — Thu, 14 Aug 2008 16:35:35 GMT

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

Re: Error ORDER BY

naimesh_patel — Thu, 14 Aug 2008 16:37:07 GMT

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

Re: Error ORDER BY

Former Member — Thu, 14 Aug 2008 16:54:53 GMT

To place this

ENDSELECT

Thanks you very much to All