Skip to Content
avatar image
Former Member

manipulating table maintenance dialog

Hello again people.

Is there a possibility to manipulate the table maintenance dialog so that the fields displayed would be filtered? I have a database table which contains several fields, including <i>company code</i>. The only fields i want to display are those belonging to a specific company code.

I have an initial screen that passes the verified value of the company code to the table maintenance dialog. The plan is, once CALL TRANSACTION is used and the table maintenance opens, only those with the company code specified in the first screen would be displayed, while those with different company codes would just remain in the database table, but will not be displayed.

Hope my explanation is not too messed up. Thank you in advance.

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

3 Answers

  • avatar image
    Former Member
    Jun 17, 2004 at 10:16 AM

    Hi Vanessa,

    One of the approaches could be:

    1. Generate the table maintenance for your table.

    2. Goto the function group you had specified in the table maintenance generator screen.

    3. Display the screen which is for your table.

    4. Add a module in the PAI to display the fields you want. Select the relevant fields here and carry on with the desired processing.

    The above steps would help you to have your own screen to enter the company code. Next you can call the SM30 transaction from the code, skipping the first screen and this would allow you to display only those fields which you want to display.

    Hope this helped.

    Regards,

    Tathagata

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 17, 2004 at 10:56 AM

    Hi Vanessa,

    perhaps it's possible to solve your problem with

    the function VIEW_MAINTENANCE_CALL

    example:

    CALL FUNCTION 'VIEW_MAINTENANCE_CALL'

    EXPORTING

    ACTION = 'S'

    VIEW_NAME = 'YOUR_TABLE'

    complex_selconds_used = 'X'

    TABLES

    dba_sellist = seltab.

    append your filter-criteria to seltab ( Type VIMSELLIST )

    Good speed!

    Andreas

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jun 18, 2004 at 02:06 AM

    Problem solved 😊 . Thanks guys.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Vanessa,

      The best approach that I have seen, thus far is to start table maintenance with restrictions, there you might specify the condition like display only the rows that have company code 1000 and so on.

      Please explore on that.

      Regards,

      Pavan