Where clause in QvSAPDSOConnector

[christian77]

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';

[tresesco]

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.

[christian77]

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.

[tresesco]

Then try like  :

where OERDAT= '20130404';

[christian77]

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

[#6]

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

[christian77]

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.

[christian77]

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.

[samuli_attido]

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