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

Pool table in a view

Former Member — Fri, 08 Aug 2008 10:29:01 GMT

Hello all,

I need to add the table T157E to a view. The problem is that this table belong to the pool ATAB and the system does not let me include it in the view.

How can i do this?

Thank you

Nuno Silva

Re: Pool table in a view

Former Member — Fri, 08 Aug 2008 11:53:16 GMT

Hi,

I think the error that you are getting is "No relationships are defined for table T157E".

If yes, then the reason is because there are no foreign key relationshipsof this table with other tables. Therefore this table is not checked against another table and is not itself the check table for another table.

You can link the table with other tables in a database view by specifying a join condition directly.

Luck,

Bhumika

Re: Pool table in a view

Former Member — Fri, 08 Aug 2008 12:01:48 GMT

Hello,

I have the table related to MSEG.

The error that i am getting is not that one.

The error i am getting is Table T157E is not transparent.

Thank you

Nuno Silva

Re: Pool table in a view

Former Member — Mon, 11 Aug 2008 05:34:02 GMT

Hi,

You would find the following links helpful:

http://help.sap.com/saphelp_nw04/helpdata/en/89/ef5a2b4e0211d2a5fc0000e82deaaa/content.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/d0/999246b2aa11d1a5700000e82deaaa/content.htm

Regards,

Prashant

Re: Pool table in a view

Former Member — Mon, 11 Aug 2008 05:51:40 GMT

Hi Nuno Silva,

U can not include Pooled Table or Cluster Table in View...

Only Transparent Tables can be used while creating views...

Alternative to that is...

In your program u can use FOR ALL ENTRIES to get related data of table T157E as it is pooled table...

Hope it will solve your problem..

Thanks & Regards

ilesh 24x7