topic Regarding Table maintainace generator in Application Development and Automation Discussions

Regarding Table maintainace generator

Former Member — Thu, 14 Jun 2007 18:31:58 GMT

Frnds,

Hope all are doing good.

I am recently working on ECC 6.0 and i want to create table maintainance generator for a ztable. Actually i hav created function grp and passed in sm30 transaction and used single screen. Problem is when i double clicking the screen number its going to se 51 and going to a standard progam named with function grp

SAPLZNEWFUNCTION. From i m confused but in that already some standard code is maintained. But there i hav created screen comprising our ztable fields..

From there i m confused .. how to link with ztable and how to create standard transaction for entering data into that screen and updating the ztable.

Frnds i hav seen so many documents .. i dont need documents ..plzz guide me with proper steps for achieveing target.

thanking u all for reading my doubt and acting on it.

regards,

karan

Re: Regarding Table maintainace generator

Former Member — Thu, 14 Jun 2007 18:48:05 GMT

Any suggestions or steps regarding this thread...

regards,

karan

Re: Regarding Table maintainace generator

uwe_schieferstein — Thu, 14 Jun 2007 19:03:57 GMT

Hello Karan

The procedure for creating a maintenance view and transaction is as following:

(1) Define your function group for the maintenance screens

(2) Create a maintenance view (with single or two screens) for your table using the maintenance generator (I always explicitly create a maintenance view for my z-tables).

(3) Create a parameter transaction (e.g. using transaction SE93) with the following parameters:

- Default for Transaction = SM30

In the table control at the bottom add the following values:

- VIEWNAME = '<name of your view or table>'
- UPDATE = 'X'

For more details refer to:

<a href="http://help.sap.com/saphelp_nw2004s/helpdata/en/43/0f955bc2086ff3e10000000a422035/content.htm">Parameter Transactions</a>

Regards

Uwe

Re: Regarding Table maintainace generator

Former Member — Fri, 15 Jun 2007 04:51:13 GMT

Frnds can anyoen give more conclusive steps...

still finding problem o get solution.

thnks&regards,

karan

Re: Regarding Table maintainace generator

Former Member — Fri, 15 Jun 2007 04:53:36 GMT

HI,

check this link to create a transaction for the ztable

http://www.sap-img.com/abap/create-a-table-maintance-program-for-a-z-table.htm

Thanks

Naren

Re: Regarding Table maintainace generator

Former Member — Fri, 15 Jun 2007 04:56:19 GMT

Check this link for creating a transaction code for a TM

http://www.sap-img.com/abap/create-a-table-maintance-program-for-a-z-table.htm

Please go throught below link ..... it was given with screen shots of the T.code Creating for the table after the maintaince view had been created ......

http://www.sapdevelopment.co.uk/tips/tips_tabmaint_tcode.htm

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

Reward points for useful Answers

Regards

Anji

Re: Regarding Table maintainace generator

Former Member — Fri, 15 Jun 2007 05:13:35 GMT

Here is the steps for making table maintaince generator ...

Creating Maintenance Views

Procedure

1.Enter an explanatory short text in the field Short text.

You can for example find the view at a later time using this short text.

2.Enter the primary table of the view under Tables in the Tables/Join conditions tab page.

Only those tables that are linked with the primary table (indirectly) with a foreign key can be included in the maintenance view.

3.If required, include more tables in the view. In a maintenance view you can only insert tables that are linked to one another with foreign keys.

Place the cursor on the primary table and choose Relationships. All existing foreign key relationships of the primary table are displayed. Select the required foreign key and choose Copy. The secondary table used in such a foreign key is included in the view. The join conditions derived from the foreign keys (see Foreign Key Relationship and Join Condition) are displayed.

You can also insert tables that are linked by foreign key with one of the secondary tables that was already inserted. To do this, place the cursor on the secondary table and choose Relationships. Then proceed as described above.

For maintenance and help views, there are certain restrictions on the foreign keys with which the tables can be included in the view (see Restrictions for Maintenance and Help Views). The foreign keys violating these conditions are displayed at the end of the list under the header Relationships with unsuitable cardinality.

4.On the View fields tab page, select the fields that you want to copy to the view.

Choose Table fields. All the tables contained in the view are displayed in a dialog box. Select a table. The fields of the table are now displayed in a dialog box. You can copy fields by selecting them in the first column and choosing Copy.

All key fields of the primary table must be included in a maintenance view. In addition, all key fields of secondary tables that are not involved in the foreign key (that is, which are not linked via a join condition to a key field already included in the view) must be included in the view.

This ensures that the records inserted with a maintenance view can be written correctly in the tables contained in the view.

5.On the Selection conditions tab page, you can (optionally) formulate restrictions for the data records that can be displayed with the view (see Maintaining Selection Conditions for Views).

The selection conditions define the data records that can be selected with the view.

6.In the Maintenance status tab page, define the maintenance status of the view.

The maintenance status defines how you can access the view data with the standard maintenance transaction (SM30).

7.Choose activate

8.Go to Transaction SE54 with Environment ® Tab.maint.generator.

From the view definition you can generate maintenance modules and maintenance interfaces that distribute the data entered with the view to the base tables of the view. You can find more information in Creating a Maintenance Dialog.

here is the link for creating Tcode .

http://www.sapdevelopment.co.uk/tips/tips_tabmaint_tcode.htm

Girish