Menu Selection - Usertable

[Former Member]

Good Day

Experts:

I wish to have a User Table maintenance connected to a Menu selection so the User does not have to hit

Tools --> User Tables --> (then navigate to the table and select from the list).

Is it possible to open the User Table maintenance for a table from a menu selection? I have not been able to find out how.

Thanks,

EJD

[Nussi · Accepted solution]

Hi,

catch the MenuEvent and insert the following

Dim oMenu As SAPbouiCOM.MenuItem
Dim i As Integer
Dim MenuUID As String
    
if pVal.MenuUID = "menuUID" And pVal.BeforeAction = True Then
        Set oMenu = oSBO.appl.Menus.item("51200")
        For i = 0 To oMenu.SubMenus.count - 1
           If oMenu.SubMenus.item(i).String = "Description of Table" Then
            MenuUID = oMenu.SubMenus.item(i).UID
           End If
        Next
        oSBO.appl.ActivateMenuItem (MenuUID)
end if

you catch it with the Description of the table

and than open it

lg Daviod

[Former Member · Accepted solution]

David:

That is great...I had no idea I could get to it that way. Ok, I will try here this afternoon and leave the post open in the event I have a question.

Thanks for the tip,

Ed

[Former Member · Accepted solution]

Thanks David...all set here.

Ed