Table Maintainance generator

[Former Member]

Hi Experts,

what is the exact use of Table Maintainance generator?

In that what is single-step and two-step?

What is the authorization group,what is function group and why there are screen numbers..

[Former Member]

Via the table maintenance generator you can create a view which can be used to maintain data in that table.

If you read the SAP online help it will explain exactly how this works.

[Former Member]

Go through the following Document

1. specially function group.. what is its significance

When we generate table maintenance,

the system , based upon the table fields,

automatically,

generates

PROGRAM CODE, SCREEN FOR ENTERING DATA,

LOGIC FOR SAVING DATA, LOGIC FOR DISPLAYING DATA

ETC.

2. All this are BUNCHED under

a FUNCTION GROUP

(if you open that function group in se80, after

creatting table maintenacne,

u will see the program code, screens, gui status etc)

3. Hence, to BUNCH all these various objects,

SAP uses the concept of function group.

*----

---

4. And also why do we need to give two screens there

Its not necessary to have to screens.

5. ONE SCREEN MEANS:

only one screen with table control to enter data

TWO SCREEN means :

first screen : only primary key fields will appear

second screen : rest of the fields will appear to enter data

6. When the table consists of many fields,

its practically more convenient to have two screens,

so that all fields come vertically downwards.

(instead of scrolling horizontally in the table

control, in case of one screen concept)

The use of the FG is only this the Table Maintainance Generator part. Neednt be declared anywhere else.

yes u need to create a FG and the use it in Table maint. gen.

http://help.sap.com/saphelp_erp2005/helpdata/en/a7/513520407a11d1893b0000e8323c4f/frameset.htm - a link for basics on Table Maintenance.

Also, Check out this weblog on table maintenance:

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

[Former Member]

Please check the following links..

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

http://help.sap.com//saphelp_470/helpdata/EN/a7/5133ac407a

11d1893b0000e8323c4f/frameset.htm

[Former Member]

Hi,

The use of the FG is only this the Table Maintainance Generator part. Neednt be declared anywhere else.

yes u need to create a FG and the use it in Table maint. gen.

http://help.sap.com/saphelp_erp2005/helpdata/en/a7/513520407a11d1893b0000e8323c4f/frameset.htm - a link for basics on Table Maintenance.

Also, Check out this weblog on table maintenance:

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

When we generate table maintenance,

the system , based upon the table fields,

automatically,generates

PROGRAM CODE, SCREEN FOR ENTERING DATA,

LOGIC FOR SAVING DATA, LOGIC FOR DISPLAYING DATA

ETC.

2. All this are BUNCHED under

a FUNCTION GROUP

(if you open that function group in se80, after

creatting table maintenacne,

u will see the program code, screens, gui status etc)

3. Hence, to BUNCH all these various objects,

SAP uses the concept of function group.

4. And also why do we need to give two screens there

Its not necessary to have to screens.

5. ONE SCREEN MEANS:

only one screen with table control to enter data

TWO SCREEN means :

first screen : only primary key fields will appear

second screen : rest of the fields will appear to enter data

6. When the table consists of many fields,

its practically more convenient to have two screens,

so that all fields come vertically downwards.

(instead of scrolling horizontally in the table

control, in case of one screen concept)

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

Rgds,

[Former Member]

Hi,

Table maintennace generator is used to create screen to maintain values in a table. Once you create maint generator you can goto transaction SM30 and add data to table . In SAP it is more relevant to customizing data.

<b>Create a table maintance program for a z table</b> :

In transaction SE11, in the attribute tab of your z table check table maintenance check box. Go to SM30 transaction, enter the ztable name and click on maintain button. Here you can enter new entries into the ztable .

Or

You can create a PARAMETER TRANSACTION for the transaction for SM30 .

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

Check the below thread for the same:

More detail on the same can be found from the following:

http://help.sap.com//saphelp_470/helpdata/EN/a7/5133ac407a11d1893b0000e8323c4f/frameset.htm

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

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

I think these will answer ur question.

Thanks,

Ramya.

[Former Member]

Hai Jak

Go through the following Document

1. specially function group.. what is its significance

When we generate table maintenance,

the system , based upon the table fields,

automatically,

generates

PROGRAM CODE, SCREEN FOR ENTERING DATA,

LOGIC FOR SAVING DATA, LOGIC FOR DISPLAYING DATA

ETC.

2. All this are BUNCHED under

a FUNCTION GROUP

(if you open that function group in se80, after

creatting table maintenacne,

u will see the program code, screens, gui status etc)

3. Hence, to BUNCH all these various objects,

SAP uses the concept of function group.

*----

---

4. And also why do we need to give two screens there

Its not necessary to have to screens.

5. ONE SCREEN MEANS:

only one screen with table control to enter data

TWO SCREEN means :

first screen : only primary key fields will appear

second screen : rest of the fields will appear to enter data

6. When the table consists of many fields,

its practically more convenient to have two screens,

so that all fields come vertically downwards.

(instead of scrolling horizontally in the table

control, in case of one screen concept)

The use of the FG is only this the Table Maintainance Generator part. Neednt be declared anywhere else.

yes u need to create a FG and the use it in Table maint. gen.

http://help.sap.com/saphelp_erp2005/helpdata/en/a7/513520407a11d1893b0000e8323c4f/frameset.htm - a link for basics on Table Maintenance.

Also, Check out this weblog on table maintenance:

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

Thanks & regards

Sreeni

[Former Member]

Hi All,

Thank you very much.

Points are given.