7 Replies Latest reply: Apr 8, 2014 3:40 AM by Vinayak Agarwal RSS

    SAP incorrect data fetch for batch.

      Hello Friends,

       

      I am fetching data in qikview from one of the SAP tables: MCH1.

       

      MCH1:

      SQL Select

        * from MCH1;

       

      The data gets fetched. The problem is, for a field BATCH (CHARG) the data is incorrect for some of the cases. (even before storing the data in the QVD and also after that)

      Example:

      * BATCH: '3206434E00' , '3206434E' and ' 3206434' are all picked as '3206434'.

      * 'WAB' and ' WAB' (there is a space before WAB) are both picked as 'WAB'.

      < NOTE: '2307311E00' gets picked correctly >

       

      Can someone please provide any suggestion or solution?

       

      Thank you.