Application Development and Automation Discussions
Join the discussions or start your own on all things application development, including tools and APIs, programming models, and keeping your skills sharp.
cancel
Showing results for 
Search instead for 
Did you mean: 
Read only

select * from <customizing view>

Former Member
0 Likes
1,201

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.

1 ACCEPTED SOLUTION
Read only

andreas_mann3
Active Contributor
0 Likes
861

Hi,

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

A.

Hi,

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

A.

6 REPLIES 6
Read only

Former Member
0 Likes
861

Hi

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

Read only

andreas_mann3
Active Contributor
0 Likes
862

Hi,

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

A.

Read only

Former Member
0 Likes
861

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.

Read only

Former Member
0 Likes
861

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

Read only

Former Member
0 Likes
861

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

Read only

Former Member
0 Likes
861

Solved on own.