topic Re: Create display-only view in Application Development and Automation Discussions

Create display-only view

Former Member — Tue, 06 Nov 2007 09:59:08 GMT

Hi guys,

I'm trying to create a table view transaction to an ODS / DSO table in BW.

I'm assuming the same steps, -> table maintenance generator,

but I'm not very sure since this is supposed be a display only view.

Any suggestions?

Kevin

Re: Create display-only view

Former Member — Tue, 06 Nov 2007 10:04:55 GMT

U need not go to table maintenence generator. Go to SE11 and in delivery/maintenence attributes specify maintenence not allowed. then only display will come.

Message was edited by:

Rama Jyothi

Re: Create display-only view

Former Member — Tue, 06 Nov 2007 10:12:22 GMT

Importance/Use of Views

Data for an application object is often distributed on several database tables. Database systems therefore provide you with a way of defining application-specific views on the data contained in several tables. These are called views.

Data from several tables can be combined in a meaningful way using a view (join). You can also hide information that is of no interest to you (projection) or only display those data records that satisfy certain conditions (selection).

A view is a logical view on one or more tables, that is, a view is not actually physically stored, instead being derived from one or more other tables.

The data of a view can be displayed exactly like the data of a table in the extended table maintenance.

Re: Create display-only view

Former Member — Tue, 06 Nov 2007 10:35:41 GMT

Thanks guys,

The SE11 Database projection view creation slipped my mind.

I've created a display only view in SE11, but now i need to link it to a custom transaction code.

I create a trnasaction code in Se93, I'm not sure to select either

- Program and screen (dialog transaction)

- Progran and selection screen (report transaction)

from the looks of the generated view program in SE80, it looks like a dialog program.

Anyway here are the results.

When i run the transaction created for a dialog trnasaction, it shows the selcetion fields of the view. When clicking F8, it doesn't show me results but brings me back to the SAP easy access menu. Why?

When I run the transaction created for a report

I get to the selection screen fields, press F8, but the screen doesn't change.

I'm very sure there are values in this table.

any idea?

Now I can access the view with selection fields using the transactio but when executing it it does not show me any values.

Re: Create display-only view

Former Member — Tue, 06 Nov 2007 10:38:58 GMT

for this when ur creating the TCODE there will be 3 check boxes available in that blow in that screen

select that check boxes

then this problem won't face again

use Program and screen (dialog transaction)

this one only

<b>REward if useful</b>

Re: Create display-only view

Former Member — Tue, 06 Nov 2007 10:58:47 GMT

I've checked the 3 checkboxes and used "Program and screen (dialog trnasaction)"

but it still does not work.

After running the transaction and pressing F8 it quits to SAP menu when pressing F8

Re: Create display-only view

Former Member — Tue, 06 Nov 2007 11:10:14 GMT

i got the same problem once

for me it occured for report

for my report i had selected that dailog programing option . then at that time it acted in the same as ur getting

then at that time i had changed that option aa for report program than it executed sucessfuly

so what i am mean to say is . that option is not correct for ur program so plz change it once and use that report program option i think it may succed

<b>reward if usefull</b>