Reading from a database view

[Former Member]

Im trying to read data from V_TVKBZ_ASSIGN view using the query *select * from V_TVKBZ_ASSIGN into zV_TVKBZ_ASSIGN where VKORG = gs_bapikna102_gwa-SALESORG VTWEG = gs_bapikna102_gwa-DISTR_CHAN SPART = gs_bapikna102_gwa-DIVISION.*

endselect.

However i get the error message " V_TVKBZ_ASSIGN" is not defined in the ABAP Dictionary as a table,projection view, or database view.

How do i go ahead with this query?

[Former Member]

hi Dexter Vaz

chk V_TVKBZ_ASSIGN is active mode or not ?

Regards

Deva

[Former Member]

Since V_TVKBZ_ASSIGN is a maintenance view you can't write select query for that. For select query it should be a database table or database view or projection view . Better you can write the select query for underlying tables of that view like

TVKBZ

TVBUR

TVKO

TVKOT

TVKBT

TASSIGN_SD_VKORG

TVKOS

TVKOV

TVTW

TSPA

TVTWT

TSPAT

[Former Member]

Can you tell me that query?

[Former Member]

ot it fellas thanks