topic Re: Function Module in Application Development and Automation Discussions

Function Module

Former Member — Fri, 11 Nov 2005 15:20:07 GMT

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

Re: Function Module

RichHeilman — Fri, 11 Nov 2005 15:21:40 GMT

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

Re: Function Module

manuel_bassani — Fri, 11 Nov 2005 15:24:55 GMT

Hi,

i never used it, but try: VIEW_MAINTENANCE_GENERATE

Manuel

Re: Function Module

RichHeilman — Fri, 11 Nov 2005 15:26:42 GMT

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

Re: Function Module

Former Member — Fri, 11 Nov 2005 15:27:28 GMT

I don't understoog your problem.

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

Re: Function Module

Former Member — Fri, 11 Nov 2005 15:30:31 GMT

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

Re: Function Module

Former Member — Fri, 11 Nov 2005 15:40:09 GMT

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

Re: Function Module

Former Member — Fri, 11 Nov 2005 15:43:11 GMT

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

Re: Function Module

RichHeilman — Fri, 11 Nov 2005 15:43:13 GMT

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

Re: Function Module

RichHeilman — Fri, 11 Nov 2005 15:45:22 GMT

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

Regards,

Rich Heilman

Re: Function Module

Former Member — Fri, 11 Nov 2005 15:46:59 GMT

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.

Re: Function Module

ananjun1 — Mon, 14 Nov 2005 19:35:39 GMT

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

Re: Function Module

Former Member — Mon, 14 Nov 2005 19:43:29 GMT

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