IDT-SHOW TABLE VALUES

[Former Member]

HI SAP COMMUNITY MEMBERS,

I Just need your help,

In the Data Foundation I have selected a table and right click and selected show table values option its showing.

For the past 2 days i have been facing this issue

I have checked with ODBC 32 AND 64 BIT Connections.---->SYSTEM DSN.

I even checked the .CNS Connections the test connections are success full.

If anyone knows please send your suggestions.

Regards,

Sraavan.

[Former Member]

Hi Guys,

Finally I could able to solve the Issue by establishing New ODBC CONNECTIONS.

I thank to Vijay,SREENIVASULU & Mantu. for their Suggestions & Support.

Regards,

Sraavan....

[former_member4998]

Hi

As Vijay Suggested, check in SQL Server Studio, weather tables POSNR have filed VBAP or not.

• SELECT * FROM POSNR
• SELECT * FROM Table Name
• SELECT Field Name From Table Name

If you are able to execute and see the data at DB, Then check the servers are running or not.

And if possible restart the servers once and check.

[Former Member]

HI SREENIVASULU

At the database level I have checked its showing the results, the data is fetch-able.

I Even tried the Query Panel at the Query Panel

I have Executed the Query , It showing the same Issue.

I even checked at the CMC SERVERS....

[former_member190895]

What is the version of the SQLSERVER?

[Former Member]

Hi Mantu,

have a look on the screen shot.

Send your Suggestions..

[former_member190895]

OK Try to create an object from the table. and they use the object in the Query panel of IDT then see if you are getting the results. Also fire the same query in the database as well.

[Former Member]

HI Mantu,

At the database level I have checked its showing the results, the data is fetch-able.

I Even tried the Query Panel at the Query Panel

I have Executed the Query , It showing the same Issue.

I finally checked the CMC SERVERS ALSO......

[P2006927273]

Hi Sraavan,

It seems to be having some problem while accessing the table.

Try selecting the whole data from VBAP table, after that try refine your search in using other fields of the table as below.

1. SELECT * VBAP

2. SELECT x y z from VBAP

Regards,

Vijay

[Former Member]

Hi Vijay,

Thanks for the response, actually I have tried what you have mentioned, Its still showing the same error. I have selected the table , Right Click show table values. Its showing...

I have Inserted the table from the data base manually, another VBAP...

In that the table values are showing...

Send your Suggestions...