topic Re: table maintainance in Application Development and Automation Discussions

table maintainance

Former Member — Wed, 14 Feb 2007 02:09:42 GMT

hi experts,

what is table maintainance

Thanks in advance

Re: table maintainance

Former Member — Wed, 14 Feb 2007 02:16:26 GMT

Hi,

table maintanance Generator is used to manually

input values using transaction sm30

follow below steps to create one:

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& .

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

using sm30 you can create entries manually.

also check below thread to assign transaction code to

table generator

create transaction use se93

select parameter transaction and give below attributes

Transaction code ZTX1

Transaction text Maintain View ZSDCZTVIEW

Transaction SM30 Screen 0

From module pool

Name of screen field Value

VIEWNAME = ZSDCZTVIEW

UPDATE = X

IN Table view u can give ur table name and for function group give any name eg: table name itself

give default authorization object &NC&

Thanks

Re: table maintainance

Former Member — Wed, 14 Feb 2007 02:48:20 GMT

Samanvi,

Open SAP tables for direct maintenance

1. SE11 enter table name

2. Go to Attributes tab

3. Change the delivery class to 'L'

4. Follow the path Utilities -> Table maintenance generator

5. Change the recording routine ( bottom of the screen) to NO, or user.

6. Activate the table, do NOT recreate the table maintenance routines

Create Parameter transaction for SM30

Assuming that you want the user to maintain a table or view using SM30 but you do not want them to see the initial screen of SM30. For e.g. V023 - Material Group.

Steps tested in 4.6x :-

SE93 - Type in a transaction name e.g. ZV023

Click create - choose parameter transaction

In the Create Parameter transaction screen, fill in the following fields :-

Transaction SM30

Tick Skip initial screen

Tick Inherit GUI attributes

Name of screen field Value

VIEWNAME V023

UPDATE X

Press F8 or click the Test button for testing.

Save it and with the required authorization, the user will be able to use transaction code ZV023 to maintain the material group

have a look here:

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

Pls. mark if useful

Re: table maintainance

Former Member — Wed, 14 Feb 2007 03:01:05 GMT

Hi Samanvi,

here I am giving the information which I collected

Table Maintenance Generator:

Table Maintenance is used to maintain the values of a custom table. Based on your requirements, you may want to change or add/delete the contents of your table.

Table Maintenance generator is required to do Manual entries in the Table. If the requirement is to update the table only programmatically and not manually then table maintenance generator is not required. Manual entries in table can be maintained (New record can be inserted / existing can be modified) using transaction SM 30, if the table maintenance for the table is generated.

The procedure for table maintenance is:

1) Go to se11 and type the table name in Display or change mode.

2) Using the menu path Utilities -> Table Maintenance Generator. Table maintenance is generated.

3) To be able to maintain your table using a transaction (using a transaction for table maintenance dialog), you need to do the following.

•Create a new transaction of the type “Parameter Transaction” from SE93, specifying SM31 as the transaction.

•The VIEWNAME parameter is set to your table name with the option ‘Skip initial Screen’ set.

•The UPDATE parameter is set to value ‘X’.

There are two type of table maintanance generators

1) )One step 2) Two step

One Step :

Only one maintenance screen is processed during extended table maintenance. The entries are displayed in list form on this screen.

Two Step : Two maintenance screens are processed during the extended table maintenance:

Create a t-code for table maintanance

Follow these steps :

1. go to transaction SE93 , give your own transaction code say ztran_tab, for maintaining your ztable.

2. Click on create button and check the radio button Transaction with parameters (PARAMETER TRANSACTION) and click on the tick button.

3. In the next screen enter default values:

transaction : SM30

check the check box skip initial screen

4. Scroll down you will find a table control for default values

Name of the screen field | value

VIEWNAME | your ztable name

SHOW | X

Save your work.

Now as you have created a custom transaction for maintaining your ztable this transaction can be called from any program with CALL transaction 'XXX'.

If you find it useful mark the points

~~Guduri

Re: table maintainance

Former Member — Wed, 14 Feb 2007 03:03:43 GMT

Hi Samanvi,

Table maintenace generator.

To Maintain the data through SM30(View maintainance) for updating database tables.

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

some more info....

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.

check these for further help.

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

http://help.sap.com/saphelp_46c/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

Regards,

Priyanka.

Re: table maintainance

Former Member — Wed, 14 Feb 2007 04:33:48 GMT

Hi TMG is defined in SAP to create multiple records in the database at a same time .

U can delete, update and create records from here , how ever this all functions are not available in SE11 or Se16..

Please let us know, if u have any specific requirement on this .

Thanks.

Re: table maintainance

sreeramkumar_madisetty — Wed, 14 Feb 2007 04:46:30 GMT

Table Maintainance Genarator is defined in SAP to maintain the records in the database .

U can delete, update and create records from here , how ever this all functions are not available in SE11 or Se16..

You can customize the table settings also using Table Maintanance genaretor using sm30 tc.

Please let us know, if u have any specific requirement on this .

Regards,

kumar

Re: table maintainance

Former Member — Thu, 15 Feb 2007 04:46:04 GMT

thanks every body for ur replies