SAP Business One gives you the power to customize the business flow easily. One of the easiest ways to do this is to run direct SQL statements on the SAP Business One database. However, it is not recommended to perform direct updates. Here are the top questions I get asked about modifying SAP Business One data:

Question 1:

Can you use SQL statements INSERT/UPDATE/DELETE on User Defined Tables (UDTs) via HANA Studio or SQL Management Studio, Add-on code and B1if?

Answer: No. Direct updates are not permitted, however, you can directly update UDT’s of type No Object & No Object with Auto. Increment.


a. Table [@DS_TESTUDT] is of type Master Data or Master Data Rows or Document or Document Rows.

  • Can I use Update [@DS_TESTUDT] Set Name = “TEST” Where Code = ‘1’ ?
  • Answer: No.

b. Table [@DS_TESTUDT] is of type No Object or No Object with Auto. Increment.

  • Can I use Update [@DS_TESTUDT] Set Name = “TEST” Where Code = ‘1’ ?
  • Answer: Yes.

Question 2: Can you use SQL Statements INSERT/UPDATE/DELETE on User Defined Fields (UDFs) for the System table via HANA Studio or SQL Management Studio, Add-on code and B1if? 

Answer: No, you are not permitted to modify SAP Business One System tables.


  • Can I use UPDATE OPOR SET U_DSIC_ParentDoc = ‘1234’? 
  • Answer: No.

Question 3: Can you use the SQL statements CREATE/ALTER/DROP in SAP Business One Database to create or modify Tables, Columns?

Answer: No, you cannot CREATE/ALTER/DROP Tables/Columns in SAP Business One Database. It should be done via SAP Business One Client or SAP Business One SDK.


These guidelines are described in the SAP Business One certification page. Take a look at the Test Plan document in section 3.4 Modifying SAP Business One Data.

The same guidelines apply while doing these modifications in the SBO_SP_PostTransactionNotice and in the SBO_SP_TransactionNotification. Refer to SAP Note 1320484 for further information.

I hope this helps you in your day-to-day work with SAP Business One Database and clarifies the guidelines on what you can and cannot modify.



by MTC Systems on Jul 21, 2017 2:41:00 AM

Leave a comment