1 Reply Latest reply: Mar 25, 2012 4:06 PM by Jonathan Dienst RSS

    Problem with Where sentnce in SAP

    Pablo Tristany

      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