topic Re: How to execute query from Qlikview load script in order to fetch data from SAP in QlikView

How to execute query from Qlikview load script in order to fetch data from SAP

Anonymous — Mon, 20 Feb 2017 10:23:55 GMT

Dear Community Users,

I have been given a SAP query from SAP team, and the objective is to run the SAP query from Qlikview load script and fetch the data.

Below is the query, when i run this query in Qlikview with connection information. am getting Script Error.

SELECT distinct b.objectvalue as ebeln

FROM CDPOS b, CDHDR a

WHERE b.objectclas = ‘EINKBELEG’

AND b.tabname = ‘EKES’

And b.objectvalue = a.objectvalue

AND b.changenr = a.changenr

AND a.objectclas = ‘EINKBELEG’

AND a.udate >= &LastRunDate ;

Appreciate your Help.

Thanks

Balamuralidharan T

Re: How to execute query from Qlikview load script in order to fetch data from SAP

petter — Mon, 20 Feb 2017 15:39:34 GMT

What does you connect statement say during script run? Do you get a successful connection? Is it the SELECT statement that really cause the "Script Error"?

You quotes in the SQL above seems off. They are a back-tick as start and forward-tick as end ... which seems odd. I don't know much about SAP but I am pretty sure that single qutoes; straight/vertical like this ' is what you need to use:

SELECT distinct b.objectvalue as ebeln

FROM CDPOS b, CDHDR a

WHERE b.objectclas = 'EINKBELEG'

AND b.tabname = 'EKES'

And b.objectvalue = a.objectvalue

AND b.changenr = a.changenr

AND a.objectclas = 'EINKBELEG'

AND a.udate >= &LastRunDate ;

Re: How to execute query from Qlikview load script in order to fetch data from SAP

aarkay29 — Mon, 20 Feb 2017 16:01:57 GMT

Try this:

LOAD OBJECTVALUE AS EBELN

;

SQL SUBSELECT OBEJECTVALUE FROM CDPOS

WHERE

OBJECTCLAS='EINKBELEG' AND TABNAME='EKES' AND OBJECTVALUE CHANGENR IN ( SELECT OBJECTVALUE CHANGENR FROM CDHDR WHERE UDATE >= '$(LastRunDate)' );

Make sure that LastRunDate is in YYYYMMDD format and also I believe that OBJECTID is the name for field OBJECTVALUE in SAP TABLE CDPOS and CDHDR.

Re: How to execute query from Qlikview load script in order to fetch data from SAP

Anonymous — Tue, 21 Feb 2017 11:57:37 GMT

Hi Aar Kay, Thanks for your reply. I did execute the query which you recommended but still am getting the script error.

Yes, am able to connect the SAP.

Please find below the snapshot of Error message,

Thanks

Balamuralidharan T

Re: How to execute query from Qlikview load script in order to fetch data from SAP

aarkay29 — Tue, 21 Feb 2017 14:19:22 GMT

Can you please post your script