Please help, points guaranteed.

[Former Member]

I do

"select * from TPFET"

but get

Server: Msg 208, Level 16, State 1, Line 1

Invalid object name 'TPFET'.

But I see

select * from sysobjects where name = 'TPFET' and type = 'U'

I see:

TPFET 193188234 U 5 11 1610612995 208 0 0 2003-09-05 01:47:03.713 0 208 0 U 1 115 0 2003-09-05 01:47:03.713 0 0 0 0 0 512 0

Why? Please help. Thanks a lot!

[Former Member · Accepted solution]

Specifically try this

SELECT * FROM [DEV].[dev].[TPFET]. Where DEV is the database name and dev is the owner.

RSB

[former_member193399]

Jennifer,

You need to know the database schema name in order to prefix the table. To get the database schema name:

1) Logon to the SAP System using SAP GUI

2) Select menu item "System->Status"

3) You can get the schema name on the right bottom of the window you under the field "Owner".

Then launch your favourite query tools i.e. Query Analyzer or SQL Management studio and execute as follows. Replace "<schema name>" in the statement to the owner name you found using the above steps:

select * from <schema name>.TPFET  

I hope this helps!

Ramesh

[Rudi_Wiesmayr]

You have to change to the SAP database with Ctrl+U.

Then TPFET is found.

(Tested on SQL2000 on a 4.7 installation)

HTH, Rudi

[Former Member]

Try select * from <username>.TPFET. Where <username> corresponds to the userid that is the owner of that table.

RSB.