topic Re: table maintanace generator in Application Development and Automation Discussions

table maintanace generator

Former Member — Mon, 03 Dec 2007 03:52:00 GMT

what is the significance of tmg.

Re: table maintanace generator

Former Member — Mon, 03 Dec 2007 04:13:43 GMT

Hi,

To Add/Change/Delete entries of the particular table which has a tmg, Even u can assign a t-code for the particular table, The purpose is in customization , for eg u can see that in SPRO t-code , table have tmg.

regards,

Santosh Thorat

Re: table maintanace generator

Former Member — Mon, 03 Dec 2007 04:23:42 GMT

Hi Shankar,

Good morning,

Please go through,

Table maintanance is for creating,adding datas to an existing table.

it is for adding muiltiple records at a time in the table

A table can be manipulated by a program or manually.

When creating table, you will find a check box 'Table maintenance allowed'. If we

check that option, we can manually enter entries using SE16 or table

maintenance generator screen.

SE16 is for data browser.

Go to SE11, give the table name and click on change. Then Go to utilities--> Table

maintenance generator.

In the table maintenance generator screen, we should give Authorization Group,

Function Group name (Function Group name can be same as table name),

Maintenance type can be one step or two step, usually we will create with one

step. we should give maintenance screen number. After clicking on create button,

a table maintenance generator will be created.

To check it go to SM30 . In SM30, we find display, Maintain options.

We can view the table contents by choosing Display and we can create table

entries by choosing Maintain.

In the production system, end-users will not be having access to transaction

codes like SE11 and SE16. Developers will not be having access to many

transaction codes including the above two.

To view the contents of the database table, we will use SE16n in Production

system. Please find out the difference between SE16 and SE16n.

All these authorizations will be maintained by BASIS team, by creating access

profiles.

So in order to edit or create the contents of a database table, we should go for

table maintenance generator. In real time, authorizations will be maintained in

production system. (even in development and Test systems to some extent).

There is an audit like Sarbanes-Oxley Act for American clients, where every thing

will be audited by government agency. To know more about SOX, use the links on

the right hand side of this page.

The second reason is, we can edit or create multiple entries at a time, using table

maintenance generator.

Apart from that we have options like 'Enter conditions' in table maintenance

screen SM30. Please try to find out the use of those, by creating an example.

Table Maintenance generator: Difference between one step and two steps.

While creating table maintenance generator, we find below options:

When we choose one step, we have to give the screen number in Overview Screen field.

When we choose two step, we have to give both overview screen number and single screen number.

You can give any number for screen. Don’t give 1000 screen number. As this

number is reserved for selection screen.

When we choose two step, two screens will be created for table maintenance. For

single step only one screen will be created.

When we choose two step, table maintenance will work as follows

Go to SM30, give the table name for which you have created table maintenance-

Overview screen will be displayed. To create entries, when you click on ‘new

entries’. Another screen will be displayed, where you give input and save. You can

enter one record at a time.

Go to SM30; give table name for which you have created table maintenance-

Overview screen will be displayed; To create entries click on ‘new entries’, you can

enter the records on the same screen. You can enter multiple records at a time.

We use single step generally, as it is user friendly.

To completely understand the difference and above points please do exercise by

creating table maintenance generator in both ways (using single step and two

step).

Thanks

Mohinder Singh Chauhan

Re: table maintanace generator

Former Member — Mon, 03 Dec 2007 04:30:39 GMT

check these links, it may be helpful to u.

this link contains information about :

1)Table Controls in ABAP Programs

2)Looping Through an Internal Table

3)Table Controls: Examples with Scrolling

http://help.sap.com/saphelp_47x200/helpdata/en/9f/dbac1d35c111d1829f0000e829fbfe/frameset.htm

Instead of using table control, use table control wizard...... very easy to populate the table.... bcoz it will automatically ask everything during its creation...ie from which database table , internal table and which all fields u want to select in the table control etc..

This wizard allows you to create a working table control quickly and easily. It also lets you generate certain standard table maintenance functions.

check this link....

http://help.sap.com/saphelp_47x200/helpdata/en/6d/150d67da1011d3963800a0c94260a5/frameset.htm

I have taken 2 screens 2nd one has table control

code to be written in module pool is

process before output.

module populate_it.

loop with control tab_ctrl.

module status_0101.

endloop.

****************************

process after input.

loop with control tab_ctrl.

module modify_mod.

endloop.

module mod_del.

module modify_ttab.

*************************************************

*Below is the code to be written in driver program

**************************************************

&----

*& Module pool Z9_TBCTRL_PRASH *

*& *

&----

*& *

&----

program z9_tbctrl_prash.

data: it_ekko type standard table of z9ekko_prash.

data: it_ekpo type standard table of z9ekpo_prash.

data: it_ekpo_del type standard table of z9ekpo_prash.

data: wa_ekko type z9ekko_prash.

data: wa_ekpo type z9ekpo_prash.

data: wa_ekpo_del type z9ekpo_prash.

data: ok_code_0100 like sy-ucomm.

data: ok_code_0101 like sy-ucomm.

controls: tab_ctrl type tableview using screen 0101.

&----

*& Module POPULATE_IT OUTPUT

&----

text

----

module populate_it output.

clear it_ekpo.

refresh it_ekpo.

clear it_ekko.

refresh it_ekko.

select single ebeln bukrs aedat ernam lifnr ekorg ekgrp waers

into corresponding fields of wa_ekko

from z9ekko_prash where ebeln = wa_ekko-ebeln.

append wa_ekko to it_ekko.

clear wa_ekko.

select ebeln ebelp matnr werks lgort menge meins

into corresponding fields of wa_ekpo

from z9ekpo_prash where ebeln = wa_ekko-ebeln.

append wa_ekpo to it_ekpo.

clear wa_ekpo.

endselect.

endmodule. " POPULATE_IT OUTPUT

&----

*& Module STATUS_0101 OUTPUT

&----

text

----

module status_0101 output.

SET PF-STATUS 'xxxxxxxx'.
SET TITLEBAR 'xxx'.

read table it_ekpo into wa_ekpo index tab_ctrl-current_line.

endmodule. " STATUS_0101 OUTPUT

&----

*& Module validate_ebeln INPUT

&----

text

----

module validate_ebeln input.

if wa_ekko-ebeln <> ' '.

call screen 0101.

endif.

endmodule. " validate_ebeln INPUT

&----

*& Module MODIFY_MOD INPUT

&----

text

----

module modify_mod input.

modify it_ekpo from wa_ekpo index tab_ctrl-current_line.

endmodule. " MODIFY_MOD INPUT

&----

*& Module MODIFY_TTAB INPUT

&----

text

----

module modify_ttab input.

case ok_code_0101.

when 'MODI'.

modify z9ekpo_prash from table it_ekpo.

call screen 0100.

when 'DELE'.

call screen 0100.

endcase.

endmodule. " MODIFY_TTAB INPUT

&----

*& Module MOD_DEL INPUT

&----

text

----

module mod_del input.

case ok_code_0101.

when 'DELE'.

refresh it_ekpo_del.

loop at it_ekpo into wa_ekpo.

if wa_ekpo-mark = 'X'.

move-corresponding wa_ekpo to wa_ekpo_del.

append wa_ekpo_del to it_ekpo_del.

endif.

endloop.

delete z9ekpo_prash from table it_ekpo_del.

endcase.

check this links.....

http://help.sap.com/saphelp_nw04/helpdata/en/9f/dbac1d35c111d1829f0000e829fbfe/frameset.htm

http://help.sap.com/saphelp_nw2004s/helpdata/en/9f/dbac1d35c111d1829f0000e829fbfe/frameset.htm

I hope it helps.

Re: table maintanace generator

Former Member — Mon, 03 Dec 2007 04:33:22 GMT

Ignore above one

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

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

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]

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.

Re: table maintanace generator

Former Member — Fri, 07 Dec 2007 11:00:13 GMT

Table Maintenance Generator (TCode: SM30) is used to create, edit and delete entries to tables which are created by the SAP User.

It is also used in creating Maintenance View. It need to be activated before the table is maintained using Maintenance View.

Re: table maintanace generator

Former Member — Fri, 07 Dec 2007 11:50:09 GMT

Well the purpose of table maintainence generator is to enable the table maintenance through SM30, and to implement and validation etc on table field inputs.

SE11->Utillities->table maintainence generator

You need to enter the values of following fields:

1. Table name

2. Authorization group , and authorization object (select the suitable one )

3. Function group and package

4. Maintainence type : single or double screen maintainence view depending on the option selected.

5. Maintain screen number : you may specify a value or let the system generate one for you.

The validation code for the table entry is written in the flow logic of this screen. Even some of the fields may be made display only , by adding suitable code in the logic or directly disabling the input in table control in the layout.

>> Activate

Regards

Pavan