topic Re: Reading from a database view in Application Development and Automation Discussions

Reading from a database view

Former Member — Thu, 28 Aug 2008 10:06:08 GMT

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?

Re: Reading from a database view

Former Member — Thu, 28 Aug 2008 10:08:12 GMT

hi Dexter Vaz

chk V_TVKBZ_ASSIGN is active mode or not ?

Regards

Deva

Re: Reading from a database view

Former Member — Thu, 28 Aug 2008 10:13:19 GMT

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

Re: Reading from a database view

Former Member — Thu, 28 Aug 2008 10:19:44 GMT

Can you tell me that query?

Re: Reading from a database view

Former Member — Thu, 28 Aug 2008 10:30:43 GMT

ot it fellas thanks