‎2007 Feb 22 2:05 PM
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
‎2007 Feb 22 2:09 PM
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
‎2007 Feb 22 2:35 PM
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
‎2007 Feb 22 2:44 PM
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
‎2007 Feb 22 2:11 PM
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.
‎2007 Feb 22 2:38 PM
Double click on the warning. The long text will give you more information.
Rob