Table Maintanence Generator

[Former Member]

hi to all experts,

while creating table maintanence gen. system ask for function group. what is it mean,

and what is importance for one step or 2 step.

thankx in advence and reward also.

Regards :

deepsama

[Former Member]

hi to all experts,

while creating table maintanence gen. system ask for function group. what is it mean,

and what is importance for one step or 2 step.

thankx in advence and reward also.

Regards :

deepsama

[Former Member]

Hi,

1. If we want to show some initial screen

eg. some primary keys,

then we want to add the addtiional fields,

then its TWO STEP.

2. Other wise, only 1 screen,

and data is shown in TABLE CONTROL.

its 1 step.

All of the function modules in a function group can access the global data of the group. For this reason, you should place all function modules that use the same data in a single function group. For example, if you have a set of function modules that all use the same internal table, you could place them in a function group containing the table definition in its global data.

the table maintenance generator creates all necessary functions to be used by transactions SM30/SM31 to create, change, delete and save entries in the table.

Functions in SAP are grouped togehther in function groups. It is a good habit to use the table name as the function group name. This makes sure you will not have any trouble after any structural change of the table to re-generate the maintenance.

Regards,

Omkaram.

[Former Member]

Hai Deep sama

Table Maintenance Generator

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

SE11->Utilities->table maintenance 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. Maintenance type: single or double screen maintenance 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.

Table maintenance is for creating, adding data to an existing table.

it is for adding multiple 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 steps, 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).

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.

If Found HelpFull .

Reward.

Regards.

Eshwar.

[Former Member]

hi deep sama,

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.

The function group contains all the generated maintenance modules.

While creating table maintenance generator, we find below options:

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

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

Two maintenance screens are processed during the extended table maintenance:

• On the Overview screen the entries are displayed in list form.

• On the Single screen one entry is displayed. The single screen can be called from the overview screen, by function key, for every entry.

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.

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

Recording:

No, or user, recording routine

Indicator that an individual recording routine will be used, if available

Changes are recorded by individual event routines, if defined, or not at all.

Standard recording of table contents changes

Indicator that the standard recording routine is to be used.

Changes are recorded by the standard recording routine. If there are individual routines, they supplement the standard routine

regards,

sravanthi

[Former Member]

Hi,

Table maintanance Generator is used to manually

input values using transaction sm30.The Table Maintenance Generator is used to create table maintenance program to add, modify or delete records in the database table. This can be accessed using transaction SE54 or in SE11 using the menu Utilities->Table Maintenance Generator

follow below steps

go to se11 check table maintanance check box under

attributes tab

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.

select maintaience type as single step.

maintainence screen as system generated numbers

this dialog box appears when you click on create

button

save and activate table

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

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.

please check the link for getting information about table maintenance generator !

https://www.sdn.sap.com/irj/sdn/advancedsearch?query=use%20of%20table%20maintenance%20generator&cat=...

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

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

Regards,

Priyanka.

[Former Member]

Q:while creating table maintanence gen. system ask for function group. what is it mean ?

sol : The table maintanence generator uses the function module ( name for which u provide) to create and maintain the table.

The module can be seen in the object repository.It contains system generated-function for implementing locks on the table while maintaining the table

Q: what is importance for one step or 2 step ?

sol : when entering data into table during table maintainence,

this option of 1 step or two step is used.Basically it translates as to how many screen do u require to enter a single row of data.

In case of two step, u can enter one row of data at any point in time,whereas u can have n rows of data entered using One step.

Hope this answers ur query

[Former Member]

Hi,

Function Group - > Is a set of Common Function Modules.

For this, U can go to SE37 -> Go to -> Function Group Create.

Then Activate the Function Group.

Regards,

N.L.Narayana

[Former Member]

Hi,

Table maintance generator is used to create table maintance program to add ,modify or delete records in the database table.

This can acessed using the transaction SM30 or SE54 OR SE11 . using the menu , utilites - tablemaintance generator.

single step and two step.

single step : only overview screen is created.

twostep : In this step two screens namely the overview screen and single screen are created.