Function Module

[Former Member]

hello,

Is there any function module for creating a Table Maintainence Generator , Where my requirement is There will not be Authorization To use SM30, so is ther any fucntion module to create table maintainence generator.

cheers

[RichHeilman]

I think you can create the table maintenance program via SE11, and then assign a "Z" transaction code to the program/screen.

Regards,

Rich Heilman

[RichHeilman]

If you want to use a wrapper program and call the maintenance via function module, use the following.

Enter your table or view name for the VIEW_NAME parameter.

call function 'VIEW_MAINTENANCE_CALL'
       exporting
            action                       = 'U'
            view_name                    = <table/viewname>
       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.

Regards,

Rich Heilman

Message was edited by: Rich Heilman

[Former Member]

hai rich,

when i passed the table name to this function module it says "The maintenance dialog for ZMBLOCK is incomplete or not defined", is anything else neede except to that of creating table in se11.

cheers

[Former Member]

In SE11, you need to go to the menu path Utilities -> Table maintenance generator and create the table maintenance screen there...

[RichHeilman]

Did you set the flag in SE11, to allow table maintenance? I believe its under attributes tab. I don't know if this will help, or not.

Regards,

Rich Heilman

Message was edited by: Rich Heilman

[RichHeilman]

Also, what is your authorization group of the table maintenance. Maybe try changing it to &NC&

Regards,

Rich Heilman

[Former Member]

Hi :

Use T/code SE11 and first maintain the table maintenance generator for your Ztable. This will remove this error.

Then assign to a transaction using SE93.

[ananjun1]

Please check the 'Display/Maintenance Allowed' flag in 'Delivery and Maintenance'in 4.7 version or maybe in 'Attributes' or similar tab in <4.6C versions(can't confirm that right away).

If you set this, it should solve the problem. If you have this as 'X' and still get errors, I would regenerate table maintenance.

Let us know if this helped.

Thanks,

Anand

[manuel_bassani]

Hi,

i never used it, but try: VIEW_MAINTENANCE_GENERATE

Manuel

[Former Member]

I don't understoog your problem.

Do you want to use sm30 with some table but you don't have authorization to sm30?

[Former Member]

Hi Kumar;

Once you create the table maintenace in SE11, you can create a Z transaction that can get past the lack of authorization for SM30, or SM31.

To do that, go to transaction SE93 and type in type in a transaction name, then click "create."

On the dialog box that comes up, select the radiobutton "Transaction with parameters."

On the next screen, enter the transaction SM31 in the transaction field and click "Skip initial screen." Also, click the "Inherit GUI attibutes" check box on the next block.

Down on the bottom portion of the screen, under default values, enter this information:

<u>NAME</u>              <u>Value</u>
VIEWNAME                 <enter your table name>
UPDATE                   X

Then, save the transaction and then you have table maintenance.

Cheers,

John

[Former Member]

Hi,

To call the function module VIEW_MAINTENANCE_CALL, you need to generate the table maintenance using the SE54 transaction or go to the table using SE11 and utilities->table maintenance generator.

Thanks

Giridhar