base table for a view

[Former Member]

How to get a base table for a given view?

[Former Member]

Hello

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

[Former Member]

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 ??

[Former Member]

Hello

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

[Former Member]

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?

[Former Member]

Hello

You use maintenance view ?

So, in this case you have not direct read.

[Former Member]

Hi Reshma,

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

Regards,

Shiny

[shahid_malayil1]

Hi Reshma,

Its better to use Logical database in your case.

Check out for the LDB: PNP in SE36

Best regards,

Shahid Malayil

[Former Member]

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

[Former Member]

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

[former_member575017]

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