topic DB View with unknown data in Application Development and Automation Discussions

DB View with unknown data

Former Member — Thu, 03 Mar 2011 17:08:52 GMT

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

Re: DB View with unknown data

Sandeep_Panghal — Thu, 03 Mar 2011 17:11:17 GMT

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

Re: DB View with unknown data

Former Member — Thu, 03 Mar 2011 17:19:31 GMT

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?

Re: DB View with unknown data

Former Member — Thu, 03 Mar 2011 17:38:44 GMT


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

Re: DB View with unknown data

Former Member — Thu, 03 Mar 2011 17:44:36 GMT

Thanks Rob.

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

Re: DB View with unknown data

Former Member — Thu, 03 Mar 2011 18:14:16 GMT

Don't believe it - the mistake is elsewhere.

Rob