Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
sathishkumar_go
Partner - Specialist
Partner - Specialist

Qv Sap Connector 5.3 will support SAP 700?

Hi All,

My Client is using SAP 700. Wheather Qlikview SAP CONNECTOR 5.3 WILL SUPPORT THIS?

-Sathish

19 Replies
sathishkumar_go
Partner - Specialist
Partner - Specialist
Author

Sunil,

For ur reference log file :

09/20/10 10:50:41: Execution started.
09/20/10 10:50:41: QlikView Version:9.00.7440.8
09/20/10 10:50:41: 0002 SET ThousandSep=','
09/20/10 10:50:41: 0003 SET DecimalSep='.'
09/20/10 10:50:41: 0004 SET MoneyThousandSep=','
09/20/10 10:50:41: 0005 SET MoneyDecimalSep='.'
09/20/10 10:50:41: 0006 SET MoneyFormat='$#,##0.00;($#,##0.00)'
09/20/10 10:50:41: 0007 SET TimeFormat='h:mm:ss TT'
09/20/10 10:50:41: 0008 SET DateFormat='M/D/YYYY'
09/20/10 10:50:41: 0009 SET TimestampFormat='M/D/YYYY h:mm:ss[.fff] TT'
09/20/10 10:50:41: 0010 SET MonthNames='Jan;Feb;Mar;Apr;May;Jun;Jul;Aug;Sep;Oct;Nov;Dec'
09/20/10 10:50:41: 0011 SET DayNames='Mon;Tue;Wed;Thu;Fri;Sat;Sun'
09/20/10 10:50:41: 0017 CUSTOMCONNECT*Provider*QvSAPConnector*XUserId*XPassword*
09/20/10 10:50:41: 0019 VBRK:
09/20/10 10:50:41: 0020 LOAD
09/20/10 10:50:41: 0021 MANDT,
09/20/10 10:50:41: 0022 VBELN,
09/20/10 10:50:41: 0023
09/20/10 10:50:41: 0024
09/20/10 10:50:41: 0025
09/20/10 10:50:41: 0026
09/20/10 10:50:41: 0027
09/20/10 10:50:41: 0028
09/20/10 10:50:41: 0029
09/20/10 10:50:41: 0030
09/20/10 10:50:41: 0031
09/20/10 10:50:41: 0032 FKDAT where year(FKDAT) > 2008
09/20/10 10:50:41: 0133 SQL Select * FROM VBRK
09/20/10 10:50:45: 3 fields found: MANDT, VBELN, FKDAT, Error: Custom read failed
09/20/10 10:51:52: 0134 STORE VBRK INTO D:\QV-Project\MB_SCM\Qvd\SalesPipelineQvd\VBRK.qvd
09/20/10 10:51:52: 0135 DROP TABLE VBRK
09/20/10 10:51:52: 0136 EXIT SCRIPT
09/20/10 10:51:52: Execution finished.

suniljain
Master
Master

pls try this onr in where condition

where FKDAT > 20080101

sathishkumar_go
Partner - Specialist
Partner - Specialist
Author

Sunil,

Ya I tried but same error

-Sathish

suniljain
Master
Master

pls try

where fkdat> '20080101' order by fkdat;

sathishkumar_go
Partner - Specialist
Partner - Specialist
Author

SUNIL,

I Think syntax is not a problem. Because if i give year(FKDAT) > 2005 ITS LOADING UPTO 7000 ROWS AFTER THAT CUSTOM ODBC FAILED.

suniljain
Master
Master

pls use attached tool for extraction by change change connection string. It help you lot.

I want to know one thing for custom odbc failed.

what is data size . I mean data of no .of year in SAP.

sathishkumar_go
Partner - Specialist
Partner - Specialist
Author

Sunil,

Really Very Very Thaks for ur Help!!!!

In that table having 1998 to 2010 Year data. after 2008 means 2009 and 2010 around 3 L .

But this sap extractoR also shows Custom ODBC cONNECTION FAILED....

-sATHISH

suniljain
Master
Master

pls check through DBA regarding whether data after 2008 is archived or what ?.

also check through your SAP Basis team. i think SAP Connector is unable to read data from 2008 . so may be is there any internal problem in this table.

Sathish , what abt other table LIKP,LIPS,VBAP,VBAK,VBFA .....................

same thing happening with other table or what ?.

Not applicable

Dear All,

I am also facing the same problem,but not for same tables.

any clue on this problem.

Regards,

Santhosh Kumar G

suniljain
Master
Master

Dear Santosh,

    Can you post more details on the issue you are facing ?.

Regards

Sunil Jain