Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
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
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
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