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:
Answer: No. Direct updates are not permitted, however, you can directly update UDT’s of type No Object & No Object with Auto. Increment.
Examples:
a. Table [@DS_TESTUDT] is of type Master Data or Master Data Rows or Document or Document Rows.
b. Table [@DS_TESTUDT] is of type No Object or No Object with Auto. Increment.
Answer: No, you are not permitted to modify SAP Business One System tables.
Example:
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.
Source:https://www.linkedin.com/pulse/support-spotlight-top-3-questions-modifying-sap-business-chauhan/