topic Re: Table maintanence generator with tcode in Application Development and Automation Discussions

Table maintanence generator with tcode

shishupalreddy — Tue, 30 Jan 2007 05:41:20 GMT

Hai,

Can you please tell me the procedure to include a selection screen for the existing

table maintenence generator which is having a parameter transaction .

thanks

Re: Table maintanence generator with tcode

Former Member — Tue, 30 Jan 2007 05:45:59 GMT

u have to make use of EVENTS , check tcode SE54.

Regards

Prabhu

Re: Table maintanence generator with tcode

shishupalreddy — Tue, 30 Jan 2007 05:57:22 GMT

hi ,

thanks for the reply ..

can you please tell me the step by step procedure .

and is there any need of specific authorizations to do this

thanks

Re: Table maintanence generator with tcode

shishupalreddy — Tue, 30 Jan 2007 11:32:57 GMT

hai Prabhu,

can you please prvide me more input on the same ....

I mean how to write the piece of code in the given events for TM generator in my case .

Urgent !!!

Thanks

Re: Table maintanence generator with tcode

kiran_k8 — Tue, 30 Jan 2007 11:55:47 GMT

Hi,

Go to SM30 and get the program name.

Prog Name is SAPMSVMA.

Copy this and give a Zname.

Then tyr adding a selection-screen in the code.

Try doing this,if it serves the purpose is served please inform me too.

K.Kiran.

Re: Table maintanence generator with tcode

Former Member — Tue, 30 Jan 2007 12:06:36 GMT

Hi,

go to enviornment -> modification->events..

There u can write ABAP code.

reward if it is use full

Regards,

Sunil

Re: Table maintanence generator with tcode

Former Member — Tue, 30 Jan 2007 12:31:15 GMT

Hey Shish,

Assuming that you are maintaining a table thru table maintenance generator and want to do some checking while saving the table entries,

1. First create a subroutine in your table maintenace generated program.

2. Now go to transaction SE54

3. Mention the table name and go to the Environments ---> Events

4. In the nest screen click new entries

5. Now in the first cell press F4 and select the event after save

6. In the second cell mention the subroutine name that u have created

7. Now while maintaing a table thru SM30 transaction and saving it this subroutine will be called.

8. In this subroutine u can do what ever u want.

Regs,

Venkat Ramanan N

Re: Table maintanence generator with tcode

shishupalreddy — Wed, 31 Jan 2007 04:56:23 GMT

hi all,

Thanks for the replies...

Sorry to say that my purpose is not yet solved ...

My requirement is to add seelction screen for table main generator ...so that user can give his selection criteria to select the data in TM GHenerator instead of all all the data displyed in the normal way ..

thanks

Re: Table maintanence generator with tcode

Bema — Fri, 02 Feb 2007 03:47:06 GMT

Hi ,

You can do it using SQ01 (ABAP query).

Regards,

Beena

Re: Table maintanence generator with tcode

Former Member — Mon, 23 Apr 2007 22:47:51 GMT

Hi shishupal

I have a similar requirement , and i am aware of response to my query ,

but the information seems to be confusing , if you can elabrote on

your point's , it will be gratefull to me , and for sure you will be rewarded

with point

thanks in advance

Re: Table maintanence generator with tcode

Former Member — Tue, 24 Apr 2007 03:25:09 GMT

Hi Shisupal Reddy,

With the help of the table maintenance generator, you are able to maintain the ENTRIES of the table in SM30 transaction.

It can be set in transaction SE11 - Tools - Table maintenance generator.

Table maintanance Generator is used to manually input values using transaction sm30

follow below steps

1) go to se11 check table maintanance check box under attributes tab

2) utilities-table maintanance Generator-> create function group and assign it under

function group input box. Also assign authorization group default &NC& .

3) select standard recording routine radio in table table mainitainence generator to move table

contents to quality and production by assigning it to request.

4) select maintaience type as single step.

5) maintainence screen as system generated numbers this dialog box appears when you click on create button

6) save and activate table

One step, two step in Table Maintenance Generator

Single step: Only overview screen is created i.e. the Table Maintenance Program will have only one screen where you can add, delete or edit records.

Two step: Two screens namely the overview screen and Single screen are created. The user can see the key fields in the first screen and can further go on to edit further details.

SM30 is used for table maintenance(addition or deletion of records),

For all the tables in SE11 for which Table maintenance is selected , they can be maintained in SM30

Sm30 is used to maintain the table ,i.e to delete ,insert or modify the field values and all..

It creates the maintenance screen for u for the aprticular table as the maintenance is not allowed for the table..

In the SE11 delivery and maintenance tab, keep the maintenance allowed..

Then come to the SM30 and then enter the table name and press maintain..,

Give the authorization group if necessary and give the function group and then select maintenance type as one step and give the screen numbers as system specified..

Then create,,,

Then u will able to see the maintenance view for the table in which u can able to insert and delete the table values...

We use SM30 transaction for entering values into any DB table.

First we create a table in SE11 and create the table maintenance generator for that Table using (utilities-> table maintenance generator) and create it.

Then it will create a View.

After that from SM30, enter the table name and Maintain, create new entries, change the existing entries for that table.

Hope this resolves your query.

*************Reward all the helpful answers.

Rgds,

P.Naganjana Reddy

Re: Table maintanence generator with tcode

Former Member — Tue, 24 Apr 2007 04:24:38 GMT

Hi Shishupalreddy,

Table maintenance is used to maintain data in the tables created (ZTABLE)

Generally for inserting new records into custom table thru transaction SM30, we need to enter all the values manually and save the record.

When certain data for the key fields needs to be populated automatically while creating entries, the steps involved are:

Maintaining the subroutine in view V_TVIMF for a particular custom table.

Logic for extracting relevant data for the fields entered, when user press enter button.

Check this blog for more information on extracting data in table maintenance.

/people/sudheer.cheedella/blog/2006/02/20/extracting-data-in-table-maintenance

check these links --

http://help.sap.com//saphelp_470/helpdata/EN/a7/5133ac407a11d1893b0000e8323c4f/frameset.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

http://help.sap.com/saphelp_nw04/helpdata/en/cf/21ed2d446011d189700000e8322d00/content.htm

http://help.sap.com/saphelp_46c/helpdata/en/a7/5133ac407a11d1893b0000e8323c4f/frameset.htm

/message/2831202#2831202 [original link is broken]

For further help look into these links

http://help.sap.com/saphelp_46c/helpdata/EN/cf/21eb6e446011d189700000e8322d00/frameset.htm

http://help.sap.com/saphelp_bw30b/helpdata/en/69/c2516e4ba111d189750000e8322d00/content.htm

Hope this resolves your query.

<b>Reward all the helpful answers.</b>

Regards

Re: Table maintanence generator with tcode

Former Member — Tue, 20 Nov 2012 06:24:28 GMT

Hi experts,

even i have requirement similar to above case...

During display i want to restrict values in output by passing parameter value.

How can we achieve it.

once i open Tcode pop will come for inputs,next it willl display data based on inputs .

Moderator Message - Create a new query for your requirement, do not use an old one.

Message was edited by: Suhas Saha

Re: Table maintanence generator with tcode

shishupalreddy — Tue, 20 Nov 2012 08:44:05 GMT

Hello Uma,

I think i have done this requirement long time ago ....please follow the below steps to achieve the same .

- Create executable program with the requried selection parameters .

- Within AT selection-screen event trigger the Parameter transaction created for the table view which must be created in SE93 - Tcode type -- Parameter transaction .

- Within PBO of the screen of TMG within the respective function group of the table view have a user defined module to filter the data in accordance with the selection screen input values .

- Within PBO of function group pleae make use of EXTRACT and TOTAL (Not sure please check ) tables where you can find the complete table view data , apply filter on these and modify these tables by making use of offset values as the data is stored in the form of string in these .

Hope this helps ,

Thanks

Shishupal.

Re: Table maintanence generator with tcode

Former Member — Tue, 20 Nov 2012 10:29:31 GMT

Hello Shishupal,

Thanks for your prompt reply.....it's working fine!

Re: Table maintanence generator with tcode

shishupalreddy — Tue, 20 Nov 2012 10:36:18 GMT

Good to hear that . Thanks