topic Re: Maintenance View in Application Development and Automation Discussions

Maintenance View

Former Member — Fri, 18 Aug 2006 12:10:38 GMT

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.

Re: Maintenance View

Former Member — Fri, 18 Aug 2006 12:12:12 GMT

Hi,

USe SM30 to maintain records.

Cheers

Re: Maintenance View

Former Member — Fri, 18 Aug 2006 12:15:06 GMT

Hi ubedulla,

1 Make sure you have saved and ACTIVATED

the view while creating it.

regards,

amit m.

Re: Maintenance View

Former Member — Fri, 18 Aug 2006 12:15:26 GMT

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

Re: Maintenance View

Former Member — Fri, 18 Aug 2006 12:17:56 GMT

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.

Re: Maintenance View

Former Member — Fri, 18 Aug 2006 12:18:51 GMT

Hi,

Try to re-generate the view.

Cheers

Re: Maintenance View

Former Member — Fri, 18 Aug 2006 12:22:24 GMT

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

Re: Maintenance View

Former Member — Fri, 18 Aug 2006 12:23:07 GMT

Hi again,

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

then TABLE MAINTENANCE generation is a must.

regards,

amit m.

Re: Maintenance View

Former Member — Fri, 18 Aug 2006 12:28:29 GMT

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

Re: Maintenance View

suresh_datti — Fri, 18 Aug 2006 12:29:24 GMT

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

Re: Maintenance View

Former Member — Fri, 18 Aug 2006 12:38:54 GMT

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

Re: Maintenance View

Former Member — Fri, 18 Aug 2006 12:55:26 GMT

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.