topic Re: base table for a view in Application Development and Automation Discussions

base table for a view

Former Member — Mon, 06 Apr 2009 05:11:22 GMT

How to get a base table for a given view?

Re: base table for a view

Former Member — Mon, 06 Apr 2009 05:38:24 GMT

Hello

SE11 -> Enter view name -> Table/join conditions -> Tables

Re: base table for a view

Former Member — Mon, 06 Apr 2009 05:41:08 GMT

Hello Reshma,

SE 11 > View> give Ur view name > Display

Then click on Table/Join Conditions tab . You will be able to see the name of the base table.

Hope this helps.

Thanks and regards

Sathya

Re: base table for a view

Former Member — Mon, 06 Apr 2009 05:44:05 GMT

For a view there are many base table exists.

I want to read the data for all these tables for a perticular condition say PERNR.

How can I read data from all these base tabels???

OR directly I can get it from view using read ??

Re: base table for a view

Former Member — Mon, 06 Apr 2009 05:50:15 GMT

Hello

Yes, you may directly get data from view (select * from view_name where pernr = <pernr>).

Re: base table for a view

Former Member — Mon, 06 Apr 2009 07:33:42 GMT

Getting an error while reading a view. "view is not defined in the ABAP dictionay as a table , projection or database view" .

Why it is so?

Re: base table for a view

Former Member — Mon, 06 Apr 2009 07:51:17 GMT

Hello

You use maintenance view ?

So, in this case you have not direct read.

Re: base table for a view

Former Member — Wed, 08 Apr 2009 09:42:12 GMT

hi reshma,

go to transcation se11,select view,give ur view name,click on display,ur view wl appear,then click on table/join condition u wl get ur base table name there

Re: base table for a view

Former Member — Wed, 08 Apr 2009 10:28:21 GMT

Hi Reshma,

Ensure that the view is activated, before trying to access it.

Regards,

Shiny

Re: base table for a view

former_member575017 — Wed, 08 Apr 2009 11:22:53 GMT

Hi,

Again it depends on the view u r creating... if u r creating view for multiple table ie DATABASE View then all these tables should be related to each other ie Foriegn key relationship....

Goto SE11 SELECT VIEW option then select Which view u want create ..

then enter the base tables and click on relationship then it will show related fields in all the tables then select the fields from individual tables which ever u want then activate.

If u r creating projection view foriegn key relationship is not needed.....

Thanks

Basu

Re: base table for a view

shahid_malayil1 — Mon, 13 Apr 2009 07:38:02 GMT

Hi Reshma,

Its better to use Logical database in your case.

Check out for the LDB: PNP in SE36

Best regards,

Shahid Malayil