maintanance view

[Former Member]

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.

[Former Member]

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.

[Former Member]

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.

[Former Member]

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

[Former Member]

Hi,

Check these threads.

Hope this helps.

-Priyanka.

[Former Member]

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

[Former Member]

Hi Kumar,

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

Regards,

Ramki.

[ulrich_frenzel]

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