cancel
Showing results for 
Search instead for 
Did you mean: 

how to access ABAP schema tables(USR02) through MaxDB studio

Former Member
0 Kudos

i want to access ABAP schema tables eg.USR02.but i couldnt do that from MaxDB studio.its saying that "table is unknown".

Even i tried these commands

dbmcli -D <SID> -u user,pwd

dbmcli>sql_connect superdba,pwd

dbmcli>sql_execute select * from USR02

dbmcli >sql_execute select * from USR02

ERR

-24988,ERR_SQL: SQL error

-4004,Unknown table name:USR02

---

Kindly help me out.

V r using MaxDB 7.7.02.11.....

Accepted Solutions (0)

Answers (1)

Answers (1)

Former Member
0 Kudos

Hello Durairaj,

you should first check which database owner is owner of the table USR02:

select * from domain.tables where tablename = 'USER02'

e.g. if the Owner of the tables is SAPR3

you should start the following SELECT: SELECT * from SAPR3.USER02

You can also connect as this User dbmcli -d ... -u SAPR3, <pwd> and start the select without the specification of the Owner.

REgards, Christiane Hienger

Former Member
0 Kudos

Hi Christiane Hienger ,

That works....

Thanks for your help.

Cheers,

Durairaj premsundar