topic Re: Where clause in QvSAPDSOConnector in QlikView

Where clause in QvSAPDSOConnector

christian77 — Tue, 01 Oct 2013 08:16:30 GMT

Hi:

I'm trying to read a DSO from SAP.

TABLE:

Load *;
SQL Select (NoKey) * from TABLE;

It works fine. When I try to slice it by date it shows error. Any suggestion? I need to slice these DSOs, they are huge.

TABLE:

Load *;
SQL Select (NoKey) * from TABLE

where OERDAT= '04/04/2013';

Re: Where clause in QvSAPDSOConnector

tresB — Tue, 01 Oct 2013 08:21:49 GMT

Possibly OERDAT data format is not similar to the one you are hard coding. Please check the format in the source and retry with similar format filter in WHERE clause.

Re: Where clause in QvSAPDSOConnector

christian77 — Tue, 01 Oct 2013 08:28:26 GMT

Thank you tresesco. I've just tried 04042013. They are telling me that the format is 20130404 in thi SAP place. I've just tried too. I get the same error.

Re: Where clause in QvSAPDSOConnector

tresB — Tue, 01 Oct 2013 08:33:37 GMT

Then try like :

where OERDAT= '20130404';

Re: Where clause in QvSAPDSOConnector

christian77 — Tue, 01 Oct 2013 08:42:09 GMT

That's what I just did. With and without quotes.

Re: Where clause in QvSAPDSOConnector

Tue, 01 Oct 2013 09:01:12 GMT

Hi Christian,

You can try:

where OERDAT = '04/04/2013'; OR
where OERDAT = '20130404';

What different above is "give one space" after field "OERDAT"

Regards,

Sokkorn

Re: Where clause in QvSAPDSOConnector

christian77 — Tue, 01 Oct 2013 14:20:46 GMT

Thanks, I’m afraid that's not it.

I've tried with another short text field, leaving a space, and I get the same error.

Not my lucky day.

Re: Where clause in QvSAPDSOConnector

christian77 — Wed, 02 Oct 2013 12:56:59 GMT

Hi. Thank you for your interest.

The right sintax for this kind of loading appears in the SAP Connector Manual 5.80 pages 41 and 42.

That manual comes with the connector itself.

Tahks again all of you.

Re: Where clause in QvSAPDSOConnector

samuli_attido — Thu, 20 Dec 2018 09:46:51 GMT

If you don't have the SAP Connector Manual search on the community, someone shared the pdf .