Skip to Content
0
Former Member
Jan 16, 2012 at 08:25 AM

B1if : error updating items pricelists

379 Views

Hi,

i've made a scenario to upload items, it work fine if you do a insert.

there are problems on the update:

- if you update a item with only a price_list: no error.

- if you update a item with more price_lists: DImsg="Exception : DI Error: (-2035) This entry already exists in the following tables (ODBC -2035)"

any ideas?

thank you.

SAP 8.81 PL 10

</Payload><Payload Role="X" id="atom16">
      <QueryParams xmlns="">
        <ItemCode>CODE123</ItemCode>
      </QueryParams>
      <Items xmlns="">
        <row>
          <ItemCode>CODE123</ItemCode>
          <ItemName>CODE123 desc</ItemName>
          <ForeignName>CODE123dsds</ForeignName>
          <ItemsGroupCode>124</ItemsGroupCode>
          <SalesUnitWeight>7.000000</SalesUnitWeight>
          <PurchaseUnitWeight>7.000000</PurchaseUnitWeight>
          <CustomsGroupCode>2</CustomsGroupCode>
          <Mainsupplier>FF921</Mainsupplier>
          <DefaultWarehouse>01</DefaultWarehouse>
          <SalesWeightUnit>3</SalesWeightUnit>
          <PurchaseWeightUnit>3</PurchaseWeightUnit>
          <U_field>aaaaaaaaa</U_field>
          <U_field2>aaaaaaaaa</U_field2>
          <U_field3>aaaaaaaaa</U_field3>
          <U_field4>aaaaaaaaa</U_field4>
          <U_field5>aaaaaaaaa</U_field5>
          <Manufacturer>-1</Manufacturer>
        </row>
      </Items>
      <Items_Prices xmlns="">
        <row>
          <PriceList>1</PriceList>
          <Price>339.000000</Price>
          <Currency>EUR</Currency>
        </row>
        <row>
          <PriceList>7</PriceList>
          <Price>250.000000</Price>
          <Currency>USD</Currency>
        </row>
        <row>
          <PriceList>9</PriceList>
          <Price>309.000000</Price>
          <Currency>EUR</Currency>
        </row>
        <row>
          <PriceList>4</PriceList>
          <Price>990.000000</Price>
          <Currency>EUR</Currency>
        </row>
        <row>
          <PriceList>2</PriceList>
          <Price>359.000000</Price>
          <Currency>EUR</Currency>
        </row>
        <row>
          <PriceList>3</PriceList>
          <Price>850.000000</Price>
          <Currency>EUR</Currency>
        </row>
      </Items_Prices>
    </Payload><Payload Role="C" id="atom15" system="0010000116" status="success" b1login="Technical User" method="Synchronous Insert with fallback to Update" objectid="4" payload="atom16" keyname="ItemCode" keyvalue="" DIresult="failure" DImsg="
Exception : DI Error: (-2035) This entry already exists in the following tables (ODBC -2035)"/>