topic Re: Maintainence View in Application Development and Automation Discussions

Maintainence View

Former Member — Tue, 29 Jul 2008 08:50:45 GMT

I have created a Maintainence View for a custom table in SE11. I have created a Transaction Code in SE93 which points to this Maintainence View , while doing this I have chosen the Trasaction Type as "Transaction with Parameters ( Parameter Transaction )". But now we have got a requirement to disable the "Display/Change Button" in the Maintainence View, that is it can only display but no maintainence. I thought I will customize this transaction by going to SHD0 and create a Screen Variant, but its saying " Variants are possible only for dialog transactions".

Can someone pls suggest any workaround for this.

Re: Maintainence View

Former Member — Tue, 29 Jul 2008 09:08:43 GMT

hi,

Maintenance View - A maintenance view is used to maintain data for an object that is technically distributed on several tables. Maintenance views offer easy ways to maintain complex application objects.

Data distributed on several tables often forms a logical unit, for example an application object, for the user. You want to be able to display, modify and create the data of such an application object together. Normally the user is not interested in the technical implementation of the application object, that is in the distribution of the data on several tables.

Maintenance views enable a business-oriented approach to looking at data, while at the same time, making it possible to maintain the data involved. Data from several tables can be summarized in a maintenance view and maintained collectively via this view. That is, the data is entered via the view and then distributed to the underlying tables by the system.

For your question about creating maintenance view, please refer below link:

Creating Maintenance View

And in Maintenance View you can use mainstatus Tab

under this Tab Access level u can use read only .

regards

Ranveer.

Re: Maintainence View

Former Member — Tue, 29 Jul 2008 11:19:43 GMT

Thanks Ranveer for that detailed reply but...u said "refer the link Creation of Maintainence View"...by that do you mean SM30??

In SM30 I have not found any Tab you are talking about. Please Clear.

Re: Maintainence View

former_member70391 — Tue, 29 Jul 2008 11:28:36 GMT

Hi Dagny,

Go to SE11-> View, enter the view name and click on Change button.

Go to Maintain Status Tab in the screen and make it read only. Activate it.

it will work.

or Create Variant for Maintenance view via SE54.

http://help.sap.com/saphelp_nw04/helpdata/en/5a/0c88924d5911d2a5fb0000e82deaaa/content.htm

Thanks & regards,

nagaraj kalbavi

Re: Maintainence View

Former Member — Tue, 29 Jul 2008 12:56:54 GMT

Nagaraj

Do you mean...I need to go to the tab Delivery and Maintainence and in that choose DataBrowser Table View Maintainence as "Display/Maintainence Not Allowed"???

But in my case, they want to maintain the data, but they want a Display Only View too. They actually want two separate Custom Transaction Codes created for this.

Please let me know if this is possible at all?

Thanks

Re: Maintainence View

former_member70391 — Tue, 29 Jul 2008 14:09:02 GMT

Hi Dagny,

You have 5 tabs

1. Attributes

2. table Join/ Conditions

3. View Firleds

4. Selection Condition

5. Maint. Status

It is available in the initial screen with Maint. Status. Where in the Data Browser/Table View Main you have options called "Display//Maint. Allowed" and 'Allowed with restriction'. An also you will following options in the same screen

Access:

1. Read Only

2. read, Change, Delete, insert

3. read and Change

4. read & change(Time specific Views)

I am currently working in SAP ECC 6.0. I think it is not available for you in instead you have one more options in Data Browser/Table View Main like Display/Change Not Allowed.

Or lese go through the link I provided and try to create a variant for the view via SE54 where the 4 options what I provided can be created. But in this case also I think it wont be available for it seems.

or Create Variant for Maintenance view via SE54.

http://help.sap.com/saphelp_nw04/helpdata/en/5a/0c88924d5911d2a5fb0000e82deaaa/content.htm

Thanks & Regards,

Nagaraj Kalbavi

Re: Maintainence View

Former Member — Tue, 29 Jul 2008 14:58:01 GMT

What is the TCode you are talking about? I am Sorry, I have not found any of the tabs you are talking about neither in ECC 6.0 or 4.7 Version. Please mention the TCode.

Re: Maintainence View

former_member70391 — Tue, 29 Jul 2008 15:16:13 GMT

Hi Dagny,

It is in Transaction Code SE11.

1. Go to Transaction Code SE11

2. En ter The view Name say ZTEST01

3. Click on Change Button

4. There are several tabs ike attributes etc. Select the Tab maint. Status.

Or try this way,

create view via SE11-> Enter The view Name-> Click on Create. Hopefully you can see the Tab Maint. View. There make access read Only.

Thanks & Regards,

Nagaraj Kalbavi

Re: Maintainence View

Former Member — Tue, 29 Jul 2008 17:34:40 GMT

Hi Dagny,

For this you can explore events

SE11 -> Utilities -> Table maintenance generator -> Environment -> Modifications -> Events

maintenance generator events can be used to control the behavior of during table maintenance. You can loop the screen fields there and set them to display only based on your logic.

Re: Maintainence View

Former Member — Wed, 30 Jul 2008 07:12:05 GMT

I think what you guys are talking about is a View formed out of two to three tables. But in my case I am creating it only for a Single table.

See the scenario is this :

1) Created a transaprent table.

2) To Maintain the data in this table ( To Add/Delete the Records) we have created a maintainance View in SE11 which has the same name as the table.

3) Now we can Maintain data for this table giving the view name in SM30.

4)Initially we had created two TCodes . One TCode will point to SE16n for this table where we can View the data ( Here we have removed the View Maintainence Button so that the user can only View but cannot maintain any data ). The other TCode will poin to SM30 where we can maintain the data.

5)In order to View the data in SE16N we need to enter some selection criteria, right? But the user doesnt want to enter, he directly wants to view all the records something similar to SM30 Screen, but without Maintainence ( that is without Change Button on the Application Toolbar).

What I had done:

I opened SE93. Created a TCode pointing to SM31 which is a Transaction Type with parameters. Then I thought I would create a Screen Variant in SHD0 for this TCode and in that Variant I will remove the Change button. But the moment I am clicking the Create Button in SHD0 for this TCode, its giving Error saying "Screen Variant can only be created for Dialog Transaction" because this TCode is Transaction with Parameters. So I am clueless as to what to do or whether what the user wants can be done at all.

I hope now the scenario is clear. Please just let me know whether it is possible or not and if its possible..then how?

Thanks in Advance.

Re: Maintainence View

Former Member — Wed, 30 Jul 2008 07:35:15 GMT

Why don`t you create a single screen transaction so as soon as user enters that Tcode for example Ztcode,you can select all the records of that table in PBO and display them.

Regards

Neha

Re: Maintainence View

former_member70391 — Wed, 30 Jul 2008 08:09:00 GMT

Hi Dagny,

Please provide me your email id so that I can show you in my system.

As I can display the data in SM30 without Change/Display Button. It is possible.

Now try this,

1. Create anew maitenance view for the table via SE11

2. Enter the view name and click on Create Button

3. Select Maitennace View radio button, Enter the Description and table name Say VBAK.

4. Now in your screen you have 5 tabs,

Attributes, table/Join Conditions, View Fields, Selection Conditions and Last one is Maint. Status.

Goto tab Maintainance Status and Choose the radio button as Read Only and Data Browser/Table View Mai as Display/ maintennace Aloowed. generate the view from Menu as you did earlier.

Now go to SE93 and create new Transaction code for the view.

I did several times in the system and it will not show Change/Display button in the SM30 view.

Thanks & Regards,

Nagaraj Kalbavi

Re: Maintainence View

former_member70391 — Wed, 30 Jul 2008 10:09:31 GMT

Hi Dagny,

Please go through the thread , I already answered this thread for similar issue and got worked.

Thanks & Regards,

Nagaraj Kalbavi

Re: Maintainence View

Former Member — Wed, 30 Jul 2008 13:25:10 GMT

The following link would be helpful

http://help.sap.com/saphelp_nw04/helpdata/en/5a/0c88924d5911d2a5fb0000e82deaaa/content.htm

Re: Maintainence View

Former Member — Wed, 30 Jul 2008 14:10:18 GMT

Thanks a lot Nagaraj and others too