10 Replies Latest reply: Dec 7, 2013 10:08 AM by Ashwani Bhatia RSS

    Proper date format in SAP table

    Jerry Lau

      Actually I would like to try implementing incremental load

      I have raised a question here: Load Script - Date Issue

      And now I have changed the script as below:

       

      [VBAK]:

      LOAD

         VBELN,KUNNR,BSTNK,

         VKGRP,VKORG,VTWEG,

         SPART,AUDAT,VDATU,

         AUART,WAERK,KNUMV,

         FAKSK,ERNAM,VKBUR,

         KTEXT,ERDAT,ERZET;

      SQL Select

         VBELN KUNNR BSTNK

         VKGRP VKORG VTWEG

         SPART AUDAT VDATU

         AUART WAERK KNUMV

         FAKSK ERNAM VKBUR

         KTEXT ERDAT ERZET

      from VBAK WHERE

         Date(ERDAT,'dd/MM/yyyy')='15/10/2013';

       

      but the error still occurs

      /QTQVC/OPEN_STREAM failed after 00:00:00 Key = SQL_ERROR (ID:00 Type:E Number:001 "'15/10/2013'" is not a valid comparison operator.)

       

      I have tried loading the data and read the format of ERDAT which should have date format in 'dd/MM/yyyy' in table viewer

      And then it still prompts error message, can anyone help me to figure out the problem?  Many thanks!!