Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
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___
New Contributor

How to make a where Clause for SAP Query Connector

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

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

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

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

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

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

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

Community Browser