topic Table maintenance generator in Application Development and Automation Discussions

Table maintenance generator

Former Member — Fri, 15 Mar 2013 05:54:37 GMT

Hi Gurus.............

I need a suggestion from u guys regarding the TMG. When ever we create a Ztable in se11 we ll usually used to create TMG too. But instead whenever i create a ztable in se11, TMG automatically want to be created. Even if any other ztable already existed but without TMG also automatically wants to be. So please suggest me an idea for my question

Thank You.

Re: Table maintenance generator

Former Member — Fri, 15 Mar 2013 10:31:27 GMT

Hi Meenakshi,

Its not required that every ZTABLE needs a TMG. It definitely needs Technical Settings but not TMG. What exactly is your query? Did you face any issue which you can post here?

Re: Table maintenance generator

Former Member — Fri, 15 Mar 2013 11:03:21 GMT

Hi Meenakshi,

What is your actual requirement? You want to create TMG automatically each time you create a table? I'm afraid that's not possible, as far as i know. Every table you create doesn't require a TMG. If you want to enter new values manually or Delete or Change entry then you go for TMG.

This is not needed if you are doing these operations programatically. In production system End-User won't have access to se11, so even in production system if the user wants to enter some values or change values directly into se11 table, we provide TMG.

If this was not your doubt, Please provide elaborated description of your requirement

Thank You

Re: Table maintenance generator

Former Member — Fri, 15 Mar 2013 11:33:52 GMT

This message was moderated.

Re: Table maintenance generator

Former Member — Fri, 15 Mar 2013 11:33:52 GMT

Hi pratheek.............thanx for your reply...............my requirement is.......in a report entry wen i call a ztable then the tmg of that table want to be displayed in the output of the report is it possible.

Re: Table maintenance generator

Former Member — Fri, 15 Mar 2013 18:15:02 GMT

Yes you can do that

Use this

CALL FUNCTION 'VIEW_MAINTENANCE_CALL'

EXPORTING

action = 'U'

view_name = 'ZTABLE_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

maintenance_prohibited = 14

OTHERS = 15.

You get Documentation for this FM. Hope this solves your problem

Re: Table maintenance generator

Former Member — Sat, 16 Mar 2013 16:17:57 GMT

Thank U Pratheek........................a helpful reply.......