DB View with unknown data

[Former Member]

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

[Former Member]

Don't believe it - the mistake is elsewhere.

Rob

[Sandeep_Panghal]

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

[Former Member]

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]

>

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

[Former Member]

Thanks Rob.

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

[Former Member]

Don't believe it - the mistake is elsewhere.

Rob