How to select data from a view (V_5UBI_B)

[Former Member]

The following SELECT won't compile. The compiler gives the message "'V_5UBI_B" is not defined in the ABAP Dictionary as a table, projection view or database view". I can run SE11 and enter it as the name of a view and pull it up so I'm obviously missing something.

SELECT SINGLE ercst
    INTO (p_covered_rate_out)
    FROM V_5UBI_B
    WHERE barea = '01'
      AND bplan = p_bplan_in
      AND bcost = '0001'.

[Former Member]

hi,

V_5UBI_B is a Maintainence view and we cannot fetch the data from maintainence view using select statements

[Former Member]

You don't need the view - just SELECT from table T5UBI.

Rob

[Former Member]

hi,

do this way ..

SELECT  ercst up to 1 rows 
    FROM T5UBI
    INTO (p_covered_rate_out)
    WHERE barea = '01'
      AND bplan = p_bplan_in
      AND bcost = '0001'.
ENDSELECT.