Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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';
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
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
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 .