topic Re: View in Application Development and Automation Discussions

View

Former Member — Thu, 22 Feb 2007 14:05:01 GMT

Hi!

I get the message "All fields are evaluated as key field "

while trying to activate a view. Is that OK?

Is a view generally empty or not.

My view is empty I don't know why.

I try to edit this view with TA SE16

and the number of entries is just 0.

Reagrds

Ilhan

Re: View

Former Member — Thu, 22 Feb 2007 14:09:48 GMT

Ilhan,

You probably have a mistake there, in the definition of the view.

The view is empty if the join condition on the transparent tables that compose the view is not defined well.

The message you receive, "All fields are evaluated as key field " seems to be related to this, and might be an argument that my supposition is true.

BR,

Bogdan

Re: View

Former Member — Thu, 22 Feb 2007 14:11:22 GMT

normally we create a view to join 2 or more tables and in configuration assign it at appropriate place so that when a transaction is run the various fields data gets inserted into this view...as ur view is empty be that ur view has not been configured at the appropriate place for filling the data.

Re: View

Former Member — Thu, 22 Feb 2007 14:35:42 GMT

Bogdan,

meanwhile I have changed some joins to say it better I have removed

some joins to see whether it takes an effect but regrettably it doesn't

do that.

Is ist so difficult to create a view ?

Reagrds

Ilhan

Re: View

Former Member — Thu, 22 Feb 2007 14:38:36 GMT

Double click on the warning. The long text will give you more information.

Rob

Re: View

Former Member — Thu, 22 Feb 2007 14:44:09 GMT

Ilhan,

Just for exercise, create a view on the tables

VBAK (sales order headers) and VBAP (sales order items)

and use, as the only join field, the VBELN (sales order number).

This is enough for a simple and illustrative join.

If you don't get any data then you should see if this client (MANDT) indeed contains any data in the source tables at all... (you can check this, ofcourse, with SE16)

BR,

Bogdan