Problem with Where sentnce in SAP

Anonymous — Sun, 25 Mar 2012 04:39:05 GMT

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

Re: Problem with Where sentnce in SAP

jonathandienst — Sun, 25 Mar 2012 20:05:03 GMT

Pablo

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

Hope that helps

Jonathan