Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

DB View with unknown data

Former Member
0 Kudos

Hi Gurus,

I have a interesting problem.There is a Z table ( transparent ).Lets say ZDUMMY_TABLE.When i try to see the data in ZDUMMY_TABLE from se16 i get an error like

"No database table exists for table ZDUMMY_TABLE" .

On the other hand there is a database view.ie. ZDUMMY_VIEW.In this view there is only one table.This table is the ZDUMMY_TABLE.When i try to see the data in ZDUMMY_VIEW from se16, it returns almost 100 lines of data.

By the way, the table ZDUMMY_TABLE has only one key field and this field is MANDT.

I couldnt figure this problem.

Thanks for your help.

Best regards,

Burak

5 REPLIES 5

Sandeep_Kumar
Advisor
Advisor
0 Kudos

Check if the table is activated and exists at DB level . You can try activate and adjust db table using SE14.

0 Kudos

Hi Sandeep,

this is the problem.Its activated but when i try to check DB utility it says "Table is not created in the database".

but from view it returns data.View has ony this table in it.

How can it be possible?

Former Member
0 Kudos

>

ZDUMMY_TABLE.When i try to see the data in ZDUMMY_VIEW from se16, it returns almost 100 lines of data.

By the way, the table ZDUMMY_TABLE has only one key field and this field is MANDT.

Not possible.

Rob

0 Kudos

Thanks Rob.

i know its hard to believe.i wouldnt believe too.

0 Kudos

Don't believe it - the mistake is elsewhere.

Rob