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

[Sokkorn]

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

[Miguel_Angel_Baeyens]

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

[#4]

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.

[its_anandrjs]

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

[#6]

Hi,

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

[its_anandrjs]

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

[Miguel_Angel_Baeyens]

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

[#9]

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.

[Miguel_Angel_Baeyens]

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