Skip to Content
author's profile photo Former Member
Former Member

UpdatewithSubDeletion

Hi


Can someone please explain how UpdatewithSubDeletion works in B1iF?

I have created a BP2BP scenario and would like the Contacts to be deleted and then updated with the new contacts.

I have two SAP B1 databases.

I have put a Call B1 Object atom in my scenario.

When I delete a contact from a BP Master, I would like it to be deleted from my other database also.

However my payload shows the following error.

Payload Role="C" id="atom1" system="0010000103" status="success" b1login="Technical
User
" method="updateWithSubDeletion" objectid="2" payload="atom2"
keyname="CardCode" keyvalue="100544" DIresult="failure"
DImsg="Exception : DI Error: (-223) Deleting rows
not supported for object BP Control Account
" />

Any help would be much appreciated.

I am using SAP B1 Version 9 Patch 9 HF1.

Thank you

Regards

Ashvin


Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • Best Answer
    Posted on Apr 23, 2014 at 03:16 PM

    Hi Ashvin,

    please also check the following discussion:

    The procedure is applicable for UpdateWithSubDeletion (used for B1 master data) as well:

    1. Read the master data - you want to update later - using a B1 Object call (#Synchronous Retrieval, #ExportImportMode).
      With ExportImportMode, you exactly get the fields and segments, you need to use later for UpdateWithSubDeletion call.
    2. Update the object using B1 Object Call (#updateDocWithSubDeletion) and - very important - in exactly the same order and with exactly the same fields and segments retrieved by step 1.

    Method UpdateWithSubDeletion is meant to update B1 master data e.g. Business Partners including their addresses and contact persons. If the Sender deletes e.g. a contact person or an address of an business partner, this contact person or address gets deleted on the receiver system, too.

    If you want to delete a Business Partner master data directly, please use the the B1 Object call with method #Synchronous Delete.

    An integration scenario for adding, updating (with subdeletion) and deleting a B1 Business Partner could look like in following screenshot (depending on the B1 event task and the SQL call against the receiver system):

    Best regards

    Bastian


    Capture.PNG (91.5 kB)
    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.