Error while fetching data from SAP

[#1]

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.

[suniljain]

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.

[#3]

THEN HOW TO DO THIS ?

[suniljain]

Dear Rajni,

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

Regards

Sunil

[#5]

ABOVE 5 CRORE DATA

[#6]

Pls give urgent reply

[#7]

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

[suniljain]

in  qlikview sap connector 5.6 . this task become easy.

thanx to qliktech

[#9]

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!

[suniljain]

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