9 Replies Latest reply: Jul 6, 2011 4:07 AM by shivareddyk RSS

    Field not found - <MaterialNo>

      hi guys,

       

      I able to connect  SAP R/3 system from Qlikview,

      I key in query as like this to get  VRPMA SAP R/3 table data into qlikview,

       

      VRPMA:

      Load [MaterialNo],

           [SalesOrg];

      SQL Select VRPMA~MATNR AS [MaterialNo] ,

                 VRPMA~VKORG AS [SalesOrg]

                 from VRPMA ;

       

       

       

      but i am geting the following error,i am assuming some thing wrong with the above script.

       

       

      Field not found - <MaterialNo>

      SQL Select VRPMA~MATNR AS [MaterialNo] ,

                 VRPMA~VKORG AS [SalesOrg]

                 from VRPMA

       

      can u let me know any one?

       

       

      Rgds