maintenace view

[Former Member]

i need to fetch the maintenance view data using

IF i_vttk[] IS NOT INITIAL.

SELECT route

vsart

vsavl

vsanl

tdlnr

fahztd

distz

medst

allowed_twgt

from V_TVRO_COM

INTO TABLE i_v_tvro_com

FOR ALL ENTRIES IN i_vttk

WHERE route = i_vttk-route

AND vsart = i_vttk-vsart

AND vsavl = i_vttk-vsavl

AND vsanl = i_vttk-vsanl

AND tdlnr = i_vttk-tdlnr

AND fahztd = i_vttk-fahztd

AND distz = i_vttk-distz

AND medst = i_vttk-medst

AND allowed_twgt = i_vttk-allowed_twgt.

ENDIF.

but i am getting errors that V_TVRO_COM is not a table or projection view or database view in se11, cont we selec the data direclty from maintenace view .

[Former Member]

No you can't. You can only select from Projection View/Database View. The solution is you can create another view in the same structure as the maintenance view and use it.

Reward all useful answers! Lest your questions be ignored!

Cheers,

Sam

[Former Member]

YO uget the same data from TVRO table also.

IF i_vttk[] IS NOT INITIAL.

SELECT route

vsart

vsavl

vsanl

tdlnr

fahztd

distz

medst

allowed_twgt

from <b>TVRO</b>

INTO TABLE i_v_tvro_com

FOR ALL ENTRIES IN i_vttk

WHERE route = i_vttk-route

AND vsart = i_vttk-vsart

AND vsavl = i_vttk-vsavl

AND vsanl = i_vttk-vsanl

AND tdlnr = i_vttk-tdlnr

AND fahztd = i_vttk-fahztd

AND distz = i_vttk-distz

AND medst = i_vttk-medst

AND allowed_twgt = i_vttk-allowed_twgt.

ENDIF.

Regards,

Ravi