using a view

[Former Member]

hi folks,

I want the help is creating and using the view. I need to grab data from four different tables JHTFP(3), JHAMOT (2), KNOV(2) AND MHND(1). The connection between these tables is BSEG. I went ahead and created a view pulling up these fields. gave the releavt join conditions between them. when I activate it is throwing me some errors.

it is asking for client dependency factor I did select the 'mandt' field on one of the tables. besides the BSEG,MHND and KONV are cluster tables. How to set up the join conditions for the 'mandt' fields in various tables?If anybody could help me setting up the view rightly that would help.

Instead of writing the complex query I went ahead with it.

Thanks.

Santhosh

[jayanthi_jayaraman]

Hi,

For help regarding views,check this link.

http://help.sap.com/saphelp_40b/helpdata/en/4f/991f82446d11d189700000e8322d00/applet.htm

[sergey_korolev]

Hi Santhosh,

Unfortunately you cannot create a database view with cluster tables.