Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

rcandeo
Contributor II

How to select a MANDT field in SAP?

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



1 Solution

Accepted Solutions
lwt
Contributor III

How to select a MANDT field in SAP?

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

2 Replies
lwt
Contributor III

How to select a MANDT field in SAP?

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
Honored Contributor

How to select a MANDT field in SAP?

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 .

Community Browser