topic How to select a MANDT field in SAP? in QlikView

How to select a MANDT field in SAP?

rcandeo — Wed, 08 Sep 2010 18:09:37 GMT

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';

Lars_Wahlstedt — Thu, 09 Sep 2010 07:54:46 GMT

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

suniljain — Thu, 09 Sep 2010 08:00:32 GMT

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 .