2 Replies Latest reply: Sep 9, 2010 4:00 AM by s j RSS

    How to select a MANDT field in SAP?

    Robson Candeo

       

      i need to make this selection above:

      SQL Select * From VBAP where MANDT = 400;

      But I am receiving an error using Qlik View Connector for SAP.

      Anyone can help me with this?

      (I´ve already tried SQL Select * From VBAP where MANDT = '400';



        • How to select a MANDT field in SAP?
          Lars Wahlstedt

          Hi Robson,

          most tables in SAP are client-dependant, meaning you can not select outside the client you are logged onto. If you try you get an error.

          So if you are logged onto client 400, you will only get data for MANDT=400 without stating the WHERE-clause.

          If you want data from another client, you need to re-connect to that client.

          Regards,

          Lars Wahlstedt

          • How to select a MANDT field in SAP?
            s j

            During connection establishment . We are specifuying client ID. So we can extract data for that client ID only.

            For another client you have to re-estabilsh connection and also require authorization of USer ID and Password .