Problem with Where sentnce in SAP

[Anonymous]

Hi, I try to create a filter in SAP with this Script

let S=date((today()-10),'YYYYMMDD');

[Remitos]:            //[CabeceraRemito]:

Load

          [VBELN] as Entrega,

          [ERDAT] as Fecha,                    //FechaCreado

          [ERZET] as HoraCreado,

          //LFDAT FechaEntrega

          [LPRIO] as Prioridad,,

          [KUNNR] as Destinatario,

          [KUNAG] as Solicitante,

          [ANZPK] as Bultos,

          [BTGEW] as PesoTotal,

          [XBLNR] as NroLegalRemito;

SQL Select VBELN ERDAT ERZET LPRIO KUNNR KUNAG ANZPK BTGEW LIFNR XBLNR from LIKP

where ERDAT>$(S);

any idea why i have a error in this script.

Regards 

[jonathandienst]

Pablo

I am not sure which DBMS this is for, but I noticed a few things which may be issues:

• double comma after Prioridad
• shouldn't there be commas between the field names in the Select statement?
• I suspect that the $(S) should be enclosed in quotes   where ERDAT>'$(S)'

Hope that helps

Jonathan