Table Maintainence generator

Helpful links.

http://help.sap.com/saphelp_erp2005/helpdata/en/a1/e45217a2f511d1a5630000e82deaaa/frameset.htm

First, go to SE11, enter your table name, click change. Click utilities, click table maintenance generator. Enter you authorization group, I usually use &NC&. Enter the name of the function group that will be created by the generator, set overview screen to 1. CLick create. Now you will be able to maintain this table via SM30.

You can also create a "Z" transaction code instead of the user using SM30.

Go to SE93, enter tcode and click create, give a description and select transaction with parameters.

Enter SM30, in the tcode field. check the box for skip initial screen.

At the bottom of the screen, you will need to put some parameters. Put these in.

VIEWNAME                      <table_name>                 
UPDATE                        X 

<table_name> is the name of your table.

Also you can call the maintenance view directly in a program.

  call function 'VIEW_MAINTENANCE_CALL'
       exporting
            action                       = 'U'
            view_name                    = <table_name>
       exceptions
            client_reference             = 1
            foreign_lock                 = 2
            invalid_action               = 3
            no_clientindependent_auth    = 4
            no_database_function         = 5
            no_editor_function           = 6
            no_show_auth                 = 7
            no_tvdir_entry               = 8
            no_upd_auth                  = 9
            only_show_allowed            = 10
            system_failure               = 11
            unknown_field_in_dba_sellist = 12
            view_not_found               = 13
            others                       = 14.
  if sy-subrc <> 0.
    message id sy-msgid type sy-msgty number sy-msgno
            with sy-msgv1 sy-msgv2 sy-msgv3 sy-msgv4.
  endif.

Please remember to award points for helpful answers and mark your posts as solved when solved completely. Thanks.

Regards,

Rich Heilman

To create table maintenance, use transaction se11 to change your table. Menu option Utilities->Table Maintenace Generator. This screen is where you define the table maintenace. You must specify an authorization group if you security checks or specify auth group "&NC&" for no authorization checks. You must also give a function group for SAP to generate the Table Maintenance program.

The One-Step/Two-Step option determines the maintenance option. One-Step displays the entire table as open for maintenance and you can maintain all entries at once. Two-Step list the table entries in display mode but you can only maintain one entry at a time.

You can call the standard table maintenance by calling function module "VIEW_MAINTENANCE_CALL" instead of calling the screens directly. You only need to pass in two parameters:

"ACTION" - U(change, S(display)

"VIEW_NAME" - table name.

Hope this helps,

Jerrod Baldauf

1. Create a table with "Table maintenance allowed" flag on

2. SE11 -> <enter table> -> Utilities -> Table maintenance generator

3. Enter Authorization group (&NC& for none)

4. Choose function group

5. Choose One step or two step (i.e. 1 screen versus 2 screens)

6. Choose screen numbers

6. Use standard recording routine

7. SAVE

Notes:

o Make sure that you choose your function group wisely. Do no cross contaminate groups with functions that are out of scope. It is better to create a new group if unsure.

o You can have SAP propose screen numbers for you. (SHIFT/F7). These will be the screen number(s) that you will reference in an ABAP program or BDC.

o From here you may go to SM30 and maintaining your table. You can access your table generated maintenance program as you would any other transaction. When creating a variant use SM30 and "skip first screen". This can be helpful for an end user or BDC.

Hope this helps.

Kyle...