Table Settings

[Former Member]

Hello Gurus,

Is there a table where the settings of the table format is stored? My problem is making some columns editable in PO, GRPO, A/P Credit Memos and A/P Invoices. In SDK, i cannot make columns visible or editable programmatically, so i think i can work around this by finding the database where the tables settings of the matrix is stored. Please helps.

[former_member184566 · Accepted solution]

Hi Gilbert Ngo

You can do it using the DI API in 2005 (new functionality), if i remember correctly it only worked while logged off SAP. It is not needed to go through the tables.

Try the following code

Dim FormSettingsService As SAPbobsCOM.FormPreferencesService

Dim ColumnSettingsData As SAPbobsCOM.ColumnsPreferences

Dim ColumnSettingsPara As SAPbobsCOM.ColumnsPreferencesParams

oCompanyService = oCompany.GetCompanyService

FormSettingsService = oCompanyService.GetBusinessService(SAPbobsCOM.ServiceTypes.FormPreferencesService)

ColumnSettingsPara = FormSettingsService.GetDataInterface(SAPbobsCOM.FormPreferencesServiceDataInterfaces.fpsdiColumnsPreferencesParams)

ColumnSettingsPara.FormID = FormID ' "133"

ColumnSettingsPara.User = 1

ColumnSettingsData = FormSettingsService.GetColumnsPreferences(ColumnSettingsPara)

Dim lngCount As Integer

For lngCount = 0 To ColumnSettingsData.Count - 1

If ColumnSettingsData.Item(lngCount).Column = "24" Then

ColumnSettingsData.Item(lngCount).EditableInForm = SAPbobsCOM.BoYesNoEnum.tNO

ColumnSettingsData.Item(lngCount).VisibleInForm = SAPbobsCOM.BoYesNoEnum.tYES

Exit For

End If

Next

FormSettingsService.UpdateColumnsPreferences(ColumnSettingsPara, ColumnSettingsData)

Hope this helps