Problem in SAP with Clause WHERE

[#1]

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

[#2]

Try

SQL SELECT * FROM CE1ALEN

WHERE KOKRS = '2000 ';

Stephen

[Sokkorn]

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

[#4]

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.

[Sokkorn]

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