read data from maintenance view
could anyone please tell me if there is any special way to read data from a maintenance view (if at all it is possible).
i wrote a simple select on it but it gave me a syntax error that the view is not defined in the dictionary. (i am able to see the view definition by double clicking and it is active too).
the following is my select.
select single lgnum from v_t320 into (w_lgnum) where werks eq p_i_werks and lgort eq p_i_lgort.
Rich Heilman replied
Well, if you try to do a select against a maint. view, the syntax check will yell at you about, saying that it needs to be a table, database view or projection view. The documentation which you speak of is mostly likly talking about the user interface to the view. Again, I would suggest reading the underlying table directly. The maintenacne view is only used for the table maintenance program.