Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am using SAP Connectors v6.6, for some reason I can't fathom the SAP Extractor Connector won't work with more than one field in the where clause.
[TABLE]:
LOAD
[DOC];
SQL EXTRACTOR TABLE
TFRMETHOD T // Transfer method (T=tRFC)
UPDMODE F // Full extractor
EXTRLANGUAGE system_default // SAP System Default
LOGSYS QTQVCEXTR1
WHERE
CREATEDON I GE 20190101,
ERROR E NE X
;
This is a script code added automatically by Qlikview when you go through the UI, still it doesn't work.
If I remove either the CREATEDON line or the ERROR, the one that remains works, but with both at same time it won't.
I get the error "invalid selection condition in the data request". Does anyone know why is this?
Thank you.
Best regards,
André Braga
Hi,
Does it work if you try the same conditions in transaction RSA3 in SAP?
Regards,
Håkan
Hi André
IF you want to get the rows where ERROR = 'X', then write:
ERROR I EQ X
Otherwise write:
ERROR I NE X
Regards,
Håkan
Hi André,
Yes, but I think the problem is that you use Exclude (E) in your condition:
CREATEDON I GE 20190101,
ERROR E NE X
What if you change to either:
CREATEDON I GE 20190101,
ERROR I NE X
or
CREATEDON I GE 20190101,
ERROR I EQ X
depending on what you want to achieve?
Regards,
Håkan
Hi again,
Have you checked the SAP extraction job log. Prefix the job name from the Extractor connector log with ‘BI’, like BIREQU_QTQVCEXTR1_20160420125150. Check job log for this job name in transaction SM37. Select the job and press the 'Job log' button.
Regards,
Håkan
Hi,
And no useful information in the Extractor connector log or in the Extractor Service log?
Regards,
Håkan