on 08-22-2017 4:40 PM
I try to update sales order with BOM items, but i got this error:
DI Error (-1029) Field cannot be updated.
This is teh XFORM before to B1i Object:
<?xml version="1.0" encoding="UTF-8"?> -<xsl:stylesheet b1im:force="" utils2:force="" sim:force="" xci:force="" b1e:force="" b1ie:force="" rfc:force="" jdbc:force="" vpf:force="" bfa:force="" version="1.0" xmlns:xsl="http://www.w3.org/1999/XSL/Transform" xmlns:xci="urn:com.sap.b1i.xcellerator:intdoc" xmlns:vpf="urn:com.sap.b1i.vplatform:entity" xmlns:utils2="com.sap.b1i.bpc_tools.Utilities" xmlns:sim="urn:com.sap.b1i.sim:entity" xmlns:rfc="urn:sap-com:document:sap:rfc:functions" xmlns:jdbc="urn:com.sap.b1i.adapter:jdbcadapter" xmlns:bfa="urn:com.sap.b1i.bizprocessor:bizatoms" xmlns:b1im="urn:com.sap.b1i.sim:b1imessage" xmlns:b1ie="urn:com.sap.b1i.sim:b1ievent" xmlns:b1e="urn:com.sap.b1i.sim:b1event"> <xsl:output indent="yes" encoding="UTF-8" method="xml"/> <xsl:param name="atom"/> <xsl:param name="sessionid"/> <xsl:variable name="msg" select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='S']"/> <xsl:variable name="vpSender" select="/vpf:Msg/vpf:Header/vpf:Sender/@Id"/> <xsl:variable name="vpObject" select="/vpf:Msg/vpf:Header/vpf:Sender/@ObjId"/> <xsl:variable name="vpReceiver" select="/vpf:Msg/vpf:Header/vpf:ReceiverList/vpf:Receiver[./@handover='P']/@Id"/> <xsl:variable name="vpSociedad" select="/vpf:Msg/vpf:Header/vpf:Properties/vpf:prop[./@id='Sociedad']/@value"/> <xsl:variable name="vpPortalSLD" select="/vpf:Msg/vpf:Header/vpf:Properties/vpf:prop[./@id='PortalSLD']/@value"/> -<xsl:template match="/"> -<Msg xmlns="urn:com.sap.b1i.vplatform:entity"> <xsl:copy-of select="/vpf:Msg/@*"/> <xsl:copy-of select="/vpf:Msg/vpf:Header"/> -<Body> <xsl:copy-of select="/vpf:Msg/vpf:Body/*"/> -<Payload id="{$atom}" Role="X"> <xsl:call-template name="transform"/> </Payload> </Body> </Msg> </xsl:template> -<xsl:template name="transform"> -<QueryParams xmlns=""> -<DocEntry> <xsl:value-of select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='S']/Principal/Cabecera/numerodepedido_sap"/> </DocEntry> </QueryParams> -<Documents xmlns=""> -<row> -<DocDueDate> <xsl:value-of select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='S']/Principal/Cabecera/pedido_fechaentrega"/> </DocDueDate> -<CardCode> <xsl:value-of select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='S']/Principal/Cabecera/codigocliente_sap"/> </CardCode> -<TaxDate> <xsl:value-of select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='S']/Principal/Cabecera/pedido_fechacreacion"/> </TaxDate> <DocObjectCode>17</DocObjectCode> -<xsl:if test="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='S']/Principal/Cabecera/moneda_sap='MXP'"> <DocCurrency>MXP</DocCurrency> </xsl:if> -<xsl:if test="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='S']/Principal/Cabecera/moneda_sap='USD'"> <DocCurrency>USD</DocCurrency> </xsl:if> <!--<SalesPersonCode> <xsl:value-of select="/vpf:Msg/vpf:Body/vpf:Payload[./@id = 'atom9']/jdbc:ResultSet/jdbc:Row/jdbc:usuario_sap"></xsl:value-of> </SalesPersonCode> --> -<NumAtCard> <xsl:value-of select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='S']/Principal/Cabecera/pedido_id"/> </NumAtCard> -<Comments> <xsl:value-of select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='S']/Principal/Cabecera/pedido_comentarios"/> </Comments> -<DocumentsOwner> <xsl:value-of select="/vpf:Msg/vpf:Body/vpf:Payload[./@id='atom9']/jdbc:ResultSet/jdbc:Row/jdbc:usuario_sap"/> </DocumentsOwner> -<U_OrdCompra> <xsl:value-of select="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='S']/Principal/Cabecera/pedido_ordendecompra"/> </U_OrdCompra> </row> </Documents> -<Document_Lines xmlns=""> -<xsl:for-each select="/vpf:Msg/vpf:Body/vpf:Payload[./@id='atom6']/jdbc:ResultSet/jdbc:Row"> -<row> -<ItemCode> <xsl:value-of select="jdbc:codigoarticulo_sap"/> </ItemCode> -<Quantity> <xsl:value-of select="jdbc:pedido_cantidad"/> </Quantity> -<U_CatFab> <xsl:value-of select="/vpf:Msg/vpf:Body/vpf:Payload[./@id = 'atom14']/jdbc:ResultSet/jdbc:Row/jdbc:U_CatFab"/> </U_CatFab> -<UnitPrice> <xsl:value-of select="jdbc:PrecioCreasy"/> </UnitPrice> -<DiscountPercent> <xsl:value-of select="jdbc:pedido_descuento"/> </DiscountPercent> -<xsl:if test="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='S']/Pedido/Cabecera/impuesto_sap=16"> <TaxCode>C16</TaxCode> </xsl:if> -<xsl:if test="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='S']/Pedido/Cabecera/impuesto_sap=11"> <TaxCode>C11</TaxCode> </xsl:if> -<xsl:if test="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='S']/Principal/Cabecera/moneda_sap='MXP'"> <Currency>MXP</Currency> </xsl:if> -<xsl:if test="/vpf:Msg/vpf:Body/vpf:Payload[./@Role='S']/Principal/Cabecera/moneda_sap='USD'"> <Currency>USD</Currency> </xsl:if> <xsl:variable name="ItemCode" select="jdbc:codigoarticulo_sap"/> <!--<xsl:for-each select="/vpf:Msg/vpf:Body/vpf:Payload[./@id = 'atom14']/jdbc:ResultSet/jdbc:Row"> <xsl:if test="$ItemCode = jdbc:ItemCode"> <BaseEntry> <xsl:value-of select="jdbc:DocEntry"></xsl:value-of> </BaseEntry> <BaseLine> <xsl:value-of select="jdbc:LineNum"></xsl:value-of> </BaseLine> <BaseType> <xsl:value-of select="jdbc:ObjType"></xsl:value-of> </BaseType> </xsl:if> </xsl:for-each> --> </row> </xsl:for-each> </Document_Lines> </xsl:template> </xsl:stylesheet>
Afther that i have a B1Objet with description below:
Description: Call to B1 via DI object API
Method: Synchronous Update
Object: 17
KeyName: #DocEntry
How can i update this sales order, with this type object?
From the error it doesn't look to be any issue with HANA.
Some notes to check perhaps:
SAP Note 1976413 & 2137833.
If they don't help then open an incident with SAP under the component SBO-SDK-DI or SBO-SDK-DI-FIN
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Sorry, cannot see your xml payload
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
107 | |
12 | |
11 | |
6 | |
5 | |
4 | |
4 | |
3 | |
3 | |
3 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.