Skip to Content
0
Former Member
Jun 23, 2008 at 11:20 AM

Secondary Index

35 Views

Hi Experts.

I need to create programmatically the secondary indexes, unique or simple index on column.

Any ideas.

Thanks regards.

P.S. An example of creating the user defined table using the code.


Dim oUserTableMD As SAPbobsCOM.UserTablesMD
Try
  oUserTablesMD = SBO_Company.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oUserTables)
  If Not oUserTablesMD.GetByKey(sTableName) Then
    oUserTablesMD.TableName = sTableName
    oUserTablesMD.TableDescription = sTableDescription
    ' ... where sTableTypeSAP = NO_OBJECT, MASTER_DATA, ...
    oUserTablesMD.TableType = sTableTypeSAP
    If oUserTablesMD.Add != 0 Then
      Call SBO_Company.GetLastError(lErrCode, sErrMsg)
      Throw New Exception(sErrMsg)
    End If
catch ex As Exception
  ' log exception
end try