2 Replies Latest reply: Nov 22, 2012 9:11 AM by Tibbout Nelis RSS

    Load from SAP: where clause on date selection

         Hello gurus!

       

      I have an easy question which is driving me crazy!

       

      The purpose is to load table AUFM from SAP.  The field BUDAT is a date in following notation:  20/11/2012.

       

      I want to load only the records from 2011 & 2012, therefore I use a where clause, but no records are loaded.

       

      What is wrong in the script:

       

      [AUFM]:

      Load
        
      [MEINS] as [Base Unit_MEINS],
        
      text([MATNR]) as [Material_MATNR],
        
      [SHKZG] as [Debit/Credit_SHKZG],
        
      [WERKS] as [Plant_WERKS],
        
      [AUFNR] as [Order_AUFNR],
        
      [MENGE] as [Quantity_MENGE],
        
      [BUDAT] as [Posting Date_BUDAT],
        
      [BWART] as [Movement Type_BWART];
      SQL Select MEINS MATNR SHKZG AUFNR WERKS MENGE BUDAT BWART  from AUFM
      where BUDAT > '31/12/2010'
      ;

       

      Thank you for your help!