get table name and fields from SAP

[#1]

I made connection to SAP data. Now I want to get tables and their fields. Please help

Thanks in advance

[suniljain]

pls use scriptbuilder.qvw

[suniljain]

Dear Anand,

Are you inplemented that scenario with SAP ?.

[#4]

Yes I used it.

But in while fetching data it is giving me Scrpt Line error on Query..

I checked in QVSAPConnector log, it is

2011-10-21 01:34:29 Progress Connected to SAP with C:\Program Files\Common Files\QlikTech\Custom Data\QvSAPConnector\QvSAPConnector.dll 5, 5, 8639 IR

2011-10-21 01:34:29 Error Creation of function /QTQVC/OPEN_STREAM failed after 00:00:00 Key = RFC_INVALID_PARAMETER (Invalid parameter 'RFC_FUNCTION_DESC_HANDLE' was passed to the API call)

2011-10-21 01:34:29 Error Creation of function /QTQVC/FETCH_STREAM failed after 00:00:00 Key = RFC_INVALID_PARAMETER (Invalid parameter 'RFC_FUNCTION_DESC_HANDLE' was passed to the API call)

2011-10-21 01:34:29 Error /QTQVC/OPEN_STREAM failed after 00:00:00 Key = RFC_INVALID_PARAMETER (Invalid parameter 'RFC_FUNCTION_HANDLE' was passed to the API call)

2011-10-21 01:34:33 Error /QTQVC/FETCH_STREAM failed after 00:00:00 Key = RFC_INVALID_PARAMETER (Invalid parameter 'RFC_FUNCTION_HANDLE' was passed to the API call)

I can not understand this issue.....

Thanks,

Swapnil

[suniljain]

are you extracting table or query ?.

[#6]

Script line error:

DD02L: 

SQL SELECT TABNAME TABCLASS FROM DD02L where ( TABCLASS = 'TRANSP' or TABCLASS = 'POOL' or TABCLASS = 'CLUSTER' or ( TABCLASS = 'VIEW' and ( VIEWCLASS = 'D' or VIEWCLASS = 'P' ) ) )

This is query from ReloadSAPDD dashboard.

Before there is connection statement. It works properely..

[#7]

Hi,

You may try to use this script:

SQL Select SPRAS, BLART, LTEXT  from T003T

Where T003T~SPRAS = 'E';

Hope this would be a help.

Best Regards,

Anne

[suniljain]

your can separetly download ReloadSAPDD.qvw from download section.

[#9]

Hello swapnil,

could it be that the QV connector transports are missing in the SAP system and has your SAP user all authorities that are required?

I have not so many experience with the QV connector because I have more experience with SAP itself. For me it looks more or less that the QV connector is not created correctly in the SAP system or the user has not enough authorities.

I hope it helps you!

Best regards!