topic Re: Problem in SAP with Clause WHERE in QlikView

Problem in SAP with Clause WHERE

Tue, 03 Dec 2013 00:10:42 GMT

Good afternoon.

I have a small problem with SAP, I have a connection, but when I want to apply some filters in the CE1 table I show an error.

example:

The next script shows me error in the Where clause

SQL SELECT * FROM CE1ALEN WHERE KOKRS = '2000 ';

But this works great

SQL SELECT * FROM CE1ALEN

I thank you in advance for your help

Re: Problem in SAP with Clause WHERE

Tue, 03 Dec 2013 00:39:06 GMT

Try

SQL SELECT * FROM CE1ALEN

WHERE KOKRS = '2000 ';

Stephen

Re: Problem in SAP with Clause WHERE

Sokkorn — Tue, 03 Dec 2013 01:22:51 GMT

Hi Octavio,

Your first select statement seem missed table name. You may try

SQL SELECT * FROM CE1ALEN WHERE KOKRS = '2000';

Octavio Morales wrote:

Good afternoon.

I have a small problem with SAP, I have a connection, but when I want to apply some filters in the CE1 table I show an error.

example:

The next script shows me error in the Where clause

SQL SELECT * FROM WHERE CE1ALEN KOKRS = '2000 ';

But this works great

SQL SELECT * FROM CE1ALEN

I thank you in advance for your help

Regards,

Sokkorn

Re: Problem in SAP with Clause WHERE

Tue, 03 Dec 2013 15:03:26 GMT

Sorry, I was wrong to post the query, the query I have as you show me, I think this is a bit more complicated, making the query for the entire table if I listed all the fields, but, wanting to apply filters for some of the fields I get an error as if the query he was wrong.

I tried to do the consultation with the ScriptBuilder but selecting this table do not muetra the relationship with the field I have already loaded the SAP dictionary and ScriptBuilder to that database and so I can not add filters to my consultation.

anyone with any idea that can be happening.

Re: Problem in SAP with Clause WHERE

Sokkorn — Wed, 04 Dec 2013 00:57:52 GMT

Hi Octavio,

Ok. Let try other way:

[Data]:

Load * Where KOKRS = '2000';

SQL SELECT * FROM CE1ALEN;

Make sure table CE1ALEN have KOKRS field.

Regards,

Sokkorn