Question 1:
Is it permitted to INSERT/UPDATE/DELETE on UDTs through SQL Scripts HANA Studio, SQL Management Studio, SDK DoQuery() method, Coding, B1if?
Answer:
Direct updates are not allowed. It is ok for User Defined Tables (UDTs) of type [No Object & No Object with Auto. Increment] only.
Question 2:
Is it permitted to INSERT/UPDATE/DELETE on UDFs from System table through SQL Scripts HANA Studio, SQL Management Studio, SDK DoQuery() method, Coding, B1if?
Answer:
No, it is not allowed for SAP Business One system tables.
Question 3:
Is it allowed to CREATE/ALTER/DROP in SAP Business One Database but not as UDTs?
Answer:
It is not allowed to create tables in SAP Business One other than via SDK UDTs.
Below are some examples:
Question 1:
Is it allowed to use the following query: UPDATE OPOR SET Printed = 'Y' ?
Answer:
No
Question 2:
Is it allowed to use the following query: UPDATE OPOR SET U_DSIC_ParentDoc = '1234' ?
Answer:
No
Question 3:
Is it allowed to use the following query: INSERT INTO [@DS_TESTUDT] ?
Answer:
No, if UDT is registered for User Defined Object (UDO)
Yes, for UDTs of type [No Object & No Object with Auto. Increment] only.
These rules are described in the SAP Business One certification page: https://www.sap.com/documents/2020/06/f8d3172b-9b7d-0010-87a3-c30de2ffd8ff.html under the section: Modifying SAP Business One Data.
The same applies while doing all these modifications in SBO_SP_PostTransactionNotice and SBO_SP_TransactionNotification. Refer to SAP Note 1320484 for the same.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
8 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
2 | |
2 | |
2 |