topic Re: select * from <customizing view> in Application Development and Automation Discussions

select * from

Former Member — Thu, 05 Oct 2006 13:57:34 GMT

Hi,

I have a customizing view. I want to select data from that view in a ZREPORT. How can I do that?

report ZREPORT .

select * from zview into it_view.

Compilation error: "ZVIEW" is not defined in the ABAP Dictionary as a table, projection view or database view.

Re: select * from

Former Member — Thu, 05 Oct 2006 14:00:49 GMT

U can use SELECT statament only for the types of table indicated in the error message.

So or you change the view type (projection or database view) of ZVIEW, or you create a new view as copy ut with type projection or database viewo in dictionary or you select the data directly from tables inserted in the ZVIEW.

Max

Re: select * from

andreas_mann3 — Thu, 05 Oct 2006 14:01:24 GMT

Hi,

copy that view as DB-View and select your Z-View

Re: select * from

Former Member — Thu, 05 Oct 2006 14:03:47 GMT

decalre the view using the TABLES statement and then use the select query. Also i think the where condition should be modified as into table itab. Please check.

Re: select * from

Former Member — Thu, 05 Oct 2006 14:05:28 GMT

Hi Harish,

report ZREPORT .

<b>Tables: ZVIEW.</b> -- >add this statement

select * from zview into it_view.

Note: Hope you created ZVIEW already in SE11,else create it and then use in SE38 program.

Mark if it helps you

Thanks

Eswar

Re: select * from

Former Member — Thu, 05 Oct 2006 14:28:49 GMT

HI,

selection is posible for

trasparent,cluster table, projection view or database view.

I assume your view is declared as maintainence view

or help view activate your view and try.

rEGARDS,

Amole

Re: select * from

Former Member — Mon, 27 Nov 2006 11:41:20 GMT

Solved on own.