Application Development Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 

using a view

Former Member
0 Kudos

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

2 REPLIES 2

jayanthi_jayaraman
Active Contributor
0 Kudos

sergey_korolev
Active Contributor
0 Kudos

Hi Santhosh,

Unfortunately you cannot create a database view with cluster tables.