Allowed to use B1iSQL to update UDO Lines?

[david_stegnitz3]

Dear B1if experts,

I have a B1if Scenario which updates Lines in a User Defined Object. Using B1 Service Call in that situation would be a bit of an issue, as potentially I have to update more than one UDO in the same Scenario step.

Technically B1iSQL in the outbound works well, but I wonder if this is a no-go, or if it is 'allowed' and SAP-Conform to use B1iSQL in order to update UDO Lines, similar to the following example?

                <B1out type="b1isql">
                        <SQL sqlmode="multiple">
                                <xsl:for-each select="/vpf:Msg/vpf:Body/vpf:Payload[./@id='atom25_5' and ./@Role='C']/jdbc:ResultSet/jdbc:Row">
                                        <Table id="[{$DB}].[dbo].[@Table_Lines]" keylist="Code" task="U" del="">
                                                <Field id="Code" value="{jdbc:Code}" wrapchar="true"></Field>
                                                <Field id="U_Status" value="Executed" wrapchar="true"></Field>
                                        </Table>
                                </xsl:for-each>
                        </SQL>
                </B1out>

[ANKIT_CHAUHAN]

Hi,

Refer to these Guidelines for Modifying SAP Business One Data.

Kind regards,

ANKIT CHAUHAN

SAP Business One Support

[Johan_H · Accepted solution]

Hi David,

If the User Defined Table and/or User Defined Field was created by you, then you can use Insert Update Delete transactions on it. Obviously in this case the risk of loss or corruption of data in User Defined Tables and Fields is entirely yours.

Doing so on system fields in system tables, is what will get you in trouble. it can cost you SAP support for the affected database, so don't do it (unless it is the Comments field in document tables, but you didn't hear that from me).

Regards,

Johan