Integration Kit for SAP - Open SQL access to tables. List incomplete.

[claudio_ciardelli2]

After we install the BO integration kit for SAP and CR 2008 we were able to connect to SAP and open SAP Data Dictionnary tables (Open SQL access).

I have a problem however:

when I display the list of available tables, the is not showing all the tables in the SAP system. I believe it stops at some point.

I see all tables with low letters or starting with /BIC...

I have custom tables with names ranging from ZR1 to ZR5.

Of these I only see tables up to ZR2*.

My guess is :

either that the table list displayed is limited to a certain mumber of tables

or that there are some authorisations issues to be solved to view all tables (but the same SAP User sees all tables in SE11)

or there is a table related setting in the Data dictionnary that makes some tables visible by CR and other not

Thanks in advance for any answer.

Claudio Ciardelli

[IngoH]

correct - it stops at one point because showing you more than 30.000 tables doesn't really help. Right click on your connection (server entry), select the menu options, there is an entry called Table name like. in your case enter Z% and hit F5 for a refresh and you will only get tables shown starting with Z

Ingo