topic Error while fetching data from SAP in QlikView

Error while fetching data from SAP

Wed, 01 Dec 2010 09:47:32 GMT

Hi ,

my code is this:

load
KSCHL ;
sql select
KONV~KSCHL
from VBAK LEFT JOIN KONV ON (KONV~KNUMV = VBAK~KNUMV) ;

I got error (Open stream failed ,Sql Error)

Pls debug it.

Error while fetching data from SAP

suniljain — Wed, 01 Dec 2010 10:37:46 GMT

you are not getting response from SAP R/3 in decided time frame.

reason is that KONV is cluster table and from KONV you cant extract data like that.

Error while fetching data from SAP

Wed, 01 Dec 2010 11:09:19 GMT

THEN HOW TO DO THIS ?

Error while fetching data from SAP

suniljain — Wed, 01 Dec 2010 11:12:01 GMT

Dear Rajni,

What is data data volume in KONV. I mean No of records.

Regards

Sunil

Error while fetching data from SAP

Wed, 01 Dec 2010 11:45:39 GMT

ABOVE 5 CRORE DATA

Error while fetching data from SAP

Wed, 01 Dec 2010 12:18:44 GMT

Pls give urgent reply

Error while fetching data from SAP

Wed, 01 Dec 2010 13:01:31 GMT

Pls give me answer if i want to fetch data on daily basis

Error while fetching data from SAP

suniljain — Fri, 07 Oct 2011 11:07:24 GMT

in qlikview sap connector 5.6 . this task become easy.

thanx to qliktech

Error while fetching data from SAP

Mon, 12 Mar 2012 22:56:36 GMT

Hello,

so far that I know the KONV is a cluster table and it is not possible to make a JOIN with a cluster table. I think you have to find a workaround e.g. SAP queries or nested SQL statements

Best regards!

Error while fetching data from SAP

suniljain — Wed, 14 Mar 2012 13:31:05 GMT

you can not make join but you can extract KONV with the help of VBAK or VBRK in sub query.