How to find Menu and tables

[Former Member]

Hi

I would like to know how the system creating main menu, and where the values comming from?? I mean what are the tables has the menu data and also parent and child relationship?

what are the tables contains the menu items and user access levels and relationship. what DIAPI object or any query is using to build the menu and menu items on the basis of the login user?

Can any one help me in the above case.

thanks in advance.

kv

[Former Member · Accepted solution]

Hi Sierdna S

I dont' find menu names in this tables (CPRF, CUMI), please let me know if you have any info. and also where can i find user permissions and tables.

thanks

kv

[Former Member · Accepted solution]

Hi Venkat Reddy.

For objects / descriptions / tables names:

-

---

- UserPermissionTree / User authorizations for add-on forms / OUPT;

- UserPermissionForms / User permission forms / UPT1;

- Users / Users of SAP Business One application / OUSR;

- UserPermission / User authorizations / USR3.

For user permissions, tables and examples you can search for words user permissions and tables in the SDK Help.

-

---

- List of permission IDs and their forms;

- Business Objects List (DI API), Administration tables;

- SetSystemPermission Method;

- The DI API samples ..\Program Files\SAP\SAP Business One SDK\Samples\COM DI\Permissions what Demonstrates adding a new permission, assigning it to users, and then testing the permission;

Regards

Sierdna S.

[Former Member · Accepted solution]

For autorizations see this menu: Main Menu / Administration / System Inizialization / Autorizations.

[Former Member]

Hi Sierdna S

I did'nt find exactly permission stored in which table.

as you we know the tables are OUPT and UPT1, but my permissions are not stored in those tables.

here is the scenario.

i have created 1 user and gave full authorization for 3 menu items are sales, finance, banking. i dont' see any new data in OUPT and UPT1 tables.

Thanks and Regards

kv

[Former Member]

Hi,

To find all need you objects you can use SQL Server Management Studio

by choosing menu Tools / SQL Server Profiler.

Regards

Sierdna S.

[Former Member]

I tested with SQL Profiler , but it shows only sql statements not any object names.

please suggest me.

thanks

kv

[Former Member]

I don't think it is a good idea to make changes to SAP system tables.

Yes, with SQL Profiler you can see trace of sql execution on dbserver (Important to stop trace when finish).

These tables hold infor about menu and user preferences:

select * from CUMI
select * from CPRF

Also you can save xml form of the main menu using catching events sdk example.

' Insert into ItemEvent sub this code
  If oForm.Title = "Main Menu" Then
    SaveAsXML(oForm)
  End If
...
Private Sub SaveAsXML(ByRef oForm As SAPbouiCOM.Form)

  Dim oXmlDoc As Xml.XmlDocument
  Dim sXmlString As String

  oXmlDoc = New Xml.XmlDocument

  '// get the form as an XML string
  sXmlString = oForm.GetAsXML

  '// load the form's XML string to the
  '// XML document object
  oXmlDoc.LoadXml(sXmlString)

  Dim sPath As String

  sPath = IO.Directory.GetParent(Application.StartupPath).ToString

  '// save the XML Document
  oXmlDoc.Save((sPath & "\" & oForm.Title.Replace(" ", "") & "_" & oForm.UniqueID & ".xml"))

End Sub