Discussion Board for collaboration on QlikView Scripting.
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';
Go to Solution.
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.
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 .