Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

How to make a where Clause for SAP Query Connector

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

4 Replies
gk___
Contributor
Contributor

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

Not applicable
Author

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
Not applicable
Author

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

agigliotti
Partner - Champion
Partner - Champion

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