topic get table name and fields from SAP in QlikView

get table name and fields from SAP

Thu, 13 Oct 2011 11:13:54 GMT

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

Thanks in advance

get table name and fields from SAP

Sokkorn — Thu, 13 Oct 2011 11:54:49 GMT

Hi Swapnil,

You want to get all tables name and fields from SAP? If you are looking for this one, I think it hard to make it happen.

Let try some query after you connect to SAP with this

SELECT * FROM VBAP;

After reload data, then you will see the table Name [VBAP] with many field name in it.

Regards,

Sokkorn

Re: get table name and fields from SAP

Miguel_Angel_Baeyens — Thu, 13 Oct 2011 11:55:32 GMT

Hi,

Use the script builder QVW file with the SAP Connector to build that. It's under

C:\ProgramData\QlikTech\Custom Data\QvSAPConnector\

You will need to set up the driver configuration in the file ReLoadSAPDD.qvw

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

get table name and fields from SAP

Thu, 13 Oct 2011 12:00:20 GMT

Hi,

I need to give correct ODBC connection and Language.

Also the metadata is coming from SQL queries.

What connection and Language I need to specify there.

Thanks.

get table name and fields from SAP

its_anandrjs — Thu, 13 Oct 2011 12:03:34 GMT

Hi,

Create a DSN naming once and use it in QV Application for the SQL queries and then connect with SAP Connector to connect SAP data.

Rgds

Anand

get table name and fields from SAP

Thu, 13 Oct 2011 12:09:47 GMT

Hi,

But which driver I have to use for that DSN and what connectivity I have to spcify for DSN.

get table name and fields from SAP

its_anandrjs — Thu, 13 Oct 2011 13:42:17 GMT

Hi,

Select OLE DB -> Connect -> Select OLE DB providers -> Next -> Give your Server Name, User Name, Password -> check your connection and then set settings and after that select tables in qlikview and then select SAP connector and load data (install SAP copnnector from the Qlikview Download section and load the drivers and connectors)

Rgds

Anand

Re: get table name and fields from SAP

Miguel_Angel_Baeyens — Thu, 13 Oct 2011 15:14:59 GMT

Hi,

Are you using the QlikView Connector for SAP or any other driver? In any case, the language you will need to specify is English ("E"), German ("D") and the letter or letters that correspond to your language (in my case, Spanish "S").

If you are using the QlikView Connector, go to the Script Editor and in the lower part of the screen you will find ODBC, OLEDB and QvSAPConnector, QvSAPReportConnector and so on. Select the QvSAPConnector (to read from "plain" tables), set your SAP server IP address or fully qualyfied domain name, user, password, client and system number (if you don't know these, you will have to ask yoru SAP expert).

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

get table name and fields from SAP

Tue, 18 Oct 2011 11:09:21 GMT

Hi,

I connected to SAP server. Now it is giving me script line error

Script line error:

SQL Select SPRAS, BLART, LTEXT from T003T

where SPRAS = 'E'

Can you help me out.

Re: get table name and fields from SAP

Miguel_Angel_Baeyens — Tue, 18 Oct 2011 11:24:34 GMT

Hi,

I still don't know whether you are using or not the QlikView SAP Connector.

Have you tried that SQL without the WHERE clause? Does it work? Does the SPRAS field have the E value? Use the Select... button in the script editor window to see a preview of the possible values in that table. As a general rule, although it should work, I never use commas between field names with SAP rather than just spaces.

Hope that helps.

Miguel Angel Baeyens

BI Consultant

Comex Grupo Ibérica

get table name and fields from SAP

suniljain — Fri, 21 Oct 2011 04:13:55 GMT

pls use scriptbuilder.qvw

get table name and fields from SAP

suniljain — Fri, 21 Oct 2011 04:30:09 GMT

Dear Anand,

Are you inplemented that scenario with SAP ?.

get table name and fields from SAP

Fri, 21 Oct 2011 05:44:42 GMT

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

get table name and fields from SAP

suniljain — Fri, 21 Oct 2011 06:08:17 GMT

are you extracting table or query ?.

get table name and fields from SAP

Fri, 21 Oct 2011 06:17:22 GMT

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..

Re: get table name and fields from SAP

Fri, 21 Oct 2011 07:16:12 GMT

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

get table name and fields from SAP

suniljain — Fri, 21 Oct 2011 08:35:58 GMT

your can separetly download ReloadSAPDD.qvw from download section.

get table name and fields from SAP

Mon, 12 Mar 2012 22:51:02 GMT

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!