topic Re: How to make a where Clause for SAP Query Connector in QlikView

How to make a where Clause for SAP Query Connector

Thu, 07 Jul 2011 05:20:02 GMT

Hello

I can access the SAP Query using a QvSAPQueryConnector.

This is a generated script by QvSAPQueryConnector

Load *;

Select SAPQUERY (QUERY (ZKRMM_VENDOR), DBACC (1000000000), USERGROUP (ZKRMM), WORKSPACE ( ), EXTERNAL_PRESENTATION (S));

Could I add a where clause in this query?

ex) Year >= 2011

How to make a where Clause for SAP Query Connector

gk___ — Fri, 08 Jul 2011 13:39:39 GMT

QVD file:

Load .......From file://\\ddd\\\ddd\d.qvd (qvd) where (fieldname = 'value');

ODBC

load .............. ;

sql select qqwqw wweew qwqwq from TABLEname where SPRAS = 'EN'

;

have a nice weekend

Gunner

Re: How to make a where Clause for SAP Query Connector

Mon, 11 Jul 2011 03:46:46 GMT

Hello

Thank you for the answer,

But In my case, I'm using the QvSAPQueryConnector.

I already tested the where clause end of script, but SAPQUERY not worked with where clause.

Test1. without where

Select SAPQUERY (QUERY (PACKING_LIST), VARIANT (SELECT), USERGROUP (ZKRSD), WORKSPACE ( ), EXTERNAL_PRESENTATION (S))

Table0 << Select SAPQUERY (QUERY (PACKING_LIST), VARIANT (SELECT), USERGRO 8 lines fetched

Test2. with where

Select SAPQUERY (QUERY (PACKING_LIST), VARIANT (SELECT), USERGROUP (ZKRSD), WORKSPACE ( ), EXTERNAL_PRESENTATION (S))
where Material(VEPO-MATNR) = '14002045';

Table0 << Select SAPQUERY (QUERY (PACKING_LIST), VARIANT (SELECT), USERGRO 8 lines fetched

Re: How to make a where Clause for SAP Query Connector

Tue, 12 Mar 2013 05:50:42 GMT

Hi all,

I also have the same issue. When I read QlikView Connector Manual,there mentioned one parameter called 'KeepCasing' which indicates that lowercase characters in the SELECT statement remains lowercase. Is this have relation to issue I am facing??

-Regards,

Jatin

Re: How to make a where Clause for SAP Query Connector

agigliotti — Tue, 22 Oct 2013 08:45:50 GMT

Hello,

I just posted a message here http://community.qlik.com/message/409959

I'm using sap query connector version 5.80 IR and I faced "SAP Queries: unable to refresh data from Server" error so I can't use any query on sap system.

Can you help me to fix it ?

Many thanks in advance.

Best Regards

Andrea