Skip to Content
0
Feb 10, 2020 at 03:39 PM

Allowed to use B1iSQL to update UDO Lines?

109 Views Last edit Feb 11, 2020 at 06:41 AM 2 rev

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>