Maintenance View

[Former Member]

Hi SDN users,

I have a Z TABLE as ZAPQI.

I have created a Maintenance view(ZRM_V_ZAPQI) for this table.

and when I am trying to maintain the View from SE16(Data browser) I am getting an error as "database view is not existing for ZRM_V_ZAPQI” in the status bar.

Please help me how to maintain this view, with out making use of table maintenance generator for the view.

Regards,

U.Khan.

[Former Member]

Hi,

USe SM30 to maintain records.

Cheers

VJ

[Former Member]

Hi Vijay,

I tried SM30, it is giving an error as below

"the maintenance dailog for view(ZRM_V_APQI) is incomplete or not defined".

Please explain in detail.

U.Khan.

[Former Member]

Hi,

Try to re-generate the view.

Cheers

VJ

[Former Member]

Hi Amit,

The views are ACTIVATED.

Hello Anurag,

I know, how to maintain Table maintenance generator for the view.

But I would like to maintain the Maintenance view

With out making use of table maintenance generator.

Cheers.

U.Khan

[Former Member]

Hi again,

1. If u want to use SM30 for maintaining records,

then TABLE MAINTENANCE generation is a must.

regards,

amit m.

[Former Member]

Sorry, I did not get your point as to maintain the Maintenance view without using the table maintenance generator...If not wrong you would need to define a maintenance view before you can change value and SE16 uses the same one as sm30.

Regards

Anurag

[suresh_datti]

I always thought a Maintenance View is for data distributed across different tables.. I doubt if you can use it to maintain a single Table..

~Suresh

[Former Member]

Hi ubedulla,

1 Make sure you have saved and ACTIVATED

the view while creating it.

regards,

amit m.

[Former Member]

U would need to create the maintenance view first for the particular table...you can use SE11 transaction and there is an option in Utilities related to Table maintenance generator.

U would need to assign an authorization group and function group to create the same also pls not you would need to set the attribute of the table to be maintainable.

Regards

Anurag

[Former Member]

Hey,

If you have to maintain entries in just one table

(ZAPQI) then u can directly create a table maintenance for the table ZAPQI.

Maintenance view has to be created if you need to maintain data in multiple tables which are linked via foreign keys. Also after creating a maintenance view you also need to generate a table maintenance dialog for the maintenance view.

Refer the below link for more details:

http://help.sap.com//saphelp_erp2004/helpdata/EN/38/81c1351181b73fe10000009b38f839/frameset.htm

-Kiran

*Please mark useful answers

[Former Member]

Hi,

Yes,

I UNDERSTAND VERY CLEARLY WHY WE WILL MAKE USE OF MAINTENACE VIEWS.

but my client wants to maintain Maintenance views for the database tables.

So, even if we created maintenance views we need to create

the table maintenance generator for maintaining the records.

thanking you all.

U.Khan.