06-20-2007 5:02 PM
hi dear friends
i would like to know about how the table maintaience generator is used in ddic .i have the step by step processor of that but i would like to know importance and advantages of it .
06-21-2007 4:17 AM
In simple, i would say that the 'table maintenance generator allows to maintain data thru SM30, you can create entries in the tables for which it is being maintained'.
Regards
Gopi
06-21-2007 4:15 AM
Nani,
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.
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
Don't forget to reward if useful.....
06-21-2007 4:19 AM
Hi,
Table Maintanance Generator is used to manually
input values using transaction sm30
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 !
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.
06-21-2007 4:17 AM
In simple, i would say that the 'table maintenance generator allows to maintain data thru SM30, you can create entries in the tables for which it is being maintained'.
Regards
Gopi
06-21-2007 5:20 AM
Hi,
Since u know the step by step process of table maintainence generator (TMG),
the main use of TMG is to add in new entries to ur table thro the transaction SM31.
The advantage of doin TMG is that, it by itself wil craete a screen thro with u directly c the SM31 screen,there by, u can give new entries for ur table.
It becomes more easy, if u wud craete a TCODE for ur table..
****Reward points if helpful.
All the best
06-21-2007 6:49 AM
As you know there are some tables which are required to be maintained then there .. so for that the changes has to be recorded in the table level ....
so there it comes the Authorisation of the Table ..... in any project there is no Authorisation for tables ...
so for Customizing and data to be maintained in the screen level ...so the Manintaincance was generatored for the table ...with Tcode .
reward points if it is usefull ...
Girish
06-21-2007 7:03 AM
- <b>Maintenance View ( SE54 )</b>
Maintenance views enable a business-oriented approach to looking at data, while at the same time, making it possible to maintain the data involved. Data from several tables can be summarized in a maintenance view and maintained collectively via this view. That is, the data is entered via the view and then distributed to the underlying tables by the system.
Girish
06-21-2007 9:24 AM
Suppose u have a simple table table with fields ROLLNO and NAME, now u want some person(data entry operator) to fill this table with values, now you don't wanna make a module pool ( dialog program ) for this simple process, u just make a TableMaintGenerator(TMG). What sap does is, it will create a Module pool program(screen and program flow) to interface data with the table, simple ain't it. The advantage of using TMG is that it takes into consideration the database rules, and will give error or success message to user, like cannot enter duplicate key fields, wallah. So at the end u didn't had to create a program, plus the users are at use with using TMG interface, so u don't have to bang ur head with em, making em understand the program. U can also edit TMG, thats the best part, as u edit a simple module pool program and put ur own validations.