Pool table in a view

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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

[Former Member]

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