topic Re: maintanance view in Application Development and Automation Discussions

maintanance view

Former Member — Fri, 22 Dec 2006 07:12:43 GMT

hi experts,

Please clarify my following doubts.All helpful answers to be awarded.

How to add the values into a maintanance view?

How to extract the data from a maintanance view? I want to pick up a value of a field for a given condition from a maintanance view.Is it possible to pick up the values from a maintanance view? If so, how?

explain me in detail. Its a bit urgent.

Thanks in advance.

Regards,

Ramesh.

Re: maintanance view

Former Member — Fri, 22 Dec 2006 08:10:48 GMT

Hi Ramesh,

Maintenance view like your normal view.

You can do all insert,select operation same as table.

use the same name which you are giving in sm30 for maintenance view.

e.g.- your view name is ZVIEW.

select will be as follows:

select * from ZVIEW into table l_t_ZVIEW.

Re: maintanance view

Former Member — Fri, 22 Dec 2006 08:15:36 GMT

Hi ramesh,

To add values in the table maintenance, you can go to sm30 and maintain there.

To get the values, you can simpley write a select statements as you would normally do over a database view or a table as Shefali has already suggested.

Regards,

ravi

Re: maintanance view

Former Member — Fri, 22 Dec 2006 09:50:24 GMT

Hi,

Check these threads.

Hope this helps.

-Priyanka.

Re: maintanance view

Former Member — Fri, 22 Dec 2006 09:53:42 GMT

1. Select the particular table in transaction SE11.

2. Press Change button

3. Use the menu Utilities->Table Maintenance Generator

4. Give Authorization code (&NC&)

5. Give Functiongroup (can be created using SE80)

6. Maintenance type (one step)

7. Click the find Scr number and ask the system to propose the number.

8. Save the same and activate

If you want to enable users to enter and edit DB table entries you must provide them with a maintenance view. The user can call transaction SM30 with the maintenance view and then modify the corresponding table.

When you generate a maintenance view for a table the SAP system generates function modules and dynpros that are collected in a function group. Thus, in order to generate a maintenance view you must tell the SAP system the function group.

Relevant transactions are:

- SE11

- SE54

- SM30 (View Maintenance)

- SM34 (View Cluster Maintenance)

Please check out the following links also . There are already a lot of threads regarding this

http://help.sap.com//saphelp_470/helpdata/EN/a7/5133ac407a11d1893b0000e8323c4f/frameset.htm

http://help.sap.com/saphelp_46c/helpdata/EN/cf/21eb6e446011d189700000e8322d00/frameset.htm

http://help.sap.com/saphelp_bw30b/helpdata/en/69/c2516e4ba111d189750000e8322d00/content.htm

check this link, there is a lot of info on table maintenance in this site:

http://fuller.mit.edu/tech/view_clusters.pdf

Award Points

Re: maintanance view

Former Member — Sat, 23 Dec 2006 09:47:55 GMT

Hi Kumar,

You can add values to your maintenance view as long as it supports. i.e., Maint. view has different Access status like i. read only, ii. read, change, delete and insert etc (Check the status in Maint. Status Tab). If the maintenance view has Table Maintenence Generator screen, you can directly maintain values using Tx. SM30

Regards,

Ramki.

Re: maintanance view

ulrich_frenzel — Wed, 27 Dec 2006 15:53:45 GMT

Hi Ramesh,

to add values: use transaction SM30

to extract them: Please note that a maintenance view is not a database object like a database view, thus a statement like

SELECT * FROM <maintenanceview>...

wont work. So you need to access the tables the maintenance view consists of.

Kind regards

Ulrich