topic Re: Table maintenance in Application Development and Automation Discussions

Table maintenance

Former Member — Thu, 27 Sep 2007 05:27:13 GMT

Hi,

I have a Ztable.I have one entry made into this table through SM30.What I need now is on executing a selection screen I need to obtain the maintenance view of this Ztable in editable mode.On my selection screen I have Companycode and a flag(checkbox).Whatever value I enter in company code, should get reflected in the table maintenance view(field-company code).The flag in the selection screen is to decide whether or not I need the old entries to be displayed.If the flag is checked then the old entries should appear ,otherwise only an editable view should appear.I am using view_maintenance_call for displaying the view.

How do I achieve this functionality?Any pointers or suggestions will be useful.

Thanks,

Vineeta

Re: Table maintenance

Former Member — Thu, 27 Sep 2007 05:34:15 GMT

Hi,

Try to code the functionality in the 'Events' section of table maintenance.

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/abap/how%20to%20implement%20events%20in%20table%20maintenance.doc

Best Regards,

Anjali

Re: Table maintenance

former_member189629 — Thu, 27 Sep 2007 05:43:36 GMT

Vineeta,

Check out this link. A simple how-to guide on table maintenance...

http://allaboutsap.blogspot.com/2007/04/table-maintenance-in-sap-step-by-step.html

Regards,

Karthik

Re: Table maintenance

varma_narayana — Thu, 27 Sep 2007 05:47:44 GMT

Hi..

Let me give u some hints on this...

You can maintain a PARAMETER TRANSACTION for the Table maintenance and call it from ur Selection Screen.

Steps:

1. Create a Z table and Activate - SE11

2. Generate the Table Maintenance using SE54

It will Generate the Function group and Screens.

3. Create a Parameter transaction to Call this Table maintenace program

Goto SE93.

Create a Tcode :

Name : ZTCODE1

Type : Parameter Transaction

In the Attributes of Parameter Transaction

Enter The Transaction SM30

Select the Checkbox : Skip first Screen

Enter the Following Fields below in the Table provide.

<b> FieldName FieldValue</b>

VIEWNAME <YOUR ZTABLE>

UPDATE X

Save the Parameter Transaction and execute it like ant other Tcode..

It will allow you to maintain the Table entries.

SET PARAMETER ID 'BUK' FIELD P_BUKRS.

CALL TRANSACTION '<TCODE>'.

<b>reward if Helpful.</b>

Re: Table maintenance

Former Member — Thu, 27 Sep 2007 06:05:55 GMT

Hi,

I have tried using parameter transaction.It partially fulfills my requirement. When I execute this transaction I get the maintenance view in editable format. I also need the old(existing) entries when the flag in my selection screen is checked.This I am not able to achieve yet :(. How do I proceed to obtain this?